https://newgraphenvironment.github.io/fish_passage_moti_2022_reporting/
Reporting for effectiveness monitoring conducted on behalf of the Ministry of Transportation and Infrastructure at three sites in northern British Columbia. Sites included:
-
Cross Creek in the Babine Lake watershed group
-
Bittner Creek
-
5-Mile Creek
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 and sqlite databases. Raw data inputs for this project included:
-
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.