As part of our collaboration with ETH Zurich's Open-Wash-Data initiative, we are excited to announce the release of the Borehole Forensics 4 – Pumping Test 2018–2024 dataset. This open-access resource provides comprehensive insights into groundwater extraction and borehole performance across Malawi, aligning with our shared mission to promote transparency and data-driven decision-making in the Water, Sanitation, and Hygiene (WASH) sector.
About the Dataset
The borehole forensics pumping test dataset encompasses 203 observations with 44 variables, detailing critical aspects of borehole functionality and water quality. Key parameters include:
- Test Conditions: Dates, administrative regions, and GPS coordinates.
- Hydrogeological Metrics: Static water levels, pumping rates, and flow measurement methods.
- Water Quality Indicators: pH, turbidity, electrical conductivity, and total dissolved solids.
- Operational Observations: Equipment used, permissions granted, and borehole performance notes.
This dataset serves multiple purposes, such as hydrogeological analysis, environmental studies, infrastructure planning, and regulatory compliance.
Empowering the WASH Community
The release of this dataset is a part of the open wash data project's commitment to fostering an active global community that applies FAIR (Findable, Accessible, Interoperable, and Reusable) principles to WASH data. By making such data openly available, we aim to:
- Enhance Data Reusability: Facilitating new insights and better monitoring.
- Promote Collaboration: Connecting professionals who value open and reusable data.
- Support Education: Providing resources for training and capacity building.
This initiative is supported by the Open Research Data Program of the ETH Board, emphasizing the importance of open science in achieving Sustainable Development Goal 6: Clean Water and Sanitation.
Accessing and Utilizing the Data
The dataset is accessible through the R package borehole forensics pumping test. Users can install it directly from GitHub:
https://github.com/openwashdata/boreholeforensicspumpingtest
Alternatively, the data can be downloaded in CSV or XLSX formats from the project's website.
An example visualization from the dataset illustrates static water levels over time:
This plot provides insights into groundwater trends, aiding in resource management and planning.
Join the Movement
We invite WASH professionals, researchers, and enthusiasts to explore the dataset, contribute to its development, and participate in the broader open wash data community. Your engagement is vital in building a sustainable and open data ecosystem for the WASH sector. For more information and to get involved, visit openwashdata.org.
Together, we can drive innovation and transparency in water resource management.