About | Contact | SUBMIT PRESS | Advertise | FAQ
Newsletters | Twitter |
HomeNewsArticlesExpertsDataJobsEDULBSSTOREEVENTSDirectoryBLOGPHOTOSSocial Media
 
advertisement

Top Geo News
Put Your News here! 
Social Connect




vimeostumble


GISuser Sponsor


GISuser Videos


See also SpatialVideos Youtube

Recent Site Additions
Webinars
GIS Job Opportunities
 

Loads of GIS Jobs!

Senior GIS Analyst
Research Analyst in Geospatial Analytics
GIS Specialist III
Implementation Specialist
GIS Technician (Temporary)
quantitative Internet Geographer/Sociologist
Engineering Technician-GIS
Senior GIS Web Developer
UX Designer/Developer Lead
State GIS Coordinator
GISuser Sponsor

Directory
TdhGIS - Vector based Spatial Analysis 
Category: Free GIS Software


GISuser Sponsor


feed

AnyGeo - Anything Geospatial

↑ Grab this Headline Animator

GISuser Feed

Hot Job

hot gis tech job
JavaScript Developer, VA

Home     

HOT JOB
post a GIS job * JOBS * Senior GIS Analyst CO / JavaScript Developer 
Browse GEO Job Opportunities
/ Geotech Salary Survey
Google Maps developer Tip: Using Google Docs & Spreadsheets to create your Google Map E-mail
Written by Glenn Letham (GISuser editor)   
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.

For example, see this sample data at http://spreadsheets.google.com/pub?key=pnEs2B_37S-DGGFI6kdQZPQ. Using data from this spreadsheet, parsed as a JASON feed (see http://code.google.com/apis/gdata/json.html), the data is then loaded into a map by using a simple spreadsheet map wizard (See Here).

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

Other Useful Links:
http://docs.google.com/
http://spreadsheets.google.com
http://code.google.com/apis/spreadsheets/gdata.html
http://code.google.com/apis/gdata/json.html
http://code.google.com/apis/gdata/index.html
http://gmaps-samples.googlecode.com/svn/trunk/spreadsheetsmapwizard/makecustommap.htm

Last Updated ( 11 July 2007 )
 
< Prev   Next >

Submit Your GIS/Geo News/PR

Featured Events

 List Your Event Here 

THE GISuser Newsletter

See Recent edition
newsletter

subscribe GISuser

We won't share your address!
Sponsor

Popular Stuff!


GISuser Site Sponsor


Most Popular
Dev Tips


Programming with Python

GISuser HOT Spots!

Google Mashup Zone
GISuser WebMaps
Free Data Articles
Spotlights & Tips
GISuser Resumes
Data Links
10 Cool Things
The LBS Zone!


Partner Sites


lbszone.com


symbianone

A Spatial Media LLC property




Spatial Media, LLC ©2003 - 2013 All rights reserved / Privacy Statement