->

25 April 2007

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

Google Spreadsheets Geocoding Nearly
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: , , , ,

0 Comments:

Post a Comment

<< Home