National governments and international organizations such as the European Commission, are promoting the increased use ofinformation and communication technologies to assist scientists in the“mining”of knowledge. A typical workflow for ahydrogeologist consists of investigating and reporting hydrogeological processes in a study area, from data collection tomodel-based analysis. While hydrogeologists may feel insufficiently skilled to undertake the self-automatizing and digitizingprocess, the digitalization of the aforementioned workflow can be easily obtained by means of agile and parsimonious method-ologies based on free and open-source software, and by using existing standards. This route is demonstrated for the digitalizationof a vadose-zone monitoring system, where a large number of raw data related to water infiltration through the vadose zone arecollected. The main aspects of the proposed methodology are a structured database (DB) where field data are stored, and a Pythonscript to manage and process the available data. The structured DB was designed to store data recorded by field sensors and togenerate inputs to run a transfer-function-based model to simulate percolation to the water table. Field data and model outputswere also exploited to automatically generate summary reports, like plots and table statistics. The proposed methodology can begeneralized to other hydrogeological processes and case studies, as it is based on commonly available standards, basic knowledgeof data-storage and data-management, and elementary programming skills to connect the different components of its suite.

An agile and parsimonious approach to data management in groundwater science using open-source resources / G. De Filippis, S. Stevenazzi, C. Camera, D. Pedretti, M. Masetti. - In: HYDROGEOLOGY JOURNAL. - ISSN 1431-2174. - 28:6(2020 Sep), pp. 1993-2008. [10.1007/s10040-020-02176-0]

An agile and parsimonious approach to data management in groundwater science using open-source resources

G. De Filippis
Primo
;
S. Stevenazzi
Secondo
;
C. Camera;D. Pedretti
Penultimo
;
M. Masetti
Ultimo
2020-09

Abstract

National governments and international organizations such as the European Commission, are promoting the increased use ofinformation and communication technologies to assist scientists in the“mining”of knowledge. A typical workflow for ahydrogeologist consists of investigating and reporting hydrogeological processes in a study area, from data collection tomodel-based analysis. While hydrogeologists may feel insufficiently skilled to undertake the self-automatizing and digitizingprocess, the digitalization of the aforementioned workflow can be easily obtained by means of agile and parsimonious method-ologies based on free and open-source software, and by using existing standards. This route is demonstrated for the digitalizationof a vadose-zone monitoring system, where a large number of raw data related to water infiltration through the vadose zone arecollected. The main aspects of the proposed methodology are a structured database (DB) where field data are stored, and a Pythonscript to manage and process the available data. The structured DB was designed to store data recorded by field sensors and togenerate inputs to run a transfer-function-based model to simulate percolation to the water table. Field data and model outputswere also exploited to automatically generate summary reports, like plots and table statistics. The proposed methodology can begeneralized to other hydrogeological processes and case studies, as it is based on commonly available standards, basic knowledgeof data-storage and data-management, and elementary programming skills to connect the different components of its suite.
groundwater management; groundwater monitoring; groundwater modelling;computer science; free and opensource software;
Settore GEO/05 - Geologia Applicata
15-giu-2020
Article (author)
File in questo prodotto:
File Dimensione Formato  
DeFilippis2020_Article_AnAgileAndParsimoniousApproach.pdf

accesso riservato

Tipologia: Publisher's version/PDF
Dimensione 3.36 MB
Formato Adobe PDF
3.36 MB Adobe PDF   Visualizza/Apri   Richiedi una copia
De Filippis et al 2020 HJ accepted.pdf

embargo fino al 30/09/2021

Tipologia: Post-print, accepted manuscript ecc. (versione accettata dall'editore)
Dimensione 1.15 MB
Formato Adobe PDF
1.15 MB Adobe PDF Visualizza/Apri
DeFilippis2020_Article_AnAgileAndParsimoniousApproach.pdf

accesso riservato

Tipologia: Publisher's version/PDF
Dimensione 3.37 MB
Formato Adobe PDF
3.37 MB Adobe PDF   Visualizza/Apri   Richiedi una copia
Pubblicazioni consigliate

Caricamento pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/2434/756391
Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 3
  • ???jsp.display-item.citation.isi??? 3
social impact