0

The following website can be used to enter a single pair of latitude and longitude coordinates and return a street address:

https://www.latlong.net/Show-Latitude-Longitude.html

I want to get street addresses for a table of lat long coords. Any ideas?

  • FYI, the site you link to is doing a process called "geocoding". What you want to do is "reverse geocoding". If you search on those two terms you'll probably find what you need. – Dan C May 1 '18 at 17:34
  • Do you have a table in database ? – Ahsan Mukhtar May 1 '18 at 17:36
  • I created an excel table of lat long coords that I uploaded to Google Maps, then I downloaded that map as a KML. Now I have a feature class of points. – Ryan Stephenson May 1 '18 at 18:45
2

You can use GeoPy to run a reverse geocode against a geocoding service, such as Google: https://geopy.readthedocs.io/en/stable/

To find the address corresponding to a set of coordinates:

>>> from geopy.geocoders import Nominatim
>>> geolocator = Nominatim()
>>> location = geolocator.reverse("52.509669, 13.376294")
>>> print(location.address)
Potsdamer Platz, Mitte, Berlin, 10117, Deutschland, European Union
>>> print((location.latitude, location.longitude))
(52.5094982, 13.3765983)
>>> print(location.raw)
{'place_id': '654513', 'osm_type': 'node', ...}

http://geopy.readthedocs.io/en/stable/index.html?highlight=reverse

1

Yes, there is a service to do that. It is called reverse geocoding and there are a few providers out there who can do that for you. The ones that are completely free will have some location offset from the actual target that can be from 50 miles to 1000 feet. An example of such a service is OpenStreetMap. If you follow the OSM link for an address 99 Monroe Ave Grand Rapids you will get an offset of 60 miles. And if you put 99 Monroe Ave Grand Rapids MI USA you get address not found.

enter image description here

Our company also has a batch reverse geocoding service that we provide to users online. Our output places each address component separately as well as we combine the full address in a separate column. You can read more about reverse geocoding here For example, if you place these coordinates 42.9650099, -85.6732398 inside the text filed on the batch geocoding tool

enter image description here

and you click Go,then select reverse geocoding and process the data.

enter image description here

The resulting file will contain your original input plus each address token in a separate column, the combined address, the relevance to the address input (1.0 is best) and the distance offset from the actual target.

enter image description here

Disclosure: I am the founder of CSV2GEO

0

You can write a Python script or any other language, that will read list of latitutde and longitude from the table and then pass to the url, that is returning the response. First you will need to have the URL, you can get that from the Network in console.

Once you have the URL, you can write a Python script using "Request" and "BeautifulSoup", that will make call to the URL and return a response and then you can use that response.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.