2016 IMWC Vancouver - Fusion Tables

The 3rd annual Indigenous Mapping Workshop Canada at the Musqueam Cultural Center, November 7-10, 2016 

Workshop Website

For today’s session you will need:

  • A laptop computer (not a mobile device, phones and tablets won’t be enough)

  • A Google Account https://google.com

  • Make sure that you can access Google Drive (some work and school laptops have filters) https://drive.google.com and make sure that you can add Fusion Tables to your Google Drive - you may have to contact your IT department if you have a work or school laptop.


Resources:

Activity for today's session:
Here are the Fusion Tables we will be creating in this session - if you get lost while building your own please feel free to go to these Fusion Tables to see what we are doing

We will begin with a Google Spreadsheet of the BIA database providing the contact information for Tribes in the U.S. and use this to create a Fusion Table map


Copy and paste this link into your Fusion Table import dialog box
https://docs.google.com/spreadsheets/d/1qXiC3CwkPaGq1u5BeXXjrwpv1r18RRno9gXScopDoZ0/edit?usp=sharing

This is the spreadsheet you are importing into your Fusion Table


Here is an example of the map you will create using Fusion Tables and the BIA Tribal Directory



Now we will make a map using polygons of the U.S. state boundaries

Go to this link and make a copy of the FT
https://fusiontables.google.com/DataSource?docid=1AtCHK2fP4aRkhSLNaJoz7JVtv1pQU1p95yAToVJ4#rows:id=1

Here is an example of the map you will make


Next we will make a map of the U.S. American Indian/Alaska Native population size by state from the U.S. Census data
This will require two steps: we will use a spreadsheet of the population data to create a new Fusion Table, then we will merge this population Fusion Table with our State Boundaries Fusion Table

Create a new Fusion Table and Copy and Paste this link into your Fusion Table import dialog box
https://docs.google.com/spreadsheets/d/19p5SeXl-NDELMNuWZJGiPOBfjnVcqBRqLB-Kt942_ys/edit#gid=0

This is the spreadsheet you are importing into your Fusion Table


Next we will merge our population data Fusion Table with our State Boundaries Fusion Table - you can "fuse" the Fusion Tables because they each have a column that is the same "state name"

Here is an example of a map we will make of the percent change in population size from 2000 to 2010



Now we will create an interactive chart of the percent population change by state