Mercurial > gemma

changeset 1717:6646ba22c94a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Made ISRSrange_area a bit more tolerant to work with reql world data. Kudos to SLT for implementing the fix.
author Sascha Wilde <wilde@intevation.de>
date Tue, 08 Jan 2019 17:29:53 +0100
parents 99be34d8f37a
children 8ddbedf296d7
files schema/isrs_functions.sql
diffstat 1 files changed, 3 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/schema/isrs_functions.sql	Tue Jan 08 16:59:04 2019 +0100
+++ b/schema/isrs_functions.sql	Tue Jan 08 17:29:53 2019 +0100
@@ -47,9 +47,10 @@
                 FROM (
                     SELECT (ST_Dump(wtwaxs)).geom AS line
                         FROM axis) AS lines,
-                    (SELECT ST_Collect(from_point.geom, to_point.geom) AS pts
+                    (SELECT ST_Collect(st_buffer(from_point.geom, 0.0001),
+                                       st_buffer(to_point.geom, 0.0001)) AS pts
                         FROM from_point, to_point) AS points
-                WHERE ST_Covers(lines.line, points.pts)),
+                WHERE ST_intersects(lines.line, points.pts)),
         axis_substring AS (
             -- Use linear referencing to clip axis between distance marks
             SELECT ST_LineSubstring(