Closest linestring to a point
Oracle EE 11g .2 release
Ok so I have a table of recods that have and SDO_GEOMETRY column and they are linestrings that represent roads. They are srid 8307.
So what I am trying to solve is to determine which records geometry is closest to a point type.
Since linestrings are maid up of several points how does one go about that. Logically each linestring could have points that were miles apart and my single point could be closer to a given point then many of the others in the linestring.
Do I have to unravel the points in the linestring or is there a function that will allow me to create an sdo_geometry that is of type point2D and then get the record that has the closest point on the linestring to my point2D?
Thanks in advance.