Month: February 2011

You asked for it, you got it – Chicago bike count data

Note: This post doesn’t have any analysis of the data or report, nor do I make any observations. I think it’s more significant to hear the ideas you have about what you see in the map or read in the data.

A lot of people wanted the Chicago bike crash and injury data overlaid with bike counts data.

In 2009, Chicago Department of Transportation (CDOT) placed automatic bike counting equipment at many locations around the city. It uses pneumatic tubes to count the number of bicyclists (excludes cars) at that point in the street – it counts ALL trips, and cannot distinguish between people going to work or going to school. This is dissimilar from Census data which asks respondents to indicate how they go to work.

Well, good news for you! CDOT today released the bike counts report from data collected in 2009 (just in time). There has been overwhelming response about the bike crash map I published – this shows how rabid the public is for information on their environments (just yesterday someone told me that they switched bike routes based on the crash frequency they noticed on their original route).

The size of the blue dot indicates the bicycle mode share for that count location. Mode share calculated by adding bikes and cars and dividing by bikes.

Get the data

A photo of the EcoCounter counting machine in action on Milwaukee Avenue (this was taken during testing phase, where CDOT compared automatic and manual counts to determine the machine’s accuracy).

How to use this map:

  1. Find a blue dot (count location) in an area you’re interested in.
  2. Zoom into that blue dot.
  3. Click on the blue dot to get the number of bikes counted there.
  4. Then observe the number of purple dots (crashes) near that count location.

What do you see that’s interesting?

What else is coming?

Now let’s hope the Active Transportation Alliance and the Chicago Park District release their Lakefront Trail counts from summer 2010. CDOT may have conducted bicycle counts in 2010 as well – I hope we don’t have to wait as long for that data.

I hope to have a tutorial on how to use GeoCommons coming soon. You should bug me about it if I don’t post it within one week.

Photos of Chicago bike commuters by Joshua Koonce.

Livable cities in Russia

When you blog, you “meet” a lot of interesting people around the world. Russian blogger Vladimir Zlokazov writes LiveStreets in both Russian and English. Although he doesn’t translate everything into English, what he does is high quality and methodically written.

His latest English article is a critique of a developer’s plan for a neighborhood in Yekaterinburg, population 1,293,537.

Academichesky – is promoted by the developer (Renova Stroygroup) as a project that utilizes the most innovative practices in architecture and urban planning. However the first built blocks clearly show that advertisment promises are not always consistent with the reality.

He offers suggestions for curb radius, intersection design, bicycle paths through intersections, appropriate locations for parking spaces (stay off the sidewalk!) and curb cuts. The draw for his particular critique are the beautiful 3D architectural renderings to show the suggested solutions in place.

“In places where pedestrian and bicycle crossings are located afar from the intersections additional measures should be taken to make them clearly visible for motorists. Such as using coloured asphalt for instance.”

Welcome to Amsterdam

The coolest city in Europe [editor’s note 12 years later: I don’t agree anymore]. I carried my GPS tracker with me at all times in Europe. I had to edit the routes to exclude my train trip to Utrecht and back. In the end, I biked about 134 kilometers / 83 miles (see my map, which is embedded at the end).

My trusty rental whip
My rental bike on the docklands in the ‘t IJ looking towards Centraal Station. The cruise ship passenger terminal is on the left. The bike is a Gazelle Superieur Special. I paid €5 per day and a €50 deposit. Thanks to Ãlvaro for the recommendation of Recycled Rentals.
Ferry to IJ-Buurtveer
One of the free ferries, this one to IJ-Buurtveer. I took this one instead, to Buiksloterwegveer (Amsterdam Nord).
Port of Amsterdam 7
Amsterdam can be described by a few things : Bikes, beer, and water. This post is heavy on water, and light on bikes. A beautifully yellow tugboat owned by the Port of Amsterdam.
Lots of trains from Paris and Brussels
Amsterdam has trains going everywhere, from Centraal Station, every few minutes. 32 trains every hour. An additional 18 trains daily. The Thalys has service to Brussels, Belgium, and Paris, France, nine times per day.

