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?”
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.
About Steven Can Plan
I started this blog in 2007 as the writing assignment for an introductory urban planning class at UIC. It's about cities (mainly Chicago), GIS oftentimes, and transportation (mainly bicycling). Learn more about me, Steven Vance. I also write for Streetsblog Chicago.
Steven Can Plan is hosted on Dreamhost.
Chicago Bike Map App
The Chicago Bike Map app is a bike and street map stored entirely in your iOS device – no data connection required. The map is designed to look much like the City of Chicago's official printed and online bike map. The app works on iPhone, iPod touch, and iPad.
Highly Recommended Bike Products
Bells can be quite useful, especially to tell people in front that you're passing them. I like the ding-dong bell the best. It makes a solid DING and then DONG on the spring's return.
So far I haven't had a flat with this tire. I've used Continental Gatorskin and Panaracer T-Serv, both of which have had flats (same Chicago streets). The Gatorskin has less tread than both, and wears to a slick surface faster.
These folding locks are lighter weight and more versatile than an equally strong u-lock.
Making Maps: A Visual Guide to Map Design for GIS by John Krygier PhD, Denis Wood PhD
If you are going to make a map, whether it be hand drawn or digital, you should really give this book a read. Then read it every time you make a map. It will help make sure your maps are laid out sensibly, in a way that others can easily read, and that it doesn't include fluff or unnecessary data.
The Practice of Local Government Planning (Municipal Management Series) by
You could basically design and administer a new town kind of effectively after reading this huge and boring textbook.
The Death and Life of Great American Cities (50th Anniversary Edition) (Modern Library) by Jane Jacobs
Sustainable Transportation Planning: Tools for Creating Vibrant, Healthy, and Resilient Communities (Wiley Series in Sustainable Design) by Jeffrey Tumlin
I was sent a review copy. I'm really excited to open it up and start reading because I've been disappointed with textbooks in the past that don't focus on bicycle and pedestrian planning.