View the updated map
Tuesday is the day when six Democratic challengers to Republican incumbents will compete in a recall primary against six “protest” candidates fielded by the GOP.
The general election between the winners of the Democratic primaries and the six incumbent Republicans is Aug. 9.
In an attempt to visualize the recall contests, I came up with this map built with the Google Maps API and Google’s Fusion Tables. There’s plenty I would like to improve on – and I know I will improve the next map around – but I’m fairly pleased with the results.
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.
Can you suggest a simple walkthrough?
Google Fusion Tables allows journalists to publish, visualize and analyze large data sets in the browser without expensive software. Learn how this free tool can help you create custom online maps, graphs and timelines, mash-up different data sets and collaborate on data.
What is Fusion Tables and how can I use it?
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.
I’ve heard about Shapefiles, do those work?
Fortunately, the U.S. Census and many municipalities provide those shapes in the form of “shapefiles.” These typically have the extension .shp, and use a format originally designed for cartographers wielding sophisticated (and pricy) software, like Esri’s ArcView.
But thanks to a nifty, online tool called ShpEscape, you can use them, too. For free. And once you have shapes to play with, there’s a lot you can build.
That makes sense. Is there a practical news example
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.
I’ve used FT to show states and population. What’s next
I’d like to do more with FT than paste an embed code onto an index page
And when that begins to make sense, consider that the only real change between that map and Wisconsin State Senate Recall map is the script:
If the pastebin code isn’t appearing, you can find it here.
I prefer to watch my tutorials
These links and resources should get you started, but if you have any questions feel free to reach out to me or anyone linked to above. John and Christopher and everyone else have been so helpful and everything a noob could ask for.