Category: Change

Getting a little closer to understanding Chicago’s pothole-filling performance status

Tom Kompare updated his web application that tracks the progress of potholes based on information in the city’s data portal in response to my query about how many potholes the city fills within 72 hours, which is the Chicago Department of Transportation’s performance measure.

He wrote to me via the Open Government Chicago group:

Without completely rewriting http://potholes.311services.org, I added a count of the number of open (not yet addressed) pothole repair tickets (requests) that exceed 3 days old. As of today, the data from the City of Chicago’s Data Portal shows 1,334 or the 1,404 open tickets in the 311 system are older than three days.

Full disclosure: The web app actually looks for greater than 4 days old. The Data Portal’s pothole data are only updated once a day, so these data are always a day old. 4 – 1 = 3.

Keep in mind that this web app only shows how many are yet to be addressed, and does not count how many have been patched within CDOT’s 3-day goal during some arbitrary time period. That is a much more intense calculation that this pure client-side Javascript web application can handle due to bandwidth restrictions on mobile (3/4G). This web app already pushes the mobile envelope with the amount of data downloaded. I can fix that, but, again, not without a rewrite.

Still, 1,334 open repair requests (12/16/2013 Data Portal data) is quite different than the number of open repair requests reported by CDOT (560 in Alley, 193 on street) on 12/16/2013. I’m not sure what is the difference.

This reminds me of a third issue with the way CDOT is presenting pothole performance data online (the first being that it’s PDF, the second that it doesn’t work in Safari). The six PDF files are overwritten for every new day of data. If you want information from two days ago, well you better have downloaded the PDF from two days ago!

CDOT misses the lesson on open data transparency

Publishing the wrong measurement as a PDF isn’t transparency.

The Chicago Department of Transportation released the first progress report to its Chicago Forward Action Agenda in October, two and a half years after the plan – the first of its kind – was published. I’ve spent an inordinate amount of time reading it and putting off a review. Why? It’s been a difficult to compare the original and update documents. The update is extremely light on specifics and details for the many goals in the Action Agenda, which should have organizational (like record keeping and efficiency improvements) and public impacts (like figuring out which intersections have the most crashes). I’ll publish my in-depth review this week.

Aside from missing specifics and details, the update presents information differently and is missing status updates for the three to five “performance measures” in each chapter. It was difficult to understand CDOT’s reporter progress without holding the original and update side-by-side. I think listing the original action item, the progress symbol, and then a status update would have been an easier way to read the document.

The update measures some action items differently than originally called for, and the way pothole repair was presented, a problem for people bicycling and driving, caught my analytical eye.

CDOT states a pothole-filling performance measure of the percentage, which it desires to be increased, “patched or fixed within 72 hours of being reported” but the average, according to the website Chicago Potholes, which tracks the city’s open data, is 101 days*. The update doesn’t necessarily explain why, writing “the 72 hour goal for filling potholes is not always feasible due to asphalt plant schedules” and nothing related to the performance measure.

As originally written, the only way to note the performance would be to list the percentage of potholes filled within the goal time, at the beginning and in the update. This performance measure has a complementary action item – an online dashboard – which could have provided the answer, but didn’t.

CDOT published that dashboard this summer as a series of six PDF files that update daily and you can hardly call it useful.

Publishing PDF files in the day and age of open government data – popular with President Obama and Mayor Rahm Emanuel – is unacceptable. Even if they are accessible – meaning you can copy/paste the text – they are poor outlets for data given the nationally-renowned civic innovation changes that Emanuel has succeeded in establishing.

There’s another problem: the dashboard file for pothole tracking doesn’t track the time it takes to close a pothole request, nor the number of pothole requests that are patched within 72 hours. It simply tells the number completed yesterday, the year to date, and the number of unpatched requests. (I’ve posted the pothole-tracking file to Scribd because the dashboard [PDF] doesn’t work in Safari; I also notified city staff to this problem which they acknowledged over three weeks ago.)

The “Chicago Works For You” website reports a different metric, that of the number of requests made each day, distributed by ward.

I discussed the proposed dashboard with former commissioner Gabe Klein over two years ago. He said he wanted to create a dashboard of projects “we’re working on that’s updated once a week.” Given Klein’s high professional accessibility to myself, John Greenfield and other reporters, I’ll give him and CDOT a pass for not doing this. But Klein also said, “I’m really big on transparency and good communication. When I left [Washington,] D.C. our [Freedom of Information Act Requests] were dramatically lowered.”

I’ll consider the pothole performance measure and action item “in need of major progress.”

* For stats geeks, the median is 86 and standard deviation is ±84.

When did everyone start caring about bicyclists dying?

A Plague of Cyclists appear to run cars off the road on The Weekly Standard’s cover.

A couple weeks ago a bunch of journalists from major international news outlets were having drinks somewhere (maybe The Billy Goat Tavern in Chicago’s basement) and wrote the same story.

Actually, they didn’t, but it’s surprisingly weird how close they were.

On Sunday the New York Times published “Is It O.K. To Kill Cyclists?”. Next, on Monday, Crain’s Chicago Business published “Why everyone hates bicyclists—and why they hate everyone back”.

