Mercurial > gemma
changeset 78:012948f18faa
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