Archived Data Management System
This document summarizes the findings from the September 25, 2003, meeting of the Study Advisory Committee on data management systems, focusing on key data archiving projects across California, Virginia, Washington, and Minnesota. It highlights the California PeMS, Virginia ADMS, Washington TDAD, and Minnesota traffic data automation, detailing their costs, functionalities, and contributions to real-time traffic management. Additionally, it addresses data processing updates and the establishment of a stakeholder survey to improve traffic data quality and analysis. The report serves to advance our understanding of traffic behavior.
Archived Data Management System
E N D
Presentation Transcript
Archived Data Management System Study Advisory Committee Meeting September 25, 2003
Literature Review • Major Data Archiving Projects: • California PeMS (freeway performance measuring system) • Started in 1998 • $2M total cost for production version • Web-based access with central database located at UC Berkeley • Raw data sent from TMCs to UC Berkeley over Caltrans wider area network • 30-sec flow, occupancy, speed by lane • Imputes missing or incorrect data, daily loop performance diagnosis • Provides delay, VMT, VHT, travel time, queue, …
Literature Review (cont’d) • Major Data Archiving Projects (cont’d) • Virginia ADMS • Started in 2002 • $1M for operational version • Located at Univ. of Virginia’s Smart Travel Lab • 2-min volume, occupancy, speed by lane, incident, weather • Data screening and imputation • Provides performance measures, real-time incident management, 511/ATIS support, historical information, quantitative impact of weather, …
Literature Review (cont’d) • Major Data Archiving Projects (cont’d) • Washington TDAD (traffic data acquisition and distribution) • Started in 1998 • Web-based access with server located in Univ. of Washington • 20-sec volume, speed, density • Data imputation performed • Query generates ASCII format output
Literature Review (cont’d) • Major Data Archiving Projects (cont’d) • Minnesota (traffic data archiving, automation) • Data disseminated through ftp site in Univ. of Minnesota Duluth in zip format • 30-sec volume and occupancy • Automation of AADT calculation
Data Needs Survey • Web-based Survey http://cvoz.uky.edu/ITSurvey/ • Stakeholders: • KYTC (traffic, operations, planning, multimodal, other) • FHWA (KY division and national office) • DOTs (Ohio, Indiana) • ARTIMIS, TRIMARC • MPOs (KIPDA, OKI, Lexington) • KTC • Other
Data Processing Update • Traffic Characteristics • Typical speed distribution • SKYI64003E, MP6.7 • 2 lanes • Friday, December 13, 2003
Data Processing Update (cont’d) • Traffic Characteristics (cont’d) • Take all data points between 4-7pm for the same site during 2002 • Plot speed-flow relationship • According to HIS, the peak capacity of this site is 4400 veh/hr.
Data Processing Update (cont’d) • 2003 Data Completeness • ARTIMIS • January – March 2003 • Segment files (15-min volume, speed, occupancy) • ARTIMIS2003.xls • S-card • sampleScard.txt • V-card
Data Processing Update (cont’d) • 2003 Data Completeness (cont’d) • TRIMARC • January – June 2003 • 18 new detector stations added • Segment file (15-min volume, speed, occupancy) • TRIMARC2003.xls • C-card • Rec3
Web Page Input • Shape files • ARTIMIS and TRIMARC detectors • ATR stations • PDF files showing the locations of detectors and ATR stations • Readme.txt
ADMS Prototype Development • Major Programming Tasks • Database design • Data archiving algorithm and its programming • Quality check and imputation • Query interface • Subcontractor?
