get_gears: Extract fishing GEAR types from CFDBS

In andybeet/cfdbs: Pulls data from the NEFSC commercial database

Extract fishing GEAR types from CFDBS

Description

Extract a list of gear types in the NEFSC "GEAR" supporting table

Usage

get_gears(channel, gears = "all")

Arguments

channel	DBI Object. Inherited from DBIConnection-class. This object is used to connect to communicate with the database engine. (see connect_to_database)
gears	specific gear code or set of codes. Either numeric or character vector. Defaults to "all" gears. Numeric codes are converted to VARCHAR2(2 BYTE) when creating the sql statement. Character codes are short character strings referencing GEARNM field.

Value

A list is returned:

gears	containing the result of the executed sqlStatement
sql	containing the sql call
colNames	a vector of the table's column names

If no sqlStatement is provided the default sql statement "select * from cfdbs.gear" is used

Reference

Use the data dictionary (http://nova.nefsc.noaa.gov/datadict/) for field name explanations

See Also

connect_to_database

Other get functions: get_age_length(), get_anything_sql(), get_areas(), get_landings_length(), get_landings_palmer(), get_landings(), get_locations(), get_ports(), get_species_itis(), get_species(), get_vessels()

Examples

## Not run: 
# extracts gear data from cfdbs.gear table based on the default \code{sqlStatement}
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_gears(channel)

# extracts info based on gear types (5,6) (numeric)
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_gears(channel,gears=c(5,6))

# extracts info based on gear types (5,6) (character)
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_gears(channel,gears=c("05","06"))

# extracts info for "Seines"
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_gears(channel,"seines") or


## End(Not run)

andybeet/cfdbs documentation built on Sept. 19, 2023, 9:34 p.m.