- Monday Morning
- Tuesday Morning
Introduction to Nonprofit Mapping Technologies
Google Mapping Tools Basic Track
Google Earth Basics
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 Earth, Earth API & KML
- Examples
- KML maps for Google Earth
- Quick overview of Earth (same as Basic Track)
- Google Earth API examples
- Coding with Google Earth API
Google Maps API
Google Fusion Tables API
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
- Slide deck: Vancouver - GIS-to-Google Earth Basics
- GIS data downloads:
- Datasets for Fusion Tables:
- Link to tools:
- ogr2gui - for converting various datasets, including shapefile to Google Earth KML
- shp2kml - for converting shapefile to Google Earth KML
- kml2shp - for converting Google Earth KML to shapefile
- Arc2Earth (see demo videos here) - great plug-in for ArcGIS for converting to Google Earth
- MapShaper - for simplifying lines and polygons for display in Google Earth
- GIS data download sites:
-
- Local government or university websites
- General GIS data download sites
- Topical GIS data download sites
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
- Make sure you have the following programs installed:
- Windows & Mac: jEdit
- At minimum: install the "XML" plugin - Plugins menu > Plugins manager > Install tab > check "XML" > Install
- Full instructions: Validating KML as you go tutorials
- Windows: Install Notepad++
- Download these files:
- The Interactive KML Sampler
- Google's KML Documentation
- For validating KML in jEdit, use this template
<?xml version="1.0" encoding="UTF-8"?>
<kml
xmlns="http://www.opengis.net/kml/2.2"
xmlns:gx="http://www.google.com/kml/ext/2.2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=
"http://www.opengis.net/kml/2.2
http://schemas.opengis.net/kml/2.2.0/ogckml22.xsd
http://www.google.com/kml/ext/2.2
http://code.google.com/apis/kml/schema/kml22gx.xsd">
</kml>
Custom Charts & Icons with the Google Chart Tools API
Advanced GIS
- Slide deck: Vancouver - Advanced GIS
- Links to Google Earth KML files as examples:
- Link to tools:
- ogr2gui - for converting various datasets, including shapefile to Google Earth KML
- shp2kml - for converting shapefile to Google Earth KML
- kml2shp - for converting Google Earth KML to shapefile
- Arc2Earth (see demo videos here) - great plug-in for ArcGIS for converting to Google Earth
- MapShaper - for simplifying lines and polygons for display in Google Earth
- GIS data download sites:
- Local government or university websites
-
- General GIS data download sites
- Topical GIS data download sites
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
- Make sure you have the following programs installed:
- Windows & Mac: jEdit
- At minimum: install the "XML" plugin - Plugins menu > Plugins manager > Install tab > check "XML" > Install
- Full instructions: Validating KML as you go tutorials
- Windows: Install Notepad++
- Download these files:
- The Interactive KML Sampler
- Google's KML Documentation
- For validating KML in jEdit, use this template
<?xml version="1.0" encoding="UTF-8"?>
<kml
xmlns="http://www.opengis.net/kml/2.2"
xmlns:gx="http://www.google.com/kml/ext/2.2"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation=
"http://www.opengis.net/kml/2.2
http://schemas.opengis.net/kml/2.2.0/ogckml22.xsd
http://www.google.com/kml/ext/2.2
http://code.google.com/apis/kml/schema/kml22gx.xsd">
</kml>
Advanced Maps API with Mano
Google Map Maker
ODK + How to create an Xform and use ODK Aggregate
- Presentation Slides (none; live demos only)
- References:
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
ď Earth Outreach, Sep 26, 2011, 2:07 AM
ď SaveTheElephants.kmz (289k) Tanya Birch, Sep 26, 2011, 12:22 AM
ď 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
ď Tanya Birch, Sep 25, 2011, 2:53 PM
ď Tanya Birch, Sep 24, 2011, 7:02 PM
ď Earth Outreach, Sep 26, 2011, 2:27 AM
ď Earth Outreach, Sep 27, 2011, 12:15 PM
ď Tanya Birch, Sep 24, 2011, 2:33 PM
ď Tanya Birch, Sep 24, 2011, 3:10 PM
ď Earth Outreach, Sep 24, 2011, 12:02 PM
ď Tanya Birch, Sep 24, 2011, 2:33 PM
ď Earth Outreach, Sep 23, 2011, 8:09 PM
|