Página inicial Explorar Ajuda
Entrar
zhangtao
/
programs_info
Observar 1
Favorito 0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: 099f5d4f5a
Branches Tags
programs_info
/
无锡市生命线项目
/
数据库备份
/
删除前备份
/
导出文件
/
video_channel.sql

video_channel.sql 16 KB
Histórico Raw

1234567891011121314151617181920212223 
  1. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32020026001310001931', '0', '五湖大道辅道出入口1细节', '无锡市/梁溪区', '32021153001320019049', '江苏省/无锡市/无锡市公安局/大数据支队', '清宁大桥', '枪机', '1', '海康', '市政设施中心', 'http://2.22.134.194:83/openUrl/it0QCru/live.m3u8', '1', '', 0, 1, '2024-01-12 00:05:47.961', '', '2024-01-23 03:04:16.551', 'admin', '0101000000406E463754538341E140810940A34A41', '海康');
    2. 

  2. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('B9E52397983641A9B03F74A1195D6CC4', NULL, '锡东取水口', '320205', NULL, '锡东水厂', '水源地', 'DS-2CD3T46WD-13', NULL, '海康威视', '无锡市水务集团有限公司', '172.20.2.2', NULL, NULL, 0, 1, '2024-01-12 00:05:47.898', NULL, NULL, NULL, '01010000208A1100008FC2F5942A548341000000C0488E4A41', NULL);
    3. 

  3. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('327742F8CFF4423890C775B9677DE53D', NULL, '南泉三公里取水口', '320211', NULL, '南泉水厂', '水源地', 'DS-2DE5230W-D', NULL, '海康威视', '无锡市水务集团有限公司', '172.20.3.2', NULL, NULL, 0, 1, '2024-01-12 00:05:47.901', NULL, NULL, NULL, '01010000208A1100006666664283528341713D0AF7A7834A41', NULL);
    4. 

  4. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('1845F25314EE4546A6E39872768716C1', NULL, '澄西取水口', '320281', NULL, '澄西水厂', '水源地', 'iDS-2DC7423MWR-A', NULL, '海康威视', '无锡市水务集团有限公司', '172.20.7.2', NULL, NULL, 0, 1, '2024-01-12 00:05:47.903', NULL, NULL, NULL, '01010000208A110000000000F6D75083418FC2F588E7F84A41', NULL);
    5. 

  5. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB42D10A5DF8A912A996F00005', NULL, '谢湾桥', '320211', NULL, '无锡市滨湖区高浪路与贡湖大道交叉口以西300米', 'b99f1bcce82c1dfe043ac5eb77010316', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.918', NULL, NULL, NULL, '0101000020B0110000236DCB9E8C538341D421EC51C49A4A41', NULL);
    6. 

  6. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB410D0A6B5DEE5281E6F00003', NULL, '高浪西路立德道东南', '320211', NULL, '无锡市滨湖区高浪西路南侧立德道东侧金匮网球场西侧绿化带', '41175e6421d73e16bb01f3c807bc5a5f', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.921', NULL, NULL, NULL, '0101000020B0110000F4F4F04177538341F89A31F74F9A4A41', NULL);
    7. 

  7. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB42720AA68453369186F00002', NULL, '建国模块局', '320211', NULL, '无锡市滨湖区华清路与高浪路交叉口建国模块局内', '9099e87fbbeb96e0611788518f6d0d34', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.923', NULL, NULL, NULL, '0101000020B0110000B545752CD9538341B3AAD9FC019C4A41', NULL);
    8. 

  8. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB42430AEC8451369186F00002', NULL, '滨湖区华庄街道高浪路华苑路路口', '320211', NULL, '无锡市滨湖区华庄街道高浪路和华苑路交口东北侧绿化带', '95e2f6e8a907d8897a2c901802afab61', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.925', NULL, NULL, NULL, '0101000020B0110000C7748599EB538341942199B8499C4A41', NULL);
    9. 

  9. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB4DBE0ABD59B9136926F00000', NULL, '滨湖区华庄街道观山名筑北', '320211', NULL, '无锡市滨湖区华庄街道高浪东路与瑞景道东南处', 'e97f32110c0562fe565774ea2ec1e2fe', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.927', NULL, NULL, NULL, '0101000020B01100008B7F1F2FC1538341E720D1649B9B4A41', NULL);
    10. 

  10. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB412D0A9F36AD4AC976F00004', NULL, '滨湖区高浪路万新桥', '320211', NULL, '无锡市滨湖区高浪路与兴梁道交叉口以西150米', '313ea6faadb21fea1a41bc65229236c3', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.929', NULL, NULL, NULL, '0101000020B0110000131C8CC6A25383415A83DFF1239B4A41', NULL);
    11. 

  11. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB42170AB136AF4AC976F00004', NULL, '新吴区新安街道菱湖大道西', '320214', NULL, '无锡市新吴区高浪东路靠近菱湖大道施工工地入口东侧绿化带中', 'deb58064e24bd30b591e03bc91fd5e0f', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.931', NULL, NULL, NULL, '0101000020B01100004B6FD72F0C548341FEABC04EEB9C4A41', NULL);
    12. 

  12. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB42060A06844F369186F00002', NULL, '滨湖区华庄街道尚锦城西', '320211', NULL, '无锡市滨湖区高浪路与南湖大道交叉口', 'e58aaba5581b79351d997754dc32e7d5', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.933', NULL, NULL, NULL, '0101000020B0110000FEC8508AB2538341DABE89DD5B9B4A41', NULL);
    13. 

  13. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB41F00AB15DF05281E6F00003', NULL, '立信大道高浪路西', '320211', NULL, '无锡市滨湖区立信大道与高浪路交叉口', '1e818d086467f9885e5de7fe253908a2', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.935', NULL, NULL, NULL, '0101000020B0110000EB1ED62A6D538341FC1AC0114D9A4A41', NULL);
    14. 

  14. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('657C41CB411B0AEE844D369186F00002', NULL, '滨湖区华庄街道高浪大桥西北', '320211', NULL, '无锡市新吴区高浪路与运河西路交叉口以西150米', 'f5ca96b690c91178e630178594dfffc1', '大华', NULL, NULL, '中国铁塔股份有限公司无锡分公司', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.937', NULL, NULL, NULL, '0101000020B01100004941FD831E54834127061541B69D4A41', NULL);
    15. 

  15. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32021452001314001181', NULL, '旺庄立交', '320214', NULL, '192旺庄立交北楼梯西', '1262341664164974594', 'DS-2CD3T27EWD-L', NULL, NULL, '公安机关', '192旺庄立交北楼梯西', NULL, NULL, 0, 1, '2024-01-12 00:05:47.951', NULL, NULL, NULL, '0101000020B0110000B84C3508D35383412FDF15DCEDA14A41', NULL);
    16. 

  16. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32021452001314001182', NULL, '旺庄立交', '320214', NULL, '193旺庄立交南楼梯西', '1262341761649778689', 'DS-2CD3T27EWD-L', NULL, NULL, '公安机关', '193旺庄立交南楼梯西', NULL, NULL, 0, 1, '2024-01-12 00:05:47.953', NULL, NULL, NULL, '0101000020B0110000B684759FD3538341A8173B5EDDA14A41', NULL);
    17. 

  17. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32021452001314001246', NULL, '新光路', '320214', NULL, '252新光路旺庄医院南(出入口)', '1262341480002265090', 'DS-2CD3T27EWD-L', NULL, NULL, '公安机关', '252新光路旺庄医院南(出入口)', NULL, NULL, 0, 1, '2024-01-12 00:05:47.955', NULL, NULL, NULL, '0101000020B0110000F188DAA31254834159D4E7B965A64A41', NULL);
    18. 

  18. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32021456001311000114', NULL, '广南立交', '320214', NULL, '广南立交北桥洞', '1724599558387478529', 'DS-2CD3T27EWD-L', NULL, NULL, '公安机关', '广南立交北桥洞', NULL, NULL, 0, 1, '2024-01-12 00:05:47.957', NULL, NULL, NULL, '0101000020B01100007CE5F176B9538341F7574977E7A94A41', NULL);
    19. 

  19. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32021456001314001126', NULL, '广南立交', '320214', NULL, '126太湖大道长江北路口广南立交圆盘东边', '1724239289220018178', 'DS-2CD3T27EWD-L', NULL, NULL, '公安机关', '126太湖大道长江北路口广南立交圆盘东边', NULL, NULL, 0, 1, '2024-01-12 00:05:47.959', NULL, NULL, NULL, '0101000020B0110000430942F6C0538341483BB3F44DAA4A41', NULL);
    20. 

  20. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('697e21e72a6d17af42f606d9007be551', NULL, '180宝龙城市广场（高空球机）', '320214', NULL, '180宝龙城市广场（高空球机）', '广场', '没有数据', NULL, NULL, '无锡市公安局', NULL, NULL, NULL, 0, 1, '2024-01-12 00:05:47.967', NULL, NULL, NULL, '0101000020B01100002876C047DE538341EC2CEF4C60A24A41', NULL);
    21. 

  21. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32021153001320019049', '0', '建筑路北奥林花园A区门口-FJ', '无锡市/梁溪区', '32021153001320019049', '江苏省/无锡市/滨湖区/溪南派出所', '清宁大桥', '枪机', '2', '海康', '市政设施中心', 'http://2.22.134.194:83/openUrl/nX8gPyo/live.m3u8', '1', '', 0, 1, '2024-01-12 00:05:47.963', '', '2024-01-23 03:03:38.925', 'admin', '0101000000406E463754538341E140810940A34A41', '海康');
    22. 

  22. INSERT INTO "video_channel" ("id", "scene", "equipment_name", "area", "channel_no", "install_address", "monitoring_object", "equipment_number", "spatial_position", "manufacturer_name", "property_unit", "video_address", "isimportance", "remark", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "geom_data", "video_store") VALUES ('32020017071310000034', '0', 'Cam202 钱胡路-钱荣路', '无锡市/梁溪区', '32021153001320019049', '江苏省/无锡市/无锡市公安局/交警支队', '清宁大桥', '枪机', '1', '海康', '市政设施中心', 'http://2.22.134.194:83/openUrl/kAsgePK/live.m3u8', '1', '', 0, 1, '2024-01-12 00:05:47.966', '', '2024-01-23 03:03:46.084', 'admin', '0101000000406E463754538341E140810940A34A41', '海康');
    23. 

  23.