Cutthroat trout observations are showing up as NA because common names are different from fishbc

fish_passage_skeena_2022_reporting/scripts/tables.R

Lines 320 to 325 in 908c914

    
           hab_fish_collect_map_prep3 <- left_join( 
        
             hab_fish_collect_map_prep2 %>% 
        
               mutate(species = as.factor(species)),  ##just needed to do this b/c there actually are no fish. 
        
             select(hab_fish_codes, common_name, species_code), 
        
             by = c('species' = 'common_name')

The freshwaterfish table has "Cutthroat Trout" as common name, whereas the common name is "Cutthroat Trout (General)" in our hab con spreadsheet. So the join function above is resulting in NA for species code. I can just do a simple mutate and fix it. You mentioned there's a new template out in this related issue here. Wondering if they changed it and dropped the "General"

	hab_fish_collect_map_prep3 <- left_join(
	hab_fish_collect_map_prep2 %>%
	mutate(species = as.factor(species)), ##just needed to do this b/c there actually are no fish.

	select(hab_fish_codes, common_name, species_code),
	by = c('species' = 'common_name')