Mercurial > dive4elements > river
diff flys-backend/doc/schema/postgresql-spatial.sql @ 1242:d6520d46edb7
Removed table boundarypolys because of wrong placed dataset
flys-backend/trunk@2715 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Hans Plum <hans.plum@intevation.de> |
|---|---|
| date | Tue, 13 Sep 2011 08:02:38 +0000 |
| parents | f68a0504dfb6 |
| children | 3ebc0a7d6793 |
line wrap: on
line diff
--- a/flys-backend/doc/schema/postgresql-spatial.sql Mon Sep 12 13:20:05 2011 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Tue Sep 13 08:02:38 2011 +0000 @@ -103,17 +103,6 @@ SELECT AddGeometryColumn('catchment','geom',31466,'POLYGON',2); ALTER TABLE catchment ALTER COLUMN id SET DEFAULT NEXTVAL('CATCHMENT_ID_SEQ'); --- Hydrologie/Einzugsgebiete/b1-polygon.shp - -- Nur fuer saar vorhanden - -- IDEE alle Begrenzungspolygone in eine Tabelle. -CREATE SEQUENCE BOUNDARYPOLYS_ID_SEQ; -CREATE TABLE boundarypolys ( - id int PRIMARY KEY NOT NULL, - river_id int REFERENCES rivers(id) -); -SELECT AddGeometryColumn('boundarypolys','geom',31466,'MULTIPOLYGON',2); -ALTER TABLE boundarypolys ALTER COLUMN id SET DEFAULT NEXTVAL('BOUNDARYPOLYS_ID_SEQ'); - -- Hydrologie/HW-Schutzanlagen -- Wird nicht benoetigt, stattdessen verwenden wir -- Gewaesser/Saar/Geodaesie/Linien/rohre-und-sperren.shp