Geotechnical Data Management for Infrastructure Resilience: A Relational Database Approach Based on the AGS Standard

Geotechnical information in digital formats remains difficult to access, as data are often dispersed across multiple sources, heterogeneous reports, and fragmented historical records. This fragmentation increases investigation costs, limits data reuse, and reduces the quality and reliability of engineering decisions. To address this challenge, this study aims to develop an open source digital system for storing and managing geotechnical information, structured around the international AGS standard to facilitate its use in both technical and academic applications. The methodology involved a review of existing geotechnical data management approaches followed by the construction of a relational model using an entity–relationship diagram, its transformation into a logical structure, and subsequent implementation in a database management system. After deployment, real geotechnical data were inserted to validate the system and generate simplified examples of practical use. The findings indicate that the AGS standard cannot be directly adopted as a database structure, requiring targeted adaptations to ensure efficient storage, validation, and querying. The developed system proved effective in standardizing, organizing, and retrieving geotechnical data, while also demonstrating versatility through seamless integration with Python-3.10 based analytical routines and GIS platforms. The main contribution of this research lies in presenting an open, modular, and AGS-aligned geotechnical data framework specifically adapted to the Brazilian context. While previous studies address important components of geotechnical data management, the approach presented here brings these elements together in a cohesive structure that supports reproducibility and future expansion. By detailing the rationale behind the digital adaptation of geotechnical information, the study provides a methodological path that supports replication and future system expansion.