[postgis-users] Find LineString segment index containing closest point?

Martin Davis mtnclimb at gmail.com
Tue Aug 4 14:51:07 PDT 2020

Good find.  And yes, the only approach currently that seems viable is to
iterate over the segments in some way and select the closest.

Nowadays using LATERAL JOIN might make this a bit simpler.

On Tue, Aug 4, 2020 at 1:43 PM Bruce Rindahl <bruce.rindahl at gmail.com>

> I found this post from a few years back by Paul Ramsey:
> http://blog.cleverelephant.ca/2015/02/breaking-linestring-into-segments.html
> One of the examples gives a collection of each segment of the line along
> with what you can use as an index.  Could you then query for the closest
> geometry from that collection and get the index number?
> Sorry, I can't test right now as my pgadmin is not working.
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200804/3cbe4ab2/attachment.html>

More information about the postgis-users mailing list