I wanted to create a map of the 35th Ward boundaries using Google My Maps for a story on Grid Chicago. I planned to create this by taking the Chicago Wards boundary shapefile and exporting just the 35th Ward using QGIS into a KML file. I ran into many problems and ended up using Google Fusion Tables as the final solution.
First, QGIS creates invalid KML files. Google Earth will tell you this. I opened the KML file in a text editor and removed the offending parts (Google Earth mildly tells you what these are; you can use this validator to get more information).
Second, Google My Maps would not import the KML file. I tried a different browser and a different KML file; a friend ran into the same issue. I reported this problem to Google.
I uploaded to Google Fusion Tables a KML file containing all wards. I did this instead of uploading the single Ward because, like a database, I can filter values in the column, selecting only the row I want with “ward=35″.
After applying the filter, the map will show the boundary for just that ward. I grab the HTML code for an embeddable map and voila, the article now displays an interactive map of the 35th Ward.
Whenever I want to create a map for a different ward, I go back to this Fusion Table, make a new filter and copy the new HTML code.
A screenshot of the embedded map, showing just 1 of 50 wards, in the Grid Chicago article.
I had the same problems with QGIS exporting and uploading the KML files to My Maps the other day when I was creating maps for the abandoned railroads for Monday’s Grid Chicago article. Not thinking about Fusion Tables, I drew on the map with my mouse the lines.
Screenshot of the map of abandoned railroads.
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
So far I haven't had a flat with this tire. I've used Continental Gatorskin and Panaracer T-Serv, both of which have had flats (same Chicago streets). The Gatorskin has less tread than both, and wears to a slick surface faster.
These folding locks are lighter weight and more versatile than an equally strong u-lock.
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.
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.
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.
Instant City: Life and Death in Karachi by Steve Inskeep
I reviewed this book that the publisher sent to me.