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).
- Login to your Google account (at Gmail, or at GFT).
- Prepare your data. Ensure it has fewer than 100,000 rows.
- 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”.
- 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.
- 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.
- Choose the file to upload and click Upload.
- 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.
If you’re looking to give this a try and see results quickly, try some sample data from the City of Chicago data portal:
- Community Areas – 77 official community areas + 3 “out” areas to make 80 polygons.
- Special Service Areas – akin to business improvement districts, including Wicker Park-Bucktown SSA.
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.
About Steven Can Plan
I started this blog in 2007 as the writing assignment for an introductory urban planning class at UIC. It's about cities (mainly Chicago), GIS oftentimes, and transportation (mainly bicycling). Learn more about me, Steven Vance. I also write for Streetsblog Chicago.
Steven Can Plan is hosted on Dreamhost.
Chicago Bike Map App
The Chicago Bike Map app is a bike and street map stored entirely in your iOS device – no data connection required. The map is designed to look much like the City of Chicago's official printed and online bike map. The app works on iPhone, iPod touch, and iPad.
Highly Recommended Bike Products
These folding locks are lighter weight and more versatile than an equally strong u-lock.
I've used this pannier to carry groceries, books, my laptop, clothing, anything. I like it because it's stylish (but also "normal" looking at the same time), stands up on its own, is extremely durable, and has the most universal attachment system: two hooks.
Bells can be quite useful, especially to tell people in front that you're passing them. I like the ding-dong bell the best. It makes a solid DING and then DONG on the spring's return.
Joyride: Pedaling Toward A Healthier Planet by Mia Birk, With Joe (Metal Cowboy) Kurmaskie, Joe Kurmaskie, Jim Moore
I met Mia Birk in October 2011.
Sustainable Transportation Planning: Tools for Creating Vibrant, Healthy, and Resilient Communities (Wiley Series in Sustainable Design) by Jeffrey Tumlin
I was sent a review copy. I'm really excited to open it up and start reading because I've been disappointed with textbooks in the past that don't focus on bicycle and pedestrian planning.
Traffic: Why We Drive the Way We Do (and What It Says About Us) by Tom Vanderbilt
As someone who doesn't like driving, but believes that cars can be efficient in moving groups of people and goods, this is my favorite book.