Spatial Data Management and Numerical Modelling: Demonstrating the Application of the QGIS-Integrated FREEWAT Platform at 13 Case Studies for Tackling Groundwater Resource Management

Because of the spatial nature of groundwater-related data and their time component, effective groundwater management requires the application of methods pertaining to the Information and Communication Technologies sector, such as spatial data management and distributed numerical modelling. The objective of this paper is to demonstrate the effectiveness of the QGIS-integrated FREEWAT platform and an approach combining spatial data management and numerical models to target groundwater management issues. FREEWAT is a free and open source platform integrated in a Geographic Information System environment and embedding tools for pre- and post-processing of spatial data and integrating numerical codes for the simulation of the hydrological cycle, with a main focus on groundwater. To this aim, this paper briefly presents the FREEWAT platform, introduces the FREEWAT approach, and showcases 13 case studies in European and non-European countries where the FREEWAT platform was applied. Application of the FREEWAT platform to real-world case studies is presented for targeting management of coastal aquifers, ground- and surface-water interaction, climate change impacts, management of transboundary aquifers, rural water management and protection of groundwater-dependent ecosystems. In this sense, compared to other existing software suites, FREEWAT allows data analysis and visualization to accomplish each step of the modelling workflow, i.e., from data analytics, to conceptual model definition, to numerical modelling and reporting of results. The presented experiences demonstrate that improved access to data and the portability of models and models’ results can help to promote water sustainability from the local- to the basin-scale. Furthermore, FREEWAT may represent a valuable tool to target the objective of increasing the capabilities of public authorities and private companies to manage groundwater resources by means of up-to-date, robust, well-documented and reliable software, without entailing the need of costly licensing, nowadays seldom affordable by public water authorities. Based on the strengths highlighted, the FREEWAT platform is a powerful tool for groundwater resources management, and for data collection, sharing, implementation and comparison of scenarios, for supporting planning and decision-making.

[1]  D. Trevisan,et al.  A simple model to assess nitrogen and phosphorus contamination in ungauged surface drainage networks: application to the Massaciuccoli Lake Catchment, Italy. , 2012, Journal of environmental quality.

[2]  W. Schmid,et al.  Software tools for management of conjunctive use of surface- and ground-water in the rural environment: integration of the Farm Process and the Crop Growth Module in the FREEWAT platform , 2019, Agricultural Water Management.

[3]  Ajay K. Singh.  Optimization modelling for seawater intrusion management , 2014 .

[4]  Raghavan Srinivasan,et al.  Introducing a new open source GIS user interface for the SWAT model , 2016, Environ. Model. Softw..

[5]  A. Jõeleht,et al.  Simulation of the hydrogeologic effects of oil-shale mining on the neighbouring wetland water balance: case study in north-eastern Estonia , 2013, Hydrogeology Journal.

[6]  M Bakker,et al.  Scripting MODFLOW Model Development Using Python and FloPy , 2016, Ground water.

[7]  M. Tonkin,et al.  MT3D-USGS version 1: A U.S. Geological Survey release of MT3DMS updated with new and expanded transport capabilities for use with MODFLOW , 2016 .

[8]  David W. Pollock,et al.  User guide for MODPATH Version 7—A particle-tracking model for MODFLOW , 2016 .

[9]  Mar Alcaraz,et al.  A loosely coupled GIS and hydrogeological modeling framework , 2017, Environmental Earth Sciences.

[10]  R. C. Izaurralde,et al.  Historical Development and Applications of the EPIC and APEX Models , 2004 .

[11]  Peter Schätzl,et al.  Tight-coupling of groundwater flow and transport modelling engines with spatial databases and GIS technology: a new approach integrating Feflow and ArcGIS , 2012 .

[12]  C. Zheng,et al.  A Modular Three-Dimensional Multispecies Transport Model for Simulation of Advection, Dispersion, and Chemical Reactions of Contaminants in Groundwater Systems , 1997 .

[13]  J. Jiao,et al.  Impact of Coastal Land Reclamation on Ground Water Level and the Sea Water Interface , 2007, Ground water.

[14]  Gil Strassberg,et al.  Arc Hydro Groundwater Data Model And Tools : Overview and Use Cases , 2011 .

[15]  Stefan Banzhaf,et al.  Groundwater and Surface Water Interaction at the Regional-scale – A Review with Focus on Regional Integrated Models , 2015, Water Resources Management.

[16]  L. Foglia,et al.  Hydrodynamic analysis of a Mediterranean aquifer system with the use of hydrochemical and isotopical analysis as supporting tools , 2018, Environmental Earth Sciences.

[17]  Rudy Rossetto,et al.  AkvaGIS: An open source tool for water quantity and quality management , 2019, Comput. Geosci..

[18]  Sven Kralisch,et al.  ILMS – a Software Platform for Integrated Environmental Management , 2012 .

[19]  Claire R. Tiedeman,et al.  UCODE_2014, with new capabilities to define parameters unique to predictions, calculate w eights using simulated values, estimate parameters w ith SVD, evaluate uncertainty with MCMC, and more , 2014 .

[20]  A. Kallioras,et al.  Groundwater flow simulation through the application of the FREEWAT modeling platform , 2019, Journal of Hydroinformatics.

[21]  M. Dettinger,et al.  A method for physically based model analysis of conjunctive use in response to potential climate changes , 2012 .

[23]  J. J. Carrera-Hernández,et al.  The groundwater modeling tool for GRASS (GMTG): Open source groundwater flow modeling , 2006, Comput. Geosci..

[24]  J. L. Amprako.  The United Nations World Water Development Report 2015: Water for a Sustainable World , 2016 .

