Transportation agencies use many computer tools for managing infrastructure. Engineers in operating divisions at the lower end of the organizational hierarchy choose a variety of tools to meet their specific needs. Managers at the top of the organizational hierarchy want a uniform "enterprise" database system that provides them direct access to agency-wide data. Frequently, these two different approaches at different levels cause inefficiencies in the agency. This study was conducted to determine if efficiencies could be gained through the process of standardizing data storage mechanisms to permit diversity at the operating level while maintaining data compatibility for aggregation at higher levels in the organization. A needs assessment regarding pavement inventory and maintenance scheduling conducted at the regional level provided the information for developing a computer-based tool for operations. The needs at headquarters for aggregating data were accommodated by exposing regional data in standard database (.dbf) formats. A variety of visual development tools were considered for the project. Borland Delphi was selected because it provides satisfactory connectivity for enterprise as well as local database backends, it provides a powerful development language (object Pascal) for engineering algorithms, and it provides an exceptionally good Integrated Developers Environment. The Pavement Preservation Prototype software consists of three coordinated sections: Pavement Treatments, Paint Treatments, and Maintenance Management Quality Assurance. Each section was provided with a custom Graphical User Interface in conjunction with a standard database backend. Because the data were converted and exposed in a standard format, straight forward GIS analyses could be applied. Examples provided for each of the three prototype sections demonstrate the advantages of standardizing regional data.


  • English

Media Info

  • Features: Appendices; Figures;
  • Pagination: 84 p.

Subject/Index Terms

Filing Info

  • Accession Number: 00782288
  • Record Type: Publication
  • Report/Paper Numbers: 99-107
  • Files: UTC, NTL, TRIS
  • Created Date: Jan 21 2000 12:00AM