Mercurial > gemma

diff schema/isrs_functions.sql @ 2486:bca9a7a89f28 octree-diff

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Merged default into octree-diff branch.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Fri, 01 Mar 2019 18:28:50 +0100
parents 7677a2850a2d
children 54c9fe587fe6
line wrap: on
line diff
--- a/schema/isrs_functions.sql	Fri Mar 01 18:28:12 2019 +0100
+++ b/schema/isrs_functions.sql	Fri Mar 01 18:28:50 2019 +0100
@@ -66,11 +66,8 @@
                         SELECT refgeom
                         UNION
                         -- Fill eventual gap
-                        SELECT ST_MakeLine(
-                            ST_ClosestPoint(
-                                ST_Boundary(refgeom), ST_Boundary(geom)),
-                            ST_ClosestPoint(
-                                ST_Boundary(geom), ST_Boundary(refgeom)))
+                        SELECT ST_ShortestLine(
+                                ST_Boundary(refgeom), ST_Boundary(geom))
                         UNION
                         -- Linestring to be added
                         SELECT geom)))