[25]  Pio Positano,et al.  The H2O20 FREEWAT participated approach for the Follonica-Scarlino aquifer case study. A common space to generate shared knowledge on the value of water , 2017 .

[26]  T. Harter,et al.  Navigating Groundwater-Surface Water Interactions under the Sustainable Groundwater Management Act , 2018 .

[27]  William W.-G. Yeh,et al.  Review: Optimization methods for groundwater modeling and management , 2015, Hydrogeology Journal.

[28]  H. Kooi,et al.  Beneath the surface of global change: Impacts of climate change on groundwater , 2011 .

[29]  Andrew Kingdon,et al.  A seamlessly coupled GIS and distributed groundwater flow model , 2016, Environ. Model. Softw..

[30]  B. Panteleit,et al.  Das Bremerhavener Grundwasser im Klimawandel , 2018, Grundwasser.

[31]  M. Hill,et al.  Modeling unsaturated zone flow and runoff processes by integrating MODFLOW-LGR and VSF, and creating the new CFL package , 2013 .

[32]  R. Rossetto,et al.  Numerical groundwater flow modelling for remediation design and seawater intrusion assessment at a coastal industrial site , 2011 .

[33]  K. Korkka-niemi,et al.  Chemical and isotopic tracers indicating groundwater/surface-water interaction within a boreal lake catchment in Finland , 2015 .

[34]  M. Grodzynskyi,et al.  Modelling the impact of rural land use scenarios on water management: a FREEWAT approach to the Bakumivka catchment case study, Ukraine , 2017 .

[35]  C. Gaye,et al.  Transboundary aquifers of Africa: Review of the current state of knowledge and progress towards sustainable development and management , 2018, Journal of Hydrology: Regional Studies.

[36]  Alyssa M. Dausman,et al.  SEAWAT Version 4: A Computer Program for Simulation of Multi-Species Solute and Heat Transport , 2008 .

[37]  Christopher J. Duffy,et al.  A tightly coupled GIS and distributed hydrologic modeling framework , 2014, Environ. Model. Softw..

[38]  Pieter J. Stuyfzand,et al.  The impact of land reclamation on groundwater quality and future drinking water supply in The Netherlands , 1995 .

[39]  Arlen W. Harbaugh,et al.  A Computer Program for Calculating Subregional Water Budgets Using Results from the U.S. Geological Survey Modular Three-dimensional Finite-difference Ground-water Flow Model , 1990 .

[40]  N. Goldscheider,et al.  Review: From multi-scale conceptualization to a classification system for inland groundwater-dependent ecosystems , 2012, Hydrogeology Journal.

[41]  Massimiliano Cannata,et al.  Open source GIS platform for water resource modelling: FREEWAT approach in the Lugano Lake , 2018, Spatial Information Research.

[42]  Yi Zheng,et al.  Modeling surface water-groundwater interaction in arid and semi-arid regions with intensive agriculture , 2015, Environ. Model. Softw..

[43]  Rudy Rossetto,et al.  Integrating free and open source tools and distributed modelling codes in GIS environment for data-based groundwater management , 2018, Environ. Model. Softw..

[44]  Peter Dillon,et al.  Advances in multi-stage planning and implementing managed aquifer recharge for integrated water management , 2018, Sustainable Water Resources Management.

[45]  S. Shrestha,et al.  Assessment of transboundary aquifer resources in Asia: Status and progress towards sustainable groundwater management , 2018, Journal of Hydrology: Regional Studies.

[46]  M. Bakker.  Analytic solutions for interface flow in combined confined and semi-confined, coastal aquifers , 2006 .

[47]  I. Emelyanova,et al.  Continental mapping of groundwater dependent ecosystems: A methodological framework to integrate diverse data and expert opinion , 2017 .

[48]  Hamed Ketabchi,et al.  Conceptualization of a fresh groundwater lens influenced by climate change: A modeling study of an arid-region island in the Persian Gulf, Iran , 2014 .

[49]  John R. Williams,et al.  The EPIC crop growth model , 1989 .

[50]  S. A. Leake,et al.  One-Water Hydrologic Flow Model (MODFLOW-OWHM) , 2014 .

[51]  B. Scanlon,et al.  Sixty years of global progress in managed aquifer recharge , 2018, Hydrogeology Journal.

[52]  I. Borsi,et al.  Management of coastal hydrosystems through the application of free and open source software tool , 2017 .

[53]  Hao Wang,et al.  Development of efficient and cost-effective distributed hydrological modeling tool MWEasyDHM based on open-source MapWindow GIS , 2011, Comput. Geosci..

[54]  E. Abarca,et al.  Preface: Saltwater and freshwater interactions in coastal aquifers , 2010 .

[55]  N. Silvestri,et al.  Diachronic analysis of farmers' strategies within a protected area of central Italy , 2012 .

[56]  A. W. Harbaugh.  MODFLOW-2005 : the U.S. Geological Survey modular ground-water model--the ground-water flow process , 2005 .

[57]  Ajay K. Singh,et al.  Managing the environmental problem of seawater intrusion in coastal aquifers through simulation–optimization modeling , 2015 .

[58]  B. Scanlon,et al.  Ground water and climate change , 2013 .

[59]  Mark Swilling,et al.  Developing a framework for supporting the implementation of integrated water resource management (IWRM) with a decoupling strategy , 2016 .

[60]  M. Primicerio,et al.  SID&GRID: integrating hydrological modeling in GIS environment , 2013 .

[61]  R. Hunt,et al.  Groundwater Regulation and Integrated Water Planning , 2016 .

[62]  C. Zheng,et al.  Optimizing conjunctive use of surface water and groundwater for irrigation to address human-nature water conflicts: A surrogate modeling approach , 2016 .