On Sat, 22 Sep 2007 05:20:16 -0000, Chalo <[email hidden]>
Quoted message said:damyth said:
A recent spate of bike fatalities in the local area (Sand Hill Road
near Menlo Park/SLAC, CA) has me wondering. Is there a map or
database pinpointing locations of bike fatalities? This would be
incredibly helpful for people to find out where the most dangerous
roads to ride are, a geographical representation of frequency, and
maybe help people to avoid/improve those areas.
That sounds useful enough, and labor-intensive enough, to persuade
someone to give you a grant for doing it. Google has opened their
Maps database for such outside hacks, e.g. Bikely, Gmap-Pedometer,
Frappr.
Chalo
Dear Chalo,
This database lets you select any county in any state, whole states,
and then see county-level maps and statistics for pedalcyclist deaths.
Here it's set to all of California, no county:
http://www-nrd.nhtsa.dot.gov/departments/nrd-30/ncsa/STSI/6_CA/2006/6_CA_2006.htm
If you scroll down, it shows 141 pedalcyclist deaths in California in
2006.
Click on "pedalcyclists," and it jumps you down to a county-by-county
colored map display:
http://www-nrd.nhtsa.dot.gov/departments/nrd-30/ncsa/STSI/6_CA/2006/6_CA_2006.htm#CTY_MAPS9
Obviously, some counties must be above average, others below average,
and--well, you get the idea.
Given only 141 fatalities, you'd be hard-pressed to avoid even a
county in California on the grounds that the whole county had more
than the average in bicycle fatalities.
The counties in white on the left-hand map had 0 bike fatalities in
2006.
The counties in light blue had 1-5 fatalities.
Dark blue means 6-15 fatalities for the whole county.
Green means Los An--er, 16 to 25 fatalities per county.
The right-hand map colors the counties according to deaths per 100,000
population compared to the U.S. national average.
You can also select earlier years back to 2002, but the obvious point
is that there just aren't enough bike fatalities to show much.
Cheers,
Carl Fogel