Mercurial > gemma

comparison schema/tap_tests_data.sql @ 3645:02951a62e8c6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
'Historicise' bottlenecks on import
author Tom Gottfried <tom@intevation.de>
date Wed, 12 Jun 2019 17:11:15 +0200
parents ec6163c6687d
children 1ecfe5d015b0
comparison
equal deleted inserted replaced
3644:9e91b416d5bb 3645:02951a62e8c6
55 ST_geomfromtext('POINT(0 0)', 4326), 55 ST_geomfromtext('POINT(0 0)', 4326),
56 0, 56 0,
57 current_timestamp, 57 current_timestamp,
58 'testorganization', 58 'testorganization',
59 current_timestamp) 59 current_timestamp)
60 RETURNING location, validity), 60 RETURNING location, validity, validity),
61 bns AS ( 61 bns AS (
62 VALUES ( 62 VALUES (
63 'testbottleneck1', 63 'testbottleneck1',
64 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, 64 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
65 ('AT', 'XXX', '00001', '00000', 2)::isrs), 65 ('AT', 'XXX', '00001', '00000', 2)::isrs),
66 ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326), 66 ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326),
67 'AT', 'AT', 'AT', 67 'AT', 'AT', 'AT',
68 1, 'depth', 'testorganization', false 68 1, 'depth', current_timestamp, 'testorganization', false
69 ), ( 69 ), (
70 'testbottleneck2', 70 'testbottleneck2',
71 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs, 71 isrsrange(('AT', 'XXX', '00001', '00000', 0)::isrs,
72 ('AT', 'XXX', '00001', '00000', 2)::isrs), 72 ('AT', 'XXX', '00001', '00000', 2)::isrs),
73 ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326), 73 ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326),
74 'AT', 'AT', 'AT', 74 'AT', 'AT', 'AT',
75 1, 'depth', 'testorganization', true 75 1, 'depth', current_timestamp, 'testorganization', true
76 )) 76 ))
77 INSERT INTO waterway.bottlenecks ( 77 INSERT INTO waterway.bottlenecks (
78 gauge_location, gauge_validity, 78 gauge_location, gauge_validity, validity,
79 bottleneck_id, stretch, area, rb, lb, responsible_country, 79 bottleneck_id, stretch, area, rb, lb, responsible_country,
80 revisiting_time, limiting, source_organization, staging_done) 80 revisiting_time, limiting, date_info, source_organization, staging_done)
81 SELECT * FROM gs, bns; 81 SELECT * FROM gs, bns;
82 82
83 INSERT INTO waterway.distance_marks_virtual VALUES ( 83 INSERT INTO waterway.distance_marks_virtual VALUES (
84 ('AT', 'XXX', '00001', '00000', 0)::isrs, 84 ('AT', 'XXX', '00001', '00000', 0)::isrs,
85 ST_SetSRID('POINT(0 0)'::geometry, 4326), 85 ST_SetSRID('POINT(0 0)'::geometry, 4326),