chiwardboard.com

Open more than a year

Loading the list…

How this list is made

• One rule, no editing. Every 311 request on city-owned infrastructure still open more than a year after it was filed, oldest first. Nothing is picked for being interesting or left off for being dull. Anyone can re-run the query against the city’s dataset and get this list.
• Only work the city is normally slow at. A year is unremarkable for a sidewalk, which takes a median of about ten months. It is very strange for a traffic signal, which the city closes in a median of five hours, so a year-old signal ticket almost certainly means a crew fixed it and never closed the record. So types the city normally closes in under a month are left off. The build measures that on every refresh, and a type that speeds up drops off on its own.
• City property only. Sidewalks, street signs, bike lane debris and the like: things the city owns and maintains, so naming the address names a place. Complaints against private property and its owners are never listed here, however long they have been open.
• Duplicates removed, and only requests filed since the May 2023 ward map, so a case sits in the ward it was filed in.
• “Checks” is how many refreshes have found a request still open, months apart. It counts from when the watching started, not from when the request was filed.
• What an open request proves. The records carry a status, not an intention. A request may be open because nobody came, or because the work is queued. Most sidewalk repairs run through CDOT’s Shared Cost Sidewalk Program, which opens for applications one day a year. Read it as work the city has not signed off on.
• “See the spot” opens Google Street View at the coordinates the city recorded, so it shows the place, not the problem. It is an ordinary link; this page loads nothing from Google.