An Approach for Detecting Data Anomalies at Permanent Cycling Count Stations

El Esawey, Mohamed;

Abstract


With the large amounts of available traffic data, it becomes necessary to develop tools that can perform several tasks related to the collected data. These tasks include storing the data in a standard format, filtering the data/flagging suspicious records, processing the data and calculating useful quantitative traffic indices, and finally, visualizing the outcomes. In this paper, a data-driven, yet novel, data-filtering approach was proposed to flag outliers in daily cycling counts at automatic traffic counters (ATCs). The approach was motivated by
the spatiotemporal relationship of cycling counts collected at permanent count stations. The proposed approach is flexible because it assumes no prior knowledge about which locations may experience sensor malfunction (i.e., outliers). The approach was tested using a large data set of more than 111,000 daily bicycle volumes collected in 4 years (2016–2019) at more than 60 different permanent count stations in the City of Vancouver, Canada. The approach was validated using complete annual sets of data at four count stations in 2016. Scenarios of undercounting and overcounting were simulated using different percentages of the actual counts. The results showed that the proposed approach has a strong ability in detecting and removing most outliers, especially for cases of substantial undercounting.


Other data

Title An Approach for Detecting Data Anomalies at Permanent Cycling Count Stations
Authors El Esawey, Mohamed 
Keywords Big data;Outliers;Filtration methods;Bicycle counts
Issue Date Jan-2023
Publisher American Society of Civil Engineers
Journal Journal of Transportation Engineering 
Volume 149
Issue 1
Start page 1
End page 10
ISSN 2473-2907
2473-2893
DOI 10.1061/JTEPBS.TEENG-6985

Attached Files

File Description SizeFormat Existing users please Login
An Approach for Detecting Data Anomalies_ASCE_2023.pdf1.64 MBAdobe PDF    Request a copy
Recommend this item

Similar Items from Core Recommender Database

Google ScholarTM

Check



Items in Ain Shams Scholar are protected by copyright, with all rights reserved, unless otherwise indicated.