search

utah-geological-survey / gwp_cloud_db

Guidelines and issues for uploading and managing data uploads to the GWP cloud database
GNU General Public License v3.0
0 stars 0 forks source link

Database structure- possible new processing table #8

Open wetlandsDiane opened 2 weeks ago

wetlandsDiane commented 2 weeks ago

Processing table would be one row per transduce file

  1. unique ID to link to readings table (or locationid + datetime); Diane strongly prefers unique ID
  2. drift parameters or NA if not estimated
  3. quality measure
  4. status approved vs. preliminary; at minimum approved should go through a few QA/QC routines and manual inspection of a graph; if some bad manual measurements at end, likely should wait until better manual measurements at end before making approved
  5. process person ID
  6. process used (maybe software version or something?)

Can create a new function to generate this info, using the drift_info table that comes out of logger loader, which already has drift and quality estimates. Could add unique ID to both row and readings data as part of Drifting function and then add in status, process personn ID and process used as part of a function