Mercurial > gemma

comparison schema/gemma.sql @ 927:48f70782400d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 271561dce2e6
children 688e1530f66a 71445b091415
comparison
equal deleted inserted replaced
925:15bf101e1522 927:48f70782400d
82 ); 82 );
83 83
84 CREATE TABLE catccls ( 84 CREATE TABLE catccls (
85 catccl smallint PRIMARY KEY 85 catccl smallint PRIMARY KEY
86 -- TODO: Do we need name and/or definition from IENC feature catalogue? 86 -- TODO: Do we need name and/or definition from IENC feature catalogue?
87 ); 87 -- (see page 328 of edition 2.3)
88 );
89 INSERT INTO catccls VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11);
88 90
89 CREATE TABLE dirimps ( 91 CREATE TABLE dirimps (
90 dirimp smallint PRIMARY KEY 92 dirimp smallint PRIMARY KEY
91 -- TODO: Do we need name and/or definition from IENC feature catalogue? 93 -- TODO: Do we need name and/or definition from IENC feature catalogue?
92 ); 94 -- (see page 381 of edition 2.3)
95 );
96 INSERT INTO dirimps VALUES (1), (2), (3), (4);
97 -- dirimp_5 left out because it cannot be used for waterway area
93 98
94 CREATE TABLE depth_references ( 99 CREATE TABLE depth_references (
95 depth_reference varchar(4) PRIMARY KEY 100 depth_reference varchar(4) PRIMARY KEY
96 -- See col. AB and AI RIS-Index Encoding Guide 101 -- See col. AB and AI RIS-Index Encoding Guide
97 -- XXX: We need a way to distinguish between geodetic (eg. col. AP 102 -- XXX: We need a way to distinguish between geodetic (eg. col. AP