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

DBHYDRO_WQ(
  date_min,
  date_max,
  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")
}