UPDATE 12-15-10: I forgot to add that the letter stated that the Freedom of Information Act doesn’t require the responding agency to create new datasets or records where one doesn’t already exist. This means that if what you ask for doesn’t exist in their databases or file cabinets, the agency is not about to filter or search through existing data to create a custom set for you.

I continue to prepare to create a bicycle crash reporting tool (or web application). Here are the previous posts. Readers have sent me many great suggestions and concerns about how to create it, what data to use, and how to present such data. I don’t expect to begin any demonstrable work on this until mid-January when I return from my 21-day European vacation.

Today I received a response letter from the Chicago Police Department regarding my recent FOIA request for bicycle crash data.

This was disappointing: “After a thorough search, it was determined that the Department has no existing record responsive to your request.” I thought, “that doesn’t seem right. They don’t make reports on bicycle crashes?”

Array

Police respond to a bicycle crash in Newberg, Oregon. Photo by Matt Haughey.

The letter later states, “The Department  does not currently possess a record which aggregates bicycle crash data.” Ah, this means something now. It seems that while the Chicago Police Department does make reports on bicycle crashes, it doesn’t keep a running tally or stored database query which it can use to produce the data I want – what I want would require a little more work, I guess.

The final paragraph does recommend that I contact the Illinois Department of Transportation Division of Traffic Safety’s Crash Reporting Section, where the police forward their reports. It turns out that I already received crash data on IDOT and I’m “playing around with it” using Google’s Fusion Tables.

Tagged with:
 
  • http://blog.theplannersdreamgonewrong.com jason tinkey

    When I was interning at Active Transportation Alliance, I did a lot of work with IDOT crash data. They do track bicycle and pedestrian crashes, it’s just wrapped up into a huge database of all yearly statewide car accidents. Send me an email if you have any specific questions about it.

    • http://www.stevevance.net/planning Steven Vance

      I only have pedalcycle crashes.

      The biggest obstacle with the data is that it came to me without any column names. They just say Field0001, Field 0002, etc… I do have the data dictionary, so I know which field is which. But I haven’t begun to retitle them.

      The next step would be to remove the fields I don’t need to speed up sorting and analysis.