BEGIN;

INSERT INTO sg1000
(geo_ref_nr,site_name_en,site_code,sg1000_label,sg1000_geom) VALUES
('2790824148','Cheung Wang Estate',77065,
ST_GeomFromText('POINT(827866 823997)',2326),
ST_GeomFromText('POLYGON((
827855 824000,
827878 824000,
827878 824000,
827878 823999,
827877 823998,
827876 823998,
827875 823997,
827874 823997,
827873 823996,
827872 823996,
827871 823996,
827870 823996,
827868 823995,
827867 823995,
827866 823995,
827865 823995,
827863 823995,
827861 823996,
827859 823997,
827857 823998,
827855 823999,
827855 824000
))',2326)),
('2816624105','CHEUNG HANG ESTATE',75567,
ST_GeomFromText('POINT(828150 823876)',2326),
ST_GeomFromText('POLYGON((
828085 824000,
828147 824000,
828163 824000,
828163 823998,
828163 823994,
828162 823989,
828162 823985,
828162 823981,
828162 823976,
828161 823972,
828161 823965,
828161 823956,
828160 823952,
828160 823950,
828160 823949,
828160 823947,
828160 823946,
828160 823944,
828161 823943,
828161 823941,
828162 823940,
828163 823938,
828164 823937,
828165 823936,
828165 823935,
828166 823934,
828168 823933,
828169 823933,
828171 823932,
828176 823930,
828180 823928,
828182 823928,
828185 823928,
828190 823927,
828195 823927,
828198 823927,
828201 823927,
828204 823928,
828209 823928,
828217 823928,
828223 823928,
828226 823929,
828230 823931,
828236 823932,
828240 823932,
828231 823905,
828218 823868,
828205 823830,
828196 823804,
828195 823800,
828192 823792,
828190 823785,
828189 823782,
828187 823778,
828185 823775,
828183 823772,
828181 823769,
828181 823768,
828180 823767,
828180 823767,
828179 823766,
828179 823764,
828178 823762,
828178 823760,
828178 823758,
828178 823756,
828178 823754,
828178 823752,
828177 823750,
828177 823747,
828176 823744,
828175 823743,
828175 823742,
828174 823740,
828173 823739,
828170 823739,
828168 823740,
828166 823741,
828164 823742,
828162 823744,
828160 823745,
828158 823747,
828157 823748,
828155 823750,
828152 823753,
828149 823756,
828144 823761,
828142 823764,
828139 823767,
828137 823770,
828135 823774,
828134 823777,
828132 823780,
828130 823784,
828129 823787,
828127 823790,
828126 823794,
828125 823797,
828124 823801,
828121 823808,
828119 823815,
828119 823816,
828113 823839,
828113 823840,
828112 823841,
828112 823842,
828112 823842,
828111 823846,
828110 823849,
828110 823852,
828109 823857,
828108 823861,
828107 823866,
828106 823870,
828105 823875,
828104 823880,
828103 823883,
828103 823886,
828103 823888,
828103 823891,
828103 823893,
828104 823902,
828102 823913,
828100 823919,
828100 823920,
828098 823924,
828096 823927,
828095 823930,
828094 823933,
828092 823936,
828092 823938,
828091 823941,
828090 823945,
828089 823949,
828089 823952,
828088 823956,
828087 823960,
828087 823960,
828086 823964,
828086 823968,
828085 823971,
828085 823974,
828085 823978,
828084 823982,
828084 823985,
828084 823989,
828085 823995,
828085 823998,
828085 824000
))',2326)),
('2816624105','CHEUNG HANG ESTATE',75567,
ST_GeomFromText('POINT(828179 824000)',2326),
ST_GeomFromText('POLYGON((
828179 824000,
828180 824000,
828180 824000,
828179 823999,
828179 824000
))',2326)),
('2867323879','TSING YI ESTATE',75418,
ST_GeomFromText('POINT(828673 823879)',2326),
ST_GeomFromText('POLYGON((
828682 823738,
828681 823739,
828680 823739,
828676 823742,
828672 823744,
828669 823746,
828665 823748,
828662 823750,
828659 823753,
828656 823755,
828652 823758,
828649 823761,
828647 823763,
828645 823765,
828643 823767,
828642 823769,
828639 823771,
828637 823774,
828635 823776,
828633 823779,
828631 823781,
828630 823784,
828628 823787,
828626 823790,
828624 823793,
828629 823795,
828627 823798,
828627 823799,
828626 823800,
828626 823801,
828625 823802,
828625 823803,
828625 823804,
828624 823805,
828624 823806,
828622 823811,
828620 823815,
828618 823820,
828616 823825,
828615 823829,
828614 823834,
828613 823840,
828612 823844,
828607 823844,
828607 823845,
828607 823846,
828607 823847,
828607 823848,
828606 823849,
828606 823851,
828605 823853,
828603 823878,
828602 823917,
828603 823917,
828603 823923,
828601 823959,
828600 823987,
828600 823989,
828600 823991,
828600 823992,
828600 823993,
828601 823994,
828601 823995,
828602 823996,
828603 823996,
828604 823997,
828605 823997,
828653 823990,
828653 823998,
828653 824000,
828667 824000,
828667 823989,
828720 823982,
828722 823982,
828723 823981,
828725 823981,
828726 823980,
828728 823979,
828729 823978,
828730 823977,
828731 823976,
828732 823974,
828733 823973,
828734 823971,
828735 823970,
828735 823968,
828736 823967,
828736 823965,
828736 823963,
828738 823920,
828738 823892,
828741 823888,
828741 823872,
828740 823872,
828740 823870,
828740 823865,
828740 823863,
828741 823863,
828741 823860,
828743 823847,
828743 823842,
828744 823838,
828746 823834,
828747 823830,
828747 823830,
828682 823738
))',2326)),
('2901223981','PO LEUNG KUK CASTAR PRIMARY SCHOOL',78398,
ST_GeomFromText('POINT(829012 823982)',2326),
ST_GeomFromText('POLYGON((
829045 824000,
829046 823976,
829046 823974,
829046 823973,
829045 823971,
829044 823970,
829043 823969,
829042 823968,
829040 823967,
829038 823967,
829022 823965,
829014 823964,
829008 823963,
829003 823962,
829000 823961,
828996 823959,
828992 823958,
828989 823955,
828985 823953,
828982 823950,
828982 823950,
828953 823965,
828985 824000,
829045 824000
))',2326)),
('2915523948','TIVOLI GARDEN',76147,
ST_GeomFromText('POINT(829155 823949)',2326),
ST_GeomFromText('POLYGON((
829217 824000,
829222 823917,
829222 823909,
829206 823908,
829162 823906,
829115 823903,
829112 823950,
829112 823963,
829111 823979,
829111 823980,
829103 823995,
829100 824000,
829153 824000,
829217 824000
))',2326)),
('2983124349','RAMBLER CHANNEL PUBLIC CARGO WORKING AREA',77860,
ST_GeomFromText('POINT(829990 823996)',2326),
ST_GeomFromText('POLYGON((
829967 824000,
830000 824000,
830000 823981,
829967 824000
))',2326)),
('2888123938','TSING YI PARK',77853,
ST_GeomFromText('POINT(828881 823938)',2326),
ST_GeomFromText('POLYGON((
828811 823897,
828810 823898,
828810 823899,
828809 823900,
828813 823908,
828834 823950,
828836 823949,
828838 823954,
828840 823957,
828847 823974,
828859 823998,
828867 823995,
828868 823997,
828878 823994,
828878 823995,
828889 823994,
828906 823986,
828906 823986,
828908 823990,
828954 823967,
828924 823907,
828924 823907,
828923 823908,
828919 823900,
828890 823914,
828889 823913,
828882 823898,
828873 823881,
828857 823889,
828855 823889,
828849 823878,
828848 823879,
828844 823881,
828811 823897
))',2326));

COMMIT;
