Google Spreadsheets - Geocoding
Google Spreadsheets - Geocoding (well almost...)
Mapperz looking for London (UK), but gets the wrong London!
*Please note this is not a full solution and it might seem to geocode, but check all locations.
Not really documented on the geocoding side but the is =GoogleLookup function that seems to understand "latitude" and "longitude" in a request formula in Google Spreadsheets
Here is an example (google account holders can edit and see the function)
http://spreadsheets.google.com/pub?key=pAxR-aN5DCiWkZ60GpHxJOQ
Note 'London' is not London,UK but London (Kentucky)
Same goes with Paris, no it's not Paris, France but Paris, Kentucky
detecting a pattern here?
But potentially a useful service, though some standards are needed to be able to get the correct users location, maybe "Location, State/County, Country"
For more information on this have a look at Ogle Earth post on it.
Sticking to having lat and lng fields in the spreadsheet and using google maps with
javascript:void(prompt(%22http://www.google.co.uk/search?
q=%22,gApplication.getMap().getCenter()));
(copy and paste that code, if doing lots create a bookmark, FireFox works best)
More details on that script on a previous post.
Labels: Geocoding, GoogleLookup, Issues, Spreadsheet, Standards
0 Comments:
Post a Comment
<< Home