changeset 86:2477cba141e9

Add axis attributes.
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Jun 2018 18:37:31 +0200
parents 1a640da943b6
children c46fb3f1faeb
files wamos.sql
diffstat 1 files changed, 4 insertions(+), 3 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Fri Jun 01 16:51:15 2018 +0200
+++ b/wamos.sql	Fri Jun 01 18:37:31 2018 +0200
@@ -148,9 +148,10 @@
        );
 
 CREATE TABLE wamos_waterway.waterway_axis (
-       dummy_attrib varchar,
-       "..." varchar
-       -- TODO: add real waterway area attributes (DRC 2.1.3)
+       wtwaxs geometry(LINESTRING, 4326) PRIMARY KEY,
+       -- TODO: Do we need to check data set quality as described in DRC 2.1.6?
+       objnam varchar NOT NULL,
+       nobjnam varchar
        );
 
 CREATE TABLE wamos_waterway.distance_mark_functions (