# HG changeset patch
# User Hans Plum <hans.plum@intevation.de>
# Date 1314869885 0
# Node ID 35740d67586669ce8da2647d62877220faa54363
# Parent  774dff3ee546beb26afa2af27bd7a922e638032b
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

diff -r 774dff3ee546 -r 35740d675866 flys-backend/ChangeLog
--- 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
diff -r 774dff3ee546 -r 35740d675866 flys-backend/doc/schema/postgresql-spatial.sql
--- 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;