Daniel Duane’s op-ed in NYT garnered a lot of response (7 of them are linked here, which doesn’t include Crain’s or The Weekly Standard). The Economist responded to the NYT article with “Cycling v cars: The American right-of-way” saying we should adopt laws like the Netherlands and gave several examples there of who’s liable for a crash between a car and bike (nearly always the driver). Bike Snob wrote the response I most agree with. Karen Altes of Tiny Fix Bike Gang got pissedTwin City Sidewalks (in Minneapolis/St. Paul) wrote that “bicyclists need to stop blaming themselves for dangerous roads”, referring to the bicyclist in question, Daniel Duane, the NYT op-ed contributor.

Tanya Snyder, writing for one of my employer’s sister blogs Streetsblog Capitol Hill, headlined her own roundup post, “The Times Blows a Chance to Tackle America’s Broken Traffic Justice System”. Andrew Smith at Seattle Transit Blog said that he gave up cycling to work in the first week he tried it. Brian McEntee wrote on his blog Tales from the Sharrows about two scenarios to consider about “following laws” (which isn’t what cyclists or drivers should be aiming for).

David Alpert, who runs a Streetsblog-like blog called Greater Greater Washington, said that it’s not okay to kill cyclists, “but if a spate of other op-eds are any indication, it’s sure okay to hate them and the facilities they ask for in a quest for safety”. BikeBlogNYC later published myriad examples of how streets continue killing everyone who’s not driving a car.

Then The Weekly Standard published something very similar to Duane’s piece. I don’t know when – it’s in the issue marked for November 18, but I believe it went up Monday, with a sweet cover. It went by two names. On the cover, “A Plague of Bicyclists” (by Christopher Caldwell) and on the site, “Drivers Get Rolled: Bicyclists are making unreasonable claims to the road—and winning”.

Most of the proceeding discussions revolve around “who’s right”. And the Economist skirts discussing the answer and instead just gives the answer: the bicyclist, because they’re the ones who die.

When you are driving in the Netherlands, you have to be more careful than you would when driving in America. Does this result in rampant injustice to drivers when accidents occur? No. It results in far fewer accidents. As the ANWB [Royal Dutch Touring Club, like the AAA] says, some drivers may think the liability treatment gives cyclists “a blank check to ignore the rules. But a cyclist is not going to deliberately ride through a red light thinking: ‘I won’t have to pay the damages anyway.’ He is more likely to be influenced by the risk that he will land in the hospital.”

I like what Evan Jenkins, a sometimes urbanist blogger studying mathematics at University of Chicago, wrote on his Twitter timeline:

That’s encouraging. He linked to several of his past articles about cyclist murder.

 

What’s also funny about this weekend’s bike-journo-fest is that Whet Moser, writing for Chicago Magazine, interviewed me two weeks ago about bike infrastructure and penned this uncomplicated, unruffled but comprehensive article saying “drivers and cyclists don’t have to be angry and fearful…with smart planning, a city can design safe roads for all.”

Chicago has started on that path. You know what might influence more change than any bike lane built? Speed cameras. And no, I won’t let them be removed.

Updated multiple times to add more responses to Duane’s op-ed. 

On Active Transportation Alliance’s transportation summit

Active Transportation Alliance invited Eric Hanns and I to speak about “using data for advocacy” at their first annual transportation summit held after a member meeting two Saturdays ago. My and Eric’s talks were complementary and centered around the data tool I built and which Eric and the other volunteers in the 46th Ward participatory budgeting program used to prioritize and market infrastructure projects in Uptown.

The tool in question is the Chicago Crash Browser I made last year and improved this year to load data faster, with great help from the Smart Chicago Collaborative and several members of the OpenGov Hack Night group I cherish.

Click or tap a spot in Chicago to retrieve the number of bicyclist-car and pedestrian-car crashes within 150 feet. With this information, the PB volunteers could show the alderman how important it was for him to support bike and pedestrian infrastructure projects in the ward, and to persuade ward voters to fund these projects.

Find more information about the four other summit “breakout groups” on Active Trans’s website. Eric and I prepared a “Using Data for Advocacy: Making the Case with Compelling Facts” handout which you can download as a PDF or see on our Google Doc. I’ve conveniently listed the links from the handout below but if you want more pointed advice on where to look for specific data, or get an answer to questions you have but don’t grok the context of each of these tools, leave me a comment.

Happy birthday Gas Tax, it’s time to retire

Descending

Traffic congestion (right) won’t change until we give transit infrastructure (left) a better footing on which to compete.

Today’s apparently the birthday of the Yosemite National Park, NASA, and also the 18.4 cents per gallon federal gas tax.

It’s time to go. Peter Rogoff, the administrator of the Federal Transit Administration said as much yesterday at the American Public Transportation Association annual meeting.

A meeting attendee asked Rogoff, during the Q&A session following his speech, about the insolvency of the Highway Trust Fund, where gas tax revenues go, and from which payments for road, transit, and bike projects are drawn. Rogoff replied,

We see a lot of governors taking this on. Wyoming raised its gas tax 15 cents. And on any given weekend there are more Democrats drinking beer in my backyard than in the entire Wyoming legislature. All options are being considered. Gas tax has diminishing returns. We can’t simultaneously lower independence on foreign oil and fund transportation systems dependent on the consumption of oil.

Here’s why the per-gallon gas tax is unsustainable: it loses purchasing power because of inflation. If it were sales tax based on the total cost of your fillup, this would be a completely different story, by decreasing driving instead of decreasing gas use (and yes, they are different because as cars become more fuel efficient, driving can remain the same or go up while gas use can remain the same or go down).

So “goodbye gas tax, hello mileage tax?”

Cross-posted to the Center for Permaculture and Appropriate Technology.