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.

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!

TUESDAY

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).

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 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!

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!