Mapping with Google Fusion Tables

Tuesday, August 28, 2018 - 23:45

How to Create Maps Using Google Fusion Tables and ACS Data

We've found that many faculty members and students would appreciate the ability to create basic map displaying U.S. Census and American Community Survey data. In this video series, we show how to use free Google tools to create maps that faculty members can share with their students and vice versa.

We created the videos to be relatively easy to consume yet to equip you to learn more by testing things out on your own. Each video lasts about 5 minutes, adding up to about 20-25 minutes in total. The videos walk through downloading American Community Survey data from American Factfinder, importing those data into Google Sheets, calculating new measures, finding and downloading KML mapping files from the Census Bureau's website, importing those files into Google Fusion Tables, merging the mapping data with the demographic data, and styling the maps. If you're already familiar with American Factfinder and Google Sheets, you may want to jump straight into the third video.

For an example of a published map, see below.

This video shows the creation of the above map visualizing by ZCTA the percentage of family households having persons under age 18 that are headed by a single mother.

Congressional Districts with Info Bubble Link to Census Reporter