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.

Traffic light scores

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
)
Traffic light scoring

Indicator category

Indicator

2020 Status

Larval_YOY

Annual Heatwave GOA Model

neutral

Spring Temperature Surface GOA Satellite

high

Spring Temperature Surface SEBS Satellite

high

Annual Eddy Kinetic Energy Amchitka Satellite

neutral

Spring Chlorophylla Biomass GOA Satellite

low

Spring Chlorophylla Biomass SEBS Satellite

neutral

Spring Chlorophylla Peak GOA Satellite

neutral

Annual Copepod Community Size EGOA Survey

neutral

Annual Copepod Community Size WGOA Survey

neutral

Annual Sablefish Size YOY Middleton Survey

neutral

Juvenile

Summer Sablefish CPUE Juvenile Nearshore GOAAI Survey

high

Summer Sablefish CPUE Juvenile GOA Survey

NA

Annual Small Sablefish Incidental Hauls EBS Fishery

high

Adult

Summer Temperature 250m GOA Survey

neutral

Summer Sablefish Condition Female Age4 GOA Survey

neutral

Summer Sablefish Condition Female Adult GOA Survey

neutral

Annual Sablefish Incidental Catch Arrowtooth Target GOA Fishery

neutral

Fishery Informed

Annual Sablefish Incidental Catch GOA Fishery

high

Annual Sablefish Incidental Catch BSAI Fishery

high

Annual Sablefish Condition Female Adult GOA Fishery

high

Economic

Annual Sablefish Retained Catch AK Fishery

neutral

Annual Sablefish Real Exvessel Price Fishery

low

Annual Sablefish TAC Utilization AK Fishery

high

Annual Sablefish Real Exvessel Value Fishery

low

Multiple years can be shown.

AKesp::esp_traffic_tab(
  data = dat,
  year = 2016:2020
)
Traffic light scoring

Indicator category

Indicator

2016 Status

2017 Status

2018 Status

2019 Status

2020 Status

Larval_YOY

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

Annual Eddy Kinetic Energy Amchitka Satellite

high

high

neutral

neutral

neutral

Spring Chlorophylla Biomass GOA Satellite

low

neutral

neutral

low

low

Spring Chlorophylla Biomass SEBS Satellite

neutral

low

neutral

neutral

neutral

Spring Chlorophylla Peak GOA Satellite

high

low

low

high

neutral

Annual Copepod Community Size EGOA Survey

neutral

neutral

neutral

low

neutral

Annual Copepod Community Size WGOA Survey

neutral

neutral

low

high

neutral

Annual Sablefish Size YOY Middleton Survey

high

neutral

neutral

neutral

neutral

Juvenile

Summer Sablefish CPUE Juvenile Nearshore GOAAI Survey

neutral

neutral

high

high

high

Summer Sablefish CPUE Juvenile GOA Survey

NA

high

NA

neutral

NA

Annual Small Sablefish Incidental Hauls EBS Fishery

neutral

high

neutral

neutral

high

Adult

Summer Temperature 250m GOA Survey

low

high

neutral

high

neutral

Summer Sablefish Condition Female Age4 GOA Survey

neutral

low

neutral

low

neutral

Summer Sablefish Condition Female Adult GOA Survey

neutral

low

neutral

neutral

neutral

Annual Sablefish Incidental Catch Arrowtooth Target GOA Fishery

neutral

high

high

high

neutral

Fishery Informed

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

Economic

Annual Sablefish Retained Catch AK Fishery

low

neutral

neutral

neutral

neutral

Annual Sablefish Real Exvessel Price Fishery

high

high

neutral

neutral

low

Annual Sablefish TAC Utilization AK Fishery

neutral

neutral

neutral

high

high

Annual Sablefish Real Exvessel Value Fishery

neutral

neutral

neutral

low

low