I'm locating the nearest point on a line segment with PostGIS and ST_ClosestPoint, I can select the point on each of these line segments which is closest to the starting point. Which looks something like this:
But! I cannot figure out how to get the second closest point, or the third closest point on a given segment.
What I would like is more like this:
I'd like a range of nearby points on the line segments.
Any thoughts about how this might be accomplished?