diff schema/tap_tests_data.sql @ 1629:9d51f022b8ee

Introduce SQL function to clip an area to a stretch
author Tom Gottfried <tom@intevation.de>
date Wed, 19 Dec 2018 17:59:31 +0100
parents f65d1767452c
children 9f8f7d3fd655
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Wed Dec 19 16:48:00 2018 +0100
+++ b/schema/tap_tests_data.sql	Wed Dec 19 17:59:31 2018 +0100
@@ -64,6 +64,26 @@
         1, 'depth', 'testorganization', true
     );
 
+INSERT INTO waterway.distance_marks_virtual VALUES (
+    ('AT', 'XXX', '00001', '00000', 0)::isrs,
+    ST_SetSRID('POINT(0 0)'::geometry, 4326),
+    'someENC'
+), (
+    ('AT', 'XXX', '00001', '00000', 1)::isrs,
+    ST_SetSRID('POINT(1 0)'::geometry, 4326),
+    'someENC'
+);
+
+INSERT INTO waterway.waterway_axis (wtwaxs, objnam) VALUES (
+    ST_SetSRID(ST_CurveToLine(
+        'CIRCULARSTRING(0 0, 0.5 0.5, 1 0, 1.5 -0.2, 2 0)'::geometry),
+        4326),
+    'testriver'
+), (
+    ST_SetSRID('LINESTRING(0.5 0.5, 1 1)'::geometry, 4326),
+    'testriver'
+);
+
 INSERT INTO users.templates (template_name, template_data)
     VALUES ('AT', '\x'), ('RO', '\x');
 INSERT INTO users.user_templates