Mercurial > dive4elements > river
comparison 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 |
comparison
equal
deleted
inserted
replaced
| 1241:f68a0504dfb6 | 1242:d6520d46edb7 |
|---|---|
| 100 "area" numeric, | 100 "area" numeric, |
| 101 "name" VARCHAR(80) | 101 "name" VARCHAR(80) |
| 102 ); | 102 ); |
| 103 SELECT AddGeometryColumn('catchment','geom',31466,'POLYGON',2); | 103 SELECT AddGeometryColumn('catchment','geom',31466,'POLYGON',2); |
| 104 ALTER TABLE catchment ALTER COLUMN id SET DEFAULT NEXTVAL('CATCHMENT_ID_SEQ'); | 104 ALTER TABLE catchment ALTER COLUMN id SET DEFAULT NEXTVAL('CATCHMENT_ID_SEQ'); |
| 105 | |
| 106 -- Hydrologie/Einzugsgebiete/b1-polygon.shp | |
| 107 -- Nur fuer saar vorhanden | |
| 108 -- IDEE alle Begrenzungspolygone in eine Tabelle. | |
| 109 CREATE SEQUENCE BOUNDARYPOLYS_ID_SEQ; | |
| 110 CREATE TABLE boundarypolys ( | |
| 111 id int PRIMARY KEY NOT NULL, | |
| 112 river_id int REFERENCES rivers(id) | |
| 113 ); | |
| 114 SELECT AddGeometryColumn('boundarypolys','geom',31466,'MULTIPOLYGON',2); | |
| 115 ALTER TABLE boundarypolys ALTER COLUMN id SET DEFAULT NEXTVAL('BOUNDARYPOLYS_ID_SEQ'); | |
| 116 | 105 |
| 117 -- Hydrologie/HW-Schutzanlagen | 106 -- Hydrologie/HW-Schutzanlagen |
| 118 -- Wird nicht benoetigt, stattdessen verwenden wir | 107 -- Wird nicht benoetigt, stattdessen verwenden wir |
| 119 -- Gewaesser/Saar/Geodaesie/Linien/rohre-und-sperren.shp | 108 -- Gewaesser/Saar/Geodaesie/Linien/rohre-und-sperren.shp |
| 120 -- hws.shp beinhaltet die Geometrien von: | 109 -- hws.shp beinhaltet die Geometrien von: |