Mercurial > dive4elements > river
changeset 1238:35740d675866
Added mappings to existing data in file system (based on river Saar); added TODOs for missing tables/mappings
flys-backend/trunk@2629 c6561f87-3c4e-4783-a992-168aeb5c3f6f
| author | Hans Plum <hans.plum@intevation.de> |
|---|---|
| date | Thu, 01 Sep 2011 09:38:05 +0000 |
| parents | 774dff3ee546 |
| children | 07882568cef8 |
| files | flys-backend/ChangeLog flys-backend/doc/schema/postgresql-spatial.sql |
| diffstat | 2 files changed, 35 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/flys-backend/ChangeLog Wed Aug 31 08:50:20 2011 +0000 +++ b/flys-backend/ChangeLog Thu Sep 01 09:38:05 2011 +0000 @@ -1,3 +1,9 @@ +2011-09-01 Hans Plum <hans@intevation.de> + + * doc/schema/postgresql-spatial.sql: + Added mappings to existing data in file system (based on + river Saar); added TODOs for missing tables/mappings + 2011-08-31 Ingo Weinzierl <ingo@intevation.de> * doc/schema/postgresql-spatial.sql: New relation for floodplains (german
--- a/flys-backend/doc/schema/postgresql-spatial.sql Wed Aug 31 08:50:20 2011 +0000 +++ b/flys-backend/doc/schema/postgresql-spatial.sql Thu Sep 01 09:38:05 2011 +0000 @@ -1,5 +1,6 @@ BEGIN; +-- Geodaesie/Flussachse+km/achse CREATE TABLE river_axes ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), @@ -8,6 +9,7 @@ SELECT AddGeometryColumn('river_axes', 'geom', 31466, 'LINESTRING', 2); +-- Geodaesie/Querprofile/* CREATE TABLE cross_section_tracks ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), @@ -17,6 +19,7 @@ SELECT AddGeometryColumn('cross_section_tracks', 'geom', 31466, 'LINESTRING', 2); +-- Geodaesie/Linien/rohre-und-spreen CREATE TABLE lines ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), @@ -29,6 +32,7 @@ -- 1: DAMM +-- Geodaesie/Bauwerke/Wehre.shp CREATE TABLE buildings ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), @@ -37,6 +41,7 @@ SELECT AddGeometryColumn('buildings', 'geom', 31466, 'LINESTRING', 2); +-- Geodaesie/Festpunkte/Festpunkte.shp CREATE TABLE fixpoints ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), @@ -48,7 +53,7 @@ SELECT AddGeometryColumn('fixpoints', 'geom', 31466, 'POINT', 2); --- Talaue +-- Hydrologie/Hydr. Grenzen/talaue.shp CREATE TABLE floodplain ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id) @@ -56,6 +61,7 @@ SELECT AddGeometryColumn('floodplain', 'geom', 31466, 'MULTIPOLYGON', 2); +-- Geodaesie/Hoehenmodelle/* CREATE TABLE dgm ( id SERIAL PRIMARY KEY NOT NULL, river_id int REFERENCES rivers(id), @@ -66,4 +72,26 @@ UNIQUE (river_id, lower, upper) ); + +-- TODO +-- Flussachse+km/km + +-- TODO +-- Hydrologie/Einzugsgebiete + +-- TODO +-- Hydrologie/HW-Schutzanlagen + +-- TODO +-- Hydrologie/Hydr. Grenzen/Linien + +-- TODO +-- Hydrologie/Streckendaten + +-- TODO +-- Hydrologie/UeSG/Berechnung + +-- TODO +-- Hydrologie/UeSG/Messung + END;