# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1525727112 -7200
# Node ID bb81404e8ad1cb6ff3a7e650a49980bbae8543a2
# Parent  a7cb0c2c3dd7e95929090ac79ca4a8c48add6e64
An area will be processed or given for clipping for surveys (see SUC10).

diff -r a7cb0c2c3dd7 -r bb81404e8ad1 wamos.sql
--- 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,