I need the query (SELECT) in MYSQL to know the line (Polyline) closest to a polygon.
mysql_query("This is i need").
I have a longitude and latitude google maps sends me, then I want a query to find me the lines that are within 500m of the point that sent me google maps
I have the coordinates of the routes in the database and the criteria is that the query returns the lines (routes) that are within 500m
Public transport routes are in the database as LineString
13 freelancers are bidding on average $1650 for this job
I have MySQL and GIS experience for this job. 30+ years of programming and database. I did GIS applications for urban spatial analysis of amenities. MySQL spatial extensions will handle your needs easily. Thanks!