Training Materials

Table of Contents





Introduction to Nonprofit Mapping Technologies

Google Mapping Tools Basic Track 

Google Earth Basics

    1. Create a placemark, and add text in the balloon: "Strathcona Park, designated in 1911, is the oldest provincial park in British Columbia."
    2. Change the icon of the placemark.
    3. Add a custom icon of a hiker: www.env.gov.bc.ca/bcparks/events/100Adventure/images/hikes.gif (source page)
    4. Create a path.
    5. Create a polygon.
    6. Modify the style of your features and labels.
    7. Add link to balloon(s): www.env.gov.bc.ca/bcparks/explore/parkpgs/strath/
    8. Add a photo of a bear in your placemark(s): click to link to jpg image (source page)
    9. Download the image of a Roosevelt Elk to your computer by clicking here, and then add it to the balloon of one of your placemarks.
    10. Add a photo of a trail to one of your placemarks: click to link to jpg image (source page)
    11. Embed a YouTube video of bear sighting in a placemark: http://www.youtube.com/watch?v=Fk5BmOQgXy0
    12. Overlay the Strathcona Park Map (using image overlay tool): click to link to jpg image (source page)
    13. Add views and perspectives to each annotation.
    14. Create a folder to hold everything you've created for this project.
    15. Create a tour of your project using one of the three methods discussed.
    16. Save your project as a KMZ file.

Google Maps Basics

Google Fusion Tables Basics

Exercise 1: Import Your Data
  • STEP ONE: Import Data into Fusion Tables. Download the Strathcona.kml or Strathcona.csv file, the iNaturalist File and the GBIF occurrences file. 
  • STEP TWO: Import those datasets into Fusion Tables by clicking New Table > Import. 
    • Sign in with this Google Account:
      • canadaworkshop2011; password ilovemaps!
    • Important: When you import your datasets, BE SURE to include your name on the title so you know which one's yours!
    • Make sure that the columns are the correct format. To check, go to Edit > Modify Columns. You are either basing your location data off of a country or a two-column designation (Latitude, Longitude). 
Exercise 2: Merge two Datasets
  • STEP ONE: Download GBIF occurrences with icons XLS:
  • STEP TWO: Import GBIFoccurrences.xls file into Fusion Tables
  • STEP THREE: Once imported, copy the table ID (it's a 7-digit number at the end of the url, like http://www.google.com/fusiontables/DataSource?dsrcid=1612144)
  • STEP FOUR: Go back to the GBIFoccurrences file you imported earlier. Select "Merge" and paste the table ID into the "Merge with" field. You will see the columns from GBIFoccurrences_icons.xls appear. Choose the two columns that the tables share in common, which in this case is "Catalogue number". You are going to create a new table out of these two tables, so give it a new name (with your name in it!). Select Merge.
  • STEP FIVE: Check out your new table. You should see custom icons for the map pins. 
  • TIP: There are many more icons available now in Fusion Tables...over 200! See them all here: https://www.google.com/fusiontables/DataSource?snapid=99003
Exercise 3: Display two datasets alongside each other - Mash 'em up! 
  • STEP ONE: Have the iNaturalist dataset and the GBIFoccurrences_icons (your versions of both files) open in a browser window. 
  • STEP TWO: Go to Google Fusion Tables Layer Builder (http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/fusiontableslayer_builder.html)
  • STEP THREE: Under Add Layer, enter the table IDs from the iNaturalist dataset into the field. Wait a moment, and you'll be able to select the column headers to choose the location column. Click "Add Layer." Zoom in to a zoom level that allows you to see all your data. Click "Update Map." Further down, select "Add Another Feature" and choose "Another layer." Repeat with the GBIFoccurrences_icons dataset and select "Add Layer." You'll see both your tables in the preview window!
Exercise 4: Embed your Fusion Tables in a Blog
  • Layer Builder Code
    • STEP ONE: Go to our Blog: http://canadaworkshop2011.blogspot.com/. (Note: you must be signed in with canadaworkshop2011@gmail.com; password: ilovemaps!) Select New Post. Make sure you are in "Edit HTML" mode.
    • STEP TWO: Take the code from the Fusion Table Layer Builder. Paste it into the post and give your post a title (with your name on it!). Publish your post, and check out your handiwork!
  • Fusion Tables Embed Code
    • STEP ONE: When in Map view, click "Get Embeddable Code." Copy all the code that appears in the window by clicking in the window and selecting CTRL-A or CMD-A (Mac).
    • STEP TWO: Go to Blogger and create a new post. You must be in "Edit HTML" mode. Paste the embed code in the blog, give it a title with your name on it, and Publish!


Google Mapping Tools Advanced Track


Google Maps API


Google Fusion Tables API


TUESDAY



Open Data Kit
  • Session slide deck (download PPT)
  • Download ODK 1.1.5 from the Android App Market
  • Download the latest Beta version by visiting the ODK Downloads page for Collect 1.1.7 on your mobile device and downloading the file onto your phone. Note: You must allow downloads from 3rd party sites (outside the App Market). 
GIS-to-Google Earth Basics

Spreadsheet Mapper

GPS Data in Google Earth

  • Download GPX File: pbirch_wed.gpx (download)
  • Download GPX saved as KML File: SkiSquaw.kml (download)
  • Download KML File: FridaysEagle_vs_Huge (download)
  • Download FNR_Aug20_2010.kmz (download)
  • Download SaveTheElephants.kmz (download)

Your First Maps API


What's New in Geo: Earth Builder & Engine Demo


Tour Storyboarding

Start coding with KML

Custom Charts & Icons with the Google Chart Tools API


Advanced GIS

More Fusion Tables Mapping

  • Filter Data - play with Filtering and Aggregating options on the Costa Rica Caterpillar Data. For example, aggregate by Sex and Wingspan to see that Females have an overall larger wingspan than males.
Exercise 1: Display two datasets alongside each other - Mash 'em up! 
  • STEP ONE: Have the iNaturalist dataset and the GBIFoccurrences_icons (your versions of both files) open in a browser window. If you haven't imported them yet, download them (iNat_obs.kml and GBIFoccurrences_icons.csv) and import them into Fusion Tables. Be sure to name them something with your own name in the Name field so you know which tables are yours (since we're all using the same Google Account). Make sure the tables are "Unlisted."
  • STEP TWO: Go to Google Fusion Tables Layer Builder (http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/fusiontableslayer_builder.html)
  • STEP THREE: Under Add Layer, enter the table IDs from the iNaturalist dataset into the field. Wait a moment, and you'll be able to select the column headers to choose the location column. Click "Add Layer." Zoom in to a zoom level that allows you to see all your data. Click "Update Map." Further down, select "Add Another Feature" and choose "Another layer." Repeat with the GBIFoccurrences_icons dataset and select "Add Layer." You'll see both your tables in the preview window!
