And adding a ST_DumpSegments function would help make this (and other uses cases) simpler as well.
On Tue, Aug 4, 2020 at 2:51 PM Martin Davis <[email protected]> wrote: > 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
