Mercurial > gemma

comparison schema/tap_tests_data.sql @ 580:e78bdbb6cac8

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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 6590208e3ee1
comparison
equal deleted inserted replaced
579:642df1164aca 580:e78bdbb6cac8
18 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); 18 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz');
19 19
20 INSERT INTO limiting_factors VALUES ('depth'), ('width'); 20 INSERT INTO limiting_factors VALUES ('depth'), ('width');
21 21
22 INSERT INTO waterway.gauges ( 22 INSERT INTO waterway.gauges (
23 location, function_code, objname, geom, zero_point, source_organization) 23 location, objname, geom, zero_point, source_organization)
24 VALUES ( 24 VALUES (
25 ('AT', 'XXX', '00001', 'G0001', 1)::isrs, 25 ('AT', 'XXX', '00001', 'G0001', 1)::isrs,
26 'xxx',
27 'testgauge', 26 'testgauge',
28 ST_geomfromtext('POINT(0 0)', 4326), 27 ST_geomfromtext('POINT(0 0)', 4326),
29 0, 28 0,
30 'testorganization' 29 'testorganization'
31 ); 30 );