Appendix - Fish Species by Watershed Group

Historical fish observations recorded in the watershed groups covered by this project (MoE 2024a). Each watershed group has its own column.

fiss_species_table <- readr::read_csv('data/inputs_extracted/fiss_species_table.csv',
                                      show_col_types = FALSE)

# Build the caption from the watershed-group columns actually present in the
# cached extract, NOT from params/wsg_names. If the extract is refreshed with
# different coverage the caption follows it, so the table cannot claim
# watershed groups the data does not contain.
cols_meta <- c("Scientific Name", "Species Name", "BC List", "COSEWIC")
wsg_in_table <- setdiff(names(fiss_species_table), cols_meta)

my_caption <- paste0(
  "Fish species recorded in the ",
  knitr::combine_words(wsg_in_table),
  " watershed groups."
)

my_footnote <- 'COSEWIC abbreviations :
                 SC - Special concern
                 DD - Data deficient
                 NAR - Not at risk
                 E - Endangered
                 T - Threatened

                 BC List definitions :
                 Yellow - Species that is apparently secure
                 Blue - Species that is of special concern
                 Exotic - Species that have been moved beyond their natural range as a result of human activity
                 '

# One column per watershed group is too wide for paged.js, so the PDF branch
# collapses presence into a single comma-separated column. One wide source of
# truth, pivoted only where it has to be.
tab_fiss_species <- if (isTRUE(gitbook_on)) {
  fiss_species_table
} else {
  fiss_species_table |>
    tidyr::pivot_longer(dplyr::all_of(wsg_in_table),
                        names_to = "wsg", values_to = "present") |>
    dplyr::filter(!is.na(present), trimws(as.character(present)) != "", present != "-") |>
    dplyr::group_by(dplyr::across(dplyr::all_of(cols_meta))) |>
    dplyr::summarise(`Present in WSGs` = paste(sort(unique(wsg)), collapse = ", "),
                     .groups = "drop")
}

tab_fiss_species |>
  fpr::fpr_kable(caption_text = my_caption,
                 footnote_text = my_footnote,
                 scroll = gitbook_on)

Table 5.2: Fish species recorded in the Francois Lake, Lower Chilako, Lower Salmon, Morkill, Nechako, Tabor, Upper Fraser, and Willow watershed groups.

Scientific Name	Species Name	BC List	COSEWIC	Francois Lake	Lower Chilako	Lower Salmon	Morkill	Nechako	Tabor	Upper Fraser	Willow
Acipenser transmontanus	White Sturgeon	No Status	E/T (Nov 2012)	Yes	Yes	–	Yes	Yes	Yes	–	–
Carassius auratus	Goldfish	Exotic	–	–	Yes	–	–	–	–	–	–
Catostomus bondi	Northern Mountain Sucker	Blue	T (Dec 2022)	–	Yes	–	–	–	–	–	–
Catostomus catostomus	Longnose Sucker	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Catostomus columbianus	Bridgelip Sucker	Yellow	–	Yes	–	Yes	–	Yes	Yes	–	–
Catostomus commersonii	White Sucker	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
Catostomus macrocheilus	Largescale Sucker	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
Chrosomus neogaeus	Finescale Dace	Yellow	–	Yes	–	–	–	–	–	–	–
Coregonus clupeaformis	Lake Whitefish	Yellow	–	Yes	Yes	Yes	–	Yes	–	–	Yes
Cottus asper	Prickly Sculpin	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
Cottus cognatus	Slimy Sculpin	Yellow	–	Yes	Yes	–	Yes	Yes	Yes	Yes	Yes
Cottus ricei	Spoonhead Sculpin	Yellow	NAR (May 1989)	Yes	–	–	–	–	–	Yes	–
Couesius plumbeus	Lake Chub	Yellow	DD	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Cyprinus carpio	Carp	Exotic	–	Yes	–	–	–	–	–	–	–
Hybognathus hankinsoni	Brassy Minnow	No Status	–	Yes	Yes	Yes	–	Yes	Yes	–	Yes
Lota lota	Burbot	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Micropterus salmoides	Largemouth Bass	Exotic	–	–	–	–	–	Yes	–	–	–
Mylocheilus caurinus	Peamouth Chub	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
Oncorhynchus clarkii	Cutthroat Trout	No Status	–	Yes	–	–	–	–	–	–	Yes
Oncorhynchus gorbuscha	Pink Salmon	Not Reviewed	–	–	Yes	Yes	–	–	–	–	Yes
Oncorhynchus kisutch	Coho Salmon	Not Reviewed	–	Yes	Yes	–	–	Yes	–	–	Yes
Oncorhynchus mykiss	Rainbow Trout	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Oncorhynchus mykiss	Steelhead	Yellow	–	–	–	–	Yes	–	–	–	–
Oncorhynchus nerka	Kokanee	Not Reviewed	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Oncorhynchus nerka	Sockeye Salmon	Not Reviewed	–	Yes	Yes	–	Yes	Yes	–	Yes	–
Oncorhynchus tshawytscha	Chinook Salmon	Not Reviewed	E/T/SC/DD/NAR (Nov 2020)	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Prosopium coulterii	Pygmy Whitefish	Yellow	NAR (Nov 2016)	–	Yes	–	–	Yes	Yes	Yes	Yes
Prosopium cylindraceum	Round Whitefish	Yellow	–	–	–	–	Yes	–	–	–	–
Prosopium williamsoni	Mountain Whitefish	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Ptychocheilus oregonensis	Northern Pikeminnow	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
Rhinichthys cataractae	Longnose Dace	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Rhinichthys falcatus	Leopard Dace	Yellow	NAR (May 1990)	Yes	Yes	Yes	–	Yes	Yes	–	Yes
Richardsonius balteatus	Redside Shiner	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
Salvelinus confluentus	Anadromous Bull Trout	Blue	SC (Nov 2012)	–	–	–	–	Yes	–	–	–
Salvelinus confluentus	Bull Trout	Blue	SC (Nov 2012)	Yes	Yes	–	Yes	Yes	Yes	Yes	Yes
Salvelinus fontinalis	Brook Trout	Exotic	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	–
Salvelinus malma	Dolly Varden	Yellow	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
Salvelinus namaycush	Lake Trout	Yellow	–	Yes	Yes	–	Yes	Yes	Yes	Yes	Yes
–	All Salmon	–	–	–	Yes	–	–	–	–	–	–
–	Arctic Char	–	–	–	–	–	–	–	–	–	Yes
–	Char, General	–	–	–	–	–	–	–	–	Yes	–
–	Chub (General)	–	–	Yes	Yes	Yes	–	Yes	–	–	Yes
–	Dace (General)	–	–	Yes	Yes	Yes	–	Yes	Yes	–	–
–	Lamprey (General)	–	–	–	–	Yes	–	–	–	–	–
–	Minnow (General)	–	–	Yes	Yes	Yes	Yes	Yes	Yes	–	Yes
–	Northern Pearl Dace	–	–	Yes	–	–	–	–	–	–	–
–	Salmon (General)	–	–	–	Yes	–	Yes	–	–	Yes	Yes
–	Sculpin (General)	–	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
–	Stickleback (General)	–	–	–	–	–	–	–	Yes	–	–
–	Sucker (General)	–	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
–	Whitefish (General)	–	–	Yes	Yes	Yes	Yes	Yes	Yes	Yes	Yes
* COSEWIC abbreviations : SC - Special concern DD - Data deficient NAR - Not at risk E - Endangered T - Threatened BC List definitions : Yellow - Species that is apparently secure Blue - Species that is of special concern Exotic - Species that have been moved beyond their natural range as a result of human activity