R interface to the South Florida Water Management District's DBHYDRO Database 💦🌴
R
Latest commit de7c9f8 Feb 20, 2017 @jsta jsta fix broken links
Permalink
Failed to load latest commit information.
R
inst
man
tests
vignettes
.Rbuildignore
.travis.yml
CONDUCT.md
DESCRIPTION
NAMESPACE
NEWS.md
README.Rmd
README.md
TODO

README.md

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

Project Status: Active - The project has reached a stable, usable state and is being actively developed. Travis-CI Build Status CRAN\_Status\_Badge CRAN RStudio mirror downloads

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("ropenscilabs/dbhydroR")

Usage

Load dbhydroR

library("dbhydroR")

Water Quality Data

Station IDs and date ranges can be viewed in the ArcGIS Online Station Map. Test names can be viewed in the Data Types Metadata Table.

One variable at one station

get_wq(station_id = "FLAB08", date_min = "2011-03-01", 
      date_max = "2012-05-01", test_name = "CHLOROPHYLLA-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 = "CHLOROPHYLLA-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 = "CHLOROPHYLLA-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("CHLOROPHYLLA-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 = "CHLOROPHYLLA-SALINE", raw = TRUE)

clean_wq(raw_data)

Hydrologic data

Station IDs and date ranges can be viewed in the ArcGIS Online Station Map.

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

Meta

  • Please report any issues or bugs.

  • Get citation information for dbhydroR in R by running citation(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

ropensci\_footer