F.buildReportCriteriaRelease: F.buildReportCriteriaRelease

In tmcd82070/CAMP_RST: CAMP RST R Routines

F.buildReportCriteriaRelease

Description

Update Access database table TempReport_Criteria_Release to contain release trapVisitIDs for the site and inclusive calendar dates specified by the user.

Usage

F.buildReportCriteriaRelease(site, min.date, max.date)

Arguments

site	The identification number of the site for which estimates are required.
min.date	The start date for data to include. This is a text string in the format %Y-%m-%d, or YYYY-MM-DD.
max.date	The end date for data to include. Same format as min.date.

Details

Unique efficiency trials are identified by unique releaseIDs falling within the specified min.date and max.date. See section Structured Query Language (SQL) Queries in function F.run.sqlFile for more details on query series.

Note that the difference between this and the buildReportCriteria query series is this one's focus on releases and subsequent recaptures related to efficiency trials.

Value

Within R, the total integer count of efficiency trials. Within Access, table TempReportCriteria_Release is created, itemizing the releases.

Examples

## Not run: 
#   ---- American River at Watt Avenue, 2013 Season
site <- 57000                 
min.date <- "2013-01-16"
max.date <- "2013-06-08" 

#   ---- Obtain inclusive releases.    
nreleases <- F.buildReportCriteriaRelease( site, min.date, max.date )

## End(Not run)

tmcd82070/CAMP_RST documentation built on April 6, 2022, 12:07 a.m.