Development of a Central Data Warehouse for Statewide ITS and Transportation Data in Florida. Phase II: Proof of Concept

Abstract

This report documents the development and operation of a prototype for the Statewide Transportation Engineering Warehouse for Archived Regional Data (STEWARD) as a proof of concept. It demonstrates that data from traffic management centers (TMCs) around the state can be centrally archived in a practical manner and that a variety of useful reports and other products can be produced. STEWARD will provide TMC managers, District ITS program managers, traffic engineers, and management with several useful functions for periodic reporting and other decision support. The effort described in this report has concentrated on the SunGuide traffic sensor subsystem (TSS) and the travel time subsystem (TVT). The SunGuide-generated archive data from Interstate 95 in District 2 has been used as a model for this development. Other SunGuide TMCs will be added as their archive data become available. The District 2 system is configured with approximately 450 detectors at 120 RTMS (Road Traffic Microwave Sensor) detection stations covering a 25 mile section of the freeway. Other systems in Florida Department of Transportation (FDOT) Districts 4, 5, 6 and 7 are now being configured for STEWARD. The major topics covered in this report include an overview of STEWARD, a description of the procedure for configuring the SunGuide facility archive, documentation of the TSS and TVT databases, reports available from STEWARD, Internet access features and useful applications of the archived data.