What the Package Does (One Line, Title Case) • boreholeforensicspumpingtest

This dataset contains borehole forensic pumping test data, capturing key parameters related to groundwater extraction, borehole performance, and water quality assessments. It includes information on the test conditions, water levels, pumping rates, flow measurement methods, and water quality indicators such as pH, turbidity, and electrical conductivity.

The dataset also documents permissions granted for testing, equipment used, and observations on borehole performance, such as whether the water level stabilized during pumping and whether the borehole passed the test.

Potential Uses of the Dataset 1. Hydrogeological Analysis: Evaluating groundwater availability and borehole efficiency. 2. Environmental Studies: Assessing water quality parameters. 3. Infrastructure Planning: Supporting water resource management and borehole maintenance decisions. 4. Regulatory Compliance: Ensuring boreholes meet required operational standards.

Installation

You can install the development version of boreholeforensicspumpingtest from GitHub with:

# install.packages("devtools")
devtools::install_github("openwashdata/boreholeforensicspumpingtest")

## Run the following code in console if you don't have the packages
## install.packages(c("dplyr", "knitr", "readr", "stringr", "gt", "kableExtra"))
library(dplyr)
library(knitr)
library(readr)
library(stringr)
library(gt)
library(kableExtra)

Alternatively, you can download the individual datasets as a CSV or XLSX file from the table below.

Click Download CSV. A window opens that displays the CSV in your browser.
Right-click anywhere inside the window and select “Save Page As…”.
Save the file in a folder of your choice.

dataset	CSV	XLSX
boreholeforensicspumpingtest	Download CSV	Download XLSX

Data

The package provides access to the Borehole Forensics 4 - Pumping Test conducted between 2018 and 2024

library(boreholeforensicspumpingtest)

boreholeforensicspumpingtest

The dataset boreholeforensicspumpingtest contains data about … It has 203 observations and 44 variables

boreholeforensicspumpingtest |> 
  head(3) |> 
  gt::gt() |>
  gt::as_raw_html()

date_of_test	administrative_region	latitude	longitude	name	type_of_waterpoint	description	type_of_test	is_it_possible_to_complete_pumping_test	specify_why_not_possible_to_complete_pumping_test	water_point_committee_permission	district_water_office_permission	static_water_level_metres_below_reference_point_before_start_of_test	water_level_reference_point	other_water_level_reference_point	reference_level_above_or_below_ground_level_in_miters	pump_intake_depth_in_miters	total_hole_depth_in_miters	was_a_water_level_logger_used	was_a_flow_meter_used	other_flow_meter_used	bucket_size_in_litres	index_1	time_in_mins	water_level_in_mbrp	flowmeter_total	flow_rate_in_liters_per_second	flow_rate_method	index_2	time_of_sample_in_min	ec_in_ms_per_cm	tds_ppt	temperature_in_celcius	ph	turbidity_ntu	Imhoff_cone_cubic_centimeter_per_liter	did_water_level_stabilise_while_pumping_at_0.25_liters_per_second	established_dwl_at_0.25l_per_second_m	maximum_successful_pumping_rate_in_liters_per_second	dwl_at_maximum_pumping_rate	silt_ejected_during_test	did_the_borehole_pass_a_pumping_test	specify_other_borehole_pass_a_pumping_test	comments_on_pumping_test
9/10/2018	STA Sandareki, Chiradzulu, Malawi	-15.68837	35.29993	Makuwa secondary school borehole 1	Borehole or tubewell	Near makuwa secondary school	Step Drawdown	Yes	NA	Yes	Yes	11.50	Top of Pedestal	NA	0.44	22	24.5	Yes	Digital	NA	20	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	Yes	14.57	0.5	16.95	Constantly	Yes	NA	3.25ppm iron. 0ppb arsenic. Large amount of sediment ejected.
10/10/2018	TA Nchema, Chiradzulu, Malawi	-15.58221	35.18867	Chindunguli borehole 2	Borehole or tubewell	Near Juma’s Maizemill	Step Drawdown	Yes	NA	Yes	Yes	10.10	Top of Pedestal	NA	0.51	45	47.0	Yes	Digital	NA	20	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	Yes	15.00	0.5	34.00	No	NA	NA	All imhoff cone sediment readings less than 0.1
24/10/2018	STA Mpunga, Chiradzulu, Malawi	-15.82110	35.25589	Nangwinya Borehole	Borehole or tubewell	Between Namitambo and Namitokoma	Step Drawdown	Yes	NA	Yes	Yes	4.61	Top of Pedestal	NA	0.51	41	42.8	Yes	Digital	NA	20	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	NA	Yes	9.63	1.0	32.27	No	NA	NA	Generator turned off due to fault near end of third step.

For an overview of the variable names, see the following table.

