Mercurial > gemma

changeset 2141:3f58809d2beb

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Waterway profiles have to match a distance mark That way, a geo-location can be assigned to every value also without an actual linestring geometry.
author Tom Gottfried <tom@intevation.de>
date Thu, 07 Feb 2019 12:23:05 +0100
parents 55bedb39295a
children 70471052f6b0
files schema/gemma.sql
diffstat 1 files changed, 2 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/gemma.sql	Thu Feb 07 10:30:44 2019 +0100
+++ b/schema/gemma.sql	Thu Feb 07 12:23:05 2019 +0100
@@ -397,8 +397,8 @@
 
     CREATE TABLE waterway_profiles (
         id int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
-        location isrs NOT NULL,
-        geom geography(linestring, 4326), -- TODO: NOT NIL
+        location isrs NOT NULL REFERENCES distance_marks_virtual,
+        geom geography(linestring, 4326),
         validity tstzrange,
         lnwl double precision,
         mwl double precision,