Mercurial > gemma
diff schema/isrs_functions.sql @ 2450:7677a2850a2d
Substitute unnecessarily home-made shortest line
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Fri, 01 Mar 2019 15:52:53 +0100 |
parents | 48495bd3081d |
children | 54c9fe587fe6 |
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)))