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

Top Geo News
Put Your News here! 
Social Connect




vimeostumble


Facebook

GISuser Sponsor


Recent Site Additions
Featured Webinar
Featured Video


GISuser TOP 10 Viewed Videos
More Photos and Videos

GIS Job Opportunities
 

Loads of GIS Jobs!

GIS Analyst
Data Processor
Software Developer
Support Analyst - Database
Applications Prototype Specialist–Web Development
Research Assistant for Geographic Information Centre
Academic Associate in Geographic Information Centre
Director of Mobile Product and Technology (Denver)
Subject Matter Expert — Infrastructure Industry - 12WD11118
GIS Analyst Senior
GISuser Sponsor

Directory
Sticker Giant 
Category: Photography Apps and Tools


GISuser Sponsor


AnyGeo - Anything Geospatial

↑ Grab this Headline Animator

GISuser RSS Feed
Home     

Feature - Using QR Codes to Deliver Maps Electronically
HOT JOB
post a GIS job * JOB OPPS * Subject Matter Expert, Autodesk CA / GIS Developer, VA
FEATURE - Using Social Media and Twitter To Land The Perfect Job
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 to GISuser



Search the Spatial Media Web Resources
More GISuser Features

feature articlesSee more GISuser Features HERE / See GISuser Spotlights Here

AnyGeo - Geospatial Updates from Glenn

↑ Grab this Headline Animator

Featured Events

 List Your Event Here 

2X A Week Newsletter

See Recent edition
newsletter

subscribe GISuser

We won't share your address!
Sponsor

Popular Stuff!


RSS and Feeds

Software

software reviews
Geo Technology Software

GISuser Site Sponsor


Most Popular
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 - 2011 All rights reserved / Privacy Statement