How to upload shapefiles to Google Fusion Tables

By On September 25, 2011 · 7 Comments

Array

It is now possible to upload a shapefile (and its companion files SHX, PRJ, and DBF) to Google Fusion Tables (GFT).

Before we go any further, keep in mind that the application that does this will only process 100,000 rows. Additionally, GFT only gives each user 200 MB of storage (and they don’t tell you your current status, that I can see).

  1. Login to your Google account (at Gmail, or at GFT).
  2. Prepare your data. Ensure it has fewer than 100,000 rows.
  3. ZIP up your dataX.shp, dataX.shx, dataX.prj, and dataX.dbf. Use WinZip for Windows, or for Mac, right-click the selection of files and select “Compress 4 items”.
  4. Visit the Shape to Fusion website. You will have to authorize the web application to “grant access” to your GFT tables. It needs this access so that after the web application processes your data, it can insert it into GFT.
  5. If you want a Centroid Geometry column or a Simplified Geometry column added, click “Advanced Options” and check their checkboxes – see notes below for an explanation.
  6. Choose the file to upload and click Upload.
  7. Leave the window open until it says it has processed all of the rows. It will report “Processed Y rows and inserted Y rows”. You will be given a link to the GFT the web application created.

Sample Data

If you’re looking to give this a try and see results quickly, try some sample data from the City of Chicago data portal:

Notes

I had trouble many times while using Shape to Fusion in that after I chose the file to upload and clicked Upload, I had to grant access to the web application again and start over (choose the file and click Upload a second time).

Centroid Geometry – This creates a column with the geographic coordinates of the centroid in a polygon. It lists it in the original projection system. So if your projection is in feet, the value will be in feet. This is a function that can easily be performed in free and open source QGIS, where you can also reproject files to get latitude and longitude values (in WGS84 project, EPSG 4326). The centroid value is surrounded in the field by KML syntax “<Point><coordinates>X,Y</coordinates></Point>”.

Simplified Geometry – A geometry column is automatically created by the web application (or GFT, I’m not sure). This function will create a simpler version of that geometry, with fewer lines and vertices. It also creates columns to list the vertices count for the simple and regular geometry columns.

Tagged with: • • • • •
 
If you enjoyed this article, please consider sharing it!
Reddit Delicious Mixx StumbleUpon Digg

  • Pingback: Upload shapefiles to Google Fusion Tables | Net Density

  • Pingback: Know more about Buy k2

  • Pingback: fisika

  • Pingback: best self help books

  • Eddie

    is it possible to have polygons such as community areas and points such as community gardens mapped at the same time in fusion tables?

    • http://www.stevevance.net/ Steven Vance

      No, it’s not possible to do this without creating your own website and interacting with the Google Fusion Tables API. This is what Derek does (although he hasn’t shown data of more than one geometry type. 

      I just tried to do this. The Fusion Tables website can only show one geometry at a time, even in a merged table (I merged CTA stations with community areas based on the community area number I assigned to each CTA station). The data merges fine. You can do this easily with GeoCommons. See How to create a map in GeoCommons for advice on where to start. 

    • Kathryn Hurley

      It can be done if the point and polygon data are in the same column.