DBHYDRO database
Programmatic access to the South Florida Water Management District’sdbhydroR
provides scripted access to the South Florida Water
Management District’s DBHYDRO database which holds over 35 million
hydrologic and water quality records from the Florida Everglades and
surrounding areas.
Installation
Stable version from CRAN
install.packages("dbhydroR")
or development version from Github
install.packages("devtools") # Requires RTools if using Windows
devtools::install_github("ropensci/dbhydroR")
Usage
Load dbhydroR
library("dbhydroR")
Water Quality Data
Station IDs and date ranges can be viewed in the Environmental Monitoring Location Maps. Test names can be viewed in the Data Types Metadata Table on the DBHYDRO website.
One variable at one station
get_wq(station_id = "FLAB08", date_min = "2011-03-01",
date_max = "2012-05-01", test_name = "CHLOROPHYLL-A, SALINE")
One variable at multiple stations
get_wq(station_id = c("FLAB08","FLAB09"), date_min = "2011-03-01",
date_max = "2012-05-01", test_name = "CHLOROPHYLL-A, SALINE")
One variable at a wildcard station
get_wq(station_id = c("FLAB0%"), date_min = "2011-03-01",
date_max = "2012-05-01", test_name = "CHLOROPHYLL-A, SALINE")
Multiple variables at multiple stations
get_wq(station_id = c("FLAB08","FLAB09"), date_min = "2011-03-01",
date_max = "2012-05-01", test_name = c("CHLOROPHYLL-A, SALINE",
"SALINITY"))
Operate on raw data
raw_data <- get_wq(station_id = "FLAB08", date_min = "2011-03-01",
date_max = "2012-05-01", test_name = "CHLOROPHYLL-A, SALINE", raw = TRUE)
clean_wq(raw_data)
Hydrologic data
Station IDs and date ranges can be viewed in the Environmental Monitoring Location Maps.
Identify unique time series (dbkeys) before-hand
get_dbkey(stationid = "C111%", stat = 'MEAN', category = "WQ", detail.level = "full")
get_hydro(dbkey = 38104, date_min = "2009-01-01", date_max = "2009-01-12")
Pass station info on-the-fly
get_hydro(date_min = "2013-01-01", date_max = "2013-02-02",
stationid = "JBTS", category = "WEATHER", param = "WNDS",
freq = "DA", stat = "MEAN", recorder = "CR10", agency = "WMD")
Operate on raw data
raw_data <- get_hydro(date_min = "2013-01-01", date_max = "2013-02-02",
stationid = "JBTS", category = "WEATHER", param = "WNDS",
freq = "DA", stat = "MEAN", recorder = "CR10", agency = "WMD", raw = TRUE)
clean_hydro(raw_data)
References
vignette("dbhydroR", package = "dbhydroR")
Meta
-
Please report any issues or bugs.
-
Get citation information for
dbhydroR
in R by runningcitation(package = 'dbhydroR')
-
Please note that this project is released with a Contributor Code of Conduct. By participating in this project you agree to abide by its terms