# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1546974131 -3600
# Node ID cfaa1291294c7ef221e7f6bed59c8fb18415de1b
# Parent  837d12b49dfdc952a391e4f564041597976e6494# Parent  29a0fe218af94e5a492a4e26c17e502a8c5c506a
Merged.

diff -r 29a0fe218af9 -r cfaa1291294c schema/isrs_functions.sql
--- a/schema/isrs_functions.sql	Tue Jan 08 19:55:15 2019 +0100
+++ b/schema/isrs_functions.sql	Tue Jan 08 20:02:11 2019 +0100
@@ -61,10 +61,9 @@
                 FROM (
                     SELECT (ST_Dump(wtwaxs)).geom AS line
                         FROM axis) AS lines,
-                    (SELECT ST_Collect(st_buffer(from_point.geom, 0.0001),
-                                       st_buffer(to_point.geom, 0.0001)) AS pts
+                    (SELECT ST_Collect(from_point.geom, to_point.geom) AS pts
                         FROM from_point, to_point) AS points
-                WHERE ST_intersects(lines.line, points.pts)),
+                WHERE ST_intersects(ST_Buffer(lines.line, 0.0001), points.pts)),
         axis_substring AS (
             -- Use linear referencing to clip axis between distance marks
             SELECT ST_LineSubstring(