--- a/flys-backend/doc/schema/postgresql-spatial.sql	Thu Sep 22 12:10:08 2011 +0000
+++ b/flys-backend/doc/schema/postgresql-spatial.sql	Fri Sep 23 10:42:25 2011 +0000
@@ -11,7 +11,11 @@
 ALTER TABLE river_axes ALTER COLUMN id SET DEFAULT NEXTVAL('RIVER_AXES_ID_SEQ');
 
 
--- Geodaesie/Querprofile/*
+-- TODO
+-- Geodaesie/Flussachse+km/km.shp
+
+
+--Geodaesie/Querprofile/QP-Spuren/qps.shp
 CREATE SEQUENCE CROSS_SECTION_TRACKS_ID_SEQ;
 CREATE TABLE cross_section_tracks (
     id       int PRIMARY KEY NOT NULL,
@@ -43,7 +47,7 @@
 CREATE TABLE buildings (
     id       int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
-    name     VARCHAR(50)
+    name     VARCHAR(256)
 );
 SELECT AddGeometryColumn('buildings', 'geom', 31466, 'LINESTRING', 2);
 ALTER TABLE buildings ALTER COLUMN id SET DEFAULT NEXTVAL('BUILDINGS_ID_SEQ');
@@ -88,92 +92,28 @@
 
 
 -- Hydrologie/Einzugsgebiete/EZG.shp
-   -- Hinweise zu ezg_saar.shp wird nicht importiert:
-   -- CLASS: Integer (8.0) KLAEREN: wir die benoetigt?
-   -- AREA: Real (19.8) laesst sich auch durch EZG.shp bestimmen
-   -- PERIMETER: Real (19.8) laesst sich auch durch EZG.shp bestimmen
-
 CREATE SEQUENCE CATCHMENT_ID_SEQ;
 CREATE TABLE catchment (
     id int PRIMARY KEY NOT NULL,
     river_id int REFERENCES rivers(id),
-    "area" numeric,
-    "name" VARCHAR(80)
+    area NUMERIC,
+    name VARCHAR(256)
 );
 SELECT AddGeometryColumn('catchment','geom',31466,'POLYGON',2);
 ALTER TABLE catchment ALTER COLUMN id SET DEFAULT NEXTVAL('CATCHMENT_ID_SEQ');
 
--- Hydrologie/HW-Schutzanlagen
--- Wird nicht benoetigt, stattdessen verwenden wir
--- Gewaesser/Saar/Geodaesie/Linien/rohre-und-sperren.shp
-    -- hws.shp beinhaltet die Geometrien von:
-        -- HWS-Lisdorf.shp -- hws_anlage
-        -- HWS-Mettlach.shp -- maßnahme -> hws_anlage
-        -- HWS-Rehlingen.shp -- hw -> hws_anlage
-        -- HWS_Saarburg.shp -- höhe? bauart?
-        -- HWS-Schoden-Rhl-Pf.shp  -- hws_anlage
-        -- HWS_Schoden.shp --höhe? bauart?
-        -- HWS-Serrig.shp --hws_anlage
--- CREATE SEQUENCE HWS_EZG_ID_SEQ;
--- CREATE TABLE hws (
---     id int PRIMARY KEY NOT NULL,
---     oid int,
---     river_id int REFERENCES rivers(id),
---     hws_facility VARCHAR(40),
---     typ VARCHAR(254)
--- );
--- SELECT AddGeometryColumn('hws','geom',31466,'MULTILINESTRING',2);
--- ALTER TABLE hw ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ');
 
--- Hydrologie/Hydr. Grenzen/Linien
+--Hydrologie/HW-Schutzanlagen/hws.shp
+CREATE SEQUENCE HWS_ID_SEQ;
+CREATE TABLE hws (
+    id int PRIMARY KEY NOT NULL,
+    oid int,
+    river_id int REFERENCES rivers(id),
+    hws_facility VARCHAR(256),
+    typ VARCHAR(256)
+);
+SELECT AddGeometryColumn('hws','geom',31466,'MULTILINESTRING',2);
+ALTER TABLE hw ALTER COLUMN id SET DEFAULT NEXTVAL('HWS_ID_SEQ');
 
 
--- Hydrologie/Streckendaten
-    -- pegellage_saar.shp
-CREATE SEQUENCE LEVELPOSITION_ID_SEQ;
-CREATE TABLE levelposition (
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id),
-    x numeric(10,0),
-    y numeric(10,0),
-    name varchar(254)
-);
-SELECT AddGeometryColumn('levelposition','geom','31466','POINT',2);
-ALTER TABLE levelposition ALTER COLUMN id SET DEFAULT NEXTVAL('LEVELPOSITION_ID_SEQ');
-
--- Hydrologie/UeSG/Berechnung
-   -- Berechnung/Aktuell/BfG
-CREATE SEQUENCE COMPUTATIONS_BFG_ID_SEQ;
-CREATE TABLE computations_bfg (
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id),
-    section varchar(254),
-    area float8,
-    perimeter float8
-);
-SELECT AddGeometryColumn('computations_bfg','geom','31466','MULTIPOLYGON',2);
-ALTER TABLE computations_bfg ALTER COLUMN id SET DEFAULT NEXTVAL('COMPUTATIONS_BFG_ID_SEQ');
-
-   -- Berechnung/Aktuell/Land
-CREATE SEQUENCE COMPUTATIONS_COUNTRY_ID_SEQ;
-CREATE TABLE computations_country(
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id),
-    text varchar(254)
-);
-SELECT AddGeometryColumn('computations_contry','geom','31466','MULTILINESTRING',2);
-ALTER TABLE computations_country ALTER COLUMN id SET DEFAULT NEXTVAL('COMPUTATIONS_COUNTRY_ID_SEQ');
-
-
--- Hydrologie/UeSG/Messung
-CREATE SEQUENCE MEASUREMENTS_ID_SEQ;
-CREATE TABLE measurements (
-    id int PRIMARY KEY NOT NULL,
-    river_id int REFERENCES rivers(id),
-    year varchar(254),
-    oid varchar(40)
-);
-SELECT AddGeometryColumn('measurement','geom','31466','MULTILINESTRING',2);
-ALTER TABLE measurements ALTER COLUMN id SET DEFAULT NEXTVAL('MEASUREMENTS_ID_SEQ');
-
 END;