Mercurial > gemma

diff schema/tap_tests_data.sql @ 2781:a2127495093e

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Prevent duplicate waterway axis and area geometries Duplicate axis geometries can prevent finding a contiguous axis between two distance marks in the current implementation of ISRSrange_axis(). Although duplicate area geometries did not show to be harmful up to now, they do not seem to be useful and generally duplicate geometries have the potential to make debugging of any geometry processing harder.
author Tom Gottfried <tom@intevation.de>
date Fri, 22 Mar 2019 14:35:32 +0100
parents d316a6e41f54
children ec6163c6687d
line wrap: on
line diff
--- a/schema/tap_tests_data.sql	Fri Mar 22 14:20:08 2019 +0100
+++ b/schema/tap_tests_data.sql	Fri Mar 22 14:35:32 2019 +0100
@@ -119,7 +119,7 @@
         ORDER BY id ASC, ids DESC
         FETCH FIRST ROW ONLY)),
 cleaned1 AS (
-    SELECT geom
+    SELECT DISTINCT geom
         FROM (SELECT (ST_Dump(cbuf)).geom FROM cleaned) AS dmp,
             waterway.waterway_axis
         WHERE ST_Intersects(geom, wtwaxs))