I'm looking for a SQL query on a postgres database that will find the closest road geometry and return the closest matching database record.
Sample Latitude, Longitude for Lookup:
This query needs to be able to handle a 1 lat/long value or multiple lat/long values
It needs to search: Streets_polyline, B_Roads_polyline, Motorways_polyline
searching the "geom" column as the road polyline line string
[url removed, login to view]
6 freelancers are bidding on average $122 for this job
hi I have 5 year experience. I can show you my precious work I'm ready to start now I'm individual freelancer I have no timing issue I can do work any time . so can we discuss once.