INSERT INTO CONTINEW_ZHICHAO.WIM_STATION_TYPE (ID,TYPE_NAME,TYPE_CODE,STATUS,CREATE_USER,CREATE_TIME) SELECT 31,UNISTR('\975e')||UNISTR('\73b0')||UNISTR('\573a')||UNISTR('\68c0')||UNISTR('\6d4b')||UNISTR('\70b9'),'31',1,1,SYSDATE FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CONTINEW_ZHICHAO.WIM_STATION_TYPE WHERE ID=31);
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION_TYPE (ID,TYPE_NAME,TYPE_CODE,STATUS,CREATE_USER,CREATE_TIME) SELECT 21,UNISTR('\8d85')||UNISTR('\9650')||UNISTR('\68c0')||UNISTR('\6d4b')||UNISTR('\7ad9'),'21',1,1,SYSDATE FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CONTINEW_ZHICHAO.WIM_STATION_TYPE WHERE ID=21);
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION_TYPE (ID,TYPE_NAME,TYPE_CODE,STATUS,CREATE_USER,CREATE_TIME) SELECT 41,UNISTR('\9ad8')||UNISTR('\901f')||UNISTR('\5165')||UNISTR('\53e3')||UNISTR('\79f0')||UNISTR('\91cd')||UNISTR('\7ad9'),'41',1,1,SYSDATE FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CONTINEW_ZHICHAO.WIM_STATION_TYPE WHERE ID=41);
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION_TYPE (ID,TYPE_NAME,TYPE_CODE,STATUS,CREATE_USER,CREATE_TIME) SELECT 42,UNISTR('\9ad8')||UNISTR('\901f')||UNISTR('\51fa')||UNISTR('\53e3')||UNISTR('\8ba1')||UNISTR('\91cd')||UNISTR('\7ad9'),'42',1,1,SYSDATE FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CONTINEW_ZHICHAO.WIM_STATION_TYPE WHERE ID=42);
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION_TYPE (ID,TYPE_NAME,TYPE_CODE,STATUS,CREATE_USER,CREATE_TIME) SELECT 71,UNISTR('\91cd')||UNISTR('\70b9')||UNISTR('\8d27')||UNISTR('\8fd0')||UNISTR('\6e90')||UNISTR('\5934')||UNISTR('\7ad9'),'71',1,1,SYSDATE FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM CONTINEW_ZHICHAO.WIM_STATION_TYPE WHERE ID=71);
UPDATE CONTINEW_ZHICHAO.WIM_STATION SET STATION_NAME=UNISTR('\7af9')||UNISTR('\56ed')||UNISTR('\9547'),LONGITUDE=106.2949,LATITUDE=32.2732,PILE_NUMBER='S208 K056+32',LANE_COUNT=2,STATION_TYPE_ID=31,ROAD_NAME='S208',UPDATE_TIME=SYSDATE WHERE STATION_CODE='5108221002';
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108021002;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108021002,UNISTR('\5927')||UNISTR('\77f3')||UNISTR('\9547'),'5108021002',31,105.954,32.3769,'K817+200',4,NULL,1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108221001;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108221001,UNISTR('\6c99')||UNISTR('\6d32')||UNISTR('\9547'),'5108221001',31,105.4694,32.7131,'G212 K705+270',2,'G212',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108231002;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108231002,UNISTR('\59da')||UNISTR('\5bb6')||UNISTR('\9547'),'5108231002',31,105.3514,32.1628,'S208 K075+814',2,'S208',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108231001;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108231001,UNISTR('\6d82')||UNISTR('\5c71')||UNISTR('\9547'),'5108231001',31,105.6486,31.653,'G347 K2373+127',2,'G347',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108241001;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108241001,UNISTR('\9675')||UNISTR('\6c5f')||UNISTR('\9547'),'5108241001',31,105.9395,31.7908,'G212 K917+0',2,'G212',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108211002;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108211002,UNISTR('\4e09')||UNISTR('\6c5f')||UNISTR('\9547'),'5108211002',31,106.604974,32.259485,NULL,2,'G542',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108211001;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108211001,UNISTR('\9ec4')||UNISTR('\6d0b')||UNISTR('\9547'),'5108211001',31,106.380816,32.242047,NULL,2,'G542',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108211004;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108211004,UNISTR('\5609')||UNISTR('\5ddd')||UNISTR('\9547')||'('||UNISTR('\65fa')||UNISTR('\82cd')||UNISTR('\65b9')||UNISTR('\5411')||')','5108211004',31,106.263102,32.248058,NULL,2,NULL,1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108211003;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108211003,UNISTR('\5609')||UNISTR('\5ddd')||UNISTR('\9547')||'('||UNISTR('\5e7f')||UNISTR('\5143')||UNISTR('\65b9')||UNISTR('\5411')||')','5108211003',31,106.309101,32.255587,NULL,2,NULL,1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108241002;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108241002,UNISTR('\6865')||UNISTR('\6eaa')||UNISTR('\4e61'),'5108241002',31,106.213931,32.101595,NULL,2,NULL,1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108111004;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108111004,UNISTR('\662d')||UNISTR('\5316')||UNISTR('\9547'),'5108111004',31,105.688112,32.323037,'S205 K25+411',2,'S205',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108111003;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108111003,UNISTR('\7ea2')||UNISTR('\5ca9')||UNISTR('\9547'),'5108111003',31,105.733197,32.21901,'S205 K45+711',2,'S205',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108111002;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108111002,UNISTR('\592a')||UNISTR('\516c')||UNISTR('\9547'),'5108111002',31,105.813799,32.07458,'G212 K870+518',2,'G212',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108111001;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108111001,UNISTR('\5143')||UNISTR('\575d')||UNISTR('\9547'),'5108111001',31,105.996348,32.264135,'G542 K41+394',2,'G542',1,1,SYSDATE);
DELETE FROM CONTINEW_ZHICHAO.WIM_STATION WHERE ID=5108021001;
INSERT INTO CONTINEW_ZHICHAO.WIM_STATION (ID,STATION_NAME,STATION_CODE,STATION_TYPE_ID,LONGITUDE,LATITUDE,PILE_NUMBER,LANE_COUNT,ROAD_NAME,STATUS,CREATE_USER,CREATE_TIME) VALUES (5108021001,UNISTR('\5b9d')||UNISTR('\8f6e')||UNISTR('\9547'),'5108021001',31,105.56403,32.332594,'G108 K1910+200',4,'G108',1,1,SYSDATE);
SELECT COUNT(*) AS cnt FROM CONTINEW_ZHICHAO.WIM_STATION WHERE STATION_CODE LIKE '5108%';
