Mercurial > gemma

changeset 78:012948f18faa

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Distance marks as link between 1D and 2D.
author Tom Gottfried <tom@intevation.de>
date Thu, 31 May 2018 16:15:50 +0200
parents e5bcd9293d3d
children c22ddffc2071
files wamos.sql
diffstat 1 files changed, 10 insertions(+), 0 deletions(-) [+]
line wrap: on
line diff
--- a/wamos.sql	Thu May 31 15:57:21 2018 +0200
+++ b/wamos.sql	Thu May 31 16:15:50 2018 +0200
@@ -96,8 +96,18 @@
        -- TODO: add real waterway area attributes (DRC 2.1.3)
        );
 
+CREATE TABLE wamos.distance_mark_functions (
+       -- XXX: Redundant information to object code in isrs code of dist. mark
+       distance_mark_function varchar(8) PRIMARY KEY
+       );
+
+-- This table allows linkage between the 1D ISRS location codes and 2D space
+-- e.g. for cutting bottleneck area out of waterway area based on virtual
+-- distance marks along waterway axis (see SUC7).
 CREATE TABLE wamos.distance_marks (
        location_code isrs PRIMARY KEY,
+       geom geometry(POINT, 3146),
+       distance_mark_function varchar(8) REFERENCES distance_mark_functions,
        -- TODO: add relations to stuff provided as enumerations
        dummy_attrib varchar,
        "..." varchar