Archived Data Management System

1
Archived Data Management System

• Study Advisory Committee Meeting
• September 25, 2003

2
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,

3
Literature Review (contd)

• Major Data Archiving Projects (contd)
• Virginia ADMS
• Started in 2002
• 1M for operational version
• Located at Univ. of Virginias 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,

4
Literature Review (contd)

• Major Data Archiving Projects (contd)
• 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

5
Literature Review (contd)

• Major Data Archiving Projects (contd)
• 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

6
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

7
Data Processing Update

• Traffic Characteristics
• Typical speed distribution
• SKYI64003E, MP6.7
• 2 lanes
• Friday, December 13, 2003

8
(No Transcript)
9
Data Processing Update (contd)

• Traffic Characteristics (contd)
• 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.

10
(No Transcript)
11
Data Processing Update (contd)

• 2003 Data Completeness
• ARTIMIS
• January March 2003
• Segment files (15-min volume, speed, occupancy)
• ARTIMIS2003.xls
• S-card
• sampleScard.txt
• V-card

12
Data Processing Update (contd)

• 2003 Data Completeness (contd)
• TRIMARC
• January June 2003
• 18 new detector stations added
• Segment file (15-min volume, speed, occupancy)
• TRIMARC2003.xls
• C-card
• Rec3

13
Web Page Input

• Shape files
• ARTIMIS and TRIMARC detectors
• ATR stations
• PDF files showing the locations of detectors and
  ATR stations
• Readme.txt

14
ADMS Prototype Development

• Major Programming Tasks
• Database design
• Data archiving algorithm and its programming
• Quality check and imputation
• Query interface
• Subcontractor?