Mercurial > gemma

comparison schema/tap_tests_data.sql @ 2514:79f4a20e31c2

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Introduce distance limit up to which axis linestrings are connected Before, e.g. a linestring representing a tributary with its mouth in the middle of another linestring, had been connected to the end of the latter.
author Tom Gottfried <tom@intevation.de>
date Tue, 05 Mar 2019 15:44:05 +0100
parents 48495bd3081d
children d316a6e41f54
comparison
equal deleted inserted replaced
2511:e958104be9a9 2514:79f4a20e31c2
92 'testriver' 92 'testriver'
93 ), ( 93 ), (
94 ST_SetSRID('LINESTRING(0.5 0.5, 1 1)'::geometry, 4326), 94 ST_SetSRID('LINESTRING(0.5 0.5, 1 1)'::geometry, 4326),
95 'testriver' 95 'testriver'
96 ), ( 96 ), (
97 ST_SetSRID('LINESTRING(1.5 0.1, 2 0)'::geometry, 4326), 97 ST_SetSRID('LINESTRING(1.5 0.00001, 2 0)'::geometry, 4326),
98 'testriver' 98 'testriver'
99 ); 99 );
100 100
101 -- Simulate waterway area as non-intersecting buffers around axis 101 -- Simulate waterway area as non-intersecting buffers around axis
102 WITH RECURSIVE 102 WITH RECURSIVE