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 2020. 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 from Rmarkdown with primarily R and SQL scripts. In addition to numerous spatial layers sourced through the BC Data Catalogue then stored and queried in local postgresql database, data inputs for this project include:
-
Populated Fish Data Submission Spreadsheet Template - V 2.0, January 20, 2020
-
Populated pscis_assessment_template_v24.xls
-
Fish Habitat Model/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