Mercurial > gemma

comparison schema/isrs_tests.sql @ 2431:48495bd3081d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Construct stretch area between distance marks also from non-contiguous axis Before, both distance marks were required to be next to the same linestring of the waterway axis.
author Tom Gottfried <tom@intevation.de>
date Thu, 28 Feb 2019 19:44:38 +0100
parents 8481e6266691
children 00cac7890574
comparison
equal deleted inserted replaced
2430:2a93a8649751 2431:48495bd3081d
98 -((ST_XMax(:'test_area'::geometry) 98 -((ST_XMax(:'test_area'::geometry)
99 - ST_XMin(:'test_area'::geometry))/3), 99 - ST_XMin(:'test_area'::geometry))/3),
100 0)), 100 0)),
101 4326))), 101 4326))),
102 'Self-intersecting multipolygon leads to one polygon in result'); 102 'Self-intersecting multipolygon leads to one polygon in result');
103
104 SELECT ok(
105 ISRSrange_area(
106 isrsrange(
107 ('AT', 'XXX', '00001', '00000', 0)::isrs,
108 ('AT', 'XXX', '00001', '00000', 2)::isrs),
109 (SELECT ST_Collect(CAST(area AS geometry))
110 FROM waterway.waterway_area)) IS NOT NULL,
111 'Area generated from non-matching distance mark and non-contiguous axis');