openwashdata/drillingdata

This dataset captures detailed information on borehole drilling and construction activities conducted across selected sites in Malawi between 2018 and 2024 # Borehole Drilling and Construction Data – Malawi, 2018 - 2024 This dataset captures detailed information on borehole drilling and construction activities conducted across selected sites in Malawi between 2018 and 2024. Data were collected using the mWater digital platform, documenting each stage of groundwater development, from site selection and hydrogeological studies to drilling operations, borehole design, and post-construction assessments. The dataset includes variables on location and site suitability, survey and geophysical methods, drilling parameters, equipment and safety compliance, geological formations encountered, casing and gravel pack details, and initial water quality measurements. Together, these data provide a comprehensive technical record of Malawi’s borehole development process. **Potential Use Cases** This dataset is valuable to a wide range of stakeholders, including: 1. Government Water Departments and District Councils: for monitoring drilling quality, verifying contractor performance, and maintaining an updated inventory of functional water points. 2. Development Partners and NGOs: for planning new water supply interventions, assessing borehole performance, and improving accountability in donor-funded projects. 3. Hydrogeologists and WASH Engineers: for analyzing aquifer characteristics, drilling efficiency, and the relationship between geology and borehole productivity. 4. Researchers and Academic Institutions: for studying groundwater development practices, environmental sustainability, and data-driven approaches to rural water supply. 5. Policy Makers and Regulators: for strengthening national standards, promoting data transparency, and improving decision-making in the water resources sector. ## Installation You can install the development version of drillingdata from GitHub with: ``` r # install.packages("devtools") devtools::install_github("openwashdata/drillingdata") ``` ``` r ## Run the following code in co …