I have a table called
place_name geometry, place_type and many other info related to the city. My database system is PostGIS.
My requirement is:
Given a latitude and longitude (which may or many not be the exact lat and long stored in the database), I need to find the nearest city or place_name from the table
osm_places with the help of the input latitude and longitude. Any help is highly appreciated.
Is there a nearest neighbor implementation in php available for this or SQL to handle this?