A Groundwater Wells Database for Brazil (GWDBrazil)

TITLE:A groundwater well database for Brazil(GWDBrazil)

ABSTRACT:Sufficient spatiotemporal in-situ groundwater-level measurements are essential for sustainable water management. Despite their importance, lack of harmonized, quality-controlled datasets has hindered large-scale groundwater studies in Brazil. In collaboration with the Geological Survey of Brazil, we present the Groundwater Wells Database for Brazil (GWDBrazil), which consolidates and standardizes information from over 351,000 wells, with records dating from 1900 to 2024, including about 450 wells with continuous daily monitoring from 2010 to 2024. Cross-verification steps were applied to ensure data accuracy. GWDBrazil is available in both tabular form and vector points, comprising information such as location, well depth, and well purpose. The dataset also provides data to support integrated surface and groundwater management, such the distance from each well to the nearest river and aquifer information. This dataset is intended to serve as a valuable resource for researchers, decision-makers, and stakeholders, providing essential information to support comprehensive water management strategies in Brazil.
FOLDER STRUCTURE:

The dataset is organized into three main folders:

1. data - This folder contains the processed products derived from the study A Groundwater Well Database for Brazil (GWDBrazil).

1.1 csv - Tabular Data

1.1.1 SIAGAS_data.csv - Final SIAGAS dataset

1.1.2 SIAGAS_data_flagged.csv - Final SIAGAS dataset with flagged data

1.1.3 Additional_data.csv - Supplementary data for surface water and groundwater interaction studies

1.1.4 RIMAS_data_flagged - Final RIMAS dataset with error and outlier flags

1.1.4.1 Rimas_IdWell.csv - Final RIMAS dataset where each CSV represents a single well

1.2 netCDF - Includes data from continuous groundwater level monitoring wells (2010 - 2024) in netCDF format.

1.2.1 Rimas_IdWell.nc - netCDF equivalent of RIMAS_data_flagged folder

1.3 shapefile - Shapefile Data

1.3.1 SIAGAS_data.shp - Shapefile equivalent of SIAGAS_data.csv

1.3.2 SIAGAS_data_flagged.shp - Shapefile equivalent of SIAGAS_data_flagged.csv

1.3.3 Additional_data.shp - Shapefile equivalent of Additional_data.csv

2. raw_data - This folder contains the original datasets extracted from Geological Survey of Brazil projects.

2.1 RIMAS - Data from the Integrated Groundwater Monitoring Network Project (RIMAS – in Portuguese: Rede Integrada de Monitoramento das Águas Subterrâneas; SGB, 2024a)

2.1.1 groundwater_level_monitoring - Groundwater data timeseries  

2.1.1.1 RimasWeb_Exportacao_Dados_Nivel_Dagua_IdWell.csv - Each CSV represents a unique well

2.1.2 hydrochemical_monitoring - Hydrogeochemical data

2.1.2.1 RimasWeb_Exportacao_Dados_Analise_Quimica_IdWell.csv - Each CSV represents a unique well

2.2 SIAGAS - Data from the Groundwater Information System (SIAGAS – in Portuguese: Sistema de Informações de Águas Subterrâneas; SGB, 2024b)

2.2.1 PT_amostra-fisico-quimica_EN_water_quality_data_physicochemical_analysis.csv - Water quality data

2.2.2 PT_aquifero_EN_aquifer_data.csv - Aquifer-related data

2.2.3 PT_dados_construtivos_EN_drilling_data.csv - Well construction data

2.2.4 PT_dados_gerais_EN_general_data.csv - General well information

2.2.5 PT_dados_hidraulicos_EN_pumping_data.csv - Pumping test data

2.2.6 PT_litologia_EN_lithological_data.csv - Lithological well data

3. supplementary_tables

3.1 Table_S1-Definitions_of_attributes_in_SIAGAS_dataset - Definition of attributes from the SIAGAS project by the Geological Survey of Brazil

3.2 Table_S2-Translation_of_terms_used_by_SGB(in Portuguese)_into_internationally_used_terms.xlsx - Translation of SIAGAS terms from Portuguese to internationally recognized terms

3.3 Table_S3-Overlaid_Aquifers_and_Aquifer_Confinement.xlsx - Summary of aquifer layers per record and their confinement status based on raw data from the SIAGAS project

3.4 Table_S4-No_well_records_step_quality_control.xlsx - Summary of the 9,655 records classified as non-wells that were removed during the quality control step

3.5 Table_S5-Duplicate_records_step_quality_control.xlsx - Summary of the 4,711 records classified as duplicates that were removed during the quality control step

3.6 Table_S6-Records_whitout_any_data_step_quality_control.xlsx - Summary of the 5,814 records removed during the quality control step due to the absence of any data indicating when they were drilled

3.7 Table_S8-RIMAS_wells_step_quality_control.xlsx - Overview of the data from 453 RIMAS wells 

USAGE NOTE: The GWDBrazil dataset has wide-ranging applications. Users are strongly encouraged to read the accompanying paper A Groundwater Well Database for Brazil (GWDBrazil) before using the data. This will help understand the criteria used for data refinement and its limitations.Users should critically evaluate the level of detail and accuracy required for their specific applications. While extensive quality control has been applied in collaboration with the Geological Survey of Brazil, additional regional and local validation may be necessary for specific studies.

CONTACT: For any questions or recommendations, please contact:Lead Author: J.G.S.M.U ([e-mail])Corresponding Author: P.T.S.O ([e-mail])

CITATION: If you use this dataset, please cite it as follows:Uchôa, J.G.S.M., Oliveira, P.T.S., Ballarin, A.S., Gastmans, A., Anache,J.A.A., Scanlon,B.R.S., Camanho,C.R.C., Filho,V.J.F. & Wendland,E.C. A groundwater well database for Brazil(GWDBrazil) (Version 1) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.15098047

LICENSE:This dataset is licensed under the Creative Commons Attribution 4.0 International (CC BY 4.0) License. You are free to share and adapt the material as long as appropriate credit is given.

REFERENCES: 

SGB - Geological Survey of Brazil [Serviço Geológico do Brasil]. (2024a). Projeto Rede Integrada de Monitoramento das Águas Subterrâneas. Retrieved from https://rimasweb.sgb.gov.br/layout/apresentacao.php. Last acess: 07/30/2024.

SGB - Geological Survey of Brazil [Serviço Geológico do Brasil]. (2024b). Sistema de Informações de Águas Subterrâneas. Retrieved from https://siagasweb.sgb.gov.br/layout/apresentacao.php. Last acess: 07/30/2024.

We recommend checking this README regularly for updates.