Function reference • afscdata

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_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_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_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

Reference

All functions