Stream Traffic Data Archival, Querying, and Analysis with TransDec

Transportation assume no liability for the contents or use thereof. The contents do not necessarily reflect the official views or policies of the State of California or the Department of Transportation. This report does not constitute a standard, specification, or regulation. ABSTRACT The goal of research was to extend the traffic data analysis of the TransDec (short for Transportation Decision-Making) system, which was developed under METRANS 09-26 research grant. The TransDec system is a real-data driven system to support decision-making in transportation systems. With TransDec, so far we have addressed the challenges in visualization, querying and management of dynamic and large-scale spatiotemporal transportation data, in particular, traffic sensors data and moving assets data. † With this proposal, building on our experience in implementing TransDec, we extended our research and technology development efforts under three specific tasks. First, we developed new techniques to create a streaming data archival repository that supports continuous querying and analysis of the vast amount of California transit data from RIITS (Regional Integration of Intelligent Transportation Systems) generated in the form of data streams. Second, we extended the current data-tier of TransDec to a distributed design to enable more scalable and stable computing environment. Finally, to demonstrate the benefits of the archived traffic datasets, we presented a novel proof-of-concept application, namely time-dependent optimal sequenced route (TD-OSR) planner using congestion prediction. This application exploits a subset of the real-world RIITS datasets, and these days we evaluating the ways to make it available for public use.