A Practical Data Extraction, Cleaning, and Integration Method for Structural Condition Assessment of Highway Bridges

The success of regional bridge condition assessment, a crucial component of systematic maintenance strategies, relies heavily on comprehensive, well-structured regional bridge databases. This study proposes the data extraction, cleaning, and integration method for the construction of such databases. First, this research proposes an extraction method tailored for unstructured data often present in inspection reports. Additionally, this paper meticulously outlines a cleaning procedure designed to rectify two distinct categories of typical errors that are present within the inspection data. Subsequently, this study takes a holistic approach by establishing integration rules that harmonize data from various sources, including inspection records, monitoring data, traffic statistics, as well as design and construction blueprints. The architectural framework of the regional bridge information database is then meticulously laid out. To validate and demonstrate the effectiveness of the method, this study applies them to a set of representative highway bridges situated within Shandong Province. The results show that this approach can be used to successfully establish a functional regional bridge database. The database plays a pivotal role in harnessing the latent potential of an extensive range of multi-source information and propels the field of bridge condition assessment forward by providing a solid basis for informed decision making and strategic planning in the realm of infrastructure maintenance.