Python, Geocoding Intersecting Addresses

Question

Hello I currently have a great geocoder I built in python using googles geocoder API service. It works great, but the issue that does not work great is that it will not correctly geocode intersecting addresses that are given in the CSV file for example:

9th & Upshur St NW
Park Rd & Holmead Pl NW
14th & Girard St NW
10th & K St NW

The & sign in the addresses are causing an issue when geocoding and resulting in random coordinates.

Is these a work around or way to read these intersecting addresses with & sign splitting the 2 addresses?

thanks

https://stackoverflow.com/a/38096991/2573061 -- try 'and' instead of '&' — C8H10N4O2, Aug 25 '17 at 20:10
@C8H10N4O2 You're awesome, that worked! thank you very much! — Michael McKeever, Aug 25 '17 at 20:22

score 0 · Answer 1 · answered Aug 25 '17 at 21:29

You should URL encode the query string. After URL encode special symbols will be converted. For example & will be converted to %26. Resulting request should be something like:

https://maps.googleapis.com/maps/api/geocode/json?address=9th%20%26%20Upshur%20St%20NW&key=YOUR_API_KEY

Have a look at this question to figure out how to URL encode query string in python:

How to urlencode a querystring in Python?

Hope this helps!

Python, Geocoding Intersecting Addresses

1 Answers1