Exercise 2: Embed your Fusion Tables in a Blog
  • Layer Builder Code
    • STEP ONE: Go to our Blog: http://canadaworkshop2011.blogspot.com/. (Note: you must be signed in with canadaworkshop2011@gmail.com; password: ilovemaps!) Select New Post. Make sure you are in "Edit HTML" mode.
    • STEP TWO: Take the code from the Fusion Table Layer Builder. Paste it into the post and give your post a title (with your name on it!). Publish your post, and check out your handiwork!
  • Fusion Tables Embed Code
    • STEP ONE: When in Map view, click "Get Embeddable Code." Copy all the code that appears in the window by clicking in the window and selecting CTRL-A or CMD-A (Mac).
    • STEP TWO: Go to Blogger and create a new post. You must be in "Edit HTML" mode. Paste the embed code in the blog, give it a title with your name on it, and Publish!
Exercise 3: Embed your Map in a Blog
  • Make sure your tables are unlisted. Choose your favorite table that we've been using for practice.
  • Go to Blogger.com and sign in with canadaworkshop2011@gmail.com; password: ilovemaps!
  • Create a New Post
  • Select “Edit HTML”
  • Go back to Fusion Tables. In Map view, select “Get Embeddable Link” and copy the embed code
  • Go back to Blogger, and paste the embed code into a new post.
  • Give the post a title.. Preferably with your name in it so you can find yours quickly!
Exercise 4: Import a Shapefile to a Fusion Table
  • STEP ONE: Go to Shpescape.com and download the Protected Planet BC Shapefile.
    • Protectedplanet_British-Columbia.zip (download)
  • STEP TWO: Grant access to the tool to Fusion Tables and upload the .zip file to the tool. Let it run, and when it's complete, it will provide a link to your new table!
