search

NewGraphEnvironment / fish_passage_fraser_2023_reporting

https://newgraphenvironment.github.io/fish_passage_fraser_2023_reporting/
Creative Commons Zero v1.0 Universal
0 stars 1 forks source link

Plan for Nechako region #5

Open NewGraphEnvironment opened 9 months ago

NewGraphEnvironment commented 9 months ago

Add a couple details of what we are doing here and why please @newgraph-lschick

push progress to repo daily or work through issues/barriers to progress here

R component QGIS component

https://github.com/NewGraphEnvironment/fish_passage_fraser_2023_reporting/blob/main/scripts/extract_planning.R

lucy-schick commented 9 months ago

My recent updates for https://github.com/NewGraphEnvironment/fish_passage_fraser_2023_reporting/blob/main/scripts/extract_planning.R are here 9393a0b2692b5221007483141180b31f46bfcfb0. Will keep pushing my edits and make a PR soon

lucy-schick commented 9 months ago

extract_planning.R combines bcfishpass crossings data with PSCIS data for the fraser region, filters to only contain sites that meet our criteria, selects applicable columns, and produces a geopackge . This geopackage contains a layer which shows all the sites that potentially need further assessment. Using this layer along with others, we can prioritize which crossings require further assessment.

NewGraphEnvironment commented 9 months ago

extract_planning.R combines bcfishpass crossings data with PSCIS data for the fraser region, filters to only contain sites that meet our criteria, selects applicable columns, and produces a geopackge . This geopackage contains a layer which shows all the sites that potentially need further assessment. Using this layer along with others, we can prioritize which crossings require further assessment.

some clarification:

extract_planning.R combines whse_fish.pscis_assessment_svw with bcfishpass.crossings to do two things:

  1. flag sites that meet a specific criteria
  2. provide data that aids in review to help plan about which sites to follow up first with both phase 1 and phase 2 assessments (ex. how big is the culvert outlet drop, what do the photos submitted to PSCIS show us..., etc.).

No filtering of sites occurs in this file as it can be completed in QGIS - allowing input of priority rankings and additional information (ex. background info, citation keys to relevant documents, notes that sites have been added to csvs in bcfishpass etc.) to sites that weren't flagged (there are multiple reasons that can happen).

Worth noting that all of this joining and filtering can be done in QGIS but doing it in R creates a reproducable workflow that tracks how it was done and more easily allows iterative changes to the planning over time (ie. redo the flagging of my_review column after field data is loaded to province PSCIS portal.

Also worth noting that we are currently out of sync with a fully rational workflow b/c the field data for many sites is already collected but not yet loaded to provincial PSCIS portal. Just getting last of the prep completed so that Schick has what she will need to finalize that PSCIS submission and re-submit