I want to do reverse geocoding from MySQL or PostGIS SQL.
I have shapefile up to town level of India. So I have a geometry boundary for each town.
What I want is to first find the nearest point from the current position and check that point is in which towns.
I want to get the result in this format: Towns, District, State, Country
I dont have knowledge of PostGIS SQL but I know MySQL. But if anyone can help me I will use the PostGIS SQL also.
So I want fastest way to do reverse geocoding.