Fusion Tables are a new capability from Google. FME includes a beta-stage reader for Fusion Tables in FME2012 beta (build 12135+). This article is intended as a short-term form of documentation, until the reader is formally released in 2012.

Creating Google Fusion Tables

Google Fusion Tables are created by logging into a Google account and visiting http://www.google.com/fusiontables
You can create tables that are either public or private, and can also access other users' tables that have been made public.

For more information on Fusion Tables, see this page.

Readers

There are two Google Fusion Tables readers in FME; one for spatial and one for non-spatial datasets.

Parameters

There are the usual connection parameters plus a table selection tool (and the new attributes to expose option):



The Table List browse tool lets you select any tables that belong to the user you are connecting as.

For obvious reasons, the browse tool does not list all public tables; these can be selected by entering their table ID number into the table list field (as above). To find a table's ID number, open it in the Google web site and choose File > About

Spatial Data

There are four different ways to include spatial data inside a fusion table field:

1. A street address string
2. A lat/long comma separated string
3. A KML geometry string supporting points, lines and polygons
4. A single lat or long column paired with an additional 'number' type column for the corresponding lat or long

If you use types 2 or 3, then the Spatial Fusion Table reader will generate features with FME geometry.

Points, lines, and polygons are all supported, as are multiple geometries.

Writers

A writer for Google Fusion Tables is also available in FME2012.