mergin tracking sern_simpcw_2023

[NewGraphEnvironment]

New issue to deal seperately with sern_simpcw_2023

v23 fix duplicate site name for what was erroneous duplicate 13905538 v24 sort and rename photos to site directories on mergin. assumes all photos were tracked in mergin field form which is not always the case.

[lucy-schick]

v25 - Cleaned form_pscis_2023, ready for QA now.

[lucy-schick]

V26 - QA half of the pscis sites. Second half coming tomorrow.

[NewGraphEnvironment]

v27 Update

sf::st_read("/Users/airvine/Projects/gis/sern_simpcw_2023/background_layers.gpkg", layer = "rfp_tracking")
#> Reading layer `rfp_tracking' from data source 
#>   `/Users/airvine/Projects/gis/sern_simpcw_2023/background_layers.gpkg' 
#>   using driver `GPKG'
#> Warning: no simple feature geometries present: returning a data.frame or tbl_df
#>          timestamp                                  content
#> 1 2024-06-25 07:23           whse_fish.pscis_assessment_svw
#> 2 2024-06-25 07:23      whse_fish.pscis_design_proposal_svw
#> 3 2024-06-25 07:23 whse_fish.pscis_habitat_confirmation_svw
#> 4 2024-06-25 07:23          whse_fish.pscis_remediation_svw
#> 5 2024-06-25 07:28    bcfishobs.fiss_fish_obsrvtn_events_vw
#> 6 2024-06-25 07:28                  bcfishpass.crossings_vw
#> 7 2024-06-25 07:28                    bcfishpass.streams_vw
#>                                                        watershed_groups
#> 1 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#> 2 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#> 3 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#> 4 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#> 5 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#> 6 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#> 7 'ADMS' 'MORK' 'UFRA' 'CANO' 'LNTH' 'UNTH' 'MURT' 'CLWR' 'CLRH' 'REVL'
#>                  source
#> 1 rfp_source_bcdata.txt
#> 2 rfp_source_bcdata.txt
#> 3 rfp_source_bcdata.txt
#> 4 rfp_source_bcdata.txt
#> 5    rfp_source_aws.txt
#> 6    rfp_source_aws.txt
#> 7    rfp_source_aws.txt
#>                                                                                                                                                                                                                                                                         description
#> 1                             This view defines the most current assessment for a stream crossing location. An assessment provides the field survey data required to determine whether a stream crossing requires remediation efforts in order to make it passable to fish habitat.
#> 2                                                                                                                      This view defines the stream crossing locations in which design proposals have been received to remediate a stream crossing that is defined as not passable.
#> 3 PSCIS_HABITAT_CONFIRMATION_SVW represents Habitat Confirmation of Stream Crossings. The Habitat Confirmation is carried out by a biologist who does an office and field review of the fish habitat to be potentially gained by remediation of an identified failed road crossing.
#> 4                                                                                                                                                                              This view defines all the stream crossing locations that have had remediation activities take place.
#> 5                                                                                                                                                                                                                                                                                  
#> 6                                                                                                                                                                                                                                                                                  
#> 7

^{Created on 2024-06-25 with reprex v2.1.0}

plus

path_gpkg <- "/Users/airvine/Projects/gis/sern_simpcw_2023/background_layers.gpkg"

layers_remove <- c("streams", "crossings", "fiss_fish_obsrvtn_events_vw")

purrr::map(layers_remove, ~ gdalraster::ogr_layer_delete(path_gpkg, .x))

[lucy-schick]

v28 - more pscis QA. Synching so I can get updated layers from v27 v29 - more pscis QA v30 - Finished QA v31 - couple more small QA edits

[NewGraphEnvironment]

v32 - add id_camera when missing . commit before running 01b_HACK_pscis_refresh.R v33 - reburn to project after cleaning with 01b_HACK_pscis_refresh.R