PSI - Issue 84

Adriana Marra et al. / Procedia Structural Integrity 84 (2026) 661–668

663

utilizing information; oriented towards supporting decisions for managing and maintaining existing infrastructure assets. 2. Materials and methods This contribution illustrates a methodological workflow based on an interdisciplinary approach that integrates digital solutions to support the dynamic and traceable management of information related to existing infrastructure management processes (see Fig. 1). This workflow involves creating an online database for the structured digitization of forms required by the Guidelines using the NocoDB platform; three-dimensional information modeling in a BIM environment, using Autodesk Revit (2023) software; and designing semi-automated information flows with visual scripts developed in Dynamo. The correlation between the online database and the BIM environment is managed through structured CSV files that serve as a data exchange tool. The workflow is based on three main steps: (1) collection, organization, and standardization of infrastructure data within a relational database; (2) validation and optimization of BrIM models; (3) implementation of visual scripts to automatically update information within the model and evaluate the CdA in a parametric environment.

Fig. 1. Operational workflow.

The first stage of the workflow involves collecting and organizing technical and management data related to the infrastructure, including the typological, constructive, and dimensional characteristics of the asset, as well as administrative and inspection aspects. The database has been organized according to the Guidelines’ forms for the different levels of knowledge and assessment. It collects information on geographical location, functional classification, main structural data (type, materials, static layout), and inspection activity history, detailing defects along with relative weights, as well as their extension and intensity coefficients. Unique identification codes have also been defined to ensure interoperability with digital models and other information tools. The database was developed on the open-source NocoDB platform, which is flexible in managing SQL-based relational databases and has a user friendly interface that enables the creation of tables and views for managing and analyzing the collected information. The second stage aims at validating and optimizing BrIM models according to the interoperability criteria defined in the Guidelines for the Application of IFC to Bridges and Viaducts by buildingSMART. The data in the information database has been normalized and translated into a system of information parameters associated with the model's elements. To ensure greater consistency of information across the entire model, these parameters have been structured uniformly with respect to the different categories included in the modeling software, specifically Autodesk Revit. The third stage focuses on automating the updating and management of model information flows using VPL. Specific visual scripts have been developed in the Dynamo environment, integrated into Revit, and designed to semi automatically import data from inspection activities into the informative model. They also support the parametric evaluation of the structural and foundation AC. The visual scripts analyze data from CSV files exported from the relational database using a combination of native nodes and customized code. These scripts update the BrIM model