road_setup.sql

Java的框架

--
-- PostgreSQL database dump
--

SET client_encoding = 'UNICODE';
SET check_function_bodies = false;
SET client_min_messages = warning;

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

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


SET search_path = public, pg_catalog;

--
-- TOC entry 1924 (class 0 OID 0)
-- Dependencies: 1579
-- Name: prrm_road_gid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('prrm_road', 'gid'), 50, true);


--
-- TOC entry 1921 (class 0 OID 173578)
-- Dependencies: 1580
-- Data for Name: prrm_road; Type: TABLE DATA; Schema: public; Owner: postgres
--

INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (1, 1, 'ABBOTSINGH ROAD', 'MAJOR', '010500000001000000010200000009000000EF5A1CA79BEB5940D089C7074A3BF53FC4AC1371CEEB594021D4ED7CC67AF53FD903180CB5EB59404926328DD4D6F53F1A0925DD68EB59403CAB4241AA1CF63FEF5A1CA79BEB5940EBBA7E77CD55F63FF97B845227EC59409BCABAADF08EF63F2D4BF53380EC5940140DC387DBB1F63F6C3BCEC064ED5940DE6C4001F3D7F63F3657299B3CEE59406557E9FC57F1F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (2, 2, 'TAMPINES EXPRESSWAY', 'EXPRESS', '010500000001000000010200000007000000A2C2A2F83CF4594080D4DB159C1AF73F23CDBC9AA4F359403D05A5EC4995F63FE5DCE30DC0F25940C395EB3C0F36F63F31188DCECEF15940D0E329B3E9B3F53FF227B441EAF05940EB06BA208E64F53F1EEBF0BB86EF5940A791E5A2DB57F53F3657299B3CEE59402E4FDDC8F034F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (3, 3, 'ABINGDON ROAD', 'MAJOR', '01050000000100000001020000000500000032D0F0244EF859402F3053F57F62F63F012BE8CB93F55940DE12DE55535FF63F855F6AF699F259403CD8F316FA58F63FAFB1D2CA8AF0594068685F729154F63FB4042D29C7EF594081B72A038545F63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (4, 4, 'ADAM DRIVE', 'MAJOR', '010500000001000000010200000009000000658A2DC2D7F95940B61AFCF0E47BF63F5A5491D27CFA594064A324A61800F63FA47A064FBCFA5940F8DB0B185897F53F194F8401C9FA594020A73CA7763EF53F3ADC248C0AFA5940207A8BD12602F53F1D79EC8967F85940EAAC5775EEEBF43FB5EF3E0B85F65940561A0E580FDCF43F370F8DF1BBF459402DF57A1D51BCF43F434529E116F459402DC8C9470180F43F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (5, 5, 'ADAM PARK', 'MAJOR', '0105000000010000000102000000040000002852B88B72FF5940DEB87BAAB3E6F53FAA710672A9FD594057A121D9FE90F53F215BB86885FC594020A73CA7763EF53F39C7F0473BFB59403BCACC141BEFF43F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (6, 6, 'CENTRAL EXPRESSWAY', 'EXPRESS', '010500000001000000010200000016000000711D9A9F82F159408CE741B447F2F43F6F08665BB3F25940998FE2D5C1E8F43FF81EB464D7F35940EAAC5775EEEBF43F4130F59C47F559405647BF2D5F18F53FEBD3E330ADF55940B53986C4554EF53F9577D2C412F65940A7BE96782B94F53FF5F44BDC38F659409A43A72C01DAF53F6AC9C98E45F659408DC8B7E0D61FF63F94039DF973F559404A4572373A7CF63F127774D84BF55940FC10F5877198F63F614205CC3CF55940614C66B3A4AFF63F99B9F2493AF559405C61DF2BF2BFF63F09A8CD4535F55940BC55355A37C6F63F172DCA2812F5594030AECF91BDCDF63FC348E8F2D0F459404312149BFECEF63F581063479CF45940740C3F3221D2F63F78D0B15D1CF45940D400956066D8F63FDE29EFE2ECF25940D947B05D54E9F63FB3710764B8F1594065EF1526CEE1F63FD8E7ABCAFEF059409FBF4ECC55C4F63F6DAF261FCAF05940614C66B3A4AFF63F0B464806ACF059405C054BB6B69EF63F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (7, 7, 'PAN ISLAND EXPRESSWAY', 'EXPRESS', '0105000000010000000102000000090000006CDEFDD214F5594005A3360D4360F43FD79113DA95F4594005FD98B8E2D8F43F19AC54EF18F3594071F1621CF37DF53FE5DCE30DC0F2594006B15D0F22CAF53F066A849801F25940F9621F99474CF63F466F9169B5F15940652A382708B5F63F7B3E024B0EF25940DF99F1D64214F73F5AB161C0CCF25940B6A10F72D430F73F0E76B8FFBDF359403D8CB86D394AF73F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (8, 8, 'ADAM ROAD', 'MINOR', '01050000000100000001020000000800000089123DE3FFE85940691689938351F53F3A47ACEF0EE95940BD72B1BBF256F53F3CFA71B029E9594024331EEDA25DF53FED2EE1BC38E959404AFBA6FF2460F53FCEBE5C7549E959407E5B5D187D63F53F7EF3CB8158E95940B8872A344067F53F90DE53E66AE95940EBE7E04C986AF53F504B859671E959403878F2719C6FF53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (9, 9, 'BALESTIER ROAD', 'MINOR', '010500000001000000010200000009000000FAB3DD9F15E9594015BA606B144CF53F0C9F650428E95940491A17846C4FF53F5C1DBCB833E959408346E49F2F53F53FCEBE5C7549E95940D0D6F5C43358F53F5F83473A69E959402AFF34F00D5EF53F0180F4A280E959408BF38A1E5364F53FBCD3D41037E959409F385FA34C76F53F3A47ACEF0EE9594006F9CBD4FC7CF53FF90018DFFAE859407A51660C8384F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (10, 10, 'BATTERY ROAD', 'MINOR', '01050000000100000001020000000D0000003BAC540054E9594035C044D49040F53F769DE18055E95940F021ACF90C36F53F287188025AE95940705C7DF2C92DF53F78DD090869E9594059F9D5A4C624F53FDCC47F9285E95940086F982A041EF53F07FB9023B4E959407647F233631BF53F1DB6AD2FD5E9594099963E21A520F53FBB4E88B3DFE95940F60C213BA623F53F46AC9639F0E9594041218C65492CF53F6E6257BCF7E95940F6977E492C34F53FD109A5BF00EA59403B361724B03EF53FAB930CC40CEA5940874A824E5347F53F975840C612EA594012FC55F5D44BF53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (11, 11, 'BAYSHORE ROAD', 'MINOR', '01050000000100000001020000000C0000005A431EFF25EB5940A423E62AFF65F53F4B0B5C5B2EEB594005183C59446CF53F6B2EA66338EB594052A84D7E4871F53FCD97847C56EB59407970D690CA73F53F8FB77BED77EB594052A84D7E4871F53F5024AD9D7EEB5940D1B78540EC68F53F807FB94980EB59404AFBA6FF2460F53F217C66B297EB5940F0D267D44A5AF53F232F2C73B2EB5940F0D267D44A5AF53FF486E587CBEB5940379762F6E35EF53F968392F0E2EB59406AF7180F3C62F53F77130EA9F3EB59406AF7180F3C62F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (12, 12, 'CAUSEWAY', 'MINOR', '0105000000010000000102000000070000002EB198C6E3EB59409B67E5758533F53F0D8E4EBED9EB5940F71420A7DC28F53F1B134BA1B6EB5940063249B32F19F53F8B01269DB1EB59403B17FBD1040CF53F6ADEDB94A7EB59407A2E4F757AFFF43F7863D87784EB5940FDA312B953F7F43F946DD13D3EEB5940B945A318F0F2F43F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (13, 13, 'CHANGI AIRPORT', 'MINOR', '010500000001000000010200000006000000779DE19370EA594041A6EDE37BDAF43F28D250A07FEA5940F85CF7BB65E6F43F816C882687EA5940246C9BCBD5F9F43FB42D2054BEEA594028B3B6C8C30AF53FC7CB6D79EBEA5940C3D3D912CC14F53F3204F32420EB5940D6371E1C0D16F53F');
INSERT INTO prrm_road (gid, id, road_name, road_type, the_geom) VALUES (14, 14, 'CHANTEK FLYOVER', 'MINOR', '0105000000010000000102000000030000004A1E8D7E27EC59409DAFBC8A0EF1F43F9433C82152EC5940B945A318F0F2F43FC8F45F4F89EC5940937D1A066EF0F43F');