USGS-R / WQ-Review

Toolbox for discrete water-quality data review and exploration.
11 stars 4 forks source link

QAQC being coded incorrectly in pull from WQReview compared to database #186

Open lrking0530 opened 1 year ago

lrking0530 commented 1 year ago

Data was pulled and a QAQC sample was coded as a blank in the file from WQReview but was coded as a replicate in the database. It was the same record number, date, time, etc. After about 4 tries WQReview pulled it correctly. Replicate.xlsx Blank.xlsx QWdata_1

cpenn-usgs commented 1 year ago

Hi @lrking0530 , WQReview is not doing any sample medium coding itself, it's pulling the medium code directly from what is in the NWIS DB at the time of access. Is it possible the sample was being worked on, reloaded, or edited in the database while you were retrieving it and there was a lag?

lrking0530 commented 1 year ago

No, it was an older sample and everything in the record was approved. No one else did anything with the sample record.

Lindsey King Hydrologist United States Geological Survey Wyoming-Montana Water Science Center 3162 Bozeman Ave Helena, MT 59601 @.*** Cell phone: (406) 465-7021


From: Colin Penn @.> Sent: Wednesday, April 12, 2023 12:39:18 PM To: USGS-R/WQ-Review @.> Cc: King, Lindsey R @.>; Mention @.> Subject: [EXTERNAL] Re: [USGS-R/WQ-Review] QAQC being coded incorrectly in pull from WQReview compared to database (Issue #186)

This email has been received from outside of DOI - Use caution before clicking on links, opening attachments, or responding.

Hi @lrking0530https://github.com/lrking0530 , WQReview is not doing any sample medium coding itself, it's pulling the medium code directly from what is in the NWIS DB at the time of access. Is it possible the sample was being worked on, reloaded, or edited in the database while you were retrieving it and there was a lag?

— Reply to this email directly, view it on GitHubhttps://github.com/USGS-R/WQ-Review/issues/186#issuecomment-1505752570, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A66EZUENFRDD6T3IQZEDLCLXA3ZFNANCNFSM6AAAAAAWRSX6TY. You are receiving this because you were mentioned.Message ID: @.***>