Fusion Tables Hands-On Workshop

Google Earth Outreach Tutorial: Import Sample Data into Fusion Mapper

How to Merge Two Datasets with a Common Column
Find "African Heads of State" data among public data
Click "Public tables" to see data tables that Google Fusion Tables users have selected to make public.
In the search box, type [african heads of state] and hit Search Tables
Find the table called "African Heads of State" from October 2009. Click to open it.

Find images of Country Flags data
Open a new browser tab or window, and go to http://www.google.com/fusiontables.
Click "Public tables" to see data tables that Google Fusion Tables users have selected to make public.
In the search box, type [Country Flags] and hit Search Tables
Find the table called "Country Flags - Large"
Click to open it.
Optional: Click on a flag to see the URL where the image is hosted. This is how Google Fusion Tables supports images.
Optional: Click Visualize > Map to see the global extent of data set
Copy the URL for this table.
Merge select columns from two data sets

The two tables have different numbers of rows. When they are merged, out of the entire list of country flags only the list of matching African countries will be part of the new table.
From within the "African Heads of State" table, click Merge
Paste URL into "Merge with" and click Get.
Select the "Country" radio button for both tables
Tip: Don't use COUNTRY, as the capital letter spelling of country names won't match any country names from the Flags file.
Tip: Although the column names are identical in this exercise, It's not necessary for the columns to be named the same in order to merge on them.
Optional: Exclude the unneeded COUNTRY column.
Check "Select columns" checkbox on left
Un-check "COUNTRY" column.
Enter a name for the new merged table (eg. "African Heads of State and Flags")
Click "Merge tables"
Import Sample CSV Data into Fusion Tables
1. Download the sample dataset Astraptes Fulgerator Complex (download)
2. Click "Create New Table" and find the file where it downloaded to.
3. Your table will import.
4. Click Visualize > Map to view your data.

Customize the Info Window

Sample HTML to copy-paste:

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

Import Shapefiles into Fusion Tables
1. Download a sample world borders dataset from http://thematicmapping.org/downloads/world_borders.php (download)
2. Go to shpescape.com and log in with your Google Account. You'll need to grant shpescape access to your Fusion Tables account.
3. Import the entire .zip file. It will upload over a few minutes, and will display a fusion tables ID as a result.
4. Open the table by clicking the Fusion Tables link ID from Shpescape. In Fusion Tables, click "Map"
5. Configure the styles by selecting different buckets for fill colors based upon the 2005 Population. Good value ranges are
0 - 2,000,000
2,000,000 - 30,000,000
30,000,000 - 50,000,000
50,000,000 - 1 billlion