Find all segments of a LineString within distance of a point
Recently I was asked: Is it possible to find all the line string with in certain distance from a point (lat, lon). It is a pretty simple question (if I interpret it correctly). Here is a solution for Oracle Spatial: Here is the input linestring and point and the result of the query: