Abstract
Geological models, and related geo-databases, derived from the integration of multiple datasets, are important tools for land planning and management of underground resources. This contribution describes a geo-database structure designed to manage a large amount of geo-environmental data used for setting up a subsurface 3D model of the Torino area, at the western termination of the Po Plain. An innovative dataset structure, founded on an explicit conceptual model, was designed to provide a reliable representation of the distribution of well and boreholes data along x, y and z axes, as well as their integration with surface geology. This framework allowed the elaboration of 3D a geological-hydrostratigraphic model, portraying the distribution and geometry of the subsurface sedimentary successions, and those of the aquifer systems and permeability barriers.
Some issues related to the representation of well data and boreholes in the z axis (QGIS), as well as their conversion and transfer to 3D software (GMS - Growndwater Modeling System) were also discussed.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Balestro, G., et al.: Carta Geologica d’Italia alla scala 1:50:000, Foglio 155 Torino Ovest. ISPRA, Istituto Superiore per la Protezione e la Ricerca Ambientale, Roma (2009)
Banca Dati Geotecnica Arpa Homepage. http://webGIS.arpa.piemonte.it/geoportale/index.php/notizie-mob/16-geologia-e-dissesto/375-banca-dati-geotecnica. Accessed 05 Jan 2021
D'Ambrogi, C., et al.: 3D geological model of the Po Plain subsurface: an example of open geological base data for basin analysis. In: EGU General Assembly 2020, Online, 4–8 May 2020, EGU2020-9889. https://doi.org/10.5194/egusphere-egu2020-9889 (2020)
De Luca D., Ossella, L.: Assetto idrogeologico della Città di Torino e del suo hinterland. Geologia dell'Ambiente, 1 (suppl.), pp. 10–15 (2014)
Festa, A., et al.: Carta Geologica d'Italia alla scala 1: 50.000. Foglio 156 “Torino Est”. ISPRA - Istituto Superiore per la Protezione e la Ricerca Ambientale, Roma (2009)
Ghielmi, M., Rogledi, S., Vigna, B., Violanti, D.: La successione messiniana e plio-pleistocenica del Bacino di Savigliano (settore occidentale del Bacino Terziario Piemontese) - Italia. Geol. Insubr. 13(1), 141 (2019)
GMS Homepage. https://www.aquaveo.com/software/gms-groundwater-modeling-system-introduction. Accessed 05 Jan 2021
Irace A., et al.: Geologia e idrostratigrafia profonda della Pianura Padana Occidentale. La Nuova Lito, Firenze (2009)
Lucchesi, S.: Sintesi preliminare dei dati di sottosuolo della pianura piemontese centrale. GEAM 103, 115–121 (2001)
Masetti, G.: Modello logico e fisico dei dati – Dizionario degli attributi delle classi. Banca Dati dei Corpi Idrici Sotterranei della Regione Toscana – Adeguamento alla DGRT 939/2009, Technical Report, intervento, vol. 6, 21p. (2016)
Mosca, P., Polino, R., Rogledi, S., Rossi, M.: New data for the kinematic interpretation of the alps-Apennines junction (Nordwestern Italy). Int. J. Earth Sci. (Geol Rundsch), 99, 833–849 (2010). https://doi.org/10.1007/s00531-009-0428-2
Morelli, M., Mallen, L., Nicolò, G., Cozzula, S., Irace, A., Piana, F.: 3D geological modeling and visualization of the subsurface data of the Piemonte plains derived from the geodatabase of digital Geological map of Piemonte. Rendiconti Online Società Geologica Italiana 42, 90–93 (2017)
Piana F., et al.: Geology of Piemonte region (NW Italy, Alps-Apennines interference zone). J. Maps 13(2), 395–405 (2017)
QGIS Homepage. https://www.qgis.org/it/site/. Accessed 25 May 2021
Regione Piemonte, DTM capture ICE 2009–2011 tile size 5 m, metadata at the link. http://www.geoportale.piemonte.it/geonetworkrp/srv/ita/metadata.show?id=2552. Accessed 25 May 2021
Rete di Monitoraggio Acque Sotterranee Homepage. http://webgis.arpa.piemonte.it/monitoraggio_qualita_acque_mapseries/monitoraggio_qualita_acque_webapp/. Accessed 25 May 2021
Acknowledgments
This research was developed during a two-year scholarship, made possible by the CNR-Istituto di Geoscienze e Georisorse (CNR-IGG), in the framework of the Executive Project “Gronda di Genova” (ASPI - Autostrade per l’Italia, Roma), commissioned by Spea Engineering spa (Milano), and the Project “MINIDROSA” commissioned by Società Metropolitana Acque Torino SMAT SpA (Torino). Special thanks to Dr. Luigi Leardi (SMAT SpA, Torino) for his fruitful discussions on wells completion and hydrostratigraphic model.
Author information
Authors and Affiliations
Corresponding authors
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2022 Springer Nature Switzerland AG
About this paper
Cite this paper
Marcelli, I. et al. (2022). The Subsurface Database of the Torino Area (Western Po Plain): From the Design of the Conceptual Scheme to 3D Modeling. In: Borgogno-Mondino, E., Zamperlin, P. (eds) Geomatics and Geospatial Technologies. ASITA 2021. Communications in Computer and Information Science, vol 1507. Springer, Cham. https://doi.org/10.1007/978-3-030-94426-1_9
Download citation
DOI: https://doi.org/10.1007/978-3-030-94426-1_9
Published:
Publisher Name: Springer, Cham
Print ISBN: 978-3-030-94425-4
Online ISBN: 978-3-030-94426-1
eBook Packages: Computer ScienceComputer Science (R0)