Category: Information

Using Google Fusion Tables to create individual Chicago Ward maps

September 13, 2011 / / 0 Comments

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.

The problems

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.

The solution

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. 

Elsewhere

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. 

Policy insight for Monday, August 1, 2011

August 3, 2011 / / 0 Comments

This isn’t refined. These are just my notes that I speak from. I may not have spoke about everything written here and I may not have written here everything I spoke about. This is for Moving Design. 

There was report of cyclist crashing on the Tuff Curb at the on-street bike parking facility in Wicker Park.

Installing the Tuff Curb

experimental projects need reviews. I don’t mean projects that are considered experiments, I mean projects that are new to the people who designed it, and new to the people who will be using it.

we need good data collection.

Did the Kinzie bike lane cause congestion? So what if it did?
We would need data points that were collected using well-known methods, and probably at different times of the day and week. And we’d have to be sure to count cyclists, too.
Then 3, 6, or 12 months later, we’d have to do it again.

What was the change?
Is that a change that meets our goals?

Back to the cyclist crashing on tuff curb, what is the city’s plan to monitor the use (or disuse) of the facility? How will the city collect data on something like this?

Census – not gonna happen in 2020
American Community Survey – 5-year estimates (with data gathered annually) will replace decennial Census.

“Here are a few Streetsblog posts about Census and NYC DOT’s bike counts, and the problems with each. The first post has some stuff about what could be done to improve on them:” (Ben Fried, Editor in Chief, Streetsblog NYC)

http://www.streetsblog.org/2010/04/27/how-many-new-yorkers-bike-each-day/
http://www.streetsblog.org/2010/10/01/did-nyc-bike-commuting-decrease-in-2009-thats-what-the-census-says/
http://www.streetsblog.org/2011/04/13/actually-if-you-build-it-they-will-bike/

Read more policy insights from Steven Vance. 

Carnage culture: Extrapolating blood alcohol content levels

June 20, 2011 / / 0 Comments

A breathalyzer test, to measure an automobile driver’s Blood Alcohol Content (BAC), is not always administered at the time and scene of a crash. I don’t know why it took four hours for Drew Forquer to have his BAC measured, but it registered at 0.045 percent, slightly more than half the legal limit of 0.08 percent.

Drew was convicted on Friday, June 17, 2011, of reckless homicide and aggravated drunken driving, but not “aggravated DUI charges that specified he was over the legal limit.”

…but the judge said it was clear to him simply from the results of field-sobriety tests, eyewitness testimony and Forquer’s “bizarre” turn — which was caught on surveillance video — that he was impaired.

The prosecution hired an expert witness to extrapolate Drew’s BAC at the time of the crash, “estimated…to be from 0.084 to 0.123 percent.”

What extrapolation means

Using evidence, prosecution and defense argue about the estimated BAC based on a variety of factors, including:

  • witness statements about driving behaviors (prosecution)
  • evidence of drinking before or during crash (prosecution)
  • field sobriety test (prosecution)
  • individual’s metabolism (defense)
  • “what the driver ate or drank that day” (defense)
  • other health issues (defense)

(The parentheses indicate which side used the factor in Drew Forquer’s case.)

In Drew’s case, his defense attorney argued that the BAC was lower because him having liver disease and chronic alcoholism would have slowed his metabolism (meaning alcohol would enter the blood stream more slowly).

Drew awaits sentencing, which can be from probation to 15 years in prison. They must be joking about probation – he’s gone to court for four previous DUI arrests!

More carnage culture articles

Story sources

Chicago Tribune – Thursday, June 16, 2011

Chicago Tribune – Friday, June 17, 2011

A taxi driver exited Lake Shore Drive and drove across the grass separating it from the Lakefront Trail. This photo, taken on July 4, 2010, is not related to the story above. Photo by Andrew Ciscel.

My protected bike lane drawing from 2007

June 17, 2011 / / 0 Comments

I was looking through my most popular bits on Flickr and came across this drawing I made in January 2007.

Notice how I put a bike rack in the street. Portland starting on-street bike parking corrals in 2002, I believe.

It looks surprisingly like the Kinzie Street bike lane 😉

I cannot remember from where I got the inspiration to draw this. I hadn’t yet traveled to New York City or Portland; I probably saw a drawing of this on Streetsblog for a facility that would soon be built in New York City (9th Avenue cycle track popped up later in 2008).

I don’t remember my obsession with bicycle planning beginning that early.

My first iPhone app – Request a bike rack

June 16, 2011 / / 0 Comments

Here’s a video preview of my first iOS app that will hopefully, in the end, allow you to request a bike rack in Chicago based on where you and your device are currently standing.

I don’t know if it will ever hit the Apple App Store because Apple requires developers to pay a $99 fee each year. I’m surely not going to pay this. It will be able to run on jailbroken iOS devices and it will work on iPhone, iPad, and iPod touch.

The code is based on my Bike Crash Portal website that asks permission to use your location (given automatically through HTML5 and the computer’s own location software). A fork of this project may include a mobile-optimized website that allows you to request a bike rack; again, based on your current location.

The purpose of this is to eliminate the need to know the address of where you want to request a bike rack. Oftentimes a person will arrive at their destination and not find any bike racks. Open the app, hit “Share my location” when the app loads and then tap submit. The Chicago Bicycle Parking Program (hopefully) will receive your request.