NWDTW 2024

The USGS frequently uses external laboratories for analyses of discrete water-quality samples. For example, if a cooperator is interested in a constituent that the National Water Quality Lab (NWQL) does not analyze, the project team may identify a suitable laboratory that performs this analysis. However, if an external lab is not contracted through the NWQL, specific data management and approval procedures must be considered. Use of a non-contracted external lab may require staff to upload sample results to the National Water Information System (NWIS), and possibly complete the USGS’s formal laboratory evaluation process (LEP).

In this presentation, we will show an example workflow describing data management, LEP document preparation, QA/QC evaluation, and uploading results to WDFN through the USGS batch data loader (BDL). This workflow was developed by the California WSC Biogeochemistry (BGC) Group and uses scripting in both Python and R, and a Tableau data visualization tool to manage and evaluate external laboratory data. These tools have helped us streamline our process, saving time and reducing transcription errors. We receive numerous data files from external laboratories, and this workflow has increased the efficiency of publishing our data in NWIS. Other Centers could likely incorporate the tools we developed into their own processes to further enhance workflows for evaluating and using external laboratories.