Talks & Papers‎ > ‎

NICAR 2012............This page at

Get the most out of Google Fusion tables
Thursday, February 23, 4-4:50pm

Google Fusion Tables can help you find the story in that data.... and tell it! In addition to stellar interactive maps, Fusion Tables is a nifty tool for gathering data from different places and combining it into one table. Plus, it offers a simple data store for publishing click-to-view and API-enabled data tables to complement your story. This demo will give you the big picture for Fusion Tables, including a preview of new features.

Tip Sheets
  1. Find data 
    1. (see #5 below)
  2. Gathering data
    1. Sync a Google Form to a Google Fusion Table
    2. Create a simple moderation system 
    3. Sample code for using Fusion Tables with Google Chart Tools visualizations
  3. Explore & Reformat data
    1. Kenya Journalists open-data workshop 2012
      1. based on steps 11-17 of exercise 3
    2. Make an intensity map with custom boundaries
    3. Apply icon styles or color by category
    4. Extract data with a merge
    5. See also: Google Refine!
  4. Illustrate the story with an interactive visualization
    1. Intro to Fusion Tables (hands-on)
    2. Advanced Google Fusion Tables (hands-on)
  5. Host data online, ready for re-use
    1. Fusion Tables public data search
    2. Resource Data in the Fusion Tables help center
    3. hosted in Fusion Tables: Australia's data.govCalifornia's 
    4. ...and of course, Google Public Data
    5. SuperPac donation data

Advanced Google Fusion tables (hands-on)
Friday, February 24, 10-10:50am
w/ Adam Playford  561-820-4427

Advanced Fusion Tables
With Google Fusion Tables and the tiniest dose of Javascript, you can create a highly custom interactive in a matter of hours. In this hands-on session, learn how to turn election results into an interactive map that tells a story, including a crash course on combining Fusion Tables with Google's mapping API to let readers dive into the data themselves. Best of all, you can do the whole thing without being an expert programmer, though comfort with simple Javascript will help.

Whet your appetite


Get started: Make a map in 20 minutes
    1. Set up the tables
      1. Merge
      2. the tables using the shared values in columns: County and NAME10 
        1. Boundaries
        2. Poll results
      3. Style the map 'by column' using WinnerColor
      4. Customize the info window to include: County, Gingrich, Romney, Santorum, Ron Paul, Winner
      5. Set table to Unlisted or Public (Unlisted is fine for now)
      6. Grab numeric table ID from File > About
    2. Use FusionTablesLayer wizard - Google it!
      1. get basic map
      2. style basemap
    3. Paste javascript code into a new HTML file & preview it
    4. Add key & wrapper*
    5. Disable default Map controls*
Make it journalism: add context & demographics
    1. Add context: Merge again to add these columns:
      1. Demographics
    2. Add resources for buttons to the page code
      1. code for twitter bootstrap & jquery
    3. Write HTML for buttons*
    4. Write javascript for buttons*
    5. Add more buttons until you're happy
  • Add Developer Console Key to track Maps API usage
  • .css for info window 
    • Set a style for : <div class='googft-info-window' style='font-family: sans-serif'>
  • Dynamic Styling 
    • if you don't own the table, you can still style it
    • support arbitrary styles in response to user input
  • More FusionTablesLayer sample code
    • completely custom info windows
    • completely custom icons
    • switch maps for different zoom levels
    • and more!
Rebecca Shapley,
Feb 24, 2012, 10:37 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM
Rebecca Shapley,
Feb 24, 2012, 10:44 AM