First meetings with Google Fusion Tables

First meetings with Google Fusion Tables

For our coverage of the 2013 Colorado general election, I employed mapping lessons learned during my attendance at the ONA13 conference. I used data from the Secretary of State to create four Fusion Table maps used on TV and online.

The first two maps showed turnout results for the mail-in ballots submitted before the actual opening of the polls on Nov. 5, 2013.

The first colors each Colorado county on a scale between blue and red, indicating which party has had a greater overall turnout.

The second shows, in solid colors, which party has had a greater percentage of their registered members vote.

Marshall Zelinger used simplified versions of these two maps in his presentation during the 5pm news on election day.

The second pair of maps were built for display on our website and in our app. They indicate the approval or rejection of two statewide initiatives.

Proposition AA – taxes on recreational marijuana

Amendment 66 – education funding changes and taxes

All of the information I used to learn this tool is available in this summary of the session I attended during ONA: https://sites.google.com/site/onaftworkshop/maps-engine