3 Methods
Workflows for the project have been classified into planning, fish passage assessments, habitat confirmation assessments, reporting and mapping. All components leveraged R, SQL or Python programming languages to facilitate workflow tracking, collaboration, transparency and continually improving research. Project workflows utilized local and remote postgreSQL databases as well as a “snapshot” of select datasets contained within a local sqlite database. A data and script repository to facilitate this reporting is located on Github.
source('scripts/packages.R')
source('scripts/tables.R')
# or the development version
# devtools::install_github("rstudio/bookdown")3.1 Collaborative GIS Environment
Geographical Information Systems are essential for developing and communicating restoration plans as well as the reasons they are required and how they are developed. Without the ability to visualize the landscape and the data that is used to make decisions it is difficult to conduct and communicate the need for restoration, the details of past and future plans as well as and the potential results of physical works.
To facilitate the planning and implementation of restoration activities a collaborative GIS environment has been established using QGIS served on the cloud using source code kept stored here. This environment is intended to be a space where project team members can access and view and contribute to the amalgamation of background spatial data and the development of restoration as well as monitoring for the project. The collaborative GIS environment allows users to view, edit, and analyze shared up to date spatial data on personal computers in an office setting as well as phones and tablets in the field. At the time of reporting, the environment was being used to develop and share maps, conduct spatial analyses, communicate restoration plans to stakeholders as well as to provide a central place to store methodologies and tools for conducting field assessments on standardized pre-developed digital forms. The platform can also be used to track the progress of restoration activities and monitor changes in the landscape over time helping encourage the record keeping of past and future restoration activities in a coordinated manner.
The shared QGIS project was created using scripts currently kept in
dff-2022 with the precise calls to project creation scripts tracked
in the project_creation_and_permissions.txt document kept in the main QGIS project directory. Information about how
GIS project creation and update scripts function can be viewed
here with outcomes of their use summarized
below:
- download and clip user specified layers from the BC Data Catalougue as well as data layers stored in custom Amazon Web Services buckets for an area of interest defined by a list of watershed groups and load to a geopackage called background_layers.gpkg stored in the main directory of the project.
- A project directory is created to hold the spatial data and QGIS project information (ie. layer symbology and naming conventions, metadata, etc.).
- Metadata for individual project spatial layers is kept in the rfp_tracking table within the background_layers.gpkg along with tables related to user supplied stream width/gradient inputs to bcfishpass to model potentially high value habitat that is accessible to fish species of interest.
3.1.1 Issue Tracking
“Issues” logged on the online github platform are effective ways to track tasks, enhancements, and bugs related to project components.
They can be referenced with the scripts, text and actions used to address them by linking documentation to the issues with text comments
or programatically through git commit messages. Issues for this project are kept here as well as past years repositories
which can be found by searches including the keywords “Skeena” and “Bulkley” here.
3.1.2 Habitat Modelling
bcfishpass calculates the average gradient of BC Freshwater Atlas stream network lines at minimum 100m long intervals starting from the downstream end of the streamline segment and working upstream. The network lines are broken into max gradient categories with new segments created if and when the average slope of the stream line segment exceeds user provided thresholds. For this project, the user provided gradient thresholds used to delineate “potentially accessible habitat” were based on estimated max gradients that salmon (15% - coho and chinook) and steelhead (20%) are likely to be capable of ascending.
Through this initiative and other SERN/New Graph led initiatives, the Provincial Fish Passage Remediation Program and connectivity restoration planning by the Canadian Wildlife Federation (Mazany-Wright et al. 2021), bcfishpass has been designed to prioritize potential fish passage barriers for assessment or remediation. The software is under continual development and has been designed and constructed by Norris ([2020] 2021) using sql and python based shell script libraries to generate a simple model of aquatic habitat connectivity. The model identifies natural barriers (ex. steep gradients for extended distances) and hydroelectric dams to classifying the accessibility upstream by fish (Norris [2020] 2021). On potentially accessible streams, scripts identify known barriers (ex. waterfalls >5m high) and additional anthropogenic features which are primarily road/railway stream crossings (i.e. culverts) that are potentially barriers. To prioritize these features for assessment or remediation, scripts report on how much modelled potentially accessible aquatic habitat the barriers may obstruct. The model can be refined with known fish observations upstream of identified barriers and for each crossing location, the area of lake and wetland habitat upstream, species documented upstream/downstream, an estimate of watershed area (on 2nd order and higher streams), mean annual precipitation weighted to upstream watershed area and channel width can be collated using bcfishpass, fwapg and bcfishobs. This, information, can be used to provides an indication of the potential quantity and quality of habitat potentially gained should fish passage be restored by comparing to user defined thresholds for the aforementioned parameters. A discussion of the methodology to derive channel width is below.
Gradient, channel size and stream discharge are key determinants of channel morphology and subsequently fish distribution. High value rearing, overwintering and spawning habitat preferred by numerous species/life stages of fish are often located within channel types that have relatively low gradients and large channel widths (also quantified by the amount of flow in the stream). Following delineation of “potentially accessible habitat”, the average gradient of each stream segment within habitat classified as below the 15% and 20% thresholds was calculated and summed within species and life stage specific gradient categories. Average gradient of stream line segments can be calculated from elevations contained in the provincial freshwater atlas streamline dataset. To obtain estimates of channel width upstream of crossing locations, Where available, bcfishpass was utilized to pull average channel gradients from Fisheries Information Summary System (FISS) site assessment data (MoE 2019b) or PSCIS assessment data (MoE 2021) and associate with stream segment lines. When both FISS and PSCIS values were associated with a particular stream segment, FISS channel width was used. When multiple FISS sites were associated with a particular stream segment a mean of the average channel widths was taken. To model channel width for 2nd order and above stream segments without associated FISS or PSCIS sites, first fwapg was used to estimate the drainage area upstream of the segment. Then, rasters from ClimateBC (Wang et al. 2012) were sampled for each stream segments and a mean annual precipitation weighted by upstream watershed area was calculated. Mean annual precipitation was then combined with the channel widths and BEC zone information (gathered through a spatial query tied to the bottom of the stream segment) into a dataset (n = 22990) for analysis fo the relationship between these variables. The details of this analysis and resulting formula used to estimate channel width on stream segments in the Skeena Watershed is included as a technical appendix here.
bcfishpass and associated tools have been designed to be flexible in analysis, accepting user defined gradient, channel width and stream discharge categories (MoE 2019b). Although currently in draft form, and subject to development revisions, gradient and channel width thresholds for habitat with the highest intrinsic value for a number of fish species in the Skeena watershed groups have been specified and applied to model habitat upstream of stream crossing locations with the highest intrinsic value (Table 3.1). Thresholds were derived based on a literature review with references provided in Table 3.2. Output parameters for modelling are presented in Table 3.3.
#`r if(identical(gitbook_on, FALSE)){knitr::asis_output("<br><br><br>")}`
bcfishpass_spawn_rear_model %>%
mutate(Species = fishbc::fbc_common_name(species_code),
spawn_gradient_max = round(spawn_gradient_max * 100 ,1),
rear_gradient_max = round(rear_gradient_max * 100 ,1)) %>%
select(Species,
`Spawning Gradient Max (%)`= spawn_gradient_max,
`Spawning Width Min (m)` = spawn_channel_width_min,
# `Spawning Width Max (m)` = spawn_channel_width_max,
# `Spawning MAD Min (m3/s)` = spawn_mad_min,
# `Spawning MAD Max (m3/s)` = spawn_mad_max,
`Rearing Gradient Max (%)` = rear_gradient_max,
`Rearing Width Min (m)` = rear_channel_width_min) %>%
# `Rearing MAD Min (m3/s)` = rear_mad_min,
# `Rearing MAD Max (m3/s)` = rear_mad_max,
# `Rearing Wetland Multiplier` = rear_wetland_multiplier,
# `Rearing Lake Multiplier` = rear_lake_multiplier) %>%
t() %>%
as_tibble(rownames = "row_names") %>%
janitor::row_to_names(row_number = 1) %>%
rename(Variable = Species) %>%
select(-`Westslope Cutthroat Trout`,
-`Arctic Grayling`,
-`Kokanee`,
-`Bull Trout`,
-`Rainbow Trout`) %>%
fpr::fpr_kable(caption_text = 'Stream gradient and channel width thresholds used to model potentially highest value fish habitat.', scroll = F)| Variable | Chinook Salmon | Chum Salmon | Coho Salmon | Pink Salmon | Sockeye Salmon | Steelhead |
|---|---|---|---|---|---|---|
| Spawning Gradient Max (%) | 4.5 | 6.5 | 5.5 | 6.5 | 2.5 | 4.5 |
| Spawning Width Min (m) | 4.0 | 2.1 | 2.0 | 2.1 | 2.0 | 4.0 |
| Rearing Gradient Max (%) | 5.5 | – | 5.5 | – | – | 8.5 |
| Rearing Width Min (m) | 1.5 | – | 1.5 | – | 1.5 | 1.5 |
bcfishpass_spawn_rear_model %>%
# remove arctic grayling and kokannee for this study area
dplyr::filter(species_code %in% c("BT", "CH", "CO", "ST")) %>%
mutate(Species = fishbc::fbc_common_name(species_code),
# for spawn_gradient_max and rear_gradient_max multiply by 100 and round to 1 digit)
spawn_gradient_max = round(spawn_gradient_max * 100 ,1),
rear_gradient_max = round(rear_gradient_max * 100 ,1)) |>
select(Species,
`Spawning Gradient Max (%)`= spawn_gradient_max,
`Spawning Width Min (m)` = spawn_channel_width_min,
# `Spawning Width Max (m)` = spawn_channel_width_max_ref,
# `Spawning MAD Min (m3/s)` = spawn_mad_min,
# `Spawning MAD Max (m3/s)` = spawn_mad_max,
`Rearing Gradient Max (%)` = rear_gradient_max) %>%
# `Rearing Wetland Multiplier` = rear_wetland_multiplier,
# `Rearing Lake Multiplier` = rear_lake_multiplier) %>%
# `Rearing MAD Min (m3/s)` = rear_mad_min,
# `Rearing MAD Max (m3/s)` = rear_mad_max) %>%
t() %>%
as_tibble(rownames = "row_names") |>
janitor::row_to_names(row_number = 1) |>
rename(Variable = Species) %>%
fpr::fpr_kable(caption_text = 'References for stream gradient and channel width thresholds used to model potentially highest value fish habitat. Preliminary and subject to revisions.', scroll = F)| Variable | Bull Trout | Chinook Salmon | Coho Salmon | Steelhead |
|---|---|---|---|---|
| Spawning Gradient Max (%) | 5.5 | 4.5 | 5.5 | 4.5 |
| Spawning Width Min (m) | 2 | 4 | 2 | 4 |
| Rearing Gradient Max (%) | 10.5 | 5.5 | 5.5 | 8.5 |
xref_bcfishpass_names %>%
filter(id_side == 1) %>%
arrange(id_join) %>%
select(Attribute = report, Definition = column_comment) %>%
fpr::fpr_kable(caption_text = 'bcfishpass outputs and associated definitions',
footnote_text = 'Steelhead model uses a gradient threshold of maximum 20% to determine if access if likely possible',
scroll = gitbook_on)| Attribute | Definition |
|---|---|
| ST Network (km) | Steelhead model, total length of stream network potentially accessible upstream of point |
| ST Lake Reservoir (ha) | Steelhead model, total area lakes and reservoirs potentially accessible upstream of point |
| ST Wetland (ha) | Steelhead model, total area wetlands potentially accessible upstream of point |
| ST Slopeclass03 Waterbodies (km) | Steelhead model, length of stream connectors (in waterbodies) potentially accessible upstream of point with slope 0-3% |
| ST Slopeclass03 (km) | Steelhead model, length of stream potentially accessible upstream of point with slope 0-3% |
| ST Slopeclass05 (km) | Steelhead model, length of stream potentially accessible upstream of point with slope 3-5% |
| ST Slopeclass08 (km) | Steelhead model, length of stream potentially accessible upstream of point with slope 5-8% |
| ST Spawning (km) | Length of stream upstream of point modelled as potential Steelhead spawning habitat |
| ST Rearing (km) | Length of stream upstream of point modelled as potential Steelhead rearing habitat |
| CH Spawning (km) | Length of stream upstream of point modelled as potential Chinook spawning habitat |
| CH Rearing (km) | Length of stream upstream of point modelled as potential Chinook rearing habitat |
| CO Spawning (km) | Length of stream upstream of point modelled as potential Coho spawning habitat |
| CO Rearing (km) | Length of stream upstream of point modelled as potential Coho rearing habitat |
| CO Rearing (ha) | Area of wetlands upstream of point modelled as potential Coho rearing habitat |
| SK Spawning (km) | Length of stream upstream of point modelled as potential Sockeye spawning habitat |
| SK Rearing (km) | Length of stream upstream of point modelled as potential Sockeye rearing habitat |
| SK Rearing (ha) | Area of lakes upstream of point modelled as potential Sockeye rearing habitat |
| * Steelhead model uses a gradient threshold of maximum 20% to determine if access if likely possible |
#to quantify upstream habitat potentially available for salmonids and facilitate stream line symbology based on stream morphology.
# while high gradient sections typically present upstream migration barriers and less available habitat. Additionally, the size of the stream (indicated by channel width) is an important determinant for habitat suitability for different species as well as specific life stages of those species.
# `bcfishpass` was used to categorize and sum potentially accessible stream segments in the study area watersheds within gradient and width categories for each stream segment.
# (0 - 3%, 3 - 5%, 5 - 8%, 8 - 15%, 15 - 20%) with these outputs further amalgamated to summarize and symbolize potential upstream habitat in three categories: riffle/cascade (0 - 5%), step-pool (5 - 15%) and step-pool very steep (15-20%) (Table \@ref(tab:tablethreshaverage)).
#threshold and average gradient table
table_thresh_average <- tibble::tibble(`Gradient` = c('0 - 5%', '5 - 15%', '15 - 20%', '>20%'),
`Channel Type` = c('Riffle and cascade pool', 'Step pool', 'Step pool - very steep', 'Non fish habitat'))
table_thresh_average %>%
fpr::fpr_kable(caption_text = 'Stream gradient categories (threshold and average) and associated channel type.')3.2 Fish Passage Assessments
In the field, crossings prioritized for follow-up were first assessed for fish passage following the procedures outlined in “Field Assessment for Determining Fish Passage Status of Closed Bottomed Structures” (BC Ministry of Environment 2011). Crossings surveyed included closed bottom structures (CBS), open bottom structures (OBS) and crossings considered “other” (i.e. fords). Photos were taken at surveyed crossings and when possible included images of the road, crossing inlet, crossing outlet, crossing barrel, channel downstream and channel upstream of the crossing and any other relevant features. The following information was recorded for all surveyed crossings: date of inspection, crossing reference, crew member initials, Universal Transverse Mercator (UTM) coordinates, stream name, road name and kilometer, road tenure information, crossing type, crossing subtype, culvert diameter or span for OBS, culvert length or width for OBS. A more detailed “full assessment” was completed for all closed bottom structures and included the following parameters: presence/absence of continuous culvert embedment (yes/no), average depth of embedment, whether or not the culvert bed resembled the native stream bed, presence of and percentage backwatering, fill depth, outlet drop, outlet pool depth, inlet drop, culvert slope, average downstream channel width, stream slope, presence/absence of beaver activity, presence/absence of fish at time of survey, type of valley fill, and a habitat value rating. Habitat value ratings were based on channel morphology, flow characteristics (perennial, intermittent, ephemeral), fish migration patterns, the presence/absence of deep pools, un-embedded boulders, substrate, woody debris, undercut banks, aquatic vegetation and overhanging riparian vegetation (Table 3.4). For crossings determined to be potential barriers or barriers based on the data (see Barrier Scoring), a culvert fix and recommended diameter/span was proposed.
fpr_table_habvalue %>%
knitr::kable(caption = 'Habitat value criteria (Fish Passage Technical Working Group, 2011).', booktabs = T) %>%
kableExtra::column_spec(column = 1, width_min = '1.5in') %>%
kableExtra::kable_styling(c("condensed"), full_width = T, font_size = font_set) | Habitat Value | Fish Habitat Criteria |
|---|---|
| High | The presence of high value spawning or rearing habitat (e.g., locations with abundance of suitably sized gravels, deep pools, undercut banks, or stable debris) which are critical to the fish population. |
| Medium | Important migration corridor. Presence of suitable spawning habitat. Habitat with moderate rearing potential for the fish species present. |
| Low | No suitable spawning habitat, and habitat with low rearing potential (e.g., locations without deep pools, undercut banks, or stable debris, and with little or no suitably sized spawning gravels for the fish species present). |
3.2.1 Barrier Scoring
Fish passage potential was determined for each stream crossing identified as a closed bottom structure as per BC Ministry of Environment (2011). The combined scores from five criteria: depth and degree to which the structure is embedded, outlet drop, stream width ratio, culvert slope, and culvert length were used to screen whether each culvert was a likely barrier to some fish species and life stages (Table 3.6, Table 3.7. These criteria were developed based on data obtained from various studies and reflect an estimation for the passage of a juvenile salmon or small resident rainbow trout (Clarkin et al. 2005 ; Bell 1991; Thompson 2013).
tab <- as_tibble(t(fpr_table_barrier_scoring)) %>%
mutate(V4 = names(fpr_table_barrier_scoring)) %>%
select(V4, everything()) %>%
janitor::row_to_names(1) %>% ##turn the table sideways
mutate(Risk = case_when(Risk == 'Value' ~ ' Value',
T ~ Risk))
tab %>%
fpr::fpr_kable(caption_text = 'Fish Barrier Risk Assessment (MoE 2011).', scroll = F)| Risk | LOW | MOD | HIGH |
|---|---|---|---|
| Embedded | >30cm or >20% of diameter and continuous | <30cm or 20% of diameter but continuous | No embedment or discontinuous |
| Value | 0 | 5 | 10 |
| Outlet Drop (cm) | <15 | 15-30 | >30 |
| Value | 0 | 5 | 10 |
| SWR | <1.0 | 1.0-1.3 | >1.3 |
| Value | 0 | 3 | 6 |
| Slope (%) | <1 | 1-3 | >3 |
| Value | 0 | 5 | 10 |
| Length (m) | <15 | 15-30 | >30 |
| Value | 0 | 3 | 6 |
fpr_table_barrier_result %>%
fpr::fpr_kable(caption_text = 'Fish Barrier Scoring Results (MoE 2011).', scroll = F) | Cumlative Score | Result |
|---|---|
| 0-14 | passable |
| 15-19 | potential barrier |
| >20 | barrier |
3.2.2 Cost Benefit Analysis
A cost benefit analysis was conducted for each crossing determined to be a barrier based on an estimate of cost associated with remediation or replacement of the crossing with a structure that facilitates fish passage and the amount of potential habitat that would be made available by remediating fish passage at the site (habitat gain index).
3.2.2.1 Habitat Gain Index
The habitat gain index is the quantity of modelled habitat upstream of the subject crossing and represents an estimate of habitat gained with remediation of fish passage at the crossing. For this project, a gradient threshold between accessible and non-accessible habitat was set at 20% (for a minimimum length of 100m) intended to represent the maximum gradient of which the strongest swimmers of anadromous species (steelhead) are likely to be able to migrate upstream.
For reporting of Phase 1 - fish passage assessments within the body of this report (Table 3.6), a “total” value of habitat <20% output from bcfishpass was used to estimate the amount of habitat upstream of each crossing less than 20% gradient before a falls of height >5m - as recorded in MoE (2020) or documented in other bcfishpass online documentation. For Phase 2 - habitat confirmation sites, conservative estimates of the linear quantity of habitat to be potentially gained by fish passage restoration, steelhead rearing maximum gradient threshold (7.4%) was used. To generate areas of habitat upstream, the estimated linear length was multiplied by half the downstream channel width measured (overall triangular channel shape) as part of the fish passage assessment protocol. Although these estimates are not generally conservative, have low accuracy and do not account for upstream stream crossing structures they allow a rough idea of the best candidates for follow up.
Potential options to remediate fish passage were selected from BC Ministry of Environment (2011) and included:
- Removal (RM) - Complete removal of the structure and deactivation of the road.
- Open Bottom Structure (OBS) - Replacement of the culvert with a bridge or other open bottom structure. Based on consultation with FLNR road crossing engineering experts, for this project we considered bridges as the only viable option for OBS type .
- Streambed Simulation (SS) - Replacement of the structure with a streambed simulation design culvert. Often achieved by embedding the culvert by 40% or more. Based on consultation with FLNR engineering experts, we considered crossings on streams with a channel width of <2m and a stream gradient of <8% as candidates for replacement with streambed simulations.
- Additional Substrate Material (EM) - Add additional substrate to the culvert and/or downstream weir to embed culvert and reduce overall velocity/turbulence. This option was considered only when outlet drop = 0, culvert slope <1.0% and stream width ratio < 1.0.
- Backwater (BW) - Backwatering of the structure to reduce velocity and turbulence. This option was considered only when outlet drop < 0.3m, culvert slope <2.0%, stream width ratio < 1.2 and stream profiling indicates it would be effective..
Cost estimates for structure replacement with bridges and embedded culverts were generated based on the channel width, slope of the culvert, depth of fill, road class and road surface type. Road details were sourced from FLNRORD (2020b) and FLNRORD (2020a) through bcfishpass. Interviews with Phil MacDonald, Engineering Specialist FLNR - Kootenay, Steve Page, Area Engineer - FLNR - Northern Engineering Group and Matt Hawkins - MoTi - Design Supervisor for Highway Design and Survey - Nelson were utilized to helped refine estimates.
Base costs for installation of bridges on forest service roads and permit roads with surfaces specified in provincial GIS road layers as rough and loose was estimated at $25000/linear m and assumed that the road could be closed during construction and a minimum bridge span of 15m. For streams with channel widths <2m, embedded culverts were reported as an effective solution with total installation costs estimated at $50k/crossing (pers. comm. Phil MacDonald, Steve Page) adjusted for inflation. For larger streams (>6m), span width increased proportionally to the size of the stream (ex. for an 8m wide stream a 12m wide span was prescribed). For crossings with large amounts of fill (>3m), the replacement bridge span was increased by an additional 3m for each 1m of fill >3m to account for cutslopes to the stream at a 1.5:1 ratio. To account for road type, a multiplier table was also generated to estimate incremental cost increases with costs estimated for structure replacement on paved surfaces, railways and arterial/highways costing up to 20 times more than forest service roads due to expenses associate with design/engineering requirements, traffic control and paving. The cost multiplier table (Table 3.8) should be considered very approximate with refinement recommended for future projects.
tab_cost_rd_mult_report %>%
fpr::fpr_kable(caption_text = 'Cost multiplier table based on road class and surface type.', scroll = F)| Class | Surface | Class Multiplier | Surface Multiplier | Bridge $K/10m | Streambed Simulation $K |
|---|---|---|---|---|---|
| FSR | Rough | 1 | 1 | 300 | 100 |
| FSR | Loose | 1 | 1 | 300 | 100 |
| Resource | Loose | 1 | 1 | 300 | 100 |
| Permit | Unknown | 1 | 1 | 300 | 100 |
| Permit | Loose | 1 | 1 | 300 | 100 |
| Unclassified | Loose | 1 | 1 | 300 | 100 |
| Unclassified | Rough | 1 | 1 | 300 | 100 |
| Unclassified | Paved | 1 | 2 | 500 | 150 |
| Unclassified | Unknown | 1 | 2 | 500 | 150 |
| Local | Loose | 4 | 1 | 1000 | 200 |
| Local | Paved | 4 | 2 | 2000 | 400 |
| Arterial | Paved | 15 | 2 | 7500 | 1500 |
| Highway | Paved | 15 | 2 | 7500 | 1500 |
| Rail | Rail | 15 | 2 | 7500 | 1500 |
3.3 Climate Change Risk Assessment
In collaboration with the Ministry of Transportation and Infrastructure (MoTi), a new climate change replacement program aims to prioritize vulnerable culverts for replacement (pers. comm Sean Wong, 2022) based on data collected and ranked related to three categories - culvert condition, vulnerability and priority. Within the “condition” risk category - data was collected and crossings were ranked based on erosion, embankment and blockage issues. The “climate” risk category included ranked assessments of the likelihood of both a flood event affecting the culvert as well as the consequence of a flood event affecting the culvert. Within the “priority” category the following factors were ranked - traffic volume, community access, cost, constructability, fish bearing status and environmental impacts (Table 3.9). This project is still in its early stages with methodology changes likely going forward.
xref_moti_climate_names %>%
slice(7:nrow(xref_moti_climate_names)) %>%
select(spdsht, report) %>%
rename(Parameter = spdsht, Description = report) %>%
fpr::fpr_kable(caption_text = 'Climate change data collected at MoTi culvert sites', scroll = gitbook_on)| Parameter | Description |
|---|---|
| erosion_issues | Erosion (scale 1 low - 5 high) |
| embankment_fill_issues | Embankment fill issues 1 (low) 2 (medium) 3 (high) |
| blockage_issues | Blockage Issues 1 (0-30%) 2 (>30-75%) 3 (>75%) |
| condition_rank | Condition Rank = embankment + blockage + erosion |
| condition_notes | Describe details and rational for condition rankings |
| likelihood_flood_event_affecting_culvert | Likelihood Flood Event Affecting Culvert (scale 1 low - 5 high) |
| consequence_flood_event_affecting_culvert | Consequence Flood Event Affecting Culvert (scale 1 low - 5 high) |
| climate_change_flood_risk | Climate Change Flood Risk (likelihood x consequence) 1-6 (low) 6-12 (medium) 10-25 (high) |
| vulnerability_rank | Vulnerability Rank = Condition Rank + Climate Rank |
| climate_notes | Describe details and rational for climate risk rankings |
| traffic_volume | Traffic Volume 1 (low) 5 (medium) 10 (high) |
| community_access | Community Access - Scale - 1 (high - multiple road access) 5 (medium - some road access) 10 (low - one road access) |
| cost | Cost (scale: 1 high - 10 low) |
| constructability | Constructibility (scale: 1 difficult -10 easy) |
| fish_bearing | Fish Bearing 10 (Yes) 0 (No) - see maps for fish points |
| environmental_impacts | Environmental Impacts (scale: 1 high -10 low) |
| priority_rank | Priority Rank = traffic volume + community access + cost + constructability + fish bearing + environmental impacts |
| overall_rank | Overall Rank = Vulnerability Rank + Priority Rank |
| priority_notes | Describe details and rational for priority rankings |
3.4 Habitat Confirmation Assessments
Following fish passage assessments, habitat confirmations were completed in accordance with procedures outlined in the document “A Checklist for Fish Habitat Confirmation Prior to the Rehabilitation of a Stream Crossing” (Fish Passage Technical Working Group 2011). The main objective of the field surveys was to document upstream habitat quantity and quality and to determine if any other obstructions exist above or below the crossing. Habitat value was assessed based on channel morphology, flow characteristics (perennial, intermittent, ephemeral), the presence/absence of deep pools, un-embedded boulders, substrate, woody debris, undercut banks, aquatic vegetation and overhanging riparian vegetation. Criteria used to rank habitat value was based on guidelines in Fish Passage Technical Working Group (2011) (Table 3.4).
During habitat confirmations, to standardize data collected and facilitate submission of the data to provincial databases, information was collected on “Site Cards”. Habitat characteristics recorded included channel widths, wetted widths, residual pool depths, gradients, bankfull depths, stage, temperature, conductivity, pH, cover by type, substrate and channel morphology (among others). When possible, the crew surveyed downstream of the crossing to the point where fish presence had been previously confirmed and upstream to a minimum distance of 600m. Any potential obstacles to fish passage were inventoried with photos, physical descriptions and locations recorded on site cards. Surveyed routes were recorded with time-signatures on handheld GPS units.
Fish sampling was conducted on a subset of sites when biological data was considered to add significant value to the physical habitat assessment information. When possible, electrofishing was utilized within discrete site units both upstream and downstream of the subject crossing with electrofisher settings, water quality parameters (i.e. conductivity, temperature and ph), start location, length of site and wetted widths (average of a minimum of three) recorded. For each fish captured, fork length and species was recorded, with results included within the fish data submission spreadsheet. Fish information and habitat data will be submitted to the province under scientific fish collection permit CB20-611971.
3.5 Reporting
Reporting was generated with bookdown (Yihui [2015] 2024) from Rmarkdown (Allaire et al. [2014] 2023) with primarily R (R Core Team 2022) and SQL scripts. The R package fpr contains many specialized custom functions related to the work (Allan Irvine [2022] 2022). In addition to numerous spatial layers sourced through the BC Data Catalogue then stored and queried in a local postgresql and sqlite databases data inputs for this project include:
Populated Fish Data Submission Spreadsheet Template - V 2.0, January 20, 2020
Populated pscis_assessment_template_v24.xls
bcfishpassoutputs.Custom CSV file detailing Phase 2 site:
- priority level for proceeding to design for replacement
- length of survey upstream and downstream
- a conservative estimate of the linear length of mainstem habitat potentially available upstream of the crossing
- fish species confirmed as present upstream of the crossing
GPS tracks from field surveys.
Photos and photo metadata
Version changes are tracked here and issues/planned enhancements tracked here.
3.6 Mapping
Mapping was completed by Hillcrest Geographics. pdf maps were generated using QGIS with data supplied via a postgreSQL database. A QGIS layer file defining and symbolizing all layers required for general fish passage mapping was developed and at the time of reporting was kept under version control within bcfishpass.