Google Maps developer Tip: Using Google Docs & Spreadsheets to create your Google Map
Written by Glenn Letham (GISuser editor)
Monday, 02 April 2007 An interesting tip comes our way from the Google developer weblog. Using data stored and maintained in a simple spreadsheet, users can use tools like the Google Spreadsheets API to quickly map your data using Google Maps.
The data is read into the wizard, optionally, the map configuration can be altered, the map is viewed online, and then the code is optionally generated and returned to the user... I think even I can handle this one!
Once the map is created the code can be used to quickly embed the map on a website or upload to a Google pages account. Those of you with no google account need not worry as a nifty tool is available from Esa where you can simply pass the ID of your Google Spreadsheet and see the resulting map. An example is here or you can simply substiture your spreadhsst's ID to view your data.
You can easily try this for yourself, provide you have a google account, some sample data, and Lat/Long values for your data - this may require the use of a geocoding routine and there are plenty of them out there, many are free! If you need to locate more mashup developer tools see this section in the GISuser repository (toolbox) - the Batch Geocoder may be a good starting point!
Recall, the Google Spreadsheets data API allows client applications to view and update Spreadsheets content in the form of Google data API ("GData") feeds
See more threads and details about Glenn's AnyGeo Weblog HERE The Editor (Glenn) started the AnyGeo blog some time ago and the threads are now also mirrored here at GISuser.com - RSS feed is available to add to your favorite news reader.
Featured Events
GeoWeb 2008 - This exciting annual conference will take place in Vancouver, Canada from July 21-25th, 2008 at the Morris J. Wosk Centre for Dialogue. The GeoWeb 2008 conference welcomes both public and private organizations to meet, discuss and learn about today’s most innovative geospatial technologies.
2008 ESRI International User Conference (ESRI UC) - Users from more than 120 countries come to learn new skills, share information, and discover best practices, tips, and tricks that they can use instantly. Be part of this extraordinary experience August 4–8, 2008, in San Diego, California.
2008 ESRI Survey & Engineering GIS Summit - August 2-5, San Diego, California. Join more than 400 surveyors and engineers in exploring the possibilities of GIS technology. See how GIS software integrates with surveying and engineering tools to provide more complete business solutions and field processes.
GITA 17th Annual GIS for Oil & Gas Conference and Exhibition, set for Sept. 21-24, 2008 - The conference is the only event of its kind, devoted exclusively to geospatial applications and technologies for all aspects of the oil and gas industry.
Community 
An interesting tip comes our way from the Google developer weblog. Using data stored and maintained in a simple spreadsheet, users can use tools like the Google Spreadsheets API to quickly map your data using Google Maps.
See more threads and details about 
Get GISuser news & updates via RSS
