Visualizing Spatial Data using Google Drive and Fusion Tables

Some people think that Google does not provide a solution for Geographic Information Scientists. I’d beg to differ, beyond their purchase of Keyhole Inc. and the subsequent formation of Google Earth, Googlers have also created the Fusion Tables experiment. Fusion Tables allow you to take data available in a Google Drive spreadsheet and visualize various datum overlaid on a Google Map base map.

Creating Maps using Google Drive Spreadsheet and the Fusion Tables Experiment

Here’s an example Fusion Table map I created, using South American butterfly data provided by the Fusion Table experiment.  Clicking the “Rows” tab will showcase how the data exists within Google Drive, complete with embedded images.

Spreadsheet data seen in Google Drive

Google Drive Spreadsheet with Data

Notice that there are columns for Latitude and Longitude that are used to geocode the coordinates.  Fusion Tables also allow Google Drive users to create and associate objects with their spreadsheet records.  The in browser geocoding ranges in accuracy, depending on how your fields are configured.  For example, I created a Fusion Table for the 32 NFL Football teams, along with their XY location for where their arena is located.  The Arizona Cardinals play in Glendale, but the geocoder defaults to a Glendale located outside of Los Angeles instead.

Geocoding Glendale, Arizona

Geocoding Glendale, Arizona

Fortunately, Google Fusion Tables allow for customization of column types by using the Change function.


Unfortunately, using the “Two column location” check box does not work when trying to specify City and State as a two column location.  This would be useful in the event that a Latitude and Longitude are not available.

Change Type

The Two column location check box is hard coded to work with Latitude and Longitude values.  Thus rendering separate Address, City, State and Zip Code columns useless within the Two column location selection.

Longitude and Latitude values seem to be set as Two column locations by default.  However, Google Drive’s Fusion Table appear to interact with Longitude locations better than locations set with Latitude columns, despite those two columns being linked as a two column location.  Below is an example comparing the differences between using Lat and Long with my sample NFL Arena table.

Using Longitude to Geocode

Using Longitude to Geocode

Latitude Location

Using Latitude to Geocode

Using my Arena Name for the Arizona Cardinals, yields a similar result as using the XY values do.  Though there is a slight discrepancy, both Arena and XY geocode to the Arizona Cardinal’s arena in this case.

Cardinals Orthoimagery

Cardinals Satellite Imagery

Cardinals in Glendale, AZ

Cardinals in Glendale, AZ

Ideally, Google Fusion Tables appear to work better with data that isn’t parsed out into separate cells. Google Drive is equipped to manipulate data, but spreadsheets that are set to use the Fusion Table experiment are a little harder to manipulate.

To wrap it up, I wanted to gauge the community to see how many folks have looked into using Google Drive and Fusion tables on a project.  Does anyone have academic or business use stories for Google Fusion Tables?

Currently I have only played around with a couple sample data sets and am looking to put together a best practices guide for this web mapping tool.

Thanks a ton,


Building a Theoretical Foundation for Prafix

Building a Theoretical Foundation for Prafix

I believe that there is a need to apply elements of Psychogeography and Phenomenology to make sense of spatial communication in the 21st century.  In building a curriculum, I often turn to these two studies to adapt their rich meaning in order to inspire a philosophical foundation to guide Prafix forward.  There is a role for elements of both of these schools of thought to be reinterpreted and applied to understanding geosocial and geomarketing datasets.

Ten years ago, before I becoming familiar with Guy Debord and Martin Heidegger in spatial context, I thought that there was a geographic relationship to how communication mediums could evoke cognitive change.  I imagined a map of dots, color coordinated and thematically shaded to visualize a given idea or identity.  Those points were fixed in a place, but there color could change over time depending on what influenced them.  Fast forward ten years and mobile computing technology could make it possible to allow these static points to roam freely as they social media savvy mobile phone users transcend physical geography.

Although it seems highly theoretical, most big data companies are selling this same exact idea to giant corporations.  What could be more valuable than point level data on your clients or potential customers?  I would argue that socioeconomic models that could predict socioeconomic consumer behavior could potentially be more valuable than the point level data itself.

I am interested in how technology can be used to help us better understand how space is perceived via communication platforms.  Social Media allows us to geocode our thoughts, essentially associating a thought bubble with a given terrestrial X, Y coordinate.  We could tell a more profound story by mapping out how those georeferenced thought bubbles evolved through space and time.

There is no shortage of geosocial or geomarketing solutions being made.  However, I believe with more theoretical discourse we can ensure that our developments are being made with a conscience.

Thanks a ton,