I arrived in the station from Wuppertal, Germany (via Venlo and Eindhoven). I left the station to get to Utrecht for a day trip and then I left the station on the DB CityNightLine to Copenhagen (a magical 15-hour journey).
House boats
Houseboats in the canals and Amstel river are quite common. A Flickr commenter describes a little more about it (click on the photo to read it). Editor’s note in 2023: One of the episodes in Ted Lasso season 3 episode 6 takes place in Amsterdam and Rebecca falls into a canal and is helped out by a man who lives in a house boat.
Not everyone has a bakfiets (cargo bike) in Amsterdam
Not everyone has a purpose-built cargo bike in Amsterdam, but more exist here than anywhere else (except perhaps Copenhagen). Just tote your stuff under your arm, including a sheet of plywood. You might want to try out the WorkCycles Fr8 – a locally designed cargo bike.
Not sure why I didn't smile more

And a gratuitous shot of me bicycling towards the docklands. I should have been smiling – as I was having such a wonderful time, but maybe I’m not because it was kind of cold.

View the 60 other photos I’ve uploaded of Amsterdam. If you want to visit, let me help you plan your trip.

Tracks around Amsterdam
Map of bike rides in Amsterdam over a few days (83 miles).

Bike crash map in the press

Thank you to the Bay Citizen, Gapers Block, and the Chicago Bicycle Advocate (lawyer Brendan Kevenides). They’ve all written about the bike crash map I produced using Google Fusion Tables. And WGN 720 AM interviewed me and aired it in April 2011.

View the map now. The map needs to be updated with injury severity, a field I mistakenly removed before uploading the data.

The Bay Citizen started this by creating their own map of bike crashes for San Francisco, albeit with more information. I had helped some UIC students obtain the data from the Illinois Department of Transportation for their GIS project and have a copy of it myself. I quickly edited it using uDig and threw it up online in an instant map created by Fusion Tables.

A guy rides his bicycle on the “hipster highway” (aka Milwaukee Avenue), the street with the most crashes, but also has the most people biking (in mode share and pure quantity).

Why did I make the map?

I made this project for two reasons: One is to continue practicing my GIS skills and to learn new software and new web applications. The second reason was to put the data out there. There’s a growing trend for governments to open up their databases, and your readers have probably seen DataSF.org’s App Showcase. But in Chicago, we’re not seeing this trend. Instead of data, we get a list of FOIA requests, or instead of searchable City Council meeting minutes, we get PDFs that link to other PDFs that you must first select from drop down boxes. But both of these are improvements from before.

I would love to help anyone else passionate about bicycling in Chicago to find ways to use this data or project to address problems. I think bicycling in Chicago is good for many people, but we can make it better and for more people.

Read the full interview.

Photos from Milan, Italy

I was in Milan on two separate days. The first for an hour while I waited for my train to Como after arriving from Rome. The second I spent eight hours there, walking around the castle, park, neighborhoods, and the Duomo. View the entire photo set.

Milano Centrale, the main train station, northeast of Piazza Duomo (I guess you would call this the “old center”). Grandi Stazioni is a company charged with “upgrading, valorizing and managing Italy’s 13 largest railway stations.”

On some of the pedestrian bridges in Parco Sempione, couples attach locks to signify their love. You may have zoom in on the photo to see the locks attached to mermaid’s “staff.” Here’s a closer view.

I brought my camera into the museum, Pinacoteca di Brera. This worker was busy restoring artwork.

In many places in Milan, the trams had segregated right-of-way. I think it looks beautiful when trains run over and through separated, landscaped corridors. See a smaller tram (one car) outside the Milano Centrale train station.

If the roof is open, go up! You get some nice views of the Piazza below, as well as the always-there crowds and the Galleria. You can also get a closer view of the cathedral buttresses.

Coming from Chicago, I don’t have access to protected or separated bike lanes. And I was surprised to see them in Milan! But I shouldn’t have been surprised, because most cities in Europe have them.