Mercurial > gemma
changeset 85:1a640da943b6
Add waterway area attributes.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 01 Jun 2018 16:51:15 +0200 |
parents | d905022a48e9 |
children | 2477cba141e9 |
files | wamos.sql |
diffstat | 1 files changed, 13 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/wamos.sql Fri Jun 01 16:14:40 2018 +0200 +++ b/wamos.sql Fri Jun 01 16:51:15 2018 +0200 @@ -102,10 +102,20 @@ -- EXCLUDE USING GIST (stretch WITH &&) -- ); +CREATE TABLE wamos_waterway.catccls ( + catccl smallint PRIMARY KEY + -- TODO: Do we need name and/or definition from IENC feature catalogue? + ); + +CREATE TABLE wamos_waterway.dirimps ( + dirimp smallint PRIMARY KEY + -- TODO: Do we need name and/or definition from IENC feature catalogue? + ); + CREATE TABLE wamos_waterway.waterway_area ( - dummy_attrib varchar, - "..." varchar - -- TODO: add real waterway area attributes (DRC 2.1.3) + area geometry(POLYGON, 4326) PRIMARY KEY, + catccl smallint REFERENCES catccls, + dirimp smallint REFERENCES dirimps ); CREATE TABLE wamos_fairway.reference_water_levels (