Mercurial > gemma
changeset 1722:cfaa1291294c
Merged.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Tue, 08 Jan 2019 20:02:11 +0100 |
parents | 837d12b49dfd (diff) 29a0fe218af9 (current diff) |
children | 50548a6df009 |
files | schema/isrs_functions.sql |
diffstat | 1 files changed, 2 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- 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(