count_activeSed: For higher level review. Retrieves all stream site sediment...

Description Usage Arguments Details Value Examples

View source: R/count_activeSed.R

Description

For higher level review. Retrieves all stream site sediment samples in a given date range via an ODBC connection to an internal NWIS server, and returns a summary table by site, water year, and number of samples in each analysis.

Usage

1
count_activeSed(DSN, env.db = "01", begin.date = NA, end.date = NA)

Arguments

DSN

A character string containing the DSN for your local server

env.db

A character string containing the database number of environmental samples

begin.date

Character string containing beginning date of data pull (yyyy-mm-dd)

end.date

Character string containing ending date of data pull (yyyy-mm-dd)

Details

For review at the center level. Function retrieves all stream site (SITE_TYP_CD = 'ST') sediment (SSC (80154), sand/silt break (70331), TSS (00530), and bedload (80225)) samples in the defined date range of the users internal NWIS database. A summary table of sample counts by site, water year, and parameter is returned.

Value

A summary dataframe

Examples

1
2
3
4
5
6
7
8
## Not run: 
#Will not run unless connected to NWISCO
activeSed <- count_activeSed(DSN = 'nwisco',
                             env.db = '01',
                             begin.date = '2015-10-01',
                             end.date = '2017-09-30')
## End(Not run)
                             

USGS-R/sedReview documentation built on Aug. 24, 2020, 9 p.m.