Tag: maps

Posted on

Visualizing the 100 Largest Cities in the U.S. (1840-2010)

In a previous post, I discussed how I like making visualizations for my classes using Google products. It’s a good exercise for me, and hopefully it leads to something useful in fall. My weekend project was this map of the 100 Largest Cities in the U.S. (1840-2010) using Google Charts’ GeoChart. It was largely based on this code. However, I had to make a number of changes to have it do what I wanted it to do. I also had to organize the data in way that was useful. The dots on the map mark cities that are amongst the top 100 urban centers in the United States in a census. The slider is a date filter that allows one to either move decade-by-decade to see the rise of cities in the Sunbelt, or see the persistence of a city in the top 100 depending on how you move the sliders.


The neat thing about the GeoChart API is that it rendered within the browser using SVG. While the GeoChart API will recognize place-names, it loads much faster if you use latitude/longitude coordinates instead of place-names. There are 269 cities in the map above, with data drawn from 18 census years.

This was meant to be a fun weekend project playing with the GeoChart API. I’ll probably play around with this a bit more, so that I can make use it in my urban sociology course in the fall.

Posted on

Prepping for Fall 2014: Visualizing School Closures

Splatter Compass

compassIn my previous post, I mentioned that I spend a lot of time during the summer prepping for academic year. This fall requires extra work because I’m changing textbooks, and re-organizing a lot of material. I’m not doing this just to improve the content or my teaching, but I do this to “exercise” my other skills – things like playing with Google Fusion Tables, Photoshop, HTML, etc.

This fall I’ll be teaching urban sociology again and I’m currently updating material for the course. New on the syllabus for this year is Robert Sampson’s book on Great American City: Chicago and the Enduring Neighborhood Effect. Reading the book the past few weeks inspired me to think of examples to help students make comparisons/connections between Chicago and Philadelphia.

Perhaps the most obvious example is that were both hit bad with school closures in 2013 affected whole communities.

Chicago Philadelphia
School Closings 2013 47 23
Students Displaced 12,700 10,000
Layoffs 2,000 3,700
Charter Schools opened 15 9

The Chicago Tribune has an excellent map that illustrates some of social and economic dimensions of neighborhoods affected by the closures. Since, I’m very much in favor of visualizing data for my statistics-adverse students, I’ve decided to make my own map in Google Fusion Tables to help me with my lesson plan in the fall. I can always use Social Explorer, but it’s also useful and fun for me go through the effort of downloading U.S. Census data and making my own map.

The below is a color coded map of census tracts based on the percent of those with high school diplomas or higher based. The purple flags are where the schools closed in 2013 are located.

[Click for Map w/ Race & Income]

In particular, the consequences for school closures have dramatically affected communities of color. The Root reports that while African-American Students represent 58% of the students in Philadelphia, they made up 81% of the students affected by the closures. In Chicago, black students account for 43% of all students, but 87 of those affected. In this map, I’ve set it up so that you can toggle layers to look at race, income, and education attainment, so that you can see the connection between race and school closures. Setting up the toggle was fun it required playing around with JavaScript. For more simple layered maps, I use the Fusion Tables Layer Wizard. However, I wanted to create something that was more interactive that students could play around with. This required trying to find a color scheme for the maps so that when you toggle layers, they interact with one another in a way that is visually informative.

I’ll continue to work on this throughout the summer, but I wanted to blog on how summer “prep” work isn’t just revising lectures and reading. It can be an opportunity to develop other skills.