More mapping, setting up a website
07 Oct 2015Links for class
- US Mass Shootings, 1982-2015: Data From Mother Jones' Investigation - raw data
- Connecting with the dots
- The different types of data vizualizations
- More fun with Google Fusion Tables
- Setting up a Github page
Assignments for Oct. 14
Read: Map App of the Day: Presidential Election Maps
Read: How The Rainbow Color Map Misleads
Read: Visual Literacy in an Age of Data
Homework 1
Answer these questions about the readings.
Questions about the Class 6 reading assignments
Homework 2
This one is a bit complicated but builds on everything you've learned so far
Make me a Choropleth map in Google Fusion Table based on the data on US Mass Shootings.
- You'll have to split out the location to create a new column with just state names
- ie. Roseburg, OR --> OR
- Forgot how? The formula is in this tutorial about halfway down
- Pivot table based on the count by state
- Adjust the number to normalize for population using state population statistics
- Get the data from the Census census.gov
- It's CSV link in the first bullet point: *Annual Estimates of the Resident Population for the United States, Regions, States, etc**
- You'll have clean it up first, to search and replace all the .
- So you've got two tables (school shootings by state and state population), join them up and then find number of shootings per 100,000 residents. (Hint, it will involve math and formulas)
- Download the kml file for all the states and make a Fusion Table from it
- Here's one somebody already made, just make a copy of it from File. Google)
- Here's a bunch of boundaries that the US Census made census.gov
- Merge the normalized shootings data to the boundaries file
- Map it out, add a legend (If state names need to be cleaned up, do that)
Make the map public and email me the link.