Mercurial > gemma
comparison 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 |
comparison
equal
deleted
inserted
replaced
1628:8ad51ad5a9ee | 1629:9d51f022b8ee |
---|---|
62 ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326), | 62 ST_geomfromtext('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))', 4326), |
63 'AT', 'AT', 'AT', | 63 'AT', 'AT', 'AT', |
64 1, 'depth', 'testorganization', true | 64 1, 'depth', 'testorganization', true |
65 ); | 65 ); |
66 | 66 |
67 INSERT INTO waterway.distance_marks_virtual VALUES ( | |
68 ('AT', 'XXX', '00001', '00000', 0)::isrs, | |
69 ST_SetSRID('POINT(0 0)'::geometry, 4326), | |
70 'someENC' | |
71 ), ( | |
72 ('AT', 'XXX', '00001', '00000', 1)::isrs, | |
73 ST_SetSRID('POINT(1 0)'::geometry, 4326), | |
74 'someENC' | |
75 ); | |
76 | |
77 INSERT INTO waterway.waterway_axis (wtwaxs, objnam) VALUES ( | |
78 ST_SetSRID(ST_CurveToLine( | |
79 'CIRCULARSTRING(0 0, 0.5 0.5, 1 0, 1.5 -0.2, 2 0)'::geometry), | |
80 4326), | |
81 'testriver' | |
82 ), ( | |
83 ST_SetSRID('LINESTRING(0.5 0.5, 1 1)'::geometry, 4326), | |
84 'testriver' | |
85 ); | |
86 | |
67 INSERT INTO users.templates (template_name, template_data) | 87 INSERT INTO users.templates (template_name, template_data) |
68 VALUES ('AT', '\x'), ('RO', '\x'); | 88 VALUES ('AT', '\x'), ('RO', '\x'); |
69 INSERT INTO users.user_templates | 89 INSERT INTO users.user_templates |
70 VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO'); | 90 VALUES ('test_user_at', 'AT'), ('test_user_ro', 'RO'); |