search

NewGraphEnvironment / dff-2022

Building digital field forms and processing data collected using R, postgresql, QGIS and other tools
Creative Commons Zero v1.0 Universal
0 stars 3 forks source link

change `Moti_id` in `form_pscis` to to `chris_culvert_id` #55

Closed NewGraphEnvironment closed 1 year ago

NewGraphEnvironment commented 1 year ago

need to fix all sites from 2022 field work. Important that Al does this before next bcdata bc2pg. Way to go is likely:

  1. pull list of moti_culvert_ids from joined pscis_forms
  2. select culvert_id, chris_culvet_id from culverts table in Al's local pg database
  3. left join moti_culvert_id = culvert_id
  4. burn out to csv for reporting
NewGraphEnvironment commented 1 year ago

this is done for form_pscis but not form_monitor. Hoping @Mateo9569 can update in qml then close