sql | R Documentation |
Write SQL text as a single character string that will result in getting the relevant data from the PacFIN database.
sql_area()
sql_bds(pacfin_species_code)
sql_catch(pacfin_species_code, council_code = "P")
sql_species()
sql_check_FINAL_FISH_AGE_IN_YEARS()
pacfin_species_code |
A vector of strings specifying the PacFIN species
code(s) you are interested in. This has sometimes been referred to as
|
council_code |
A vector of character strings specifying the council code
that you wish to retain data for. The default |
sql_area()
results in area data
sql_bds()
results in biological data
sql_bds()
results in catch data
sql_species()
results in data frame of species names
sql_check_FINAL_FISH_AGE_IN_YEARS()
results in a data frame of number of
unique FISH_ID
s present in PacFIN per PACFIN_SPECIES_CODE
and
AGENCY_CODE
, i.e., species and state sampling agency, that have entries for
AGE_IN_YEARS
but have NULL
values for FINAL_FISH_AGE_IN_YEARS
. In
theory, this table should have zero rows. But, there may be reasons why these
entries do not have a final age value and potentially should not be used in
assessments of population status. Thus, the result is used in an automated
check and to create warning labels when downloading data.
A single character string formatted as an sql call.
Kelli F. Johnson and John R. Wallace
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.