Exploring Crowdsourced Monitoring Data for Safety - StreetLight Data Bicycle Count Estimates vs Texas Permanent Bicycle Counts (TTI-Student-05)

Project Description: These data represent monthly average weekday and weekend bicycle counts and count index values at specific points locations across eight cities in Texas: Allen, Austin, Dallas, Fort Worth, Houston, North Richland Hills, Plano, and San Antonio. The bicycle counts were produced from permanent counters with complete sets of 15-minute counts per day. The bicycle count index values were provided by StreetLight Data and represent a normalized estimate that controls for variation in the passive data sample penetration rates each month. StreetLight uses passive data from mobile devices, i.e. crowdsourced location-based services, to algorithmically derive mode of travel and route. Depending on data availability, the data represent April, May, and June of 2018. These data were used to evaluate crowdsourced bicyclist activity data from StreetLight Data against actual bicycle counts. The researchers found promising correlations (R2 of 62% and 69% for monthly weekday and weekend daily averages) when the StreetLight bicyclist index values were compared to bicyclist counts from 32 permanent counter locations in eight Texas cities, and even better correlation (R2 of 94%) when compared with countywide Strava data expanded to represent total bicycling activity estimates. Data Scope: Monthly average weekday and weekend bicycle counts and crowdsourced bicycle count index values. 32 unique count locations. 8 cities across Texas. 58 monthly observations. Data Specification: KEY - character varying; unique ID; no missing values City - text; Allen, Austin, Dallas, Fort Worth, Houston, North Richland Hills, Plano, and San Antonio; no missing values Station ID TMG - character varying; no missing values Month - numeric; 4-6; 4 = April, 5 = May, 6 = June; no missing values StL Monthly Weekday Average - numeric; 5-611; no missing values TxDOT Monthly Weekday Average - numeric; 17-1518; no missing values StL Monthly Weekend Average - numeric; 11-800; no missing values TxDOT Monthly Weekend Average - numeric; 34-2507; no missing values