Data retrieval from South Florida Water Management District online database (DBHYDRO)

DBHYDRO_WQ(
  date_min,
  date_max,
  station_id,
  test_number,
  matrix = "SW",
  cust_str = NULL,
  Exclude.FieldQC = "Y",
  Exclude.Flagged = "Y",
  sample_type = "SAMP",
  target_code = "file_csv"
)

Arguments

date_min

input start date as.Date (YYYY-MM-DD)

date_max

input end date as.Date

station_id

SFWMD Water Quality Monitoring location

test_number

corresponds to SFWMD data management system

matrix

default is "SW" for surface water other variables include "BAL","BAN","DI","BFE","BFI","GW","PERI","BPL","PW","RA","SE","SO","UNK"

cust_str

custom HTML string to add to query, example "+and+station_id+in+('L31NNGW4')" to look for a specific location (if station_id is NULL)

Exclude.FieldQC

true/false field

Exclude.Flagged

true/false field

sample_type

default 'SAMP'

target_code

default file_csv but can have "screen" and default browser will launch

Value

This function returns water quality dataset from the SFWMD monitoring network (https://apps.sfwmd.gov/WAB/EnvironmentalMonitoring/index.html). This function assumes some familiarity with the District monitoring network and data management. .

Examples

# Water Quality Data
sdate=as.Date("2001-05-01");
edate=as.Date("2002-05-01");
parameter=25;#Test Number for Phosphate, Total as P (mg/L)
dat=DBHYDRO_WQ(sdate,edate,"S12A",parameter,target_code="file_csv")