Google Fusion Tables

Recent posts

Google Fusion Maps with Joe Wertz

StateImpact Oklahoma’s Joe Wertz, mapping wizard, shows us how to create an interactive map using Google Fusion Maps and some raw data in this quick and simple tutorial.

Here is the data that you can use, if you’d like to try this at home.

(Don’t be alarmed! The audio doesn’t kick in until about ten seconds in.)

Creating a Legend

Of special note, around minute 31 (31:00), Joe walks us through creating a legend for your map. To do that (in the new and improved version):

  1. In the map view, click on the little arrow on top of the “Map of…” tab and navigate down to “change map styles.
  2. Whether you are dealing with points or polygons, make sure that your bucket ranges are exactly as you’d like them to appear in your legend.
  3. Click on “automatic legend” (your last option on the list to the left).
  4. Create a title for your legend.
  5. Decide where you’d like your legend to appear (typically in the bottom right-hand corner,  unless your map makes a different corner preferable).
  6. Hit “Save.”

Embedding an Iframe Into Your Site

At minute 32 (32:35), Joe shows us how to embed an iframe with your map and legend right into your site.

  1. Click on Share (in the upper right-hand corner) and publish it to the web. You’ll see your current sharing settings listed towards the top. If it doesn’t say “Public” hit the blue “Change” and select “Public on the web.” Continue reading

Nuts and Bolts: Embed Charts and Tables in WordPress and Core Publisher

After you get your chart or table into Google Drive and formatted the way you’d like to, follow these steps, kindly collected by data viz maven Emilie Ritter Saunders, to get it into your post:

Embedding Charts in WordPress

  1. Make your chart public to the web: Share —-> Change “public on the web”
  2. Publish your table: Click the arrow dropdown (upper right corner of the chart) —-> Select a chart1publish format “Image.”
  3. Copy that “Image” code and paste it into the HTML side of your WordPress editor.

Embedding Tables in WordPress

  1. Make your table public to the web: Share —-> Change “public on the web”
  2. Publish your table: File —-> Publish to the web —-> Click Publish or Republish Now
  3. Copy the URL.
  4. Paste the URL into the spreadsheet function in WordPress, “Google Spreadsheet Key.” Continue reading

Don’t Be Afraid Of The New Google Fusion Maps

Have you found yourself creating a map in Google Fusion Tables as of late and suddenly found yourself lost and confused? Did things look different or slightly out of place?

Don’t fret. It’s not you; it’s Google. Really.

A map of deep injection wells in Oklahoma, made recently in the newfangled Google Fusion Maps.

If you would like to go back to your comfort zone, select “back to classic look” from the drop-down Help tab. (Actually, do this no matter what. It is the only way for it to display properly in our pre-built plug-in.) If you need any tips on using that tool, please refer to Matt Stiles’ handy, 20-minute webinar or simply follow the documentation here.

The New Look 

If you don’t wish to use our plug in (and the lovely legend display that comes with it) and are simply uploading your data for your own reporting and background, here are the main differences in the new version, as far as we can tell:

1. The method of switching from map to table view.

Continue reading

Data Workshop Webinar: How to Use Google Fusion Tables

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. Our Database Reporting Coordinator Matty Stiles’ webinar on Google Fusion Tables is now available below.

Examples:

How to use Fusion Tables?

  • Upload data: kml, cvs, xls
  • Upload metadata: table name, description, attribution
  • Share your data
  • Merge with other tables
  • Make a map in minutes

A detailed tutorial post is also available here.