NewGraphEnvironment / fish_passage_bulkley_2022_reporting

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

Link sites to unique moTi ID and add to reporting #25

Closed NewGraphEnvironment closed 1 year ago

NewGraphEnvironment commented 1 year ago

perhaps we just make a new csv that has a xref_pscis_moti . Not sure if we even will be able to automate the joining of the culvert_id to the chris_culvert_id as our skeena mergin project may have been made from bcbarriers and therefor likely updated. Will confirm and document here.

NewGraphEnvironment commented 1 year ago

tiny join work to get the chris_culvert_id is now complete and was done here in this line https://github.com/NewGraphEnvironment/fish_passage_skeena_2022_reporting/blob/216ebbd3234506b2d1cef2a277ba1c3b09affb9e/scripts/pscis_tidy.R#L121

resulting csv is here https://github.com/NewGraphEnvironment/fish_passage_bulkley_2022_reporting/blob/main/data/dff/form_pscis_moti_20230511.csv