Mercurial > gemma

comparison wamos.sql @ 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
comparison
equal deleted inserted replaced
77:e5bcd9293d3d 78:012948f18faa
94 dummy_attrib varchar, 94 dummy_attrib varchar,
95 "..." varchar 95 "..." varchar
96 -- TODO: add real waterway area attributes (DRC 2.1.3) 96 -- TODO: add real waterway area attributes (DRC 2.1.3)
97 ); 97 );
98 98
99 CREATE TABLE wamos.distance_mark_functions (
100 -- XXX: Redundant information to object code in isrs code of dist. mark
101 distance_mark_function varchar(8) PRIMARY KEY
102 );
103
104 -- This table allows linkage between the 1D ISRS location codes and 2D space
105 -- e.g. for cutting bottleneck area out of waterway area based on virtual
106 -- distance marks along waterway axis (see SUC7).
99 CREATE TABLE wamos.distance_marks ( 107 CREATE TABLE wamos.distance_marks (
100 location_code isrs PRIMARY KEY, 108 location_code isrs PRIMARY KEY,
109 geom geometry(POINT, 3146),
110 distance_mark_function varchar(8) REFERENCES distance_mark_functions,
101 -- TODO: add relations to stuff provided as enumerations 111 -- TODO: add relations to stuff provided as enumerations
102 dummy_attrib varchar, 112 dummy_attrib varchar,
103 "..." varchar 113 "..." varchar
104 -- TODO: add real distance mark attributes (DRC 2.1.7) 114 -- TODO: add real distance mark attributes (DRC 2.1.7)
105 ); 115 );