Mapping DC Bike Counts
February 21st, 2013 [programming]
Last June, DDOT and MWCOG counted bicycle traffic over an 8-hour period in 48 locations. I got a copy of the results, and converted the spreadsheet into a map. The Bicycle Counts Stat Mapper uses the same interface I created for the Bicycle Accidents Stat Mapper, but with a few new features added.
A total of 21,930 cyclists were counted. They also recorded the rider’s sex, whether they were on a sidewalk, whether they were wearing a helmet, and whether they were riding a Capital Bikeshare bike: 75% were male, 27% were on a sidewalk, 69% wore helmets, 5% were on CaBi.
The place with the most bike traffic was the 15th St cycle track, measured north of P St. It got just under 200 cyclists per hour (198.8 to be exact). Its busiest hour saw 355 cyclists go through.
Close behind was Water St NW in Georgetown, connecting K St (under the Whitehurst Freeway) to the Capital Crescent Trail. Its average was 198.4 cyclists per hour, with a peak hour of 351 cyclists.
It’s good to have traffic numbers for all 9 of Washington, DC’s river-crossing bridges. Here they are listed in order of most bike traffic:
|George Mason Bridge (14th St)||182.4|
|Arlington Meml Bridge||112.9|
|Teddy Roosevelt Bridge||39.5|
|Douglass Meml Bridge (S Capitol St)||32.9|
|Sousa Bridge (Pennsylvania Ave)||9.6|
|11th St Bridge||3.5|
|Whitney Young Meml Bridge (E Capitol St)||0.4|
The high traffic numbers for the 14th Street Bridge support the proposal from GreaterGreaterWashington to Fix the 14th Street bridge bike connection with 3 easy steps.
The place with the highest percentage of female riders, 40%, was Garfield St NW, near the St Albans School.
The normal caveat for geocoded data applies: the coordinates were generated by Google’s geocoder, which prefers giving inaccurate results to not responding at all. I manually edited locations for many of the spots. If you find misplaced markers, leave a comment below.
You can also view heat maps of the selected statistics, though bear in mind a heat map is not the most appropriate method for these numbers, since two little spots near each other will combine to look like a single big spot.
Check out the Bicycle Counts Stat Mapper and see what you can discover.
See also Mapping DC’s Bicycle Accidents.