Mercurial > gemma

diff schema/tap_tests_data.sql @ 579:642df1164aca

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Ensure gauges are identified by appropriate ISRS location code The Object Reference Code ist checked according to section I.3.4 Waterway Gauge of the RIS-Index Encoding Guide.
author Tom Gottfried <tom@intevation.de>
date Thu, 06 Sep 2018 16:15:38 +0200
parents e6c9d2da2e20
children e78bdbb6cac8
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Thu Sep 06 13:19:51 2018 +0200
+++ b/schema/tap_tests_data.sql	Thu Sep 06 16:15:38 2018 +0200
@@ -22,7 +22,7 @@
 INSERT INTO waterway.gauges (
     location, function_code, objname, geom, zero_point, source_organization)
     VALUES (
-        ('AT', 'XXX', '00001', '00000', 1)::isrs,
+        ('AT', 'XXX', '00001', 'G0001', 1)::isrs,
         'xxx',
         'testgauge',
         ST_geomfromtext('POINT(0 0)', 4326),
@@ -35,7 +35,7 @@
     revisiting_time, limiting, source_organization, staging_done)
     VALUES (
         'testbottleneck1',
-        ('AT', 'XXX', '00001', '00000', 1)::isrs,
+        ('AT', 'XXX', '00001', 'G0001', 1)::isrs,
         isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
             ('AT', 'XXX', '00001', '00000', 2)::isrs),
         ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326),
@@ -43,7 +43,7 @@
         1, 'depth', 'testorganization', false
     ), (
         'testbottleneck2',
-        ('AT', 'XXX', '00001', '00000', 1)::isrs,
+        ('AT', 'XXX', '00001', 'G0001', 1)::isrs,
         isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
             ('AT', 'XXX', '00001', '00000', 2)::isrs),
         ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326),