dbhydroR

R interface to the South Florida Water Management District's DBHYDRO Database :sweat_drops: :palm_tree:

Programmatic access to the South Florida Water Management District’s DBHYDRO database

dbhydroR 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")

DBHYDRO User’s
Guide