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:
51.38356, 0.15047
51.42524,0.23797
51.40002,0.20599
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
sample DB
[login to view URL]
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.
hello
sir i can give this work with 100% satisfaction within time limit,and also i have great hands on SQL ,waiting for your message
Experience in PHP, PHP Frameworks Like Codeigniter, Yii 2 and laravel 5 and its customization.