Training Materials

Tools Overview -- From the Ground to the Cloud 

Open Data Kit

Google Fusion Tables

Exercise 1Import Your Data
  • STEP ONE: To import Data into Fusion Tables, first download one or more of the KML files below.
    • Choose from these KML Files of Brazilian Datasets: 
      • Brazil Indigenous Territory - Large KML (polygon data) (download)
      • Brazil Amazon Basin Hydrology (line data) (download)
        • Credit: http://siscom.ibama.gov.br/shapes/
      • Brazil Integrated Protection Protected Area (polygon data) (download)
      • Brazil Sustainable Use Protected Area (polygon data) (download)
        • Credit: http://www.ceuc.sds.am.gov.br/
  • STEP TWO: Import those datasets into Fusion Tables by clicking New Table > Import. 
    • Sign in with your Google Account
    • 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: Embed your Fusion Tables in a Blog
  • Fusion Tables Embed Code
    • 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 imazonworkshop2011@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. If you don't see that link in Map view, your table isn't public or unlisted yet. Try changing those settings and then refresh the page.
    • 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 3: Display two datasets alongside each other - Mash 'em up! 
  • STEP ONE: Have at least 2 of the datasets you uploaded open in different browser tabs. OR, if you want to work with some new point data (instead of polygon data), use these datasets: 
    • Costa Rica Butterfly Data CSV (download)
    • Costa Rica Protected Areas KML (download)
  • 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 first 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 second dataset and select "Add Layer." You'll see both your tables in the preview window!

Exercise 4: Import a Shapefile to a Fusion Table
  • STEP ONE: Download the BR_UCS_TODAS.zip Shapefile.
  • STEP TWO: Go to Shpescape.com and 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>
      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 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!
    • You can also create a network link to dynamically connect your Fusion Table to Google Earth. In doing so, anytime your Fusion Table dataset is updated, your KML in Google Earth will be updated as well. This is the best approach to take if, for example, you wish to embed the Earth API with a Fusion Table map within your website. In Map View, click "Get Network Link". Then, Open Google Earth. Go to Add > Network Link and paste the URL from Fusion Tables into the URL field. Name your network link, and you're done! Now, your KML will always have the most current data from your Fusion Table displayed.

ODK & How to create an Xform and use ODK Aggregate


Earth Engine Overview 

SAD Online Under the Covers

IMAZON SAD-Online 

Google Earth Builder Demo 

Case Study Presentations by Participants

  • World Resources Institute, presented by Kemen Austin (slide deck)
  • IMAZON and ODK for Ground Validation, presented by Heron Martins (slide deck)
  • Amazon Conservation Team, Brazil, presented by Hebert A. Lucena Silva and Wesley Luis Pacheco (slide deck)
  • IDESAM & Open Data Kit, presented by Heberton Barros (slide deck)
  • Community-based Monitoring for Effective REDD+ implementation, Wageningen University, presented by Arun Pratihast (slide deck)
  • Greenpeace's Deforestation Monitoring, by Edwin Keizer and Pablo Pacheco (slide deck)
  • Monitoring Deforestation by SEMMA/Paragominas/Pa using the Open Data Kit with Deforestation Alert System, presented by Felipe Zagalo (slide deck)
 
ć
Earth Outreach,
Nov 22, 2011, 4:03 PM
ć
Earth Outreach,
Nov 22, 2011, 4:03 PM
ċ
BR_TERRA_INDIGENA.kml
(60751k)
Earth Outreach,
Nov 5, 2011, 9:46 PM
ċ
BR_UCS_TODAS.zip
(7974k)
Earth Outreach,
Nov 5, 2011, 10:26 PM
ċ
B_AMAZ_HIDROGRAFIA.kml
(12791k)
Earth Outreach,
Nov 5, 2011, 9:46 PM
ć
Earth Outreach,
Nov 22, 2011, 2:54 PM
ć
Earth Outreach,
Nov 22, 2011, 5:15 PM
ć
Earth Outreach,
Nov 8, 2011, 2:49 AM
ċ
CostaRicaProtectedAreas(1).kml
(1943k)
Earth Outreach,
Nov 7, 2011, 7:17 AM
ċ
CostaRicacaterpillardata(1).csv
(22k)
Earth Outreach,
Nov 5, 2011, 10:10 PM
ć
Earth Outreach,
Nov 14, 2011, 12:24 PM
ċ
Ecoregions_Boundaries_Attributes.csv
(8475k)
Earth Outreach,
Nov 5, 2011, 10:10 PM
ć
Earth Outreach,
Nov 22, 2011, 2:52 PM
Ċ
Earth Outreach,
Nov 8, 2011, 5:21 AM
ć
Earth Outreach,
Nov 14, 2011, 12:29 PM
ċ
UCPI_Brasil_SNUC_latlong__10Dez2008.kml
(13855k)
Earth Outreach,
Nov 5, 2011, 9:54 PM
ċ
UCUS_Brasil_SNUC_latlong__10Dez2008.kml
(27317k)
Earth Outreach,
Nov 5, 2011, 9:55 PM
ć
Earth Outreach,
Nov 22, 2011, 3:47 PM
ć
Earth Outreach,
Nov 22, 2011, 2:58 PM
ć
Earth Outreach,
Nov 22, 2011, 4:00 PM
ć
Earth Outreach,
Nov 22, 2011, 2:57 PM
ć
Earth Outreach,
Nov 22, 2011, 4:01 PM
Comments