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

DBHYDRO_WQ(
  date_min = NULL,
  date_max = NULL,
  station_id = NA,
  test_number = NA,
  collect_method = NULL,
  matrix = "SW",
  cust_str = NULL,
  Exclude.FieldQC = T,
  Exclude.Flagged = T,
  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, see details
test_number: corresponds to SFWMD data management system
collect_method: default is NULL but can specify G, GP, ACF, ACT, ADT
matrix: default is "SW" for surface water
cust_str: custom sql query string to add to link (not implemented)
Exclude.FieldQC: true/false field, DEFAULT is TRUE
Exclude.Flagged: true/false field, DEFAULT is TRUE
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. .

Details

Sample Type definitions include SAMP=Sample, RS=Replicate Sample, SS= Split Sample, EB=Equipment Blank, FCEB=Field Cleaned Equipment Blank, FD=Field Duplicate

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

target_code can be either "file_csv" (for CSV) and "screen" (launch default browser). Other formats like "file_txt" (for fixed column width) and "file_pdf" (for pdf) and "screen" (launch default browser) have not been implemented

station_id can use wildcard character but not in combination with wildcard and non-wildcard (i.e. S12%, S333)

Examples

# Water Quality Data
if (FALSE) {
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,"S12%",parameter,target_code="file_csv")
}