DBHYDRO_WQ: Data retrieval from South Florida Water Management District...

In SwampThingPaul/AnalystHelper: Helper functions developed over the years to extract and format data

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

Description

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

Usage

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

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)

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
## Not run: 
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")

## End(Not run)

SwampThingPaul/AnalystHelper documentation built on Nov. 3, 2024, 10:02 a.m.