Mercurial > gemma
changeset 580:e78bdbb6cac8
Remove worthless attribute
According to RIS-Index Encoding Guide, section I.3.4 Waterway Gauge,
the function code of a gauge is always 'wtwgag'. There is no point in
storing the same value with every record.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Thu, 06 Sep 2018 16:27:17 +0200 |
| parents | 642df1164aca |
| children | fb5d9d5ff320 |
| files | schema/gemma.sql schema/tap_tests_data.sql |
| diffstat | 2 files changed, 1 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/schema/gemma.sql Thu Sep 06 16:15:38 2018 +0200 +++ b/schema/gemma.sql Thu Sep 06 16:27:17 2018 +0200 @@ -204,7 +204,6 @@ location isrs PRIMARY KEY CHECK( (location).orc SIMILAR TO 'G[[:digit:]]{4}' AND CAST(substring((location).orc from 2 for 4) AS int) < 2048), - function_code varchar(10) NOT NULL, -- XXX: What is this really for? objname varchar NOT NULL, is_left boolean, -- XXX: Or reference position_codes? geom geography(POINT, 4326) NOT NULL,
--- a/schema/tap_tests_data.sql Thu Sep 06 16:15:38 2018 +0200 +++ b/schema/tap_tests_data.sql Thu Sep 06 16:27:17 2018 +0200 @@ -20,10 +20,9 @@ INSERT INTO limiting_factors VALUES ('depth'), ('width'); INSERT INTO waterway.gauges ( - location, function_code, objname, geom, zero_point, source_organization) + location, objname, geom, zero_point, source_organization) VALUES ( ('AT', 'XXX', '00001', 'G0001', 1)::isrs, - 'xxx', 'testgauge', ST_geomfromtext('POINT(0 0)', 4326), 0,