Mercurial > gemma
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