Mercurial > gemma

changeset 85:1a640da943b6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add waterway area attributes.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 16:51:15 +0200
parents d905022a48e9
children 2477cba141e9
files wamos.sql
diffstat 1 files changed, 13 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri Jun 01 16:14:40 2018 +0200
+++ b/wamos.sql	Fri Jun 01 16:51:15 2018 +0200
@@ -102,10 +102,20 @@
 --        EXCLUDE USING GIST (stretch WITH &&)
 --        );
 
+CREATE TABLE wamos_waterway.catccls (
+       catccl smallint PRIMARY KEY
+       -- TODO: Do we need name and/or definition from IENC feature catalogue?
+       );
+
+CREATE TABLE wamos_waterway.dirimps (
+       dirimp smallint PRIMARY KEY
+       -- TODO: Do we need name and/or definition from IENC feature catalogue?
+       );
+
 CREATE TABLE wamos_waterway.waterway_area (
-       dummy_attrib varchar,
-       "..." varchar
-       -- TODO: add real waterway area attributes (DRC 2.1.3)
+       area geometry(POLYGON, 4326) PRIMARY KEY,
+       catccl smallint REFERENCES catccls,
+       dirimp smallint REFERENCES dirimps
        );
 
 CREATE TABLE wamos_fairway.reference_water_levels (