road_setup.sql

Java的框架

INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (15, 15, 'DELL LANE', 'MINOR', '01050000000100000001020000000900000012A79F002AEC594092D9AE7BA911F53FCCAAB59F4FEC59409720CA789722F53FC8F45F4F89EC59400B7964B01D2AF53F3CFC8B8DD4EC59403141EDC29F2CF53F00CF48BF10ED5940EEE27D223C28F53F6B07CE6A45ED5940362C744A521CF53F38A9312F98ED59407543C8EDC70FF53F003244B19AED59408460F1F91A00F53F003244B19AED5940D6DB89A6D1F4F43F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (16, 16, 'DELTA ROAD', 'MINOR', '0105000000010000000102000000040000007132AB508BED5940A9825B92A3ECF53FA7CE6DA6A5ED5940891BFBD6FAA7F53F1207F351DAED594098DC8F6D1277F53F2E74E7091EEE5940BA2F33C80858F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (17, 17, 'DUNLOP ROAD', 'MINOR', '0105000000010000000102000000070000001E3E635B2EEE59408B1B7CFC9336F53F156FBCC817EE59405034DE78BD4BF53F5C8AB9B628EE5940557BF975AB5CF53F6F2807DC55EE5940D71E87742265F53F81C6540183EE59402EE13A1EC76AF53F8B95FB9399EE594072560F9C7977F53F8B95FB9399EE5940E0ACBD6EFE86F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (18, 18, 'EAST COAST PARKWAY', 'MINOR', '0105000000010000000102000000060000001B14FBD28FF059409C0677B911C5F53F75CD45E6CDF05940A6C51FEB279CF53F913A3A9E11F15940B084C81C3E73F53F3BDE283277F159402A9A1F21D959F53F6AE96A0FE8F159406481BDA4AF44F53FB461A1A49CF25940B6FC55516639F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (19, 19, 'FRENCH ROAD', 'MINOR', '0105000000010000000102000000020000002B6A4395E8EE5940FA25EF255837F63F2B6A4395E8EE5940FA25EF255837F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (20, 20, 'FULLERTON ROAD', 'MINOR', '010500000001000000010200000006000000B0D196DEF3EE59400E73CE514A30F63F8EF2343B3DEF594012BAE94E3841F63FAB5F29F380EF5940C03E51A2814CF63FD09BC43DDBEF5940D48B30CE7345F63F3324B6E32FF05940E291F4FC772DF63FD4F8FDE47EF059403954A8A61C33F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (21, 21, 'GUILLEMARD CRESENT', 'MINOR', '01050000000100000001020000000600000093823F01E6F259406CDE816751B1F53FE36CE3810DF35940EE810F66C8B9F53FB8BEDA4B40F359405DD8BD384DC9F53FCB5C28716DF35940363EFFE068D7F53FA0AE1F3BA0F35940E4C26634B2E2F53FF098C3BBC7F35940D0758708C0E9F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (22, 22, 'GUILLEMARD ROAD', 'MINOR', '010500000001000000010200000002000000B9F1AB6A45F65940A8AA5679A142F63FB9F1AB6A45F65940A8AA5679A142F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (23, 23, 'HAVELOCK ROAD', 'MINOR', '01050000000100000001020000000500000041B6385BF4F659404544C30F6DBFF53FD9BBD9C92CF75940E93AF468DAA8F53FD9BBD9C92CF759407BE445965599F53F9B6F836E32F759401FDB76EFC282F53F67F2D3A54EF759405AC21473996DF53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (24, 24, 'HOLLAND AVENUE', 'MINOR', '01050000000100000001020000000600000029D94E6959FA5940092CB3545C1FF63F8D61400FAEFA5940350D8DA92E22F63F40D4D5352AFB5940092CB3545C1FF63F5C41CAED6DFB5940DE4AD9FF891CF63FDB36B04B06FC594087882556E516F63FB088A71539FC59408CCF4053D327F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (25, 25, 'JALAN KAYU', 'MINOR', '010500000001000000010200000007000000D80C48C367FE5940DF7B4B37C4D1F53FEBAA95E894FE594023F11FB576DEF53F6F12E931A0FE59409147CE87FBEDF53F79E18FC4B6FE5940D5BCA205AEFAF53F8B7FDDE9E3FE594082410A59F705F63FE53828FD21FF59401D7992804E18F63F736F22D943FF594078826127E12EF63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (26, 26, 'JURONG ROAD', 'MINOR', '0105000000010000000102000000040000007AF6C30886FD5940D0758708C0E9F53F9CD525AC3CFD5940A9DBC8B0DBF7F53F806831F4F8FC5940576030042503F63F131199BB8DFC5940F197B82B7C15F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (27, 27, 'LENTOR FLYOVER', 'MINOR', '0105000000010000000102000000040000005F6B32760CF9594023F11FB576DEF53F787BED86ACF859407EFAEE5B09F5F53FE0754C1874F85940ED509D2E8E04F63FEFB66096FDF75940E8098231A0F3F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (28, 28, 'MANDAI FLYOVER', 'MINOR', '010500000001000000010200000014000000D91A6A6155F35940E6930EA45C63F53F1EBDA80E6DF3594079DCE24B5266F53FE8EC01B586F3594079865A3AC669F53F191039DFC3F35940C3D36FE2E273F53FEF5AC777E1F359407A2E39F49577F53F6D840FE00CF45940E8395429887BF53F42CF9D782AF459409FBFE143817DF53FC42A4F2941F459407AAF850E6872F53FB5DDB0EE51F45940C2D508178769F53FE24985B761F45940542076F32062F53F425497916CF459409C1B35F3F95AF53FB89413507FF4594052A35B429752F53F23BA5A1C8EF459409B7356392A4DF53F8EDFA1E89CF45940082D1BC6D83FF53F99FAD6DAA0F4594007D92BE9F038F53F64A5366878F45940BD0ACA260234F53FF29623F250F459402A187E90982DF53F05162B752BF459402A6E06A2242AF53FDBDBBFF406F45940BC62EB6C3226F53F4E65D951ECF359402A1A17C53C23F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (29, 29, 'MANDAI ROAD', 'MINOR', '0105000000010000000102000000020000008771DC2542F45940C354BCFCB46EF53F72AC85F673F35940C0AE76778956F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (30, 30, 'NANYANG FLYOVER', 'MINOR', '01050000000100000001020000000300000068D79FB063F459400A521431325DF53FD0C08A0203F4594052A35B429752F53F15DECF96D8F359402F0E81896361F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (31, 31, 'NEW BRIDGE ROAD', 'MINOR', '010500000001000000010200000002000000E771FBCDC8F35940E24783990533F53FE600E8188FF459402D12B3F2AB4CF53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (32, 32, 'ONRAET ROAD', 'MINOR', '010500000001000000010200000007000000425F461F21F45940B26C79615313F63F3EC3E0892EF5594034B10CB22E1DF63F8C665563D9F559403634C4E7C023F63F7650B3EFD9F75940B7F59F020A27F63F738753E901FA594031AB9D460A10F63FD44A10BFEEFB594022102A63E6D4F53F6CF593DC51FE594007E0B107C36BF53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (33, 33, 'BUKIT TIMAH EXPRESSWAY', 'EXPRESS', '01050000000100000001020000000C000000486E4EF63EE959407A89D1747A3AF53F25A7CFAA0AEA594007E0B107C36BF53F3258AC823FEB594054170028B09EF53F5256CBC79BEC5940612FBCD541D3F53F83A12C7A1FEE5940ADE352C09CFFF53FD8861207F2EF5940B0E9C12BC10CF63F0AD273B975F15940F18B0BD4AE11F63F86F7E93ECCF559401E0ABBF7C1C7F53FFF7654A6EDF759403E70AE6D4349F53F0D28317E22F95940FE501CFBE74AF53F945878BD78FC59405CA695348BBFF53FF51B359365FE5940A14E4E489DD1F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (34, 34, 'PANDAN FLYOVER', 'MINOR', '010500000001000000010200000005000000DCACC38C7BE959405BAE422EB049F53F1CA809365EE95940E8DE7B138655F53F2D027C8A4BE959409A510087065FF53F3E5CEEDE38E9594096481B17DC63F53F2942C68827E959404578E48EB166F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (35, 35, 'PASIR RIS DRIVE', 'MINOR', '010500000001000000010200000004000000D73F40E4A8E95940539C784E5B53F53F158EB8E6DCE95940B8D3FE91DA43F53FC38B32425EEA5940960E458B5B58F53FC1AB57414CEA594027BC0FF85C76F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (36, 36, 'SELETAR FLYOVER', 'MINOR', '0105000000010000000102000000060000003B6DF624D3EB59400C352AA5987EF53F080F5AE925EC59409C23AB6A0088F53F1BADA70E53EC594084D4DFD90C97F53FC55096A2B8EC5940107C45A2868FF53F7F54AC41DEEC59401A801D6C897FF53F9BC1A0F921ED594029CB10337A80F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (37, 37, 'SIMEI ROAD', 'MINOR', '01050000000100000001020000000A00000086EA87E6D8E9594057BD048F8320F53FA431E9E6E0E95940FB5D729FD81AF53FF1F9F83CF0E9594011087D56D814F53F8AAA3DE8FCE9594062D8B3DE0212F53F8C8A18E90EEA5940419F4DC0820FF53FD025EF9427EA594027B2870DD80EF53F21AEB4EC5AEA5940AD5C4AFB570DF53FEADFA7ED6EEA5940B8B1CFD6570AF53FA90487437AEA5940AC22746FD701F53F0907E4EE88EA594075052D0ED7F9F43F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (38, 38, 'TAMPINES FLYOVER', 'MINOR', '010500000001000000010200000004000000FFF9CF4380EA594023C1496EABE5F43F2F7B7E9987EA5940CEAD57EAD5E1F43F3988924490EA5940E45762A1D5DBF43F998AEFEF9EEA594087F8CFB12AD6F43F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (39, 39, 'TAMPINES ROAD', 'MINOR', '01050000000100000001020000000200000074F43269D7EE5940211938C1B304F63F527004EBF0EE5940E6C86F761030F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (40, 40, 'TELOK BLANGAH ROAD', 'MINOR', '010500000001000000010200000006000000D1865525DAEE59408C31A49CAE03F63FFE5371E8DDEE594022DDE12E2BECF53FDD9322D25DEF59409CAD099BD9B9F53F5B6AF5A2BFEF59403259472D56A2F53FFF7C63BE7BF05940A16AC667EE98F53FF8EBE245D2F05940931FD3A0FD97F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (41, 41, 'ULU PANDAN ROAD', 'MINOR', '01050000000100000001020000000F000000ACA5709E10F05940304CEC47CE87F63FDE8BA5F42AF0594073F0CFA8F98EF63F46159AE64CF059402CC7CA193E94F63F3D9B845B72F05940D3A99A74CD99F63F6AC42E6C9FF05940B068EB117C9EF63F01A2CA89C2F05940DF71FD92D9A1F63F46754830F0F0594096A1513A05A3F63F09EA003427F1594031BCBE7688A0F63F0C0E1C8959F159402D6E71E35698F63F2D9995B979F159400FB2E3AE9590F63FED7BC09297F15940BA19D537B589F63F30BDB00EACF1594067286D8AED86F63F6DAF881ABAF1594070A28215C886F63FAAA16026C8F1594070A28215C886F63FE6933832D6F159404CBA2CE95D87F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (42, 42, 'ULU SEMBAWANG FLYOVER', 'MINOR', '010500000001000000010200000008000000BBFC1B4CC2F159404DD1A5E130A4F63F897D7705EDF159400E7B0F1437A5F63FC1B2C4CB0DF259407CDAB7628EA7F63FEC49E1B121F25940A269B45811ABF63FD0E282D633F25940DAECDB6449AEF63F4F164B5E56F2594009F6EDE5A6B1F63FCF4913E678F25940427915F2DEB4F63F25784CB2A0F25940F701C3CFF1B1F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (43, 43, 'UNIVERSITY FLYOVER', 'MINOR', '01050000000100000001020000000F0000008640A6E68CF45940E72411B20FCFF63F3A85A0DF9DF45940043AF81CB8D2F63FBE75F3ACADF45940EA725E4541D7F63F8A64C13BBFF45940249D2C1B92DEF63F605F3280C4F45940A697A649B7E4F63F5CA2A73AD7F45940EBE23074FBEFF63F2EE08D39EFF4594049F55476B6F6F63F9CB89A9B17F559402F2EBB9E3FFBF63F3AE54E2941F559400373F6B01300F73F0117927265F5594061851AB3CE06F73F670EF9396EF55940FFEDD482830CF73FE5AF339777F55940667A0E101913F73FB7ED19968FF559400E048534C11CF73F538840F99FF55940A14B83AF821EF73F07CD3AF2B0F559408F575899CD1EF73F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (44, 44, 'UPPER CHANGI ROAD', 'MINOR', '0105000000010000000102000000070000006EF6809A2FF55940518FC5A31CC5F63F70880EC548F55940242D5AECD7C5F63F95D0123B56F55940A4802D51E4C7F63F1504DBC278F55940F9183CC8C4CEF63F21A20BA385F55940BB694CC4E3D3F63FE741C1C190F559407DBA5CC002D9F63F2E403C8392F559408008AA5334E1F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (45, 45, 'UPPER SERANGOON ROAD', 'MINOR', '0105000000010000000102000000080000001F107E786CF55940A627D41AFDCBF63FF24D647784F559402E4E1641CBC9F63F053BADC797F5594008BF194B48C6F63F71812CFFA6F55940190C9E97E4C1F63FFCC0973CBDF559403C4D4DFA35BDF63F5DFB73BED8F5594057BB8D9BC5BCF63F52EFD008E5F5594057BB8D9BC5BCF63F8A241ECF05F65940A9054F7F74BBF63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (46, 46, 'WEST COAST HIGHWAY', 'MINOR', '010500000001000000010200000012000000959751943EF6594053CB27F639DEF53FC02E6E7A52F65940C083297B78DCF53F2E077BDC7AF65940F5B803F47ED7F53FDD8EEA8F9EF659407565308F72D5F53FF7CA4B50B8F65940A020F57C9ED0F53F47AA6CACD9F6594096FF3828ABCCF53FEB2539AA09F75940301AA6642ECAF53FAE9AF1AD40F759408D85239DD0CCF53FEC1E57E467F75940B314209353D0F53F5216BEAB70F759402174C8E1AAD2F53F88B97D4778F7594090D3703002D5F53FBF5C3DE37FF75940EEE59432BDDBF53F9557AE2785F75940C4D1760EAAE4F53F61467CB696F7594014E56357FAF7F53FF04272399AF759401733B1EA2B00F63F0E3C5E3FA1F759402E1CD05D2B0CF63FBC3140C8ABF759401BF1D0AC1721F63FF2D4FF63B3F75940CB4DB6928126F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (47, 47, 'YIO CHU KANG ROAD', 'MINOR', '0105000000010000000102000000130000002C9CDA54EDF7594075138F094749F53F486AC93F20F85940D9C14D326560F53F61A62A003AF85940334F50069073F53F084DF4183EF8594070C76B6F1283F53FC14E79573CF859400FD7CC08E08CF53F20F7C7AE3EF859404AA841A84998F53F9E98020C48F8594043D5D2E6879CF53FFFD2DE8D63F85940D61CD161499EF53F7268763579F85940D61CD161499EF53F1BA1CD7896F859405E431388179CF53FA6E038B6ACF85940780AAD5F8E97F53F90C8F24AC5F8594063C834B6A78FF53F6D127CFFD0F85940FB3BFB281289F53F1A085E88DBF85940674D56E43783F53F0FFCBAD2E7F859402D23880EE77BF53F6AE77EE4FCF8594062586287ED76F53F971029F529F9594096E69536DB6DF53F5A85E1F860F95940AE0689443965F53F0B9FDED69DF95940F388E709DC5BF53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (48, 48, 'XILIN AVENUE', 'MINOR', '01050000000100000001020000000A0000008B0B6805D8F859400C897F75AE84F53F72C8247F1CF95940D753A5FCA789F53FFF991DE74BF959407E367557378FF53F1D9309ED52F95940E31B081BB491F53FD8261C566AF959406964CFDC0AA0F53F77E55D0EADF95940178AE02716BAF53FA37C7AF4C0F95940FEC246509FBEF53FF9AAB3C0E8F95940ED75C20303C3F53F79DE7B480BFA59404AE13F3CA5C5F53F6F6466BD30FA594066F626A74DC9F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (49, 49, 'ZENGHUA FLYOVER', 'MINOR', '01050000000100000001020000000F000000AC2F5126B3F8594036466E5CD7C1F53F215776F8E1F8594040672AB1CAC5F53FA7D956F00AF95940A8F3633E60CCF53F1B017CC239F959400F809DCBF5D2F53F5336C9885AF95940DA4AC352EFD7F53FEFD0EFEB6AF959406D92C1CDB0D9F53F03BE383C7EF9594036B6408B91DAF53F8DFDA37994F959406D92C1CDB0D9F53F32797077C4F959403E89AF4C53D6F53F5204EAA7E4F95940AB41B1D191D4F53F26D45DD115FA5940CD826034E3CFF53F69154E4D2AFA5940E749FA0B5ACBF53F2EB5036C35FA594082646748DDC8F53F3DE5C1765BFA5940073D5CDB79BEF53FEA41340FABFA59404CBFBAA01CB5F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (50, 50, 'ZION ROAD', 'MINOR', '01050000000100000001020000000E000000085039B4B1FE594014E56357FAF7F53FE175A7138BFE5940FCC470499C00F63F89B5E01C4AFE5940A1009ADA1202F63FAE96548312FE5940B3F4C4F0C701F63FEEB329AAF4FD5940B14D1E27AFFDF53FEA8F0E55C2FD5940B9208DE870F9F53F110310E6A3FD5940EE55676177F4F53F87C3A4A88DFD5940EB071ACE45ECF53F5020E50C86FD5940AA0ADD3633E9F53FF17796B583FD5940E8B9CC3A14E4F53F92CF475E81FD59406E396897C9DDF53F627BA03280FD5940231B6FABC3D6F53F3227F9067FFD59400DD9F601DDCEF53FD37EAAAF7CFD594079EA51BD02C9F53F');

--
-- TOC entry 1925 (class 0 OID 0)
-- Name: DUMP TIMESTAMP; Type: DUMP TIMESTAMP; Schema: -; Owner: 
--

-- Completed on 2006-06-19 16:19:03 Malay Peninsula Standard Time