dbfishR: An R package for fish and water quality data access and entry
Persistent URL
Author(s)
Wilson, Matthew J.
Ashcraft, Sara A.
Kirk, Mark A.
Allegheny College
Ressler, Daniel E.
Date Issued
July 30, 2026
Abstract
The dbfishR package is designed to access data collected as part of Pennsylvania’s Unassessed Waters Initiative, a state-wide program to sample fish communities and water quality in headwater streams throughout the state, currently including 1491 stream sites collected between 2010–2025. With the package database, we have also released a robust database template to both facilitate collaboration and future data contributions through data standardization for in-stream collection of data related to water quality; discharge; site metadata, and fish counts, lengths, and weights. The database includes structured forms with value limits for data entry to support efficiency, accessibility, and quality control. The package is structured for tidy import from the relational database structure for ease of data analysis and comparison with external data. Because of these data and query structures, the package and database can be expanded to include data from any aquatic research involving substrate, water quality, or fish and amphibians. We present the package and database as readily available access to the existing dataset while offering opportunity for future contribution, specifically from the eastern United States, as well as adaptability for use in data curation and access for watersheds globally.
Journal
Data in Brief
Citation
Wilson, Matthew J., Sara A. Ashcraft, Mark A. Kirk, and Daniel E. Ressler. "dbfishR: An R Package for Fish and Water Quality Data Access and Entry." Data in Brief 68,(2026): 113118. doi:10.1016/j.dib.2026.113118. https://doi.org/10.1016/j.dib.2026.113118.
Publisher
Elsevier BV
DOI
10.1016/j.dib.2026.113118
ISSN
2352-3409
Rights
© 2026 The Author(s). Published by Elsevier Inc. This is an open access article under the CC BY license (http://creativecommons.org/licenses/by/4.0/)
Type of Publication
Journal Article
File(s)![Thumbnail Image]()
Name
2026_Kirk_dbfishR.pdf
Size
281.3 KB
Format
Adobe PDF
Checksum (MD5)
40f6ab62af452ba8d6bb7925940662e8