1

Let's clarify the issue. I want to find the location of nearest ATM booths from my house. I have the latitude and longitude values of my location and a distance value let's say 500 meter around my house. I need to find the locations (latitudes) of ATM booths 500 meter around my house. Input value: 1. latitude of my house, 2. Distance in meter

Asking for your valuable suggestions.

Fahad Munir
  • 31
  • 2
  • 7
  • Where are the ATM locations stored? Why do you only want the latitudes of the ATMs and not the longitudes? – Mark Setchell Jul 26 '20 at 13:06
  • Locations are stored in mysql database as a latitude and longitude. I want to use latitude because it can easily be converted as kilometers or meter as it's value is more consistent than longitude. – Fahad Munir Jul 26 '20 at 13:12
  • But it probably won't be possible to measure the actual distance only based on latitudes. – Fahad Munir Jul 26 '20 at 13:29
  • https://stackoverflow.com/questions/11112926/how-to-find-nearest-location-using-latitude-and-longitude-from-sql-database – geocodezip Jul 26 '20 at 14:33
  • https://automating-gis-processes.github.io/site/notebooks/L3/nearest-neighbor-faster.html – Willem Hendriks Jul 28 '20 at 13:47
  • 1
    Google Maps' Places API Nearby Search can help you achieve this. It's a service that lets you search for places within a specified area: https://developers.google.com/places/web-service/search#PlaceSearchRequests – jabamataro Jul 31 '20 at 05:16
  • Since you use MySQL, you can probably use the spatial convenience functions, and have MySQL actually return you the distance between the house and all the points see https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html#function_st-distance-sphere – Wolf Bergenheim Aug 03 '20 at 12:16

0 Answers0