Mercurial > gemma

comparison schema/tap_tests_data.sql @ 1629:9d51f022b8ee

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
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');