Submitted:
20 November 2024
Posted:
21 November 2024
You are already at the latest version
Abstract
Keywords:
1. Introduction
1.1. Background and Motivation
1.2. Literature Review
1.3. Significance of the study
- to create a PostgreSQL [40] database integrating disparate data formats;
- to define and operationalise risk analysis indicators;
- to visualise the results of cross-sectional data queries graphically;
- to propose a scalable methodology that can integrate multiple data sources and types for multi-hazard analysis.
2. Methodology
2.1. Dynamic Data Management at the Temporal Scale
2.2. Geospatial Data Management at the Territorial Scale
2.3. Data Management at the Building Scale
3. Use Case Implementation
3.1. Case Study
3.2. Data Collection
3.3. Data Processing
3.4. Findings
4. Conclusion and Discussion
- Scientific community. This research provides a potential mechanism for those within the scientific community researching any particular single hazard to contextualise their research within the context of other natural hazards [42]. The framework will help foster improved communication between hazard and critical infrastructure specialists and encourage a more interdisciplinary approach.
- Critical Infrastructure players. Overcoming spatial and temporal scales empowers operators with a much deeper knowledge of the works. In fact, from the perspective of DTs, a punctual understanding of the works in terms of technical data, maintenance procedures, and safety protocols must be supplemented with information that returns their operation in real-time and cast about the characteristics and conditions of the territory in which they are located.
- Emergency management and disaster risk reduction practitioners and policymakers. This study simplifies a large amount of complex information to facilitate practical analysis. The developed visualisation schemes can empower stakeholders in these sectors to comprehend and anticipate the impact of hazards at various levels. Specifically, it provides valuable insights for detailed building-specific information, enhancing preparedness and response strategies.
- Government and spatial planner. As vulnerability dynamics are likely to change between each component of a hazard cascade scenario, it is essential to understand the potential implications of such scenarios on housing or infrastructure developments [42].
5. Future Works
Author Contributions
Data Availability Statement
Acknowledgments
Conflicts of Interest
References
- Khallaf, R. , Khallaf L., Anumba C.J., Madubuike O.C. (2022) Review of Digital Twins for Constructed Facilities. Buildings (12): 2029. [CrossRef]
- Hu, W. , Zhang T., Deng X., Liu Z.,Tan J. (2021) Digital twin: a state-of-the-art review of its enabling technologies, applications and challenges. Journal of Intelligent Manufacturing and Special Equipment, Vol. 2 No. 1, pp. 1-34. [CrossRef]
- Fuller, A. , Fan Z., Day C. and Barlow C. (2019), DT: enabling technology, challenges and open research, IEEE Access, Vol. 8, pp. 108952-108971.
- Khademizadeh, S. , Veisi, A., Zadeh, M. (2013). Do we live an information society? Does it matter?. International Journal of Advanced Research (2013), Volume 1, Issue 3, 362-366.
- Maas, W. (1999). Metacity / Datatown. Uitgeverij 010, Rotterdam.
- Pisano, C. , Lucchesi, F. (2020). City of Data. Contesti. Città, Territori, Progetti, (1), 4–11. [CrossRef]
- Rashid, B. (2017). Access methods for Big Data: current status and future directions. ICST Transactions on Scalable Information Systems. 4. 153520. [CrossRef]
- Laney, D. (2001). 3D Data management: controlling data volume, velocity, and variety. Meta Group Research Note, 6.
- Statista (2024). Volume of data/information created, captured, copied, and consumed worldwide from 2010 to 2020, with forecasts from 2021 to 2025. https://www.statista.com/statistics/871513/worldwide-data-created/.
- Innowise (2024). Big data trends 2024: Navigating the future of data technology. https://innowise.com/blog/big-data-trends-2024/.
- Lazarova-Molnar, S. , Mohamed N. (2020). Collaborative data analytics for smart buildings: opportunities and models. Cluster Comput, No. 22, pp. 1065-1077.
- Planu, F. , Fredduzzi G. (2023). Integrated Digital Platforms for the Management of the Existing Built Heritage: the InSPiRE Project. In Cannella M., Garozzo A., Morena S. (Eds.). Transitions. Proceedings of the 44th International Conference of Representation Disciplines Teachers.; Milano: FrancoAngeli, pp. 3007-3022. [Google Scholar] [CrossRef]
- United Nations. Sendai Framework for Disaster Risk Reduction 2015-2030. https://www.undrr.org/publication/sendai-framework-disaster-risk-reduction-2015-2030, last accessed 2024/05/07.
- United Nations Office for Disaster Risk Reduction. https://www.undrr.org/gar/gar2023-special-report, last accessed 2024/05/07.
- Ugliotti, F.M. , Osello A., Daud M., Yilmaz O.O. (2023). Enhancing Risk Analysis toward a Landscape Digital Twin Frawemework: A Multi-Hazard Approach in the Context of a Socio-Economic Perspective. Sustainability (15):12429. [CrossRef]
- Liu, X. , Xiangyu W., Wright, G., Cheng, J. C. P., Li, X., Liu, R. (2017). A State-of-the-Art Review on the Integration of Building Information Modeling (BIM) and Geographic Information System (GIS). ISPRS International Journal of Geo-Information 6, no. 2: 53. [CrossRef]
- Nguyen, T.D. , Adhikari S. (2023) The Role of BIM in Integrating Digital Twin in Building Construction: A Literature Review. Sustainability, 15, 10462. [CrossRef]
- Wang, H. , Pan, Y., Luo, X. (2019). Integration of BIM and GIS in sustainable built environment: A review and bibliometric analysis. Automation in Construction, vol. 103, pp. 41-52. ISSN 0926-5805. [CrossRef]
- Shkundalov, D. , Vilutienė, T. (2021). Bibliometric analysis of Building Information Modeling, Geographic Information Systems and Web environment integration. Automation in Construction, vol. 128: 103757. ISSN 0926-5805. [CrossRef]
- Iacono, E. , Ugliotti, F.M., Osello, A. (2023) BIM-GIS Integration for Risk Assessment of Built Heritage: Testing Recent Developments on Italian Public Buildings. DN. BIM-GIS Integration for Risk Assessment of Built Heritage: Testing Recent Developments on Italian Public Buildings, 13, pp. 72-81.
- Khajavi, S.H.; Motlagh, N.H.; Jaribion, A.; Werner, L.C.; Holmström, J. (2019). Digital Twin: Vision, Benefits, Boundaries, and Creation for Buildings. IEEE Access 2019, 7, 147406–147419. [Google Scholar] [CrossRef]
- Zhu, J. , Wright, G., Wang, J., Wang, X. (2018). A Critical Review of the Integration of Geographic Information System and Building Information Modelling at the Data Level. ISPRS International Journal of Geo-Information 7, no. 2: 66. [CrossRef]
- Kang, T.W. , Hong, C.H. (2015). A study on software architecture for effective BIM/GIS-based facility management data integration. Automation in Construction, vol. 54, pp. 25-38. ISSN 0926-5805. [CrossRef]
- Boguslawski, P. , Mahdjoubi, L., Zverovich, V., Fadli, F., Barki, H. (2015). BIM-GIS modelling in support of emergency response applications. WIT Transactions on The Built Environment, vol. 149, pp. 381-391, WIT Press. [CrossRef]
- Ravankhah, M. , Chliaoutakis, A., Revez, M.J., de Wit, R., Argyriou, A.V., Anwar, A., Heeley, J., Birkmann, J., Sarris, A., Žuvela-Aloise, M. (2020). A Multi-Hazard Platform for Cultural Heritage at Risk: The STORM Risk Assessment and Management Tool. IOP Conference Series: Materials Science and Engineering, vol. 949, n. 1, 012111, IOP Publishing. [CrossRef]
- Daud, M. , Ugliotti F.M., Osello A. (2024) Comprehensive Analysis of the Use of Web-Geographic Information System for Natural Hazard Management: A Systematic Review. Sustainability 2024 (16): 4238. [CrossRef]
- Zhou, X. , Zhao, J., Wang, J., Su, D., Zhang, H., Guo, M., Guo, M, Li, Z. (2019). OutDet: an algorithm for extracting the outer surfaces of building information models for integration with geographic information systems. International Journal of Geographical Information Science, 33(7), 1444–1470. [CrossRef]
- Zhu, J. , Wang, J., Wang, X., Tan, Y. (2019). An Economical Approach to Geo-Referencing 3D Model for Integration of BIM and GIS. Innovative Production and Construction, 19, pp. 321-334. [CrossRef]
- Planu F., Rizzi D., Fredduzzi G. (2023). Piattaforme digitali integrate per la gestione del patrimonio costruito esistente: il progetto InSPiRE/Integrated Digital Platforms for the Management of the Existing Built Heritage: the InSPiRE Project. In Cannella M., Garozzo A., Morena S. (Eds.). Transizioni. Atti del 44° Convegno Internazionale dei Docenti delle Discipline della Rappresentazione/Transitions. Proceedings of the 44th International Conference of Representation Disciplines Teachers. Milano: FrancoAngeli, pp. 3007-3022. [CrossRef]
- Basir, W. N. F. W. A., Ujang, U., Majid, Z. (2021). Building Information Modeling (BIM) And Geographic Information System (GIS) Data Compatibility For Construction Project. Journal of Information System and Technology Management, 6 (24), 278-289. [CrossRef]
- Antofie, T. , Doherty, B. Marin Ferrer, M. (2018). Mapping of risk web-platforms and risk data: collection of good practices, EUR 29086 EN, Publications Office of the European Union, Luxembourg, 2018, ISBN 978-92-79-80171-6, JRC109146. [CrossRef]
- Sani, M.J. , Abdul Rahman, A. (2018). GIS and BIM Integration at Data Level: a Review. The International Archives of the Photogrammetry, Remote Sensing and Spatial Information Sciences, XLII-4/W9, pp. 299-306. [CrossRef]
- Zhu, J. , Wang, X., Wang, P., Wu, Z., Kim, M.J. (2019). Integration of BIM and GIS: Geometry from IFC to shapefile using open-source technology. Automation in Construction, vol. 102, pp. 105-119. ISSN 0926-5805. [CrossRef]
- Narindri, B.P.K. , Nugroho, A.S.B., Aminullah, A. (2022). Developing Building Management System Framework using Web-based-GIS and BIM Integration. Civil Engineering Dimension, 24(2), 71-84. [CrossRef]
- Tang, S. , Shelden, D.R., Eastman, C.M., Pishdad-Bozorgi, P., Gao, X. (2019). A review of building information modeling (BIM) and the internet of things (IoT) devices integration: Present status and future trends. Automation in Construction, vol. 101, pp. 127-139. ISSN 0926-5805. [CrossRef]
- Pan, Y. , Zhang, L. (2021). A BIM-data mining integrated digital twin framework for advanced project management. Automation in Construction, vol. 124, 103564. ISSN 0926-5805. [CrossRef]
- Shahinmoghadam, M. , Motamedi, A. (2021). An Ontology-Based Mediation Framework for Integrating Federated Sources of BIM and IoT Data. Toledo Santos, E., Scheer, S. (eds) Proceedings of the 18th International Conference on Computing in Civil and Building Engineering. ICCCBE 2020. Lecture Notes in Civil Engineering, vol 98. Springer, Cham. [CrossRef]
- Cheng, J.C.P. , Deng, Y. (2015). An Integrated BIM-GIS Framework for Utility Information Management and Analyses. Computing in Civil Engineering, pp. 667-674. [CrossRef]
- Abdalwhab, A.A.B. , Haron, N.A., Ales, A.H., and Teik Hua Law. 2021. Investigating Approaches of Integrating BIM, IoT, and Facility Management for Renovating Existing Buildings: A Review. Sustainability 13, no. 7: 3930. [CrossRef]
- PostgreSQL: The World's Most Advanced Open Source Relational Database. https://www.postgresql.org/, last accessed 2024/05/14.
- Kirschbaum, D. , Stanley T. (2018) Satellite-Based Assessment of Rainfall-Triggered Landslide Hazard for Situational Awareness. Earth’s Future (6): 505-523. [CrossRef]
- Gill, J. C., B. D. Malamud (2014). Reviewing and visualizing the interactions of natural hazards, Rev. Geophys., 52, 680–722. https://doi.org/10.1002/2013RG000445. [CrossRef]
- GitHub - opengeos/python-geospatial: A collection of Python packages for geospatial analysis with binder-ready notebook examples. https://github.com/opengeos/python-geospatial, last accessed 2024/05/15.
- Osello, A. , Fonsati A, Rapetti N., Semeraro F. (eds.) (2019) InfraBIM. Il BIM per le infrastrutture. Gangemi Editore, Roma.
- Industry Foundation Classes (IFC) – buildingSMART Italia. https://www.buildingsmartitalia.org/standard/standard-bs/industry-foundation-classes-ifc/, last accessed 2024/05/12.
- Introduction to Visual Programming in Architecture. https://www.novatr.com/blog/visual-programming-in-architecture, last accessed 2024/05/13.
- The Dynamo Primer. https://primer.dynamobim.org/, last accessed 2024/05/15.
- FME by Safe Software. https://fme.safe.com/, last accessed 2024/05/15.
- Geodan/pg2b3dm: Tool for creating 3D Tiles from PostGIS geometries. https://github.com/Geodan/pg2b3dm, last accessed 2024/05/13.
- Regione Piemonte, Classificazione sismica. https://www.regione.piemonte.it/web/temi/protezione-civile-difesa-suolo-opere-pubbliche/prevenzione-rischio-sismico/classificazione-sismica, last accessed 2024/07/31.
- GeoStru. Geoapp. Mappa di zonazione sismica Regione Piemonte 2020. https://geoapp.geostru.eu/app/classificazione-sismica-regione-piemonte-2020/, last accessed 2024/07/31.
- ISPRA - Istituto Superiore per la Protezione e la Ricerca Ambientale. Rapporto sulle condizioni di pericolosità da alluvione in Italia e indicatori di rischio associati, 353/2021. https://www.isprambiente.gov.it/it/pubblicazioni/rapporti/rapporto-sulle-condizioni-di-pericolosita-da-alluvione-in-italia-e-indicatori-di-rischio-associati, last accessed 2024/07/15.
- Geoportale Arpa Piemonte. Conoidi alluvionali in Piemonte. https://geoportale.arpa.piemonte.it/app/public/?pg=mappa&ids=5554d33c511140e0acc77ff46fcac86c, last accessed 2024/07/15.
- Autodesk. Level of Development (LOD) in BIM. https://www.autodesk.com/solutions/bim-levels-of-development, last accessed 2024/08/01.
- European Union. TINITALY, a digital elevation model of Italy with a 10 meters cell size (Version 1.1). https://data.europa.eu/data/datasets/ingv-https-data-ingv-it-metadata-iso19115-807-xml?locale=en, last accessed 2024/08/05.
- USGS. EarthExplorer. https://earthexplorer.usgs.gov/, last accessed 2024/08/05.
- Open-Meteo. Weather Forecast API. https://open-meteo.com/en/docs, last accessed 2024/05/02.
- Open-Meteo. Climate API. https://open-meteo.com/en/docs/climate-api, last accessed 2024/05/02.
- Copernicus Land Monitoring Service. https://land.copernicus.eu/en/map-viewer?product=130299ac96e54c30a12edd575eff80f7, last accessed 2024/08/05.
- ISPRA. IdroGEO - Open Data. https://idrogeo.isprambiente.it/app/page/open-data, last accessed 2024/08/05.
- US Army Corps of Engineers, Hidrologic Engineering Center. HEC-HMS (Hidrologic Modeling System). https://www.hec.usace.army.mil/software/hec-hms/, last accessed 2024/08/06.
- Open-Meteo. Free Open-Source Weather API. https://open-meteo.com/, last accessed 2024/05/02.












