QC.extract: Extract the information for the Quebec ECSAS database

In RoyChristian/ECSASconnect: Import and export data from the Eastern Canada Seabirds at Sea (ECSAS) and the Suivi des oiseaux en mer de l'est du Canada (SOMEC) databases

Extract the information for the Quebec ECSAS database

Description

The function will connect to the Access database, create a series of queries and import the desired information in a data frame.

Usage

QC.extract(
  sp = "ATPU",
  years = c(2006, 2013),
  lat = c(30, 70),
  long = c(-70, -30),
  Obs.keep = NA,
  Obs.exclude = NA,
  intransect = T,
  ecsas.drive = "C:/Users/christian/Dropbox/ECSAS",
  ecsas.file = "Oiseaux marins 2006-2014.accdb"
)

Arguments

sp	Alpha code for the specie desired in the extraction. If more than one species all the desired species must be saved into a vector ex: c("COMU,"TBMU", "UNMU")
years	Years desired for the extraction
lat	Pairs of coordinate giving the southern and northern limits of the range desired.
long	Pairs of coordinate giving the western and eastern limits of the range desired. Note that longitude values must be negative.
Obs.exclude	Name of the observer to exlude for the extraction.The name of the observer must be followed by it's first name (eg: "Bolduc_Francois").
intransect	Should we keep only the birds counted on the transect or not.
ecsas.drive	Where is located the Quebec ECSAS Access database
ecsas.file	What is the name of the Quebec ECSAS Access database
obs.keep	Name of the observer to keep for the extraction. The name of the observer must be followed by it's first name (eg: "Bolduc_Francois").

Details

The function will produce a data frame that will contains all the pertinent information.

Author

Christian Roy

See Also

ECSAS.extract

RoyChristian/ECSASconnect documentation built on May 8, 2024, 11:30 a.m.