A comprehensive system for management roadway infrastructure

Alexander Paz, Daniel Emaasit, HANNS ANIBAL DE LA FUENTE MELLA

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

Abstract

Utility infrastructure assets in the United States continue to grow as millions of utility features were installed within the properties of state and local agencies. With this growth, the management of the utility data records is becoming a complex problem in terms of large amounts of data. On one hand, management of data for utility infrastructures is extremely valuable to state and local agencies because the timely access to utility-related information is a significant requirement for the delivery of construction and renovation projects on time and within budget. On the other hand, many challenges arise, such as difficulties in effective data storage of complex and messy datasets, data analysis, and data visualization. Utility owners face challenges in collecting utility data in standardized formats, data storage, and providing easy access to all stakeholders. Using a case study in Nevada, this paper demonstrates how tools and a strategic workflow process can be harnessed to develop an end-to-end management solution for large and complex data of a utility infrastructure. This end-to-end utility data management solution builds upon existing systems which are not adequate for large utility data management because they are non-scalable, do not allow for access by multiple users, involve manual data uploads, do not control consistency of data attributes, and lack visualization tools for non-GIS experts. In addition, they do not provide an end-to-end data management pipeline from data acquisition, through data integration, quality control, storage and finally to data access. The developed system in this case study was used for an end-to-end management test of large data during the testing phase and proved to perform seamlessly. Our approach could be adopted by other utility jurisdictions to manage their utility data. Such a data management system allows for automated and proper management of utility data thereby helping state and local agencies reduce utility conflicts and offset construction costs due to utility damages. This data could be combined with other rich data sources, such as financial data, and mined for valuable, hidden insights.

Original languageEnglish
Title of host publicationRecent Progress on
Subtitle of host publicationMechanical, Infrastructure and Industrial Engineering - Proceedings of the International Symposium on Advances in Mechanical Engineering, ISAME 2019: Quality in Research 2019
Editors Nahry, Dwinanti Rika Marthanty
PublisherAmerican Institute of Physics Inc.
ISBN (Electronic)9780735419865
DOIs
StatePublished - 6 May 2020
Externally publishedYes
Event16th International Conference on Quality in Research, QiR 2019 - 2019 International Symposium on Advances in Mechanical Engineering, ISAME 2019 - Padang, Indonesia
Duration: 22 Jul 201924 Jul 2019

Publication series

NameAIP Conference Proceedings
Volume2227
ISSN (Print)0094-243X
ISSN (Electronic)1551-7616

Conference

Conference16th International Conference on Quality in Research, QiR 2019 - 2019 International Symposium on Advances in Mechanical Engineering, ISAME 2019
CountryIndonesia
CityPadang
Period22/07/1924/07/19

Fingerprint Dive into the research topics of 'A comprehensive system for management roadway infrastructure'. Together they form a unique fingerprint.

Cite this