Category: States

Finding data about traffic and roads in Illinois

There are two good websites that provide information about roads, traffic, and their many attributes. One is provided by the Illinois Department of Transportation (IDOT) called Getting Around Illinois (GAI). The second is the Traffic Count Database System (TCDS).

Both provide Average Daily Traffic (ADT) counts with TCDS making the information easier to find and presents more of it.

The GAI map has an important layer: jurisdiction. With that information you can determine who has “ownership” of a road. Jurisdiction has been an important factor in the nearly year-long delay of the Jackson Boulevard protected bike lane segment from Ogden Avenue to Halsted Street. IDOT has jurisdiction over this segment (which continues east to Lake Shore Drive; the road is also known as Route 66) and is requiring that the Chicago Department of Transportation do more analysis and revise their designs.

If you are looking for ADT counts, I highly recommend TCDS as it uses the more familiar Google Maps and doesn’t require the Microsoft Silverlight plugin (which is slow and often denigrated with poor usability applications).

GAI has truck routes and crash information as well.

Slicing the crash data into interesting visualizations

The Chicago Crash Browser as it looks now. This only exists on my laptop and no place else. I can’t put it online because it’s so inefficient it would kill the server. 

I presented my Chicago Crash Browser to attendees of an OpenGov Hack Night three weeks ago and gathered a lot of feedback and some interest from designers and programmers there.

We collaboratively came up with a new direction: instead of focusing on creating a huge web application that I proposed, we (anyone who wants to help) would start small with a website and a couple of crash data visualizations. The visualizations would serve two purposes:

  • attract attention to the project
  • start building a gallery of data-oriented graphics that describes the breadth and extent of the crash data

Continue reading

Tucson’s neighborhood friendly ordinances

I’m moving to Tucson so I can bike on Dutch-style separated bike paths.*

My Grid Chicago writing partner John Greenfield visited Tucson, Arizona, earlier this month. His post about their bicycle facilities is on our site today. I published two posts about my visit in 2010, first Tucson has every kind of bikeway and Rialto theater in downtown Tucson.

In John’s post, he describes that the proliferation of bikeways (of all kinds!) are in part due to a city ordinance that requires they be installed in all road projects. Think Complete Streets but where you actually have to make one instead of just “considering” making one, which is what happens here.

I started digging into the city code to find the ordinance and its exact language. I haven’t found it yet, but I did find this:

Chapter 15, Section 13 is about going to the voters to approve or reject the city’s involvement in any project to construct “freeway, parkway or other controlled-access highway” or “grade-separated interchange”. So, in a regular or special election, the city must ask voters whether or not the city should be involved in building big roads, on a project by project basis.

Imagine that. What if the voters of Chicago could reject the destruction of their neighborhoods because of expressway construction for the Dan Ryan, Eisenhower, and Kennedy? Well, first of all, would people approve or reject those projects?

“(e) If the voters reject the proposed project, the mayor and council shall request that the state department of transportation not include the proposed project in the state highway system.”

An approval for a project is valid for five years. If no construction happens in that time, then the project approval has lapsed and the voters must be asked again. I’m sure many people (especially the people proposing the project) would find this law an enormous barrier to “progress”, but it ensures some level of public participation.

* Just kidding.

Figuring out how many CMAQ projects are for roads

Simplified, the purpose of Congestion Mitigation and Air Quality (CMAQ) grant is to fund projects that reduce congestion and improve air quality. This usually means bicycle, pedestrian, and transit facilities and vehicles. But it also means road projects. Like intersection widening, new signals, changes to signal programming, and “signal interconnect” (timing the signals to cooperate with each other to have some free flowing traffic). It can also mean making grade separations at railroad tracks to eliminate backups when trains cross. However, not everything is infrastructure: there’s also marketing, encouragement, analysis, bike sharing, and education.

In a conversation I was having last night with some transportation advocate friends, one joked that most of CMAQ funds road projects. I agreed (probably because the irony of reducing congestion by making higher capacity roads was funny to me), and we moved on to other topics. I set out verify the actual distribution share for the six-county region in Northeastern Illinois.

I spent almost an hour converting the Chicago Metropolitan Agency for Planning’s CMAQ 2012-2016 projects list from PDF to Excel and then quickly identified every project as being “road” or “not road”. I tallied the amount of proposed CMAQ funding for the projects to get the answer: road projects take up 25.7% of CMAQ funding.

But I can’t stop there! Now that I have CMAP’s data in a spreadsheet, I can get the average of Daily VOC eliminated for road and non-road projects, as well as the estimated cost per VOC kilogram eliminated.

On average, non-road projects have a lower cost per VOC kilogram eliminated ($4,109.37 versus $9,472.90). And non-road projects on average eliminate 19.7 times more kilograms of VOC daily (5.918 kg versus 0.301 kg for road projects).

There are some disclaimers! These are all estimates and not every project has received funding. Also, projects are not selected solely on cost per kilogram of VOC eliminated, or daily VOC eliminated. I’d also like to see estimates on the number of people affected by each project.

You can check my math by downloading my modified projects list (XLS).

The first raised crosswalk I’ve seen in Illinois

The raised crosswalk, a view looking northeast, from the sidewalk. 

Forest Park was a client of mine in 2012 via my work for Active Transportation Alliance; they’re a technical consultant for cities that had grants from the Communities Putting Prevention to Work program. I visited the village with one of their staffers to identify great locations for bike racks (that also included advice on their existing rack inventory, and suggestions for exactly which models to buy).

We would drive around town and then stop and walk a lot. One place where we did a lot of walking was in their downtown, on Madison Street (the same Madison Street as in Chicago). I was pleasantly surprised that their signage reflected the “stop for pedestrians in crosswalk” law, replacing the now-irrelevant “yield for pedestrians in crosswalk” signs. And to top it off, they had talking and lighted signals at some of the crosswalks. I do not support any widespread installation of these: I think they help move our culture in a direction that perpetuates the low respect we have for pedestrians. I believe there are other ways to enforce driver compliance that do not require this kind of equipment.

Forest Park has installed one of those ways: it’s a raised crosswalk (also known as a speed table). It looks like a speed hump, but is much wider, has a flat top, and carries a marked crosswalk (see my article on Grid Chicago “What is an unmarked crosswalk?“). It causes drivers to slow down and has an added – subjective – benefit of intimating that the driver is entering a “protected space”, one for people on foot and that it should be respected. They bring the roadway up to the pedestrian’s level instead of dipping the sidewalk down to the driver’s level.

I don’t know of one in Chicago, but three guys are working to get several installed in a Logan Square traffic circle redesign.

Note: If you are interested in knowing exactly which models of bike racks to buy, learn more at Simple Bike Parking, or contact me directly. I may charge a fee.

The raised crosswalk as seen from a car moving westbound.