slides

Getting the most out of 
Google Fusion Tables

Rebecca Shapley 
Feb 23, 2012

What is Google Fusion Tables?

Beautiful maps, right?

Amazing things you've done since CAR 2011


Google Fusion Tables
Visualize, combine, host, and share your data tables

  • Find the story in the data, and tell it
  • Host data online, ready for re-use
  • Gather data

How can Fusion Tables help you in the story cycle?

How can Fusion Tables help you in the story cycle?

  • Find good data
  • Gather data
  • Explore and reformat data
  • Illustrate the story powerfully
  • Share what's behind the story

Find good data

Find good data


Gather data

Gather data

  • Roll-your-own - Instructions
  • Use Google Forms, then sync with a Fusion Table - Instructions
  • Use Open Data Kit forms on Android phones, pushed to a Fusion Table - Instructions
  • Give each contributor their own table to maintain. They roll up into a master Fusion Table - Instructions

DEMO:
Sync Google Forms to a Fusion Table

Demo


Extra fancy bonus! Create a simple moderation system

  • Add a "status" column to the Fusion Table
  • Type "good" when you accept the submission
    EntryStatus
    Our streets are clean             good
    Snow not plowed yet!             good
    asdfasdfnope
  • Use a view table where status = good for any visualizations
    Entry
    Our streets are clean           
    Snow not plowed yet!         

Instructions

Remember
"give each contributor their own table to maintain...
gather it in a master table"?

Instructions

Explore and reformat data

Explore and reformat data

  • Extract data with a filter
  • Aggregate data, then download it
  • Merge data together
  • Extract a subset by merging --Fancy!

Walkthrough: Extract by filtering

Download the .shp file

Use shpescape.com to bring it into Fusion Tables

Visualize > Map

Filter to just Montreal

Zoom in...

File > Export to download

DEMO: Aggregate & download

DEMO: Merge two tables

Merge data together

DEMO: Extract a want-list of data



Explore and reformat data

  • Extract data with a filter
  • Aggregate data, then download it
  • Merge data together
  • Extract a subset by merging
  • ...and don't forget: Google Refine 
    (Hands-On: 2pm Friday!)

Preview: The new Fusion Tables

Walkthrough:
Charts in info windows or cards

Convert the image url to template code


This URL will return one single chart image, with the specified data

<img src="http://chart.apis.google.com/chart?
chxl=1:|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec&
chxr=0,0,5&chxt=y,x&chbh=a,1,9&chs=380x145&cht=bvg&
chco=FF0000,0000FF&chds=0,5,0,5&
chd=t:2.497,2.878,2.733,2.468,2.626,2.112,2.337,2.319,2.315,2.793,2.647,2.191
|2.113,1.524,1.714,2.55,2.789,3.26,2.96,2.052,1.748,1.564,2.019,2.432
&chdl=2011|Historical&chdlp=t&chtt=Average+daily+rainfall+(mm)
&chts=676767,11" width="380" height="145" alt="Average daily rainfall (mm)" />

This template for a URL grabs data from the columns. Each row has it's own chart

<img src="http://chart.apis.google.com/chart?
chxl=1:|Jan|Feb|Mar|Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec
&chxr=0,0,5&chxt=y,x&chbh=a,1,9&chs=380x145&cht=bvg
&chco=FF0000,0000FF&chds=0,5,0,5
&chd=t:{Jan 2011},{Feb 2011},{Mar 2011},{Apr 2011},{May 2011},{Jun 2011},{Jul 2011},{Aug 2011},{Sep 2011},0,0,0
|{January},{February},{March},{April},{May},{June},{July},{August},{September},{October},{November},{December}
&chdl=2011|Historical&chdlp=t&chtt=Average+daily+rainfall+(mm)
&chts=676767,11" width="380" height="145" />

How can Fusion Tables help you in the story cycle?

  • Find good data
  • Gather data
  • Explore and reformat data
  • Illustrate the story powerfully
  • Share what's behind the story

Illustrate the story powerfully

Make a map!

  • Fri 9 am: Hands-on intro to Fusion Tables
    • Style the map
    • Customize the info window
  • Fri 10 am: Hands-on Advanced Fusion Tables
    with FusionTablesLayer wizard and the Google Maps API
    • multiple layers
    • change style of the base map
    • use .css to style the info window from the page
    • sample code: lots of power with the Google Maps API

DEMO: Zoomable line chart

Network Graph --sneak preview!

Network Graph --sneak preview!

Network Graph --sneak preview!

Network Graph --sneak preview!

Share what's behind the story

Host data online, ready for re-use

Available to users browsing your story with one click. No download or software needed.

Document the data with attribution and descriptions.

Make it public, to show up in search.

And it's immediately API enabled.

For example, here's the SuperPAC data.

How can Fusion Tables help you in the story cycle?

  • Find good data
  • Gather data
  • Explore and reformat data
  • Illustrate the story powerfully
  • Share what's behind the story

We look forward to seeing what YOU do with it next!


Thank you!

Tip Sheet and Slides:
http://goo.gl/Wkm0f

Comments