variable_name	variable_type	description
date_of_test	character	date on which the borehole pumping test was conducted.
administrative_region	character	area where the water point is located.
latitude	numeric	GPS location of the water point (latitude).
longitude	numeric	GPS location of the water point (longitude).
name	character	name of the water point.
type_of_waterpoint	character	type of the water point.
description	character	description of water point.
type_of_test	character	The type of pumping test performed on the borehole.
is_it_possible_to_complete_pumping_test	character	Indicates whether the pumping test was successfully completed.
specify_why_not_possible_to_complete_pumping_test	character	Reason why the pumping test could not be completed, if applicable.
water_point_committee_permission	character	Whether permission was granted by the water point committee to conduct the test.
district_water_office_permission	character	Whether permission was granted by the district water office to conduct the test.
static_water_level_metres_below_reference_point_before_start_of_test	numeric	Water level below the reference point before the start of the test (in meters).
water_level_reference_point	character	The reference point used to measure water level (e.g., top of casing, ground level).
other_water_level_reference_point	character	Additional reference point used for measuring water level, if applicable.
reference_level_above_or_below_ground_level_in_miters	numeric	Measurement of the reference level relative to ground level (in meters).
pump_intake_depth_in_miters	numeric	Depth at which the pump intake is placed within the borehole (in meters).
total_hole_depth_in_miters	numeric	Total depth of the borehole (in meters).
was_a_water_level_logger_used	character	Indicates whether a water level logger was used to record measurements.
was_a_flow_meter_used	character	Indicates whether a flow meter was used during the test.
other_flow_meter_used	logical	Whether an alternative flow meter was used during the test.
bucket_size_in_litres	numeric	Capacity of the bucket used for manual flow measurements (in liters).
index_1	logical	A logical index variable for internal tracking.
time_in_mins	logical	Whether time was recorded in minutes during the test.
water_level_in_mbrp	logical	Whether the water level was measured in meters below reference point.
flowmeter_total	logical	Whether the total flowmeter reading was recorded.
flow_rate_in_liters_per_second	logical	Whether the flow rate was measured in liters per second.
flow_rate_method	logical	Whether the method used to measure flow rate was recorded.
index_2	logical	A second logical index variable for internal tracking.
time_of_sample_in_min	logical	Whether the sampling time was recorded in minutes.
ec_in_ms_per_cm	logical	Whether electrical conductivity (EC) in millisiemens per centimeter was recorded.
tds_ppt	logical	Whether total dissolved solids (TDS) in parts per thousand (ppt) were recorded.
temperature_in_celcius	logical	Whether water temperature in degrees Celsius was recorded.
ph	logical	Whether pH of the water was measured.
turbidity_ntu	logical	Whether turbidity in nephelometric turbidity units (NTU) was measured.
Imhoff_cone_cubic_centimeter_per_liter	logical	Whether sediment concentration was measured using an Imhoff cone.
did_water_level_stabilise_while_pumping_at_0.25_liters_per_second	character	Whether the water level stabilized while pumping at 0.25 liters per second.
established_dwl_at_0.25l_per_second_m	numeric	Depth to the water level (DWL) at 0.25 liters per second pumping rate (in meters).
maximum_successful_pumping_rate_in_liters_per_second	numeric	Highest pumping rate successfully achieved during the test (in liters per second).
dwl_at_maximum_pumping_rate	numeric	Depth to the water level at the maximum pumping rate (in meters).
silt_ejected_during_test	character	Whether silt was observed being ejected from the borehole during the test.
did_the_borehole_pass_a_pumping_test	character	Whether the borehole passed the pumping test based on performance criteria.
specify_other_borehole_pass_a_pumping_test	logical	Additional details on the borehole’s performance in the pumping test.
comments_on_pumping_test	character	Additional comments or observations about the pumping test.

Example

library(boreholeforensicspumpingtest)
library(ggplot2)
library(lubridate)

# Convert date_of_survey_or_test to Date format and extract year
boreholeforensicspumpingtest$year <- year(mdy(boreholeforensicspumpingtest$date_of_survey_or_test))

# Create the plot
ggplot(boreholeforensicspumpingtest, aes(x = year, y = static_water_level_metres_below_reference_point_before_start_of_test)) +
  geom_point() +
  theme_minimal() +
  labs(
    title = "Static Water Level by Year",
    x = "Year",
    y = "Static Water Level (m below reference point)"
  )

License

Data are available as CC-BY.

Citation

Please cite this package using:

citation("boreholeforensicspumpingtest")
#> To cite package 'boreholeforensicspumpingtest' in publications use:
#> 
#>   Mhango E, Paterson F, Kumpukwe P (2025).
#>   _boreholeforensicspumpingtest: What the Package Does (One Line, Title
#>   Case)_. R package version 0.0.0.9000,
#>   <https://github.com/openwashdata/boreholeforensicspumpingtest>.
#> 
#> A BibTeX entry for LaTeX users is
#> 
#>   @Manual{,
#>     title = {boreholeforensicspumpingtest: What the Package Does (One Line, Title Case)},
#>     author = {Emmanuel Mhango and Finlay Paterson and Paul Kumpukwe},
#>     year = {2025},
#>     note = {R package version 0.0.0.9000},
#>     url = {https://github.com/openwashdata/boreholeforensicspumpingtest},
#>   }