BEGIN;

INSERT INTO rg1000
(geo_type,map_20k,map_10k,local_id,road_code,road_name_en,rg1000_geom) VALUES
('rg',10,'ne',1,13786,'NORTH WEST TSING YI INTERCHANGE',ST_GeomFromText('LINESTRING(
826745 824000,
826747 823996
)',2326)),
('rg',10,'ne',5,12452,'TSING YIP STREET',ST_GeomFromText('LINESTRING(
828685 824000,
828742 823989,
828749 823987
)',2326)),
('rg',10,'ne',6,12453,'TSING YU STREET',ST_GeomFromText('LINESTRING(
828585 823988,
828537 823985,
828516 823984
)',2326)),
('rg',2,'se',532,10138,'CASTLE PEAK ROAD - SAN TIN',ST_GeomFromText('LINESTRING(
825158 839557,
825114 839576,
825062 839600,
825061 839600,
825004 839625,
824995 839629,
824970 839639,
824941 839650,
824928 839654,
824926 839655,
824925 839655,
824924 839655,
824923 839655,
824922 839655,
824921 839656,
824920 839656,
824919 839656,
824918 839656,
824916 839656,
824915 839656,
824914 839656,
824913 839656,
824912 839656,
824911 839656,
824910 839656,
824909 839656,
824907 839656,
824906 839656,
824905 839656,
824904 839655,
824902 839655,
824901 839655,
824900 839655,
824899 839655,
824898 839655,
824897 839655,
824896 839655,
824894 839654,
824893 839654,
824892 839654,
824891 839654,
824890 839653,
824889 839653,
824888 839653,
824886 839653,
824885 839652,
824884 839652,
824883 839651,
824882 839651,
824881 839651,
824880 839650,
824808 839620,
824760 839600,
824750 839595,
824717 839581,
824608 839534,
824607 839534,
824598 839530,
824578 839521,
824566 839516,
824556 839512,
824542 839506
)',2326)),
('rg',2,'se',533,14082,'KAM CHUI ROAD',ST_GeomFromText('LINESTRING(
829392 839502,
829409 839516,
829433 839535,
829438 839539,
829444 839543,
829452 839547
)',2326)),
('rg',6,'nw',1039,10875,'HUNG TIN ROAD',ST_GeomFromText('LINESTRING(
817941 833614,
817943 833619,
817959 833694,
817976 833774,
817986 833835,
817994 833902,
817995 833914
)',2326));

COMMIT;
