load_road.sql

Java的框架

BEGIN;
CREATE TABLE "prrm_road" (gid serial PRIMARY KEY, "id" int4, "road_name" varchar, "road_type" varchar);
SELECT AddGeometryColumn('','prrm_road','the_geom','-1','MULTILINESTRING',2);
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('2','CCC EXPRESSWAY','EXPRESS','010500000001000000010200000007000000A2C2A2F83CF4594080D4DB159C1AF73F23CDBC9AA4F359403D05A5EC4995F63FE5DCE30DC0F25940C395EB3C0F36F63F31188DCECEF15940D0E329B3E9B3F53FF227B441EAF05940EB06BA208E64F53F1EEBF0BB86EF5940A791E5A2DB57F53F3657299B3CEE59402E4FDDC8F034F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('4','CDE ROAD','MAJOR','010500000001000000010200000009000000658A2DC2D7F95940B61AFCF0E47BF63F5A5491D27CFA594064A324A61800F63FA47A064FBCFA5940F8DB0B185897F53F194F8401C9FA594020A73CA7763EF53F3ADC248C0AFA5940207A8BD12602F53F1D79EC8967F85940EAAC5775EEEBF43FB5EF3E0B85F65940561A0E580FDCF43F370F8DF1BBF459402DF57A1D51BCF43F434529E116F459402DC8C9470180F43F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('5','DEF ROAD','MAJOR','0105000000010000000102000000040000002852B88B72FF5940DEB87BAAB3E6F53FAA710672A9FD594057A121D9FE90F53F215BB86885FC594020A73CA7763EF53F39C7F0473BFB59403BCACC141BEFF43F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('7','BBB EXPRESSWAY','EXPRESS','0105000000010000000102000000090000006CDEFDD214F5594005A3360D4360F43FD79113DA95F4594005FD98B8E2D8F43F19AC54EF18F3594071F1621CF37DF53FE5DCE30DC0F2594006B15D0F22CAF53F066A849801F25940F9621F99474CF63F466F9169B5F15940652A382708B5F63F7B3E024B0EF25940DF99F1D64214F73F5AB161C0CCF25940B6A10F72D430F73F0E76B8FFBDF359403D8CB86D394AF73F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('8','EFG ROAD','MINOR','01050000000100000001020000000800000089123DE3FFE85940691689938351F53F3A47ACEF0EE95940BD72B1BBF256F53F3CFA71B029E9594024331EEDA25DF53FED2EE1BC38E959404AFBA6FF2460F53FCEBE5C7549E959407E5B5D187D63F53F7EF3CB8158E95940B8872A344067F53F90DE53E66AE95940EBE7E04C986AF53F504B859671E959403878F2719C6FF53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('9','FGH ROAD','MINOR','010500000001000000010200000009000000FAB3DD9F15E9594015BA606B144CF53F0C9F650428E95940491A17846C4FF53F5C1DBCB833E959408346E49F2F53F53FCEBE5C7549E95940D0D6F5C43358F53F5F83473A69E959402AFF34F00D5EF53F0180F4A280E959408BF38A1E5364F53FBCD3D41037E959409F385FA34C76F53F3A47ACEF0EE9594006F9CBD4FC7CF53FF90018DFFAE859407A51660C8384F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('11','HIJ ROAD','MINOR','01050000000100000001020000000C0000005A431EFF25EB5940A423E62AFF65F53F4B0B5C5B2EEB594005183C59446CF53F6B2EA66338EB594052A84D7E4871F53FCD97847C56EB59407970D690CA73F53F8FB77BED77EB594052A84D7E4871F53F5024AD9D7EEB5940D1B78540EC68F53F807FB94980EB59404AFBA6FF2460F53F217C66B297EB5940F0D267D44A5AF53F232F2C73B2EB5940F0D267D44A5AF53FF486E587CBEB5940379762F6E35EF53F968392F0E2EB59406AF7180F3C62F53F77130EA9F3EB59406AF7180F3C62F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('12','IJK ROAD','MINOR','0105000000010000000102000000070000002EB198C6E3EB59409B67E5758533F53F0D8E4EBED9EB5940F71420A7DC28F53F1B134BA1B6EB5940063249B32F19F53F8B01269DB1EB59403B17FBD1040CF53F6ADEDB94A7EB59407A2E4F757AFFF43F7863D87784EB5940FDA312B953F7F43F946DD13D3EEB5940B945A318F0F2F43F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('13','JKL ROAD','MINOR','010500000001000000010200000006000000779DE19370EA594041A6EDE37BDAF43F28D250A07FEA5940F85CF7BB65E6F43F816C882687EA5940246C9BCBD5F9F43FB42D2054BEEA594028B3B6C8C30AF53FC7CB6D79EBEA5940C3D3D912CC14F53F3204F32420EB5940D6371E1C0D16F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('14','KLM ROAD','MINOR','0105000000010000000102000000030000004A1E8D7E27EC59409DAFBC8A0EF1F43F9433C82152EC5940B945A318F0F2F43FC8F45F4F89EC5940937D1A066EF0F43F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('15','LMN ROAD','MINOR','01050000000100000001020000000900000012A79F002AEC594092D9AE7BA911F53FCCAAB59F4FEC59409720CA789722F53FC8F45F4F89EC59400B7964B01D2AF53F3CFC8B8DD4EC59403141EDC29F2CF53F00CF48BF10ED5940EEE27D223C28F53F6B07CE6A45ED5940362C744A521CF53F38A9312F98ED59407543C8EDC70FF53F003244B19AED59408460F1F91A00F53F003244B19AED5940D6DB89A6D1F4F43F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('17','NOP ROAD','MINOR','0105000000010000000102000000070000001E3E635B2EEE59408B1B7CFC9336F53F156FBCC817EE59405034DE78BD4BF53F5C8AB9B628EE5940557BF975AB5CF53F6F2807DC55EE5940D71E87742265F53F81C6540183EE59402EE13A1EC76AF53F8B95FB9399EE594072560F9C7977F53F8B95FB9399EE5940E0ACBD6EFE86F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('18','OPQ ROAD','MINOR','0105000000010000000102000000060000001B14FBD28FF059409C0677B911C5F53F75CD45E6CDF05940A6C51FEB279CF53F913A3A9E11F15940B084C81C3E73F53F3BDE283277F159402A9A1F21D959F53F6AE96A0FE8F159406481BDA4AF44F53FB461A1A49CF25940B6FC55516639F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('19','PQR ROAD','MINOR','0105000000010000000102000000020000002B6A4395E8EE5940FA25EF255837F63F2B6A4395E8EE5940FA25EF255837F63F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('20','QRS ROAD','MINOR','010500000001000000010200000006000000B0D196DEF3EE59400E73CE514A30F63F8EF2343B3DEF594012BAE94E3841F63FAB5F29F380EF5940C03E51A2814CF63FD09BC43DDBEF5940D48B30CE7345F63F3324B6E32FF05940E291F4FC772DF63FD4F8FDE47EF059403954A8A61C33F63F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('21','RST ROAD','MINOR','01050000000100000001020000000600000093823F01E6F259406CDE816751B1F53FE36CE3810DF35940EE810F66C8B9F53FB8BEDA4B40F359405DD8BD384DC9F53FCB5C28716DF35940363EFFE068D7F53FA0AE1F3BA0F35940E4C26634B2E2F53FF098C3BBC7F35940D0758708C0E9F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('22','STU ROAD','MINOR','010500000001000000010200000002000000B9F1AB6A45F65940A8AA5679A142F63FB9F1AB6A45F65940A8AA5679A142F63F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('23','TUV ROAD','MINOR','01050000000100000001020000000500000041B6385BF4F659404544C30F6DBFF53FD9BBD9C92CF75940E93AF468DAA8F53FD9BBD9C92CF759407BE445965599F53F9B6F836E32F759401FDB76EFC282F53F67F2D3A54EF759405AC21473996DF53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('24','UVW ROAD','MINOR','01050000000100000001020000000600000029D94E6959FA5940092CB3545C1FF63F8D61400FAEFA5940350D8DA92E22F63F40D4D5352AFB5940092CB3545C1FF63F5C41CAED6DFB5940DE4AD9FF891CF63FDB36B04B06FC594087882556E516F63FB088A71539FC59408CCF4053D327F63F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('25','VWX ROAD','MINOR','010500000001000000010200000007000000D80C48C367FE5940DF7B4B37C4D1F53FEBAA95E894FE594023F11FB576DEF53F6F12E931A0FE59409147CE87FBEDF53F79E18FC4B6FE5940D5BCA205AEFAF53F8B7FDDE9E3FE594082410A59F705F63FE53828FD21FF59401D7992804E18F63F736F22D943FF594078826127E12EF63F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('26','WXY ROAD','MINOR','0105000000010000000102000000040000007AF6C30886FD5940D0758708C0E9F53F9CD525AC3CFD5940A9DBC8B0DBF7F53F806831F4F8FC5940576030042503F63F131199BB8DFC5940F197B82B7C15F63F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('27','XYZ ROAD','MINOR','0105000000010000000102000000040000005F6B32760CF9594023F11FB576DEF53F787BED86ACF859407EFAEE5B09F5F53FE0754C1874F85940ED509D2E8E04F63FEFB66096FDF75940E8098231A0F3F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('28','AAB ROAD','MINOR','010500000001000000010200000014000000D91A6A6155F35940E6930EA45C63F53F1EBDA80E6DF3594079DCE24B5266F53FE8EC01B586F3594079865A3AC669F53F191039DFC3F35940C3D36FE2E273F53FEF5AC777E1F359407A2E39F49577F53F6D840FE00CF45940E8395429887BF53F42CF9D782AF459409FBFE143817DF53FC42A4F2941F459407AAF850E6872F53FB5DDB0EE51F45940C2D508178769F53FE24985B761F45940542076F32062F53F425497916CF459409C1B35F3F95AF53FB89413507FF4594052A35B429752F53F23BA5A1C8EF459409B7356392A4DF53F8EDFA1E89CF45940082D1BC6D83FF53F99FAD6DAA0F4594007D92BE9F038F53F64A5366878F45940BD0ACA260234F53FF29623F250F459402A187E90982DF53F05162B752BF459402A6E06A2242AF53FDBDBBFF406F45940BC62EB6C3226F53F4E65D951ECF359402A1A17C53C23F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('29','BBC ROAD','MINOR','0105000000010000000102000000020000008771DC2542F45940C354BCFCB46EF53F72AC85F673F35940C0AE76778956F53F');
INSERT INTO "prrm_road" ("id","road_name","road_type",the_geom) VALUES ('30','CCD ROAD','MINOR','01050000000100000001020000000300000068D79FB063F459400A521431325DF53FD0C08A0203F4594052A35B429752F53F15DECF96D8F359402F0E81896361F53F');