clean_weirData: Clean Weir Trapping Data

In ryankinzer/cuyem: Snake River Basin Anadromous Fish Summaries and Metric Estimation

Clean Weir Trapping Data

Description

Processes the raw FINS trapping query and adds important fields for summaries (e.g., Survey Year, Reporting Group, Transect Name, Above Weir, Origin, Mark and Recapture etc.)

Usage

clean_weirData(data)

Arguments

data	raw CDMS redd dataset from cdmsR::getDatasetView(datastore = 78) or from CDMS dataset export

Author(s)

Ryan N. Kinzer

Examples

con <- RODBC::odbcConnect(dsn = 'Fins', uid = 'guest', pwd = 'guest')
qry <- "SELECT distinct(Facility) FROM FINS_all_trapping"
f <- RODBC::sqlQuery(con, qry) %>% mutate_all(as.character) %>% pull(Facility)
npt_f <- f[grepl('NPT', f)]
weir_dat <- get_FinsTrapping(npt_f, odbc_connection = con)
tmp <- clean_weirData(weir_dat)

ryankinzer/cuyem documentation built on April 20, 2024, 2:10 p.m.