load_road_defect.sql

Java的框架

BEGIN;
CREATE TABLE "prrm_roaddefect" (gid serial PRIMARY KEY, "id" int8, "severity" varchar, "defecttype" varchar, "status" varchar);
SELECT AddGeometryColumn('','prrm_roaddefect','the_geom','-1','POINT',2);
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('1','Normal','Edge Rut','Pending','01010000001E34D51F56F35940CB3A21E97063F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('2','Major','Base Failure','Pending','01010000008B71624251F459406BF83522C869F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('3','Minor','Other','Pending','01010000009634FF3163E959405820FEDCD829F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('4','Normal','Pothole','Pending','010100000049FF6838C3EA594018B1ABD0600BF53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('5','Minor','Edge Rut','Pending','01010000009AA56C1B81EB594087B138BFD6F6F43F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('6','Minor','Base Failure','Pending','0101000000224FBD6CFDEC5940D85BF09E7B72F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('7','Minor','Pothole','Pending','0101000000499EBAD27EF359405E5A20A93483F63F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('8','Minor','Edge Rut','Pending','010100000021E84ABD0CF65940DACD5B425171F63F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('9','Major','Base Failure','Pending','010100000063819D8C72F7594076A0CEF87BD2F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('10','Critical','Other','Pending','0101000000B71742F973F95940712052001CDAF53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('11','Critical','Base Failure','Pending','0101000000D3415BC753F95940C2E7BE463F91F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('12','Normal','Other','Pending','0101000000F1ED651421F85940C9201A881B60F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('13','Major','Pothole','Pending','0101000000D2E9C3C8C1FA594065CB78F17074F53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('14','Normal','Pothole','Pending','0101000000ED71CC199CFD5940F30321D80DEBF53F');
INSERT INTO "prrm_roaddefect" ("id","severity","defecttype","status",the_geom) VALUES ('15','Critical','Base Failure',NULL,'0101000000CFE1FDCC0BFF5940F48A808BC110F63F');
END;