create-tables.Rmd
Tables can be automatically created from the
table_spreadsheet.csv
and the .csv
files in
the tables
folder. Additionally, the AKesp
package can also create some tables that require data analysis.
A traffic light table can be automatically created from a spreadsheet that has a column for year and a column for each indicator.
dat <- AKesp::get_esp_data("Alaska Sablefish")
AKesp::esp_traffic_tab(
data = dat,
year = 2020
)
Indicator category |
Indicator |
2020 Status |
---|---|---|
Physical |
Annual Heatwave GOA Model |
neutral |
Spring Temperature Surface GOA Satellite |
high |
|
Spring Temperature Surface SEBS Satellite |
high |
|
Summer Temperature 250m GOA Survey |
neutral |
|
Lower Trophic |
Spring Chlorophylla Biomass GOA Satellite |
neutral |
Spring Chlorophylla Biomass SEBS Satellite |
neutral |
|
Spring Chlorophylla Peak GOA Satellite |
neutral |
|
Spring Chlorophylla Peak SEBS Satellite |
neutral |
|
Annual Copepod Community Size EGOA Survey |
neutral |
|
Annual Copepod Community Size WGOA Survey |
neutral |
|
Summer Euphausiid Abundance Kodiak Survey |
NA |
|
Annual Sablefish Growth YOY Middleton Survey |
neutral |
|
Upper Trophic |
Summer Sablefish CPUE Juvenile Nearshore GOAAI Survey |
high |
Summer Sablefish CPUE Juvenile GOA Survey |
NA |
|
Annual Sablefish Mean Age Female Adult Model |
low |
|
Annual Sablefish Age Evenness Female Adult Model |
low |
|
Summer Sablefish Condition Female Age4 GOA Survey |
neutral |
|
Annual Arrowtooth Biomass GOA Model |
low |
|
Annual Sablefish Incidental Catch Arrowtooth Target GOA Fishery |
neutral |
|
Summer Sablefish Condition Female Adult GOA Survey |
neutral |
|
Fishery Performance |
Annual Sablefish Combined CPUE Alaska Fishery |
low |
Annual Sablefish Pot CPUE Alaska Fishery |
high |
|
Annual Sablefish Incidental Catch GOA Fishery |
high |
|
Annual Sablefish Incidental Catch BSAI Fishery |
high |
|
Annual Sablefish Condition Female Adult GOA Fishery |
high |
|
Annual Sablefish Condition Female Adult BSAI Fishery |
NA |
|
Economic |
Annual Sablefish Real Exvessel Value Fishery |
low |
Annual Sablefish Real Exvessel Price Fishery |
low |
Multiple years can be shown.
AKesp::esp_traffic_tab(
data = dat,
year = 2016:2020
)
Indicator category |
Indicator |
2016 Status |
2017 Status |
2018 Status |
2019 Status |
2020 Status |
---|---|---|---|---|---|---|
Physical |
Annual Heatwave GOA Model |
high |
neutral |
neutral |
high |
neutral |
Spring Temperature Surface GOA Satellite |
high |
neutral |
neutral |
high |
high |
|
Spring Temperature Surface SEBS Satellite |
high |
neutral |
high |
high |
high |
|
Summer Temperature 250m GOA Survey |
low |
high |
neutral |
high |
neutral |
|
Lower Trophic |
Spring Chlorophylla Biomass GOA Satellite |
low |
neutral |
neutral |
low |
neutral |
Spring Chlorophylla Biomass SEBS Satellite |
neutral |
low |
neutral |
low |
neutral |
|
Spring Chlorophylla Peak GOA Satellite |
high |
low |
low |
high |
neutral |
|
Spring Chlorophylla Peak SEBS Satellite |
neutral |
low |
high |
low |
neutral |
|
Annual Copepod Community Size EGOA Survey |
neutral |
neutral |
neutral |
low |
neutral |
|
Annual Copepod Community Size WGOA Survey |
neutral |
neutral |
low |
high |
neutral |
|
Summer Euphausiid Abundance Kodiak Survey |
NA |
low |
NA |
neutral |
NA |
|
Annual Sablefish Growth YOY Middleton Survey |
neutral |
neutral |
neutral |
high |
neutral |
|
Upper Trophic |
Summer Sablefish CPUE Juvenile Nearshore GOAAI Survey |
neutral |
neutral |
high |
high |
high |
Summer Sablefish CPUE Juvenile GOA Survey |
NA |
high |
NA |
neutral |
NA |
|
Annual Sablefish Mean Age Female Adult Model |
neutral |
neutral |
neutral |
low |
low |
|
Annual Sablefish Age Evenness Female Adult Model |
low |
low |
low |
low |
low |
|
Summer Sablefish Condition Female Age4 GOA Survey |
neutral |
low |
neutral |
low |
neutral |
|
Annual Arrowtooth Biomass GOA Model |
neutral |
neutral |
neutral |
neutral |
low |
|
Annual Sablefish Incidental Catch Arrowtooth Target GOA Fishery |
neutral |
high |
high |
high |
neutral |
|
Summer Sablefish Condition Female Adult GOA Survey |
neutral |
low |
high |
neutral |
neutral |
|
Fishery Performance |
Annual Sablefish Combined CPUE Alaska Fishery |
low |
low |
low |
low |
low |
Annual Sablefish Pot CPUE Alaska Fishery |
neutral |
neutral |
neutral |
high |
high |
|
Annual Sablefish Incidental Catch GOA Fishery |
neutral |
neutral |
high |
high |
high |
|
Annual Sablefish Incidental Catch BSAI Fishery |
neutral |
neutral |
neutral |
high |
high |
|
Annual Sablefish Condition Female Adult GOA Fishery |
neutral |
neutral |
neutral |
neutral |
high |
|
Annual Sablefish Condition Female Adult BSAI Fishery |
neutral |
NA |
NA |
NA |
NA |
|
Economic |
Annual Sablefish Real Exvessel Value Fishery |
neutral |
neutral |
neutral |
low |
low |
Annual Sablefish Real Exvessel Price Fishery |
neutral |
high |
neutral |
neutral |
low |