In this installment of How We Did It Chris Keller of Madison.com discusses how he's using Google Fusion Tables and other tools to create interactive data maps. Be sure to check out another article by Keller which appears as a link at the end of this post.
I'm long overdue for a walk-through to share what I've learned from others who shared what they had learned. But rather than reinvent the walkthrough, I'll use the power of linking to highlight those who helped me get to the recall map, and show a bit more of the coding that I used.
What is Fusion Tables and how can I use it?Via Poynter: If the data has been normalized and saved as an Excel file, .ods, .csv or .kml, Google Fusion Tables can help. Fusion Tables manages large collections of data so you can query, map, timegraph, chart, and add interaction — including user comments — to them.
That makes sense. Is there a practical news example?Via Christopher Groskopf & the Tribune's News Apps Blog re: the Chicago Homicide Tracker This might be the trickiest part. Our system “knows” that the addresses in this spreadsheet are in Chicago, but other systems wouldn’t because the addresses do not include city, state, or zip. To remedy this problem we need to add that information. Rather than doing it by hand, we will use a spreadsheet formula.
- Google's Fusion Tables
- Fusion Tables Help
- Google's Fusion Tables Group
- Google Maps API
- Google's Maps API Group
- TIGER/Line Shapefiles