[postgis-users] Find LineString segment index containing closest point?
mtnclimb at gmail.com
Tue Aug 4 09:52:34 PDT 2020
On Tue, Aug 4, 2020 at 8:46 AM Martin Davis <mtnclimb at gmail.com> wrote:
> A frequent question on GISSE is to find the LineString segment index
> containing the closest point to a given point, to allow inserting the
> closest point into the line using AT_AddPoint.
I just realized that ST_Snap does a nice job of inserting close points into
LineStrings in a single step:
SELECT ST_AsText( ST_Snap(
'LINESTRING (1 2, 1 5, 1 9)',
'POINT (1 3)',
I have updated the GISSE posts (including this one  about snapping to
It would still be useful to be able to get the segment index for other use
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users