changeset 51:bb81404e8ad1

An area will be processed or given for clipping for surveys (see SUC10).
author Tom Gottfried <tom@intevation.de>
date Mon, 07 May 2018 23:05:12 +0200
parents a7cb0c2c3dd7
children 70c6efae5a3d
files wamos.sql
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Mon May 07 23:01:12 2018 +0200
+++ b/wamos.sql	Mon May 07 23:05:12 2018 +0200
@@ -122,7 +122,7 @@
        bottleneck_id varchar NOT NULL REFERENCES bottlenecks,
        date_info date NOT NULL,
        PRIMARY KEY (bottleneck_id, date_info),
-       area int, -- XX: Check SRS/test data what this should be
+       area geometry(POLYGON, 3146) NOT NULL,
        type int, -- XX: Check SRS/test data what this should be
        surtyp varchar NOT NULL REFERENCES survey_types,
        coverage varchar NOT NULL REFERENCES coverage_types,