roaddefect.sql

Java的框架

CREATE TABLE prrm_roaddefect
(
  gid serial NOT NULL,
  id int8,
  severity varchar,
  defecttype varchar,
  status varchar,
  the_geom geometry,
  CONSTRAINT prrm_roaddefect_pkey PRIMARY KEY (gid),
  CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = -1)
) 
WITHOUT OIDS;
ALTER TABLE prrm_roaddefect OWNER TO postgres;

INSERT INTO "geometry_columns" VALUES ('','public','prrm_roaddefect','the_geom',2,4326,'POINT');