I downloaded the CSV from Freddy Martinez. See all the data, and the FOIA request, on their repo. This data dump should show the same data the Chicago Tribune used in its analysis of where Chicago police officers issue tickets to people bicycling.
The CSV started with 15,971 total records.
I performed the following corrections of the data:
- Removed 71 records on Unknown street
- Coalesced all records on KING DR to use the same spelling
- Removed the following ambiguous ones (sorry, I should have recorded the unique record ID along with these):
-
- 850 67TH
-
- 2050 71 STREET
-
- 2550 79TH
-
- 50 GARFIELD
-
- 5650 NAGLE
-
- 1050 PULASKI RD
-
- 350 PULASKI
-
- 150 WASHTENAW
-
- 50 W TERMINAL ST
-
- 3950 W THOME
-
- 1350 S 75TH ST (could be east or west)
-
- 250 W 10th St (Chicago doesn't have a 10th Street)
-
- 7450 S BURNHAM (the street doesn't start until the 7650 block)
-
- 3850 S BURNHAM (ibid)
-
- 6150 W 18TH (not in Chicago)
-
- 2050 S Laramie (this is in Cicero, although it could be N Laramie, which is in Chicago; removed anyway)
-
- 4950 W 16TH ST (Cicero)
-
- P005160013 - 269XX E 79TH CT - can't determine what address this is supposed to be.
-
- P004508214 - 450 W Laramie - ambiguous address because Laramie is N/S
-
- P004472803 - 343XX W 67TH ST - can't determine/I don't want to assume
-
- P004541553 - 98XX S MAPLE (no street with this name, could be Maplewood)
-
- P004979358 - 550 W CICERO (ambiguous)
-
- P004946750 - XX E STATE (invalid direction)
-
- P003330075 - 11750 S HARLEM ST (no such address)
- Changed the following:
-
- Changed 4750 S MUNURE ST to 4750 W MONROE ST
-
- Changed 4650 N SHORE DR to 4650 S Shore DR - still not a valid address
-
- Changed 2350 E State St to 2350 S State ST
-
- Changed P004568505 - 154XX W HOWARD ST to 1540 W Howard
-
- Moved P005100048 to Marshfield and Madison, even though Marshfield doesn't actually intersect with Madison.
This resulted in 100 removed records, now standing at 15,871.