get_locations: Extract LOCATION information from CFDBS

In NOAA-EDAB/comlandr: Pulls and processes commercial fishing data from the Northeast US

Extract LOCATION information from CFDBS

Description

Extract a list of lat, long, ten minute square, etc from the NEFSC "loc" supporting table

Usage

get_locations(channel, sqlStatement = "select * from cfdbs.loc")

Arguments

channel	an Object inherited from ROracle::Oracle. This object is used to connect to communicate with the database engine. (see dbutils::connect_to_database)
sqlStatement	Character string. An sql statement (optional). If no sqlStatement is provided the default sql statement "select * from cfdbs.loc" is used

Value

A list is returned:

data	containing the result of the executed sqlStatement
sql	containing the sqlStatement itself
colNames	a vector of the table's column names

Reference

Use the data dictionary for field name explanations

See Also

connect_to_database

Other get functions: get_areas(), get_gears(), get_ports(), get_species(), get_species_itis(), get_vessels()

Examples

## Not run: 
# extracts complete locations table based on default sql statement
channel <- connect_to_database(server="name_of_server",uid="individuals_username")
get_locations(channel)

# extracts subset of location information. Statistical area, and 10 minute square based
# on custom sql statement
sqlStatement <- "select area TENMSQ from cfdbs.loc;"
get_locations(channel,sqlStatement)

# extracts 10 minute square info for an area on geaorges bank (511) based on custom sql statement
sqlStatement <- "select area, tenmsq  from cfdbs.loc where area=511;"
get_locations(channel,sqlStatement)

## End(Not run)

NOAA-EDAB/comlandr documentation built on March 1, 2025, 8 p.m.