Mercurial > gemma
changeset 927:48f70782400d
Add categories of CEMT class and directions of impact
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Mon, 08 Oct 2018 13:04:30 +0200 |
parents | 15bf101e1522 |
children | 688e1530f66a 71445b091415 |
files | schema/gemma.sql |
diffstat | 1 files changed, 5 insertions(+), 0 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Sat Oct 06 13:34:51 2018 +0200 +++ b/schema/gemma.sql Mon Oct 08 13:04:30 2018 +0200 @@ -84,12 +84,17 @@ CREATE TABLE catccls ( catccl smallint PRIMARY KEY -- TODO: Do we need name and/or definition from IENC feature catalogue? + -- (see page 328 of edition 2.3) ); +INSERT INTO catccls VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11); CREATE TABLE dirimps ( dirimp smallint PRIMARY KEY -- TODO: Do we need name and/or definition from IENC feature catalogue? + -- (see page 381 of edition 2.3) ); +INSERT INTO dirimps VALUES (1), (2), (3), (4); +-- dirimp_5 left out because it cannot be used for waterway area CREATE TABLE depth_references ( depth_reference varchar(4) PRIMARY KEY