Skip to contents

All functions

accepted_model()
copy the previous SSC accepted model as the new "base" model
bsai_amak()
raw data query for the BSAI Atka mackerel assessment
bsai_amak_catch_1977_1990
BSAI Atka mackerel historical catch
bsai_atf()
raw data query for BSAI arrowtooth flounder
bsai_fhs()
raw data query for BSAI flathead sole
bsai_fhs_catch_1964_1994
BSAI flathead sole historical catch data 1964-1994
bsai_nrs()
raw data query for BSAI northern rocksole
bsai_octopus()
raw data query for BSAI octopus
bsai_orox()
raw data query for BSAI other rockfish
catch_to_ss3()
Reformat Catch to SS3 structure currently only handles a single fleet, values in t
collapse_filters()
utility function for sql queries
connect()
utility function to connect to server
disconnect()
utility function to disconnect from server
fmp_key
Sablefish fmp area key by location
gap_check_bio()
compare GAP updated survey biomass to (now) retired design-based biomass estimates
goa_amak()
raw data query for the GOA Atka mackerel assessment
goa_atf()
raw data query for GOA arrowtooth founder
goa_atf_catch_1961_1990
GOA arrowtooth flounder historical catch data
goa_dusk()
raw data query for GOA dusky rockfish
goa_dusk_catch_1977_1990
GOA dusky rockfish historical catch data
goa_fhs()
raw data query for GOA flathead sole
goa_fhs_catch_1978_1990
GOA flathead sole historical catch
goa_nork()
raw data query for GOA northern rockfish
goa_nork_catch_1961_1992
GOA northern rockfish historical catch data
goa_octopus()
raw data query for GOA octopus
goa_pcod_catch_1977_1990
GOA Pacific cod historical catch
goa_pcod_larval_indices
GOA Pacific cod historical larval index data
goa_pop()
raw data query for GOA POP
goa_pop_catch_1960_1990
GOA POP historical catch data
goa_pop_fixed_fish_length_comp
GOA POP historical fishery length comp data
goa_rebs()
raw data query for GOA rougheye/blackspotted rockfish
goa_rebs_catch_1977_2004
GOA rougheye/blackspotted rockfish historical catch data
goa_shal_flats()
raw data query for GOA shallow-water flatfish
goa_thornyhead()
raw data query for GOA thorynhead rockfish
q_bts_agecomp()
query bottom trawl survey agecomps
q_bts_biomass()
query bottom trawl survey biomass
q_bts_gap_agecomp()
query GAP bottom trawl survey agecomps
q_bts_gap_length()
query bottom trawl survey length data from GAP on the AKFIN server
q_bts_gap_sizecomp()
query GAP bottom trawl survey sizecomps
q_bts_gap_specimen()
query GAP bottom trawl survey specimen data from the AKFIN server
q_bts_length()
query bottom trawl survey length data from the AFSC server
q_bts_sizecomp()
query bottom trawl survey sizecomps
q_bts_specimen()
query bottom trawl survey specimen data from the AFSC server
q_catch()
query fishery catch data from AKFIN server
q_catch_foreign()
query foreign catch data from the AKFIN server
q_date()
utility function for date of data query
q_discards()
query fishery discard data from AKFIN server
q_fish_obs()
fishery observer data query
q_fish_ticket()
query fish ticket data
q_fsh_length()
query fishery length data from the AKFIN server
q_fsh_specimen()
query fishery specimen data from the AKFIN server
q_gap_biomass()
query GAP products bottom trawl survey biomass note: pay attention to the 'design_year' column, particularly for region or depth queries as there may be data duplicates
q_incidental()
query incidental FMP species catch estimates
q_lls_length()
query nmfs longline survey raw length frequencies at the depth stratum and station level
q_lls_rpn()
query nfms longline survey relative population numbers or weights
q_lls_rpn_length()
query nfms longline survey rpn-weighted length frequencies
q_lls_sable_specimen()
query nmfs longine survey specimen data (age, length, weight, sex, maturity). only available for sablefish!
q_nontarget()
query non-target species catch estimate
q_psc()
query prohibited species catch (psc) estimate
q_specs()
Query specs
saa_pop_60
GOA POP historical size at age parameters data
sabl_fixed_abundance
Sablefish historical abundance data
sabl_fixed_comps
Sablefish age and length comp data
sabl_new_areas
Sablefish defining areas for age samples
sabl_vessel_lengths
vessel lengths
sabl_waa
Sablefish fixed weights at age
setup_folders()
Setup folder structure
sharks()
raw data query for GOA/BSAI sharks
sql_filter()
utility function to filter sql files
sql_read()
utility function to read sql file
sql_run()
utility function to run sql query