Idea: mapping bicycle collisions in Cape Town
I would like to establish a Google Map on which all of the cycling collisions (and muggings, and bikejackings) reported in the media can be mapped and tracked. There can be no doubt that such a map (if one doesn’t already exist – please DM me on Twitter or comment here, if so) would start to produce valuable data about the kind of streets that kill, in our city.
In particular, I expect that the timing of crashes, plotted in space, would show that certain sidewalk-free arterial roads (which are often the only choice for cyclists moving across parts of the city, due to #automobility) are consistently fatal, even if the gap of months or years between fatalities allows individual tragedies to fade from public awareness.
I, for one, am aware of a steady stream of deaths, but can’t easily recall where the last, or next-to-last, crash took place. It is very unlikely that the police would have such figures.
When I have time, the steps I propose would thus be:
- Determine what mapping platform (if not Google Maps) would best suit such a project (for the preliminary mapping phase).
- Contact the SAPS and other sources, requesting all the cycling collision data they have. Put out a few public calls for same.
- Analyse PPA and other sources and archives for collision data going back 5-10 years
- Plot these points in GIS, once the analysis is complete, for a secondary mapping phase. Cross-reference cycling collision points with posted speed, slope, time of day and other spatial data to come up with a statistical argument.
- Present these findings back to the CoCT.