Spatial Analysis of Bicycle Count Data: Final Project Report

Every year since 2010, volunteers from more than 50 communities have helped the Washington State
Department of Transportation (WSDOT) collect bicycle count data.
This project created the AADB (Annual Average Daily Bicyclists) Estimation website that communities can
use to make maps of bicycle volumes across their street network. Someone using the website begins
by uploading a spreadsheet of short-duration count data (i.e. manual counts for a period less than 24 hours).
The website analyzes the short-duration count data and seasonally adjusts the values based on continuous count
data that WSDOT collects at locations throughout the state and from other sources. The seasonally adjusted
values are an estimation of Annual Average Daily Bicyclists. Next, the website spatially extrapolates AADB
from the count locations to every segment in the street network. The spatial extrapolation is done by predicting
the flow of bicycle travel between commercial destinations and residential locations that have been synthesized
from US Census bicycle commuting information.
The AADB Estimation website can help communities conduct safety analysis and prioritize new bicycle

Publication Date: 
Tuesday, November 14, 2017
Publication Number: 
WA-RD 875.3
Last modified: 
03/02/2018 - 15:51
Michael B. Lowry
Pacific Northwest Transportation Consortium (PacTrans)
Number of Pages: 
Bicycle counts, Bicycle travel, Data collection, Spatial analysis, Manual traffic counts, Extrapolation, Traffic volume, Networks, Estimates.