| Type | Purpose | Format | Data Provider | Accessibility |
|---|---|---|---|---|
| DEM | Digital Elevation Model for mapping and analysis | Raster (GeoTIFF) | Online (API) - National Mapping Agency [55] | Open |
| DTM | Digital Terrain Model for hydrological and topographical analysis | Raster (GeoTIFF) | Online (API) - National Mapping Agency [56] | Open |
| Soil Curve Number | Soil curve number raster for runoff calculation in hydrological models | Raster (GeoTIFF) | Online (API) - Environmental Agency | Open |
| Precipitation Data | Real-time precipitation measurements for flood forecasting | Time-series (CSV) | Online (OpenMeteo API) - Weather Stations [57] | Open |
| Meteorological Data | Weather parameters (temperature, humidity, wind) for detailed flood impact analysis | Time-series (CSV) | Online (OpenMeteo API) - Weather Stations [58] | Open |
| Soil Moisture Data | To assess soil saturation levels which impact runoff and flooding potential | Time-series (CSV) | Online (API) - National Weather Service [58] | Open |
| Building Information | Detailed architectural and structural data for flood risk assessment of buildings | IFC | Offline - Local/Architectural Firms | Closed |
| Land Use/Land Cover | Classification of land cover types for flood impact analysis | Vector (SHP) | Online (GIS) - Environmental Agency [59] | Open |
| Historical Flood Footprints | Records and extent of past flood events for risk assessment and planning | Vector (SHP) | Historical (GIS) - National Disaster Agency [60] | Open |
| Hydrological Models | Simulation models for predicting flood behaviour and water flow dynamics | Model (HEC-HMS) | Offline - Hydrological Institutes [61] | Closed |
Disclaimer/Publisher’s Note: The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of MDPI and/or the editor(s). MDPI and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content. |
© 2024 by the authors. Licensee MDPI, Basel, Switzerland. This article is an open access article distributed under the terms and conditions of the Creative Commons Attribution (CC BY) license (http://creativecommons.org/licenses/by/4.0/).