Exercise 5: Custom Styling Options
  • STEP ONE: Download the Ecoregions_Boundaries_Attributes.csv dataset and import into Fusion Tables (you're getting good at this, now!)
    • Ecoregions_Boundaries_Attributes.csv (download)
    • Credit TNC/WWF
  • STEP TWO: Select "Customize Styles" then "Fill Color" then "Gradient." Choose "Forest Area" and keep the range from 0 - 1. 
Exercist 6: Customize your info windows (aka popup balloons)
  • STEP ONE: Download the Costa Rica Butterfly Data.csv (download)
    • Credit: D. Janzen and W. Hallwachs
  • STEP TWO: In Map View, Click "Customize Info Window." 
    • Copy/Paste this code into the Info Window for your Costa Rica Butterfly Data table.

      Custom HTML for Info Window

      <div class="googft-info-window"
          style="font-family: sans-serif; width: 330px; height: 20em; overflow-y: auto;">
        <img src="{URL cp lateral}" style="width: 150px; vertical-align: top; margin-right: .5em" />
        <img src="{URL adult}" style="width: 150px; vertical-align: top" />
        <h2 class="color: brown">{herbivore species}</h2>
        <p>Caterpillar found feeding on host plant <em>{host plant species}</em>,
            {host plant family} in the {primary eco},{year}.</p>
        <p>See specimen record {voucher} at <a href="http://janzen.sas.upenn.edu/">
            Caterpillars, pupae, butterflies and moths of the A.C.G.</a></p>
      </div>
Exercise 7: Exporting your data into Google Earth
    • Use the file you just downloaded, Costa Rica Caterpillar Data (download)
    • Click "Export KML" from the Map view. 
    • Open the KML in Google Earth and pop a few balloons.
    • When in Google Earth, you can load additional layers, such as the Costa Rica Protected Areas KML file (Download). Put both files in a Folder and Save Place As... now you have more data alongside your table data!

Advanced KML coding



Advanced Maps API with Mano


Google Map Maker


ODK + How to create an Xform and use ODK Aggregate

Life of a Mapping Project

Closing Session


ć
Tanya Birch,
Sep 24, 2011, 8:44 PM
ć
Tanya Birch,
Sep 27, 2011, 1:44 AM
ć
Earth Outreach,
Sep 27, 2011, 1:27 PM
ċ
CostaRicaProtectedAreas.kml
(1943k)
Earth Outreach,
Sep 26, 2011, 11:24 PM
ċ
CostaRicacaterpillardata(1).csv
(22k)
Tanya Birch,
Sep 24, 2011, 5:47 PM
ċ
CostaRicacaterpillardata.csv
(22k)
Earth Outreach,
Sep 26, 2011, 11:24 PM
Ċ
Earth Outreach,
Sep 27, 2011, 10:57 PM
ċ
Ecoregions_Boundaries_Attributes.csv
(8475k)
Earth Outreach,
Sep 26, 2011, 11:45 PM
ċ
FNR_20Aug2010.kmz
(1601k)
Tanya Birch,
Sep 26, 2011, 12:20 AM
ċ
Fridays_Eagle_VS_Huge.kmz
(59k)
Tanya Birch,
Sep 27, 2011, 1:16 AM
ċ
GBIFoccurrences.csv
(633k)
Tanya Birch,
Sep 24, 2011, 3:10 PM
Ĉ
Tanya Birch,
Sep 24, 2011, 3:10 PM
ċ
GBIFoccurrencesWITHicons.csv
(650k)
Earth Outreach,
Sep 26, 2011, 11:39 PM
Ĉ
Tanya Birch,
Sep 24, 2011, 4:55 PM
ċ
RedPillar.kmz
(2k)
Earth Outreach,
Sep 26, 2011, 2:07 AM
ċ
SaveTheElephants.kmz
(289k)
Tanya Birch,
Sep 26, 2011, 12:22 AM
ċ
SkiSquaw.kmz
(27k)
Tanya Birch,
Sep 27, 2011, 1:30 AM
ą
Earth Outreach,
Sep 26, 2011, 1:58 AM
ċ
Strathconaparkproject_completed.kmz
(582k)
Earth Outreach,
Sep 26, 2011, 3:09 AM
ċ
VancouverIslandTopo.kmz
(1k)
Earth Outreach,
Sep 26, 2011, 2:11 AM
ą
Earth Outreach,
Sep 24, 2011, 11:22 AM
ą
Earth Outreach,
Sep 23, 2011, 8:07 PM
ċ
kml_supperabbrevs.txt
(5k)
Earth Outreach,
Sep 27, 2011, 12:14 PM
ċ
pbirch-wed.gpx
(877k)
Tanya Birch,
Sep 25, 2011, 2:53 PM
ċ
Tanya Birch,
Sep 24, 2011, 7:02 PM
ą
Earth Outreach,
Sep 26, 2011, 2:27 AM
ċ
schema_header.kml
(0k)
Earth Outreach,
Sep 27, 2011, 12:15 PM
ċ
strathcona.csv
(227k)
Tanya Birch,
Sep 24, 2011, 2:33 PM
ċ
strathcona.kml
(202k)
Tanya Birch,
Sep 24, 2011, 3:10 PM
ċ
strathcona.kmz
(58k)
Earth Outreach,
Sep 24, 2011, 12:02 PM
ċ
Tanya Birch,
Sep 24, 2011, 2:33 PM
ą
Earth Outreach,
Sep 23, 2011, 8:09 PM
Comments