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

Bruce Rindahl bruce.rindahl at gmail.com
Tue Aug 4 13:42:35 PDT 2020


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200804/d90980f7/attachment.html>


More information about the postgis-users mailing list