Page 82 of 173

BikeLock app based on dataset I opened up

Bike parking at Daley Plaza, downtown Chicago. 

It’s really cool to see work you did “go places”. A friend of mine who works at Groupon just linked me to an iOS app called BikeLock that finds bike racks near you on iPhones, iPads, and iPod touches. It’s based on bike rack location data in the City of Chicago’s Data Portal. (The data on there is old, while the data in the public API I built is real time.)

Download it from the iTunes Store for 99 cents. The developer is Mike Jahn, another Groupon staffer. You can get the same information for free, though, on my mostly mobile-friendly Can I bring my bike on Metra? web app, and a website I made for the Chicago Department of Transportation (CDOT).

A screenshot of the Can I bring my bike on Metra? bike rack finder website. 

That data comes straight from the Bike Parking Web Application I started developing in 2008 soon after I started working in the Chicago Bicycle Program. It was good that my supervisor had the same perspectives I did about open and transparent data and work. But it didn’t start like that; here’s the full story:

My first job at the Bicycle Parking Program was to deal with abandoned bikes, get them off the street. I was taught the existing method of keeping track of my work, but I used my programming skills (in PHP, MySQL, and with the Google Maps API) to develop a web application that tracked it faster and mapped out the abandoned bikes I had to visit and tag with a notice. I was using this for a few days or few weeks and then show my boss. His reaction was something like, “Great! Now make one for bike racks!”

Why? Well, let’s take this quote from Judy Baar Topinka, Illinois comptroller, speaking Tuesday about her office’s new website, The Ledger, which lists the state’s unpaid bills among other financial data.

“The object of the exercise is to make everything that we know of in the comptroller’s office public. If we know it, you’ll know it.” WBEZ

I made one for bike racks. I created two environments, one for private administration at the office (“Bike Parking Web Application”) and one for the public (“public interface”). A later feature I added to the public interface was the Advanced Search. This allows you to filter by Ward, Community Area, and Status. You can then choose your sorting method. A map will appear above the results. You can download the results as either an XLS file, and XLS file that’s designed to be imported in GIS programs (like QGIS), or a KML file.

I’m aware of just one other app that uses this data set: MassUp.us. I don’t know if MassUp uses the real-time API that my Metra bike rack finder uses.

Intersections are long!

There are many intersections in Chicago that are so long that, while cycling, I can enter it (by passing the stop bar) on a green light, be in it during the entire 3-second yellow phase, and exit the intersection after it’s been red for several seconds.

I don’t like this. I think it puts me at risk. We could make our intersections shorter or we could increase the length of the yellow and all-red phases. One of these intersections is Elston Avenue at Ashland Avenue. Going southbound on Elston Avenue, the distance from the west side to the east side is about 200 feet. Traveling at 14 MPH (because you didn’t have to stop, it was green when you arrived), that will take you 9.75 seconds to cross. Some people will be traveling faster but at this point you’re also riding uphill because of the railroad viaduct you just crossed under.

Traveling at 17 MPH, it will take you 8 seconds to cross – you’ll still be in the intersection when it’s red!

Driving in the protected bike lane, eh

Updated 4/5/12 to add links to other discussions on this topic, my response to one of the discussions, and a link to my tweet mention this issue to 25th Ward Alderman Solis. 

I was hanging out on 18th Street on Tuesday, watching traffic as I often do, and interviewing Alyson Fletcher about her bike count project. I captured this driver of a Chevy Malibu casually driving in the protected bike lane.

Aside from emailing this to Alderman Solis and the Chicago Department of Transportation, I have no idea what to do about this (I haven’t done either of those things yet – maybe you, as a resident, should do that; I tweeted to Alderman Solis on April 4, 2012). I think the design could be modified to physically prevent automobile traffic here (except, perhaps, emergency vehicles). Other things could be added to make this more apparent as a bike lane, by adding more color and doubling the size of the pavement bicycle symbols.

I also photographed two other people driving in the bike lane. Is there not a place where people can cycle without the danger of drivers impeding their space?

Kia Forte driver.

BMW driver.

Follow the discussion elsewhere:

  • The Expired Meter – Author poses question about possible lack of clarity in the signage, symbols, or road design that sends the message that the curbside lane is for cycling only. I haven’t investigated this part. I don’t know if there are signs at the entrances to the lane that describe it as “right lane bike only” (I’m not sure if this sign is acceptable to the MUTCD – I can’t find it there – but there are many instances of it being used in Chicago). However, that sign’s posted restriction is further than what’s necessary. A sign that says “bike lane” (R3-17) is sufficient to cause that any driving in said lane is a citable offense under Municipal Code of Chicago 9-40-060.
  • EveryBlock – I posted it here.
  • Grid Chicago – I posted this about this topic later on Grid Chicago asking which bike issues most concerns readers.

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.