| /* | |
| This has been generated by the overpass-turbo wizard. | |
| The original search was: | |
| “railway=light_rail and name="Green Line"” | |
| */ | |
| [out:json][timeout:25]; | |
| // gather results | |
| ( | |
| // query part for: “railway=light_rail and name="Green Line"” |
The source is IDOT's ArcGIS server: http://ags10s1.dot.illinois.gov/ArcGIS/rest/services/SafetyPortal/SafetyPortal/MapServer/12 It was obtained using pyesridump, created by Ian Dees.
IDOT asks that this disclaimer appears anywhere the data is used: "The motor vehicle crash data referenced herein was provided by the Illinois Department of Transportation. The author is responsible for any data analyses and conclusions drawn."
| update table_name set geom = st_transform(st_setsrid(st_geomfromgeojson('{ | |
| "type": "Polygon", | |
| "coordinates": [ | |
| [ | |
| [ | |
| -87.638478577137, | |
| 41.90763496036403 | |
| ], | |
| [ | |
| -87.63751566410065, |
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:
| Hello, I am thrilled that Aldi has reopened here, with a new design, and is more pedestrian-friendly, because one of the entrances is on the sidewalk. | |
| However, the store doesn't have a good place to park a bike. The bike rack model that has been installed hold a very small number of bicycles (2-4 depending on how people use it; it's hard to park here because the metal tubes are so close together), but it is also an insecure model. | |
| The bike rack uses thin, round metal tubing, which can be easily cut with a handheld pipe cutter. The bike rack is installed on the ground with only 2 thin screws, which can be removed with hand tools obtained from any hardware store. | |
| Because of this insecure installation, and the trouble of shuffling my bike into a crowd of other bikes at this rack, I lock my bike to the guard rails at the shopping cart pen. | |
| The store is only going to get busier with bicyclists as more of your previous customers (and all of the new residents who've moved in when the store was gone) see that |
