Enhancing Bridge Modelling
Overview
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. The project included the following five phases:
Project Summary
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: Configure 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
Refine 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 outlines the conditions of the bridges by classification, as well as the treatment expenditures over the next five years by classification and treatment. This phase includes successful generation of component condition and treatments reports based on the execution of the analysis and optimizations of various budget scenarios determined by the Department, once all enhancements have been completed, and a report to document the results.
