I have a table of linestrings in MySQL. I need to run a query to find the distance between a point (latitude,longitude) and the closest point in the linestring. Query should find the closest linestring in the table and calculate the distance between the point and the closest point in the linestring. See attached MySQL script.
Skills: geographic information systems, geolocation, mysql programming