Skip to content

Instantly share code, notes, and snippets.

@mjrich

mjrich/google-refine-geocoding

Created July 15, 2012 21:13
Show Gist options
  • Star 4 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save mjrich/3118660 to your computer and use it in GitHub Desktop.
Save mjrich/3118660 to your computer and use it in GitHub Desktop.
Download ZIP
Google Refine Geocoding
Raw
google-refine-geocoding
Step One
Fetch URL based on column:
'http://www.datasciencetoolkit.org/maps/api/geocode/json?sensor=false&address=' + escape(value, 'url')'
Step Two
Parse Json for longitude:
value.parseJson()["results"][0]["geometry"]["location"]["lng"]
then latitude:
value.parseJson()["results"][0]["geometry"]["location"]["lat"]
Source: http://www.youtube.com/watch?v=5tsyz3ibYzk&feature=player_embedded
@mjrich
Copy link
Author

mjrich commented Jul 15, 2012

Clickable Google Refine Video Instructions

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment