PgInterface/tagPosition.sql at 134508dc5837c3072f1a369e7c1fba4b813afb03

Fork: 0
codedev / PgInterface
Find file
Newer
Older
PgInterface / tagPosition.sql
T480-lenovo on 19 Aug 2019 110 KB position data&scripts&interface
Raw Blame History
prompt PL/SQL Developer Export Tables for user ZHYQ@XE
prompt Created by LenovoWork on 20190709
set feedback off
set define off

prompt Dropping PG_TAGPOSITION...
drop table PG_TAGPOSITION cascade constraints;
prompt Creating PG_TAGPOSITION...
create table PG_TAGPOSITION
(
  id                 NUMBER(11) default 0 not null,
  hostid             VARCHAR2(20) not null,
  hostname           VARCHAR2(100),
  tagid              VARCHAR2(20) not null,
  tagmac             VARCHAR2(30) not null,
  tagmacname         VARCHAR2(100),
  coordinatesname    VARCHAR2(100),
  coordinate         VARCHAR2(20),
  x                  VARCHAR2(30),
  y                  VARCHAR2(30),
  positionupdatetime VARCHAR2(40),
  parsedtime         DATE,
  querytime          DATE default sysdate
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
create index QUERYTIME_IDX on PG_TAGPOSITION (QUERYTIME)
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
alter table PG_TAGPOSITION
  add constraint TAGPOSITION_ID_PK primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

prompt Disabling triggers for PG_TAGPOSITION...
alter table PG_TAGPOSITION disable all triggers;
prompt Loading PG_TAGPOSITION...
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (194, '112', '谢晓威', '14449', 'B0:8E:1A:40:0D:B3', 'B0:8E:1A:40:0D:B3', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4273762+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (195, '186', '0D68', '27260', 'B0:8E:1A:41:0D:68', 'B0:8E:1A:41:0D:68', null, '1160', '-3.7899999618530273', '-3.869999885559082', '2019-07-08T13:32:55.6406975+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (196, '214', '蓝牙标签0129-360351', '30420', 'B0:8E:1A:36:03:51', 'B0:8E:1A:36:03:51', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:07.2298563+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (197, '151', 'Model_D 011A（1-24）', '17745', 'B0:8E:1A:33:01:1A', 'B0:8E:1A:33:01:1A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5383873+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (198, '243', '楚云飞', '27776', 'B0:8E:1A:41:10:80', 'B0:8E:1A:41:10:80', null, '33', '40.84', '39.54', '2019-07-09T09:34:00.7033423+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (199, '238', '3568', '32059', '02:90:30:35:35:68', '02:90:30:35:35:68', null, '1242', '-91.06999969482422', '-37.7400016784668', '2019-07-08T13:33:13.2344567+08:00', to_date('08-07-2019 13:33:13', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (200, '144', 'Model-D 测试0548', '17429', 'B0:8E:1A:33:05:48', 'B0:8E:1A:33:05:48', null, '38', '-85.63287353515625', '-23.543903350830078', '2019-07-08T13:32:52.5123847+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (201, '142', 'Model-D 测试0544', '17399', 'B0:8E:1A:33:05:44', 'B0:8E:1A:33:05:44', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.4923827+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (202, '153', 'NEWAPI4796', '11449', 'B0:8E:1A:50:47:96', 'B0:8E:1A:50:47:96', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2043539+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (203, '225', '0019', '14130', 'B0:8E:1A:40:00:19', 'B0:8E:1A:40:00:19', null, '0', '-1.0', '-1.0', '2019-07-08T13:32:52.3843719+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (204, '136', '测试0013', '16423', 'B0:8E:1A:40:00:13', 'B0:8E:1A:40:00:13', null, '33', '-44.05439376831055', '-38.5018424987793', '2019-07-08T13:32:52.4693804+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (205, '135', '0015蓝牙标签(1103 17:00)', '14145', 'B0:8E:1A:40:00:15', 'B0:8E:1A:40:00:15', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3923727+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (206, '138', '董-Model-D 0017', '14096', 'B0:8E:1A:40:00:17', 'B0:8E:1A:40:00:17', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:32:52.36537+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (207, '139', '杨-Model-D 0016', '14100', 'B0:8E:1A:40:00:16', 'B0:8E:1A:40:00:16', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3743709+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (208, '169', 'Model-B test 0295', '21494', 'B0:8E:1A:36:02:95', 'B0:8E:1A:36:02:95', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6904025+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (209, '126', '蓝牙信号测试1', '12844', 'B0:8E:1A:40:0E:C8', 'B0:8E:1A:40:0E:C8', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.3143649+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (210, '46', '龚丽珍', '11408', 'B0:8E:1A:40:0A:EB', 'B0:8E:1A:40:0A:EB', null, '21', '27.66', '35.05', '2019-07-09T09:34:00.6953415+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (211, '236', '雅马哈03', '30403', 'B0:8E:1A:36:03:09', 'B0:8E:1A:36:03:09', null, '1237', '-205.69000244140625', '-202.38999938964844', '2019-07-08T13:33:07.1658499+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (212, '226', '雅马哈', '30389', 'B0:8E:1A:36:03:0C', 'B0:8E:1A:36:03:0C', null, '1230', '-73.38999938964844', '-53.91999816894531', '2019-07-08T13:33:07.1118445+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (213, '143', 'Model-D 测试05AC', '17457', 'B0:8E:1A:33:05:AC', 'B0:8E:1A:33:05:AC', null, '868', '-85.16999816894531', '-26.760000228881836', '2019-07-08T13:32:52.5203855+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (214, '203', '48', '29189', 'B0:8E:1A:41:1B:48', 'B0:8E:1A:41:1B:48', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7244058+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (215, '205', '44', '29190', 'B0:8E:1A:41:1B:44', 'B0:8E:1A:41:1B:44', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7304064+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (216, '212', '4A', '29213', 'B0:8E:1A:41:1B:4A', 'B0:8E:1A:41:1B:4A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8214155+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (217, '209', '4B', '29198', 'B0:8E:1A:41:1B:4B', 'B0:8E:1A:41:1B:4B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7654099+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (218, '204', '4E', '29217', 'B0:8E:1A:41:1B:4E', 'B0:8E:1A:41:1B:4E', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8394173+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (219, '234', '雅马哈01', '30498', 'B0:8E:1A:36:03:23', 'B0:8E:1A:36:03:23', null, '0', '0.0', '0.0', '2019-07-08T13:33:07.5108844+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (220, '220', '蔡曦铭Model D', '30382', 'B0:8E:1A:36:03:2F', 'B0:8E:1A:36:03:2F', null, '1237', '205.69000244140625', '202.38999938964844', '2019-07-08T13:33:07.0858419+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (221, '152', 'Model_D 0406（1-24）', '17772', 'B0:8E:1A:33:04:06', 'B0:8E:1A:33:04:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.555389+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (222, '147', 'Model_D 0404（1-24）', '17768', 'B0:8E:1A:33:04:04', 'B0:8E:1A:33:04:04', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.545388+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (223, '166', '王思琦', '13221', 'B0:8E:1A:40:0D:75', 'B0:8E:1A:40:0D:75', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3423677+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (224, '180', '潘桂成', '12860', 'B0:8E:1A:40:0D:77', 'B0:8E:1A:40:0D:77', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3213656+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (225, '181', '伍树灼', '12098', 'B0:8E:1A:40:0D:76', 'B0:8E:1A:40:0D:76', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2913626+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (226, '154', '渠立汉', '11522', 'B0:8E:1A:40:0A:A2', 'B0:8E:1A:40:0A:A2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.2413576+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (227, '146', '资产4FCA(1-5)', '12670', 'B0:8E:1A:50:4F:CA', 'B0:8E:1A:50:4F:CA', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3013636+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (228, '188', 'areoscout1', '20298', 'B0:8E:1A:41:03:D4', 'B0:8E:1A:41:03:D4', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6664001+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (229, '192', '贡云炳Home', '27262', 'B0:8E:1A:41:0C:F4', 'B0:8E:1A:41:0C:F4', null, '1169', '12.029999732971191', '10.5', '2019-07-08T13:32:55.6516986+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (230, '233', 'model b BC', '31793', 'B0:8E:1A:36:01:BC', 'B0:8E:1A:36:01:BC', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:12.2383571+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (231, '104', '赵慧', '14323', 'B0:8E:1A:40:0A:C2', 'B0:8E:1A:40:0A:C2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.4103745+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (232, '195', 'ModelD360302', '29182', '36:03:02:00:00:00', '36:03:02:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.696403+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (233, '237', '雅马哈04', '28438', 'B0:8E:1A:40:03:2E', 'B0:8E:1A:40:03:2E', null, '33', '40.84', '39.54', '2019-07-09T09:34:00.6693389+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (234, '248', '张大爷', '32282', 'B0:8E:1A:41:07:A0', 'B0:8E:1A:41:07:A0', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5174011+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (235, '229', '摔倒158A', '30279', 'B0:8E:1A:41:15:8A', 'B0:8E:1A:41:15:8A', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5284022+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (236, '241', '摔倒0794', '32279', 'B0:8E:1A:41:07:94', 'B0:8E:1A:41:07:94', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.516401+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (237, '221', '石福林', '11386', 'B0:8E:1A:40:0A:87', 'B0:8E:1A:40:0A:87', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5003994+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (238, '201', 'kkkkj', '11579', 'B0:8E:1A:40:0D:73', 'B0:8E:1A:40:0D:73', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5254019+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:37', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (239, '97', '武娟', '11355', 'B0:8E:1A:40:0A:71', 'B0:8E:1A:40:0A:71', '研发东北', '22', '24.86', '54.52', '2019-07-09T09:56:01.5234017+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (240, '246', '0C41', '32307', 'B0:8E:1A:41:0C:41', 'B0:8E:1A:41:0C:41', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5214015+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (241, '223', '测试223', '11545', 'B0:8E:1A:40:0E:DC', 'B0:8E:1A:40:0E:DC', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:54:54.4226923+08:00', to_date('09-07-2019 09:54:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (2, '29', '姜洪良', '11356', 'B0:8E:1A:40:0A:7C', 'B0:8E:1A:40:0A:7C', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1543489+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (3, '242', 'NB手环7405', '32534', '02:90:36:29:74:05', '02:90:36:29:74:05', null, '1400', '-3.119999885559082', '-2.390000104904175', '2019-07-08T13:33:14.9846317+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (4, '7', '董永平', '11381', 'B0:8E:1A:40:0F:90', '00010001', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1613496+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (5, '194', 'ModelD2000', '28326', 'B0:8E:1A:00:00:00', 'B0:8E:1A:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:59.5620896+08:00', to_date('08-07-2019 13:32:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (6, '240', '摔倒07CE', '32281', 'B0:8E:1A:41:07:CE', 'B0:8E:1A:41:07:CE', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:14.0465379+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (7, '248', '张大爷', '32282', 'B0:8E:1A:41:07:A0', 'B0:8E:1A:41:07:A0', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.0889044+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (8, '229', '摔倒158A', '30279', 'B0:8E:1A:41:15:8A', 'B0:8E:1A:41:15:8A', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.1019057+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (9, '231', '摔倒158B', '30277', 'B0:8E:1A:41:15:8B', 'B0:8E:1A:41:15:8B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.7028036+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (10, '241', '摔倒0794', '32279', 'B0:8E:1A:41:07:94', 'B0:8E:1A:41:07:94', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.0919047+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (11, '221', '石福林', '11386', 'B0:8E:1A:40:0A:87', 'B0:8E:1A:40:0A:87', null, '33', '-40.84', '-39.54', '2019-07-08T17:58:26.4285841+08:00', to_date('08-07-2019 17:58:26', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (12, '96', '马桶监测505488', '11003', 'B0:8E:1A:50:54:88', 'B0:8E:1A:50:54:88', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1293464+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (13, '201', 'kkkkj', '11579', 'B0:8E:1A:40:0D:73', 'B0:8E:1A:40:0D:73', null, '38', '88.77', '24.06', '2019-07-08T18:59:00.1009056+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (14, '222', 'B', '26585', 'B0:8E:1A:40:06:B0', 'B0:8E:1A:40:06:B0', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:53.0994434+08:00', to_date('08-07-2019 13:32:53', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:17', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (15, '202', 'ModelD360301', '30348', '36:03:01:00:00:00', '36:03:01:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.9598293+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (16, '210', '64', '29197', 'B0:8E:1A:41:1B:64', 'B0:8E:1A:41:1B:64', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7594093+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (17, '113', '摔倒', '14663', 'B0:8E:1A:40:0F:1B', 'B0:8E:1A:40:0F:1B', null, '957', '85.87000274658203', '30.559999465942383', '2019-07-08T13:32:52.4363771+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (18, '125', '蓝牙信号测试', '12866', 'B0:8E:1A:40:04:C8', 'B0:8E:1A:40:04:C8', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3283663+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (19, '72', '吴家晟737', '11385', 'B0:8E:1A:40:0A:7D', 'B0:8E:1A:40:0A:7D', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1763511+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (20, '97', '武娟', '11355', 'B0:8E:1A:40:0A:71', 'B0:8E:1A:40:0A:71', null, '38', '-88.77', '-24.06', '2019-07-08T18:01:55.7445136+08:00', to_date('08-07-2019 18:01:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (21, '145', 'Model-D 测试053A', '17485', 'B0:8E:1A:33:05:3A', 'B0:8E:1A:33:05:3A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5313866+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (22, '170', 'Model-B test 0266', '21462', 'B0:8E:1A:36:02:66', 'B0:8E:1A:36:02:66', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6824017+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (23, '232', 'model b F2', '31795', 'B0:8E:1A:36:01:F2', 'B0:8E:1A:36:01:F2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:12.2533586+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (24, '193', '吴晟', '27066', 'B0:8E:1A:41:10:EE', 'B0:8E:1A:41:10:EE', null, '1138', '-42.7400016784668', '-7.190000057220459', '2019-07-08T13:32:54.9576292+08:00', to_date('08-07-2019 13:32:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (25, '197', 'ModelDV23602FC', '30140', '36:02:FC:00:00:00', '36:02:FC:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.2017535+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (26, '158', '测试卡片2', '19918', 'B0:8E:1A:40:21:92', 'B0:8E:1A:40:21:92', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.6063941+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (27, '246', '0C41', '32307', 'B0:8E:1A:41:0C:41', 'B0:8E:1A:41:0C:41', null, '33', '40.84', '39.54', '2019-07-08T18:59:00.0819037+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (28, '223', '测试223', '11545', 'B0:8E:1A:40:0E:DC', 'B0:8E:1A:40:0E:DC', null, '33', '40.84', '39.54', '2019-07-08T18:59:00.0959051+08:00', to_date('08-07-2019 18:59:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (29, '141', 'Model-D 测试051E', '17415', 'B0:8E:1A:33:05:1E', 'B0:8E:1A:33:05:1E', null, '38', '-85.39399719238281', '-21.90399932861328', '2019-07-08T13:32:52.5033838+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (30, '217', '董永平Model D', '28842', 'B0:8E:1A:36:02:FA', 'B0:8E:1A:36:02:FA', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:01.436277+08:00', to_date('08-07-2019 13:33:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (31, '148', 'Model_D 04F0（1-24）', '17775', 'B0:8E:1A:33:04:F0', 'B0:8E:1A:33:04:F0', null, '38', '-86.52385711669922', '-24.785438537597656', '2019-07-08T13:32:52.5803915+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (32, '178', '拉绳350035', '23471', 'B0:8E:1A:35:00:35', 'B0:8E:1A:35:00:35', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.715405+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (33, '177', '拉绳350036', '23472', 'B0:8E:1A:35:00:36', 'B0:8E:1A:35:00:36', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7224057+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (34, '133', '资产4FE8(9-26)', '11561', 'B0:8E:1A:50:4F:E8', 'B0:8E:1A:50:4F:E8', null, '38', '88.77', '24.06', '2019-07-08T18:57:19.9988964+08:00', to_date('08-07-2019 18:57:19', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (35, '168', 'Model-B test 01D5', '21608', 'B0:8E:1A:36:01:D5', 'B0:8E:1A:36:01:D5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7004035+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (36, '174', '李全宝', '17156', 'B0:8E:1A:40:1A:B5', 'B0:8E:1A:40:1A:B5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4863821+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (37, '239', 'NB演示', '32490', '02:90:36:42:64:83', '02:90:36:42:64:83', null, '1259', '-13.6899995803833', '-6.099999904632568', '2019-07-08T13:33:14.817615+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (38, '216', 'wifi蓝牙标签0333', '30655', 'B0:8E:1A:36:03:33', 'B0:8E:1A:36:03:33', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:08.0699403+08:00', to_date('08-07-2019 13:33:08', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (39, '244', 'dyp10002', '30398', 'B0:8E:1A:36:03:30', '00010002', null, '38', '88.77', '24.06', '2019-07-08T18:58:59.1028058+08:00', to_date('08-07-2019 18:58:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (40, '64', '高燕', '11500', 'B0:8E:1A:40:0A:F2', 'B0:8E:1A:40:0A:F2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.2193554+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (41, '137', '黄-Model-D 0019', '16375', 'B0:8E:1A:40:0A:F7', 'B0:8E:1A:40:0A:F7', null, '38', '88.77', '24.06', '2019-07-08T18:58:56.0965052+08:00', to_date('08-07-2019 18:58:56', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (42, '167', '蔡曦铭', '11406', 'B0:8E:1A:40:0E:FF', 'B0:8E:1A:40:0E:FF', null, '38', '-88.77', '-24.06', '2019-07-08T18:03:02.0711456+08:00', to_date('08-07-2019 18:03:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (43, '247', '1315', '11320', 'B0:8E:1A:50:13:15', 'B0:8E:1A:50:13:15', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.135347+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (44, '179', '梁琰佳', '16448', 'B0:8E:1A:40:0D:01', 'B0:8E:1A:40:0D:01', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.4763811+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (45, '31', '陆萍萍', '11511', 'B0:8E:1A:40:0F:95', 'B0:8E:1A:40:0F:95', null, '38', '-88.77', '-24.06', '2019-07-08T17:56:54.2993721+08:00', to_date('08-07-2019 17:56:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (46, '103', '黄东升', '29949', 'B0:8E:1A:41:09:08', 'B0:8E:1A:41:09:08', null, '38', '-88.77', '-24.06', '2019-07-08T17:58:43.559297+08:00', to_date('08-07-2019 17:58:43', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (47, '131', 'ESP马桶检测000B', '16273', 'B0:8E:1A:40:00:0B', 'B0:8E:1A:40:00:0B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4463781+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (48, '187', '1D60', '27261', 'B0:8E:1A:40:1D:60', 'B0:8E:1A:40:1D:60', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:55.645698+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (49, '200', '9b', '26520', 'B0:8E:1A:41:11:9B', 'B0:8E:1A:41:11:9B', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.7584093+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (50, '110', '摔倒0000', '13608', 'B0:8E:1A:40:00:00', 'B0:8E:1A:40:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3493684+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (51, '111', '摔倒1126', '14332', 'B0:8E:1A:40:11:26', 'B0:8E:1A:40:11:26', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4183753+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (52, '63', '时林虎', '11516', 'B0:8E:1A:40:0A:95', 'B0:8E:1A:40:0A:95', null, '33', '-40.84', '-39.54', '2019-07-08T17:35:37.10367+08:00', to_date('08-07-2019 17:35:37', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (53, '155', 'model_b', '20121', 'B0:8E:1A:36:11:11', 'B0:8E:1A:36:11:11', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.615395+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
commit;
prompt 100 records committed...
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (54, '9', '杨亦铭', '11492', 'B0:8E:1A:40:0A:BB', 'B0:8E:1A:40:0A:BB', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.2113546+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (55, '150', 'Model_D 0434（1-24）', '17773', 'B0:8E:1A:33:04:34', 'B0:8E:1A:33:04:34', null, '1139', '-45.43000030517578', '-5.789999961853027', '2019-07-08T13:32:52.5633898+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (56, '245', '手环01', '32613', 'B0:8E:5A:00:00:01', 'B0:8E:5A:00:00:01', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:15.2986631+08:00', to_date('08-07-2019 13:33:15', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (57, '196', 'ModeD3602FB', '29464', '36:02:FB:00:00:00', '36:02:FB:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.7725106+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (58, '45', '贡云炳', '11384', 'B0:8E:1A:40:0A:6F', 'B0:8E:1A:40:0A:6F', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1673502+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (59, '224', '1589', '30268', 'B0:8E:1A:41:15:89', 'B0:8E:1A:41:15:89', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.6607994+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (60, '235', '雅马哈02', '30400', 'B0:8E:1A:36:03:10', 'B0:8E:1A:36:03:10', null, '1235', '-112.12999725341797', '-200.58999633789062', '2019-07-08T13:33:07.1538487+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (61, '84', '周乾', '11573', 'B0:8E:1A:40:0A:D4', 'B0:8E:1A:40:0A:D4', null, '33', '40.84', '39.54', '2019-07-08T18:59:01.0910046+08:00', to_date('08-07-2019 18:59:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (62, '189', 'areoscout2', '20775', 'B0:8E:1A:41:01:D2', 'B0:8E:1A:41:01:D2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6744009+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (63, '159', '测试卡片3', '19824', 'B0:8E:1A:40:22:2E', 'B0:8E:1A:40:22:2E', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.5933928+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (64, '207', '52', '29199', 'B0:8E:1A:41:1B:52', 'B0:8E:1A:41:1B:52', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7704104+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (65, '206', '56', '29218', 'B0:8E:1A:41:1B:56', 'B0:8E:1A:41:1B:56', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8454179+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (66, '208', '5A', '29186', 'B0:8E:1A:41:1B:5A', 'B0:8E:1A:41:1B:5A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7124046+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (67, '165', '李立峰', '13077', 'B0:8E:1A:40:0D:84', 'B0:8E:1A:40:0D:84', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3343669+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (68, '106', 'test0980', '13792', 'B0:8E:1A:90:09:80', 'B0:8E:1A:90:09:80', null, '0', '1.0', '1.0', '2019-07-08T13:32:52.355369+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (69, '163', 'model_b004', '20162', 'B0:8E:1A:36:00:04', 'B0:8E:1A:36:00:04', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6593994+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (70, '164', 'Model-B 0003', '20161', 'B0:8E:1A:36:00:03', 'B0:8E:1A:36:00:03', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6473982+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (71, '160', 'ModelB02', '20160', 'B0:8E:1A:36:00:02', 'B0:8E:1A:36:00:02', null, '946', '-85.97000122070312', '-11.779999732971191', '2019-07-08T13:32:52.6403975+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (72, '162', 'ModelB01', '20127', 'B0:8E:1A:36:00:01', 'B0:8E:1A:36:00:01', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6233958+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (73, '161', 'ModelB00', '20159', 'B0:8E:1A:36:00:00', 'B0:8E:1A:36:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6313966+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (74, '211', '3D', '29432', 'B0:8E:1A:41:1B:3D', 'B0:8E:1A:41:1B:3D', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.646498+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (75, '107', 'test3C3B', '11548', 'B0:8E:1A:50:3C:3B', 'B0:8E:1A:50:3C:3B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.255359+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (76, '171', '拉绳test 0006', '22652', 'B0:8E:1A:34:00:06', 'B0:8E:1A:34:00:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7074042+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (77, '149', 'Model_D 0566（1-24）', '17774', 'B0:8E:1A:33:05:66', 'B0:8E:1A:33:05:66', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5723907+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (78, '112', '谢晓威', '14449', 'B0:8E:1A:40:0D:B3', 'B0:8E:1A:40:0D:B3', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4273762+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (79, '186', '0D68', '27260', 'B0:8E:1A:41:0D:68', 'B0:8E:1A:41:0D:68', null, '1160', '-3.7899999618530273', '-3.869999885559082', '2019-07-08T13:32:55.6406975+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (80, '214', '蓝牙标签0129-360351', '30420', 'B0:8E:1A:36:03:51', 'B0:8E:1A:36:03:51', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:07.2298563+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (81, '151', 'Model_D 011A（1-24）', '17745', 'B0:8E:1A:33:01:1A', 'B0:8E:1A:33:01:1A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5383873+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (82, '243', '楚云飞', '27776', 'B0:8E:1A:41:10:80', 'B0:8E:1A:41:10:80', null, '33', '40.84', '39.54', '2019-07-08T18:59:01.0960051+08:00', to_date('08-07-2019 18:59:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (83, '238', '3568', '32059', '02:90:30:35:35:68', '02:90:30:35:35:68', null, '1242', '-91.06999969482422', '-37.7400016784668', '2019-07-08T13:33:13.2344567+08:00', to_date('08-07-2019 13:33:13', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (84, '144', 'Model-D 测试0548', '17429', 'B0:8E:1A:33:05:48', 'B0:8E:1A:33:05:48', null, '38', '-85.63287353515625', '-23.543903350830078', '2019-07-08T13:32:52.5123847+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (85, '142', 'Model-D 测试0544', '17399', 'B0:8E:1A:33:05:44', 'B0:8E:1A:33:05:44', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.4923827+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (86, '153', 'NEWAPI4796', '11449', 'B0:8E:1A:50:47:96', 'B0:8E:1A:50:47:96', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2043539+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (87, '225', '0019', '14130', 'B0:8E:1A:40:00:19', 'B0:8E:1A:40:00:19', null, '0', '-1.0', '-1.0', '2019-07-08T13:32:52.3843719+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (88, '136', '测试0013', '16423', 'B0:8E:1A:40:00:13', 'B0:8E:1A:40:00:13', null, '33', '-44.05439376831055', '-38.5018424987793', '2019-07-08T13:32:52.4693804+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (89, '135', '0015蓝牙标签(1103 17:00)', '14145', 'B0:8E:1A:40:00:15', 'B0:8E:1A:40:00:15', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3923727+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (90, '138', '董-Model-D 0017', '14096', 'B0:8E:1A:40:00:17', 'B0:8E:1A:40:00:17', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:32:52.36537+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (91, '139', '杨-Model-D 0016', '14100', 'B0:8E:1A:40:00:16', 'B0:8E:1A:40:00:16', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.3743709+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (92, '169', 'Model-B test 0295', '21494', 'B0:8E:1A:36:02:95', 'B0:8E:1A:36:02:95', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6904025+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (93, '126', '蓝牙信号测试1', '12844', 'B0:8E:1A:40:0E:C8', 'B0:8E:1A:40:0E:C8', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.3143649+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (94, '46', '龚丽珍', '11408', 'B0:8E:1A:40:0A:EB', 'B0:8E:1A:40:0A:EB', null, '38', '-88.77', '-24.06', '2019-07-08T17:57:02.2361657+08:00', to_date('08-07-2019 17:57:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (95, '236', '雅马哈03', '30403', 'B0:8E:1A:36:03:09', 'B0:8E:1A:36:03:09', null, '1237', '-205.69000244140625', '-202.38999938964844', '2019-07-08T13:33:07.1658499+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (96, '226', '雅马哈', '30389', 'B0:8E:1A:36:03:0C', 'B0:8E:1A:36:03:0C', null, '1230', '-73.38999938964844', '-53.91999816894531', '2019-07-08T13:33:07.1118445+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (97, '143', 'Model-D 测试05AC', '17457', 'B0:8E:1A:33:05:AC', 'B0:8E:1A:33:05:AC', null, '868', '-85.16999816894531', '-26.760000228881836', '2019-07-08T13:32:52.5203855+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (98, '203', '48', '29189', 'B0:8E:1A:41:1B:48', 'B0:8E:1A:41:1B:48', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7244058+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (99, '205', '44', '29190', 'B0:8E:1A:41:1B:44', 'B0:8E:1A:41:1B:44', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7304064+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (100, '212', '4A', '29213', 'B0:8E:1A:41:1B:4A', 'B0:8E:1A:41:1B:4A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8214155+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (101, '209', '4B', '29198', 'B0:8E:1A:41:1B:4B', 'B0:8E:1A:41:1B:4B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7654099+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (102, '204', '4E', '29217', 'B0:8E:1A:41:1B:4E', 'B0:8E:1A:41:1B:4E', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8394173+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (103, '234', '雅马哈01', '30498', 'B0:8E:1A:36:03:23', 'B0:8E:1A:36:03:23', null, '0', '0.0', '0.0', '2019-07-08T13:33:07.5108844+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (104, '220', '蔡曦铭Model D', '30382', 'B0:8E:1A:36:03:2F', 'B0:8E:1A:36:03:2F', null, '1237', '205.69000244140625', '202.38999938964844', '2019-07-08T13:33:07.0858419+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (105, '152', 'Model_D 0406（1-24）', '17772', 'B0:8E:1A:33:04:06', 'B0:8E:1A:33:04:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.555389+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (106, '147', 'Model_D 0404（1-24）', '17768', 'B0:8E:1A:33:04:04', 'B0:8E:1A:33:04:04', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.545388+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (107, '166', '王思琦', '13221', 'B0:8E:1A:40:0D:75', 'B0:8E:1A:40:0D:75', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3423677+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (108, '180', '潘桂成', '12860', 'B0:8E:1A:40:0D:77', 'B0:8E:1A:40:0D:77', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3213656+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (109, '181', '伍树灼', '12098', 'B0:8E:1A:40:0D:76', 'B0:8E:1A:40:0D:76', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.2913626+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (110, '154', '渠立汉', '11522', 'B0:8E:1A:40:0A:A2', 'B0:8E:1A:40:0A:A2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.2413576+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (111, '146', '资产4FCA(1-5)', '12670', 'B0:8E:1A:50:4F:CA', 'B0:8E:1A:50:4F:CA', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3013636+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (112, '188', 'areoscout1', '20298', 'B0:8E:1A:41:03:D4', 'B0:8E:1A:41:03:D4', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6664001+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (113, '192', '贡云炳Home', '27262', 'B0:8E:1A:41:0C:F4', 'B0:8E:1A:41:0C:F4', null, '1169', '12.029999732971191', '10.5', '2019-07-08T13:32:55.6516986+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (114, '233', 'model b BC', '31793', 'B0:8E:1A:36:01:BC', 'B0:8E:1A:36:01:BC', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:12.2383571+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (115, '104', '赵慧', '14323', 'B0:8E:1A:40:0A:C2', 'B0:8E:1A:40:0A:C2', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.4103745+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (116, '195', 'ModelD360302', '29182', '36:03:02:00:00:00', '36:03:02:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.696403+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (117, '237', '雅马哈04', '28438', 'B0:8E:1A:40:03:2E', 'B0:8E:1A:40:03:2E', null, '38', '88.77', '24.06', '2019-07-08T18:59:01.0840039+08:00', to_date('08-07-2019 18:59:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('05-07-2019 11:12:18', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (118, '29', '姜洪良', '11356', 'B0:8E:1A:40:0A:7C', 'B0:8E:1A:40:0A:7C', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1543489+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (119, '242', 'NB手环7405', '32534', '02:90:36:29:74:05', '02:90:36:29:74:05', null, '1400', '-3.119999885559082', '-2.390000104904175', '2019-07-08T13:33:14.9846317+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (120, '7', '董永平', '11381', 'B0:8E:1A:40:0F:90', '00010001', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1613496+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (121, '194', 'ModelD2000', '28326', 'B0:8E:1A:00:00:00', 'B0:8E:1A:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:59.5620896+08:00', to_date('08-07-2019 13:32:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (122, '240', '摔倒07CE', '32281', 'B0:8E:1A:41:07:CE', 'B0:8E:1A:41:07:CE', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:14.0465379+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (123, '248', '张大爷', '32282', 'B0:8E:1A:41:07:A0', 'B0:8E:1A:41:07:A0', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6932413+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (124, '229', '摔倒158A', '30279', 'B0:8E:1A:41:15:8A', 'B0:8E:1A:41:15:8A', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6952415+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (125, '231', '摔倒158B', '30277', 'B0:8E:1A:41:15:8B', 'B0:8E:1A:41:15:8B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.7028036+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (126, '241', '摔倒0794', '32279', 'B0:8E:1A:41:07:94', 'B0:8E:1A:41:07:94', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6962416+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (127, '221', '石福林', '11386', 'B0:8E:1A:40:0A:87', 'B0:8E:1A:40:0A:87', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6822402+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (128, '96', '马桶监测505488', '11003', 'B0:8E:1A:50:54:88', 'B0:8E:1A:50:54:88', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.1293464+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (129, '201', 'kkkkj', '11579', 'B0:8E:1A:40:0D:73', 'B0:8E:1A:40:0D:73', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6952415+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (130, '222', 'B', '26585', 'B0:8E:1A:40:06:B0', 'B0:8E:1A:40:06:B0', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:53.0994434+08:00', to_date('08-07-2019 13:32:53', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (131, '202', 'ModelD360301', '30348', '36:03:01:00:00:00', '36:03:01:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:06.9598293+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (132, '210', '64', '29197', 'B0:8E:1A:41:1B:64', 'B0:8E:1A:41:1B:64', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7594093+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (133, '113', '摔倒', '14663', 'B0:8E:1A:40:0F:1B', 'B0:8E:1A:40:0F:1B', null, '957', '85.87000274658203', '30.559999465942383', '2019-07-08T13:32:52.4363771+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (134, '125', '蓝牙信号测试', '12866', 'B0:8E:1A:40:04:C8', 'B0:8E:1A:40:04:C8', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3283663+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (135, '72', '吴家晟737', '11385', 'B0:8E:1A:40:0A:7D', 'B0:8E:1A:40:0A:7D', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1763511+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (136, '97', '武娟', '11355', 'B0:8E:1A:40:0A:71', 'B0:8E:1A:40:0A:71', null, '22', '24.86', '54.52', '2019-07-09T09:33:59.690241+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (137, '145', 'Model-D 测试053A', '17485', 'B0:8E:1A:33:05:3A', 'B0:8E:1A:33:05:3A', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5313866+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (138, '170', 'Model-B test 0266', '21462', 'B0:8E:1A:36:02:66', 'B0:8E:1A:36:02:66', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6824017+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (139, '232', 'model b F2', '31795', 'B0:8E:1A:36:01:F2', 'B0:8E:1A:36:01:F2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:12.2533586+08:00', to_date('08-07-2019 13:33:12', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (140, '193', '吴晟', '27066', 'B0:8E:1A:41:10:EE', 'B0:8E:1A:41:10:EE', null, '1138', '-42.7400016784668', '-7.190000057220459', '2019-07-08T13:32:54.9576292+08:00', to_date('08-07-2019 13:32:54', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (141, '197', 'ModelDV23602FC', '30140', '36:02:FC:00:00:00', '36:02:FC:00:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.2017535+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (142, '158', '测试卡片2', '19918', 'B0:8E:1A:40:21:92', 'B0:8E:1A:40:21:92', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.6063941+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (143, '246', '0C41', '32307', 'B0:8E:1A:41:0C:41', 'B0:8E:1A:41:0C:41', null, '33', '40.84', '39.54', '2019-07-09T09:33:59.6942414+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (144, '223', '测试223', '11545', 'B0:8E:1A:40:0E:DC', 'B0:8E:1A:40:0E:DC', null, '38', '88.77', '24.06', '2019-07-09T09:33:58.6821402+08:00', to_date('09-07-2019 09:33:58', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (145, '141', 'Model-D 测试051E', '17415', 'B0:8E:1A:33:05:1E', 'B0:8E:1A:33:05:1E', null, '38', '-85.39399719238281', '-21.90399932861328', '2019-07-08T13:32:52.5033838+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (146, '217', '董永平Model D', '28842', 'B0:8E:1A:36:02:FA', 'B0:8E:1A:36:02:FA', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:01.436277+08:00', to_date('08-07-2019 13:33:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (147, '148', 'Model_D 04F0（1-24）', '17775', 'B0:8E:1A:33:04:F0', 'B0:8E:1A:33:04:F0', null, '38', '-86.52385711669922', '-24.785438537597656', '2019-07-08T13:32:52.5803915+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (148, '178', '拉绳350035', '23471', 'B0:8E:1A:35:00:35', 'B0:8E:1A:35:00:35', null, '35', '-28.059999465942383', '-17.56999969482422', '2019-07-08T13:32:52.715405+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (149, '177', '拉绳350036', '23472', 'B0:8E:1A:35:00:36', 'B0:8E:1A:35:00:36', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7224057+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (150, '133', '资产4FE8(9-26)', '11561', 'B0:8E:1A:50:4F:E8', 'B0:8E:1A:50:4F:E8', null, '38', '-88.77', '-24.06', '2019-07-09T09:31:38.7141448+08:00', to_date('09-07-2019 09:31:38', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (151, '168', 'Model-B test 01D5', '21608', 'B0:8E:1A:36:01:D5', 'B0:8E:1A:36:01:D5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7004035+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (152, '174', '李全宝', '17156', 'B0:8E:1A:40:1A:B5', 'B0:8E:1A:40:1A:B5', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4863821+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (153, '239', 'NB演示', '32490', '02:90:36:42:64:83', '02:90:36:42:64:83', null, '1259', '-13.6899995803833', '-6.099999904632568', '2019-07-08T13:33:14.817615+08:00', to_date('08-07-2019 13:33:14', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
commit;
prompt 200 records committed...
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (154, '216', 'wifi蓝牙标签0333', '30655', 'B0:8E:1A:36:03:33', 'B0:8E:1A:36:03:33', null, '38', '88.7699966430664', '24.059999465942383', '2019-07-08T13:33:08.0699403+08:00', to_date('08-07-2019 13:33:08', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (155, '244', 'dyp10002', '30398', 'B0:8E:1A:36:03:30', '00010002', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6892409+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (156, '64', '高燕', '11500', 'B0:8E:1A:40:0A:F2', 'B0:8E:1A:40:0A:F2', null, '24', '54.12', '54.62', '2019-07-09T09:33:59.6892409+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (157, '137', '黄-Model-D 0019', '16375', 'B0:8E:1A:40:0A:F7', 'B0:8E:1A:40:0A:F7', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6912411+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (158, '167', '蔡曦铭', '11406', 'B0:8E:1A:40:0E:FF', 'B0:8E:1A:40:0E:FF', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6922412+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (159, '247', '1315', '11320', 'B0:8E:1A:50:13:15', 'B0:8E:1A:50:13:15', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.135347+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (160, '179', '梁琰佳', '16448', 'B0:8E:1A:40:0D:01', 'B0:8E:1A:40:0D:01', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.4763811+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (161, '31', '陆萍萍', '11511', 'B0:8E:1A:40:0F:95', 'B0:8E:1A:40:0F:95', null, '21', '27.66', '35.05', '2019-07-09T09:33:59.6812401+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (162, '103', '黄东升', '29949', 'B0:8E:1A:41:09:08', 'B0:8E:1A:41:09:08', null, '38', '88.77', '24.06', '2019-07-09T09:33:59.6712391+08:00', to_date('09-07-2019 09:33:59', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:34', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (163, '131', 'ESP马桶检测000B', '16273', 'B0:8E:1A:40:00:0B', 'B0:8E:1A:40:00:0B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4463781+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (164, '187', '1D60', '27261', 'B0:8E:1A:40:1D:60', 'B0:8E:1A:40:1D:60', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:55.645698+08:00', to_date('08-07-2019 13:32:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (165, '200', '9b', '26520', 'B0:8E:1A:41:11:9B', 'B0:8E:1A:41:11:9B', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.7584093+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (166, '110', '摔倒0000', '13608', 'B0:8E:1A:40:00:00', 'B0:8E:1A:40:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.3493684+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (167, '111', '摔倒1126', '14332', 'B0:8E:1A:40:11:26', 'B0:8E:1A:40:11:26', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.4183753+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (168, '63', '时林虎', '11516', 'B0:8E:1A:40:0A:95', 'B0:8E:1A:40:0A:95', null, '38', '88.77', '24.06', '2019-07-09T09:33:56.6719392+08:00', to_date('09-07-2019 09:33:56', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (169, '155', 'model_b', '20121', 'B0:8E:1A:36:11:11', 'B0:8E:1A:36:11:11', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.615395+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (170, '9', '杨亦铭', '11492', 'B0:8E:1A:40:0A:BB', 'B0:8E:1A:40:0A:BB', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.2113546+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (171, '150', 'Model_D 0434（1-24）', '17773', 'B0:8E:1A:33:04:34', 'B0:8E:1A:33:04:34', null, '1139', '-45.43000030517578', '-5.789999961853027', '2019-07-08T13:32:52.5633898+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (172, '245', '手环01', '32613', 'B0:8E:5A:00:00:01', 'B0:8E:5A:00:00:01', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:15.2986631+08:00', to_date('08-07-2019 13:33:15', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (173, '196', 'ModeD3602FB', '29464', '36:02:FB:00:00:00', '36:02:FB:00:00:00', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.7725106+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (174, '45', '贡云炳', '11384', 'B0:8E:1A:40:0A:6F', 'B0:8E:1A:40:0A:6F', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.1673502+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (175, '224', '1589', '30268', 'B0:8E:1A:41:15:89', 'B0:8E:1A:41:15:89', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:33:06.6607994+08:00', to_date('08-07-2019 13:33:06', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (176, '235', '雅马哈02', '30400', 'B0:8E:1A:36:03:10', 'B0:8E:1A:36:03:10', null, '1235', '-112.12999725341797', '-200.58999633789062', '2019-07-08T13:33:07.1538487+08:00', to_date('08-07-2019 13:33:07', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (177, '84', '周乾', '11573', 'B0:8E:1A:40:0A:D4', 'B0:8E:1A:40:0A:D4', null, '33', '40.84', '39.54', '2019-07-09T09:34:00.6883408+08:00', to_date('09-07-2019 09:34:00', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (178, '189', 'areoscout2', '20775', 'B0:8E:1A:41:01:D2', 'B0:8E:1A:41:01:D2', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6744009+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (179, '159', '测试卡片3', '19824', 'B0:8E:1A:40:22:2E', 'B0:8E:1A:40:22:2E', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.5933928+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (180, '207', '52', '29199', 'B0:8E:1A:41:1B:52', 'B0:8E:1A:41:1B:52', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7704104+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (181, '206', '56', '29218', 'B0:8E:1A:41:1B:56', 'B0:8E:1A:41:1B:56', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.8454179+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (182, '208', '5A', '29186', 'B0:8E:1A:41:1B:5A', 'B0:8E:1A:41:1B:5A', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:02.7124046+08:00', to_date('08-07-2019 13:33:02', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (183, '165', '李立峰', '13077', 'B0:8E:1A:40:0D:84', 'B0:8E:1A:40:0D:84', null, '0', '0.0', '0.0', '2019-07-08T13:32:52.3343669+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (184, '106', 'test0980', '13792', 'B0:8E:1A:90:09:80', 'B0:8E:1A:90:09:80', null, '0', '1.0', '1.0', '2019-07-08T13:32:52.355369+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (185, '163', 'model_b004', '20162', 'B0:8E:1A:36:00:04', 'B0:8E:1A:36:00:04', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6593994+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (186, '164', 'Model-B 0003', '20161', 'B0:8E:1A:36:00:03', 'B0:8E:1A:36:00:03', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6473982+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (187, '160', 'ModelB02', '20160', 'B0:8E:1A:36:00:02', 'B0:8E:1A:36:00:02', null, '946', '-85.97000122070312', '-11.779999732971191', '2019-07-08T13:32:52.6403975+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (188, '162', 'ModelB01', '20127', 'B0:8E:1A:36:00:01', 'B0:8E:1A:36:00:01', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.6233958+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (189, '161', 'ModelB00', '20159', 'B0:8E:1A:36:00:00', 'B0:8E:1A:36:00:00', null, '33', '-40.84000015258789', '-39.540000915527344', '2019-07-08T13:32:52.6313966+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (190, '211', '3D', '29432', 'B0:8E:1A:41:1B:3D', 'B0:8E:1A:41:1B:3D', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:33:03.646498+08:00', to_date('08-07-2019 13:33:03', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (191, '107', 'test3C3B', '11548', 'B0:8E:1A:50:3C:3B', 'B0:8E:1A:50:3C:3B', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.255359+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (192, '171', '拉绳test 0006', '22652', 'B0:8E:1A:34:00:06', 'B0:8E:1A:34:00:06', null, '38', '-88.7699966430664', '-24.059999465942383', '2019-07-08T13:32:52.7074042+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (193, '149', 'Model_D 0566（1-24）', '17774', 'B0:8E:1A:33:05:66', 'B0:8E:1A:33:05:66', null, '867', '-79.18000030517578', '-26.959999084472656', '2019-07-08T13:32:52.5723907+08:00', to_date('08-07-2019 13:32:52', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:33:35', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (242, '133', '资产4FE8(9-26)', '11561', 'B0:8E:1A:50:4F:E8', 'B0:8E:1A:50:4F:E8', '101洗漱间', '38', '-88.77', '-24.06', '2019-07-09T09:51:55.4978016+08:00', to_date('09-07-2019 09:51:55', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (243, '244', 'dyp10002', '30398', 'B0:8E:1A:36:03:30', '00010002', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5224016+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (244, '64', '高燕', '11500', 'B0:8E:1A:40:0A:F2', 'B0:8E:1A:40:0A:F2', '研发西北', '24', '54.12', '54.62', '2019-07-09T09:56:01.5234017+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (245, '137', '黄-Model-D 0019', '16375', 'B0:8E:1A:40:0A:F7', 'B0:8E:1A:40:0A:F7', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5234017+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (246, '167', '蔡曦铭', '11406', 'B0:8E:1A:40:0E:FF', 'B0:8E:1A:40:0E:FF', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5244018+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (247, '31', '陆萍萍', '11511', 'B0:8E:1A:40:0F:95', 'B0:8E:1A:40:0F:95', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5094003+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (248, '103', '黄东升', '29949', 'B0:8E:1A:41:09:08', 'B0:8E:1A:41:09:08', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5064+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (249, '63', '时林虎', '11516', 'B0:8E:1A:40:0A:95', 'B0:8E:1A:40:0A:95', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5064+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (250, '84', '周乾', '11573', 'B0:8E:1A:40:0A:D4', 'B0:8E:1A:40:0A:D4', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5174011+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (251, '243', '楚云飞', '27776', 'B0:8E:1A:41:10:80', 'B0:8E:1A:41:10:80', '101客厅', '33', '40.84', '39.54', '2019-07-09T09:56:01.5224016+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (252, '46', '龚丽珍', '11408', 'B0:8E:1A:40:0A:EB', 'B0:8E:1A:40:0A:EB', '101卧室', '21', '27.66', '35.05', '2019-07-09T09:56:01.5244018+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
insert into PG_TAGPOSITION (id, hostid, hostname, tagid, tagmac, tagmacname, coordinatesname, coordinate, x, y, positionupdatetime, parsedtime, querytime)
values (253, '237', '雅马哈04', '28438', 'B0:8E:1A:40:03:2E', 'B0:8E:1A:40:03:2E', '101洗漱间', '38', '88.77', '24.06', '2019-07-09T09:56:01.5074001+08:00', to_date('09-07-2019 09:56:01', 'dd-mm-yyyy hh24:mi:ss'), to_date('07-07-2019 01:55:38', 'dd-mm-yyyy hh24:mi:ss'));
commit;
prompt 252 records loaded
prompt Enabling triggers for PG_TAGPOSITION...
alter table PG_TAGPOSITION enable all triggers;

create or replace view tagpositionview as
select hostId "hostId",hostName "hostName" ,X ,Y ,tagMac "tagMac",
positionUpdateTime "positionUpdateTime" ,
coordinatesName "coordinatesName"
 from pg_tagposition where id in (
select max(id) from pg_tagposition
--where querytime between sysdate-1/12 and sysdate
group by hostid
)
;

set feedback on
set define on
prompt Done