changeset 2450:7677a2850a2d

Substitute unnecessarily home-made shortest line
author Tom Gottfried <tom@intevation.de>
date Fri, 01 Mar 2019 15:52:53 +0100
parents 0c9121abf120
children 960550ccca55
files schema/isrs_functions.sql
diffstat 1 files changed, 2 insertions(+), 5 deletions(-) [+]
line wrap: on
line diff
--- a/schema/isrs_functions.sql	Fri Mar 01 13:51:09 2019 +0100
+++ b/schema/isrs_functions.sql	Fri Mar 01 15:52:53 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)))