Mercurial > gemma
changeset 2141:3f58809d2beb
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,