->

11 June 2009

Google Fusion Tables [Fast Batch Geocoding]

Google Fusion Tables [Fast Batch Geocoding]

"A fast an effective way to batch geocode spreadsheet data."

World Cities Population in Open Office
Take some data, with no geographic information. Upload to the New Google Fusion Tables and Map it.

Some spot checking of data in location - as geocoding is not an exact science.
World Cities with population checking locations

Simply import the data will then give you access to 'Map' the data.

Automatic Batch Geocoding
Then the real magic of automatic batch geocoding on the fly - you can visually see the data being placed on the map.
All within a few seconds - then whole process takes less than 30 seconds [based on 606 cities] though only 1-200 markers are display at one time.

And to finish it off - it is easy to create a simple thematic map.Population Summary Thematic Map

Suggestions, would be nice to be able to overlay the thematic map [based in flash] over the Google Map (or creating gpolygons).
Sharing with the option of embedding and link to would be convenient.
*Note currently in Google Labs things will change.

A nice tool with great potential has unique features and powerful visualization functions.

Summary
Google Chart meets Google Maps with Google Spreadsheets binding them.

Related
http://googlemapsmania.blogspot.com/2009/06/
google-fusion-tables-google-maps.html

Official Post
http://googleresearch.blogspot.com/2009/06/google-fusion-tables.html

Labels: , , , , , , , ,

4 Comments:

At Thursday, June 11, 2009 3:26:00 pm, Anonymous Anonymous said...

What about getting the geocoded data back into the raw format in the spreadsheet now? Yes the data is geocoded on the map, but it would be nice to get it back in the spreadsheet with lat/long values so you can use the data elsewhere. I suppose this would be fairly easy using the google maps api to loop through the points and get their lat/long values and insert into the spreadsheet, or is there an existing automated method for this?

 
At Thursday, June 11, 2009 4:13:00 pm, Blogger Mapperz said...

If you want a down-loadable file to use yourself that has latitude and longitude then there are plenty geocoders available online.

example:
http://dev.paulcarvill.net/sandbox/geocode-spreadsheet/

source:
http://www.google.co.uk/search?q=spreadsheet+geocode

'never trust a geocoder'

 
At Tuesday, April 13, 2010 12:03:00 am, Blogger skei said...

You can also get the coordinates from the kml file.

 
At Monday, September 27, 2010 9:11:00 pm, Anonymous Anonymous said...

route4me offers publicly available batch geocoding and reverse geocoding with file export capabilities.

 

Post a Comment

<< Home