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 <[email protected]> wrote: > 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 > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
