The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences
Publications Copernicus
Articles | Volume XLVIII-1/W2-2023
13 Dec 2023
 | 13 Dec 2023


F. Gaspari, F. Barbieri, J. P. Duque, R. Fascia, F. Ioli, G. Zani, D. Carrion, and L. Pinto

Keywords: WebGL, Potree, PostgreSQL, Django, open-source

Abstract. The recent collapse of bridges in Italy has prompted numerous studies on monitoring and maintenance. Many structures in Italy have been in service for over 50 years, necessitating new approaches to ensure their safety. To address this issue, Italy's Consiglio Superiore dei Lavori Pubblici (Superior Council of Public Works) has developed the Guidelines for Risk Classification and Management, proposing a multi-level approach to bridge management within a complex geomorphological environment. The guidelines outline a multi-level process that includes surveying the structures, conducting detailed inspections, and assigning risk classes based on hazard, exposure, and vulnerability. Current inspection processes are time-consuming and costly. Therefore, alternative monitoring technologies are crucial. Unmanned aerial vehicles equipped with cameras, laser technologies, and GPS systems offer flexible and cost-effective solutions for visual inspection. These technologies enable the collection of both quantitative and qualitative data, such as size, material properties, and overall condition. In this context, efficient data management and exploration systems are necessary to handle the vast amount of geo-referenced information. Multi-epoch databases play a crucial role in documenting the conditions of bridges and supporting a maintenance and structural health monitoring workflow. These databases can be utilized within a Bridge Management System to aid road managers in decision-making processes. Additionally, 3D exploration platforms provide visual analysis and highlight areas of interest within the structure. This work presents a multi-epoch geo-database that adheres to the Italian guidelines, offering optimized data management and queryability for 2D and 3D information. The entire process is designed using open-source and reproducible solutions.