I need the query (SELECT) in MYSQL to know the line (Polyline) closest to a polygon.
$450-3750 MXN
Preklicano
Objavljeno pred več kot 11 leti
$450-3750 MXN
Plačilo ob dostavi
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
Saludos.
I work with a software team in the transportation field, so I know what geo formulas to use to get the closest distance to a polygon. I would need to know the exact table structure, but I'm confident it can be accomplished.
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!