sum_WeirData: Summarise Fins Trapping Data

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

Summarise Fins Trapping Data

Description

summarizes and processes https://www.finsnet.org/ trapping module data for quick dissemination and mark/recapture analysis

Usage

sum_WeirData(df)

Arguments

df	the data.frame output from get_FINSdata and the 'Trapping' module

Value

a list with two objects. 1) a summary data.frame to easily pivot table for counts of fish trapped and their disposition, 2) a data.frame with the number of fish marked and released upstream and any recaptured

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)]
df <- get_FinsTrapping(npt_f, odbc_connection = con)
sum_df <- summarise_FinsTrapping(df)

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