The repository builds an interactive report documenting planning, fish passage assessments and habitat confirmation assessments at road-stream crossings within the Bulkley River and Morice River watershed groups in the summer/fall of 2021. The report will also provide planning inputs for fish passage/fisheries assessments as well as restoration activities in both watersheds in coming years.
Reporting was generated with bookdown
[@bookdown2016] from Rmarkdown
[@R-rmarkdown] with primarily R
and SQL
scripts. The R
package fpr
contains many specialized custom functions related to the work. 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
-
bcfishpass
outputs. -
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.