Challenge

The Connecticut Department of Transportation (CTDOT) wished to enhance the current dTIMS bridge management implementation to provide for more accurate deterioration models and better analysis results.

Solution

The project included the following five phases:

Phase 1: Automation of Data Loading Developed automated workflows to extract the bridge data from InspectTech system and other databases.

Phase 2: Deterioration Model Enhancement Performed statistical analysis to highlight components and elements that are deteriorating outside of the ranges based upon CTDOT expectations, the modified performance prediction models in dTIMS, and then produce a report that outlines the work completed.

Phase 3: Configured National Performance Measures Created dTIMS analysis variables and the analysis expressions required to automate the calculation of the MAP-21 bridge performance measures. Implemented reporting mechanisms to easily determine the effects of the measures for alternative budget scenarios.

Phase 4: Enhanced Treatments, Triggers, Resets, Costs Refined existing bridge treatments, triggers, resets and costs to ensure the recommendations from the dTIMS analysis can be used effectively to create work candidates and bridge projects. Produced a document outlining the new treatment methodology implemented during this phase.

Phase 5: Report Automation Developed a Sequel Server Reporting Services (SQL) report that summarizes the analysis results for a selected budget scenario. The report outlined the conditions of the bridges by classification, as well as the treatment expenditures over the next five years by classification and treatment. This phase included successful generation of component condition and treatments reports based on the execution of the analysis and optimizations of various budget scenarios determined by CTDOT. A report to document the results was developed.

Results

New performance and prediction models were developed including corresponding reports.