Information on Demand: In-House Development of a Highway Preservation Database System

The paper discusses the issues within a current highway preservation data integration project. The goal of the project is to integrate all technical and management data into a consolidated properly designed database that enables the organization to deliver evidence based decision-making. The project is an in?house development which is the opposite of many government directions for database development at the moment. The scope of the database is extensive as it covers all data to support the following data categories related to highway maintenance and rehabilitation: expenditures; performance; inspections; inventory management; treatment and maintenance budgeting; long and short?term condition and performance history; and treatments history. All data will be related to the highway inventory and stored for analysis. In addition to the above it is planned that information will be stored in the corporate database regarding the following: Shoulders (including the width, type, and condition ? linked to tolerability categories as a minimum); Risk assessment factors for each segment (updated periodically); Defects at a segment level so trends can be tracked over time; and Efficiency and quality of maintenance work. The main focus of the paper is how the design and construction is being managed within the Ministry. Issues surrounding the scope and documentation of the database functionality are covered in detail. How the design is being translated into practice and rolled out with training is also discussed in the paper. (A) For the covering abstract of this conference see ITRD record number 201310RT334E.


  • English

Media Info

  • Pagination: 14 p.
  • Monograph Title: 2013 Conference and Exhibition of the Transportation Association of Canada - Transportation: Better - Faster - Safer

Subject/Index Terms

Filing Info

  • Accession Number: 01518000
  • Record Type: Publication
  • Source Agency: Transportation Association of Canada (TAC)
  • Files: ITRD, TAC
  • Created Date: Mar 11 2014 10:57AM