An Integrated Online Application for SiteManager and Pavement Analyst
-
2025-01-01
Details:
-
Creators:
-
Corporate Creators:
-
Corporate Contributors:
-
Subject/TRT Terms:
-
Publication/ Report Number:
-
Resource Type:
-
Geographical Coverage:
-
Edition:September 2022 – August 2024
-
Corporate Publisher:
-
Abstract:The objectives of this study were to integrate material, construction, maintenance, and performance information, and to deploy the unified data on a commercial system licensed by TxDOT so that Division and District personnel can access and interact with these data. Data from the SMGR, PA, and DCIS databases were identified, integrated, and processed using Tableau Prep Builder flows. Maintenance activities identified by the four-year project planning records from the PA database were also included. The integrated data-sources were then used to develop Tableau dashboards for easy visualization and tracking of performance of projects, specification Items, and mixture constituents. A text guide and a video guide were developed to demonstrate the utilization and management of the integrated data-sources and developed dashboards. Feedback from TxDOT personnel were sought to identify the needs of various Divisions and Districts and improve dashboard functionality. With an ability of easy visualization, the online application system incorporates maintenance activities, for the first time, in accounting the total dollar spent on a pavement section, determining the actual age of the pavement surface layers, and tracking the long-term performance of materials and specification Items. The flows and the dashboards developed in this study present the foundational framework for the integration and tracking of performance of materials and construction practices for other design-build projects and pilot projects introducing new specification items.
-
Format:
-
Funding:
-
Collection(s):
-
Main Document Checksum:
-
Download URL:
-
File Type: