This map was created using GPS Visualizer's do-it-yourself geographic utilities.

Please wait while the map data loads...

  GPS Visualizer

Generating a dynamic map from a Google Spreadsheet

The markers on this map are pulled from the Google Drive spreadsheet shown below. If the data in the spreadsheet is updated, the map will be updated the next time it is viewed. You can create a map like this by pasting a spreadsheet's URL into the box labeled "URL that the map will load dynamically" in the Google Maps input form. (Just make sure that in Google Drive, you have enabled the "Publish to the web" feature.)

Although the spreadsheet does NOT contain a "desc" column -- which GPS Visualizer normally needs to display detailed information about each marker -- the map includes the following options as part of gv_options['dynamic_data'], which cause name and description fields to be constructed from existing columns:

synthesize_fields:{
  desc:'Height (feet): {elev. (ft)}<br> Height (meters): {elev. (m)}',
  folder:'{status}'
},

The synthesize_fields options allow you to put multiple fields together to form more complicated text; you do this by including the original field names in {curly brackets}. You can also include as much HTML coding as you want; in the desc example, line break tags (<br>) are used. You can include formulas for "synthesize name" and "synthesize description" right in GPS Visualizer's Google Maps input form -- just open the "Advanced waypoint options" section.

For more information on which fields can be used in a GPS Visualizer Google Map, see the waypoints tutorial, especially the last section entitled "Summary."