Extract STRATA information from SVDBS

Source: R/get_strata.R

Extract STRATA information from the SVDBS.SVMSTRATA table

get_strata(channel, strata = "all")

Arguments

channel

an Object inherited from DBIConnection-class. This object is used to connect to communicate with the database engine. (see connect_to_database)

strata

Numeric or character vector. Set of strata codes. Default = "all". Numeric codes are converted to VARCHAR2(5 BYTE) when creating the sql statement. Alternatively enter name of stratum

Value

A list is returned:

species

containing the result of the executed $sql statement

sql

containing the sql call

colNames

a vector of the table's column names

Reference

Use the data dictionary for field name explanations

See also

connect_to_database

Other helper: get_conversion_factors(), get_cruise_purpose(), get_length_weight(), get_maturity(), get_sex(), get_sex_fscs(), get_species(), get_vessel()

Examples

if (FALSE) { # \dontrun{
# extracts complete strata table
channel <- dbutils::connect_to_database(server="serverName",uid="userName")
get_strata(channel)

# extracts info for a single stratum
get_strata(channel,strata=6940)
get_strata(channel,strata="6940")
get_strata(channel,"SNE BLOCK ISLAND")
get_strata(channel,"SNE Block Island")

# extracts multiple strata
get_strata(channel,strata= c(6940,6400,6380))
get_strata(channel,strata=c("6940","6400","6380"))
} # }