Integrated SiteManager and Pavement Analyst Database on an Online Platform

The Texas Department of Transportation (TxDOT) maintains several databases to record materials, construction, and performance information for roadway projects: materials and test records in the SiteManager database; construction related information in TxDOT Connect or Design and Constructions Information System; and performance measures in the Pavement Analyst database. Data from these databases has been compiled in a recent project to identify relationships between the materials and construction records and observed long-term performance of hot mix asphalt pavements. The objective of this project is to implement this work through a visualization and analysis tool via a commercially available software and that can be accessed in near real time by TxDOT on an ongoing basis. The research team will utilize Tableau Prep Builder to integrate data from all data sources and develop the visualization and identification interface on Tableau Packaged Workbook. In addition to the aforementioned databases, maintenance history from Compass and geographic information system (GIS) information from the TxDOT Open Portal to locate and map all projects will be incorporated. A text and visual guide on how to use the Tableau interface will be developed, and an online workshop will be held to demonstrate the functionality of the interface to TxDOT’s Divisions and Districts. Such a tool will allow TxDOT to investigate all construction and maintenance projects performed on a pavement section and understand the effect of materials, design and construction processes on the long-term pavement performance.

• Record URL:
  https://library.ctr.utexas.edu/Presto/project=0-7028-01
• Supplemental Notes:
  • Continuation of TxDOT Project 0-7028: https://library.ctr.utexas.edu/Presto/project=7028

Language

• English

Project

• Status: Active
• Funding: $139965
• Contract Numbers:

  0-7028-01

• Sponsor Organizations:

  Texas Department of Transportation

  125 E. 11th Street
  Austin, TX  United States  78701-2483
• Managing Organizations:

  Texas Department of Transportation

  125 E. 11th Street
  Austin, TX  United States  78701-2483
• Project Managers:

  Schwerdt, Tom

• Performing Organizations:

  Center for Transportation Research

  3925 W. Braker Lane
  Austin, TX  United States  78759
• Principal Investigators:

  Bhasin, Amit

• Start Date: 20220901
• Expected Completion Date: 20240831
• Actual Completion Date: 0

Subject/Index Terms

• TRT Terms: Data fusion; Databases; Hot mix asphalt; Pavement performance; Visualization
• Subject Areas: Construction; Data and Information Technology; Highways; Maintenance and Preservation; Pavements;

Filing Info

• Accession Number: 01863313
• Record Type: Research project
• Source Agency: Texas Department of Transportation
• Contract Numbers: 0-7028-01
• Files: RIP, STATEDOT
• Created Date: Nov 3 2022 11:35AM