Google Fusion Tables + census data = wicked awesome.
Sarah Morris and I figured out how to take block-level data of the Columbia Public School District and overlay it on a Google map. It’s pretty darn awesome.
Check it out:
This is a map of the under-18 population. The darker the color, the more people who live in that census block.
There were a few hiccups with the process, though. In order to get what we wanted out of it, I had to use ArcGis to limit the number of blocks. I overlayed a shapefile of the school district on county-wide, block-level data and used the Intersect tool to merge the two. That produced a shapefile of block-level data that we could filter by school district, what you saw above.
Pretty neat stuff.