Mercurial > gemma

diff schema/tap_tests_data.sql @ 2431:48495bd3081d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Construct stretch area between distance marks also from non-contiguous axis Before, both distance marks were required to be next to the same linestring of the waterway axis.
author Tom Gottfried <tom@intevation.de>
date Thu, 28 Feb 2019 19:44:38 +0100
parents 4c16f5ad1905
children 79f4a20e31c2
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Thu Feb 28 17:30:26 2019 +0100
+++ b/schema/tap_tests_data.sql	Thu Feb 28 19:44:38 2019 +0100
@@ -76,6 +76,10 @@
     ('AT', 'XXX', '00001', '00000', 1)::isrs,
     ST_SetSRID('POINT(1 0)'::geometry, 4326),
     'someENC'
+), (
+    ('AT', 'XXX', '00001', '00000', 2)::isrs,
+    ST_SetSRID('POINT(1.6 0)'::geometry, 4326),
+    'someENC'
 );
 
 INSERT INTO waterway.waterway_axis (wtwaxs, objnam) VALUES (
@@ -89,6 +93,9 @@
 ), (
     ST_SetSRID('LINESTRING(0.5 0.5, 1 1)'::geometry, 4326),
     'testriver'
+), (
+    ST_SetSRID('LINESTRING(1.5 0.1, 2 0)'::geometry, 4326),
+    'testriver'
 );
 
 -- Simulate waterway area as non-intersecting buffers around axis