#
# File created on 2024-06-15 22:11:33 EDT
#
# U.S. Geological Survey
# 
# This file contains selected water-quality data for stations in the National Water 
# Information System water-quality database.  Explanation of codes found in this file are 
# followed by the retrieved data. 
#
# The data you have secured from the USGS NWISWeb database may include data that have 
# not received Director's approval and as such are provisional and subject to revision. 
# The data are released on the condition that neither the USGS nor the United States 
# Government may be held liable for any damages resulting from its authorized or 
# unauthorized use.
#
# To view additional data-quality attributes, output the results using these options:  
# one result per row, expanded attributes.  Additional precautions are at:
# https://help.waterdata.usgs.gov/tutorials/water-quality-data/help-using-the-water-quality-data-retrieval-system#Data_retrievals_precautions
#
#  agency_cd                  - Agency Code
#  site_no                    - USGS site number
#  sample_dt                  - Begin date
#  sample_tm                  - Begin time
#  sample_end_dt              - End date
#  sample_end_tm              - End time
#  sample_start_time_datum_cd - Time datum
#  tm_datum_rlbty_cd          - Time datum reliability code
#  coll_ent_cd                - Agency Collecting Sample Code
#  medium_cd                  - Sample Medium Code
#  tu_id                      - Taxonomic unit code
#  body_part_id               - Body part code
#  parm_cd                    - Parameter code
#  remark_cd                  - Remark code
#  result_va                  - Parameter value
#  val_qual_tx                - Result value qualifier code
#  meth_cd                    - Method code
#  dqi_cd                     - Data-quality indicator code
#  rpt_lev_va                 - Reporting level
#  rpt_lev_cd                 - Reporting level type
#  lab_std_va                 - Lab standard deviation
#  anl_ent_cd                 - Analyzing entity code
#
# The following parameters are included:
#  01005  - Barium, water, filtered, micrograms per liter
#  01010  - Beryllium, water, filtered, micrograms per liter
#  01025  - Cadmium, water, filtered, micrograms per liter
#  01030  - Chromium, water, filtered, micrograms per liter
#  01035  - Cobalt, water, filtered, micrograms per liter
#  01040  - Copper, water, filtered, micrograms per liter
#  01046  - Iron, water, filtered, micrograms per liter
#  01047  - Iron(II), water, filtered, micrograms per liter
#  01048  - Iron(II) plus Iron(III), water, filtered, micrograms per liter
#  01049  - Lead, water, filtered, micrograms per liter
#  01056  - Manganese, water, filtered, micrograms per liter
#  01057  - Thallium, water, filtered, micrograms per liter
#  01060  - Molybdenum, water, filtered, micrograms per liter
#  01065  - Nickel, water, filtered, micrograms per liter
#  01075  - Silver, water, filtered, micrograms per liter
#  01080  - Strontium, water, filtered, micrograms per liter
#  01085  - Vanadium, water, filtered, micrograms per liter
#  01090  - Zinc, water, filtered, micrograms per liter
#  01106  - Aluminum, water, filtered, micrograms per liter
#  01130  - Lithium, water, filtered, micrograms per liter
#
# Description of sample_start_time_datum_cd:
# PST  - Pacific Standard Time
# PDT  - Pacific Daylight Time
#
# Description of tm_datum_rlbty_cd:
# K  - Known
# T  - Transferred
#
# Description of coll_ent_cd and anl_ent_cd:
# USGS-WRD  - U.S. Geological Survey-Water Resources Discipline
# USGSCAWC  - USGS - California Water Science Center
# USGSNWQL  - USGS-National Water Quality Lab, Denver, CO
# USGSTMCO  - USGS-NRP, Trace Metals Research Lab, Boulder, CO
#
# Description of medium_cd:
# WG  - Groundwater
#
# Description of tu_id:
# https://www.itis.gov/
#
# Description of body_part_id:
#
# Description of remark_cd:
# <  - Less than
# V  - Value affected by contamination
#
# Description of val_qual_tx:
# c  - see result laboratory comment
# d  - sample was diluted
# n  - below the reporting level but at or above the detection level
#
# Description of meth_cd:
# AA021  - Lithium, wf, direct AAS
# AA038  - Strontium, wf, direct AAS
# CL202  - Fe(II) & Fe(tot), wf, FerroZine
# DCP02  - Aluminum, wf, DCP-AES
# PLA11  - Metals, wf, ICP-AES (NWQL)
# PLM10  - Elements, wf, cICP-MS
# PLM40  - Metals, water, ICP-MS (NWQL)
# PLM43  - Metals, wf, ICP-MS
#
# Description of dqi_cd:
# A  - Historical data
# R  - Reviewed and approved
# S  - Provisional
#
# Description of rpt_lev_cd:
# DLBLK  - Detection limit by Blank Data
# DLDQC  - Detection limit by DQCALC
# LRL  - Laboratory reporting level
# MDL  - Method detection limit
#
# Data for the following sites are included:
#  USGS 341128119034101 001N021W03R001S
#
agency_cd	site_no	sample_dt	sample_tm	sample_end_dt	sample_end_tm	sample_start_time_datum_cd	tm_datum_rlbty_cd	coll_ent_cd	medium_cd	tu_id	body_part_id	parm_cd	remark_cd	result_va	val_qual_tx	meth_cd	dqi_cd	rpt_lev_va	rpt_lev_cd	lab_std_va	anl_ent_cd
5s	15s	10d	5d	10d	5d	3s	1s	8s	3s	11s	11s	5s	1s	12s	5s	5s	1s	12s	6s	11s	8s
USGS	341128119034101	1991-03-12	13:15			PST	T	USGS-WRD	WG			01005		57.0		PLA11	A				
USGS	341128119034101	1991-03-12	13:15			PST	T	USGS-WRD	WG			01046		51.0		PLA11	A				
USGS	341128119034101	1991-03-12	13:15			PST	T	USGS-WRD	WG			01056		19.0		PLA11	A				
USGS	341128119034101	1991-03-12	13:15			PST	T	USGS-WRD	WG			01080		1900		PLA11	A				
USGS	341128119034101	1991-03-12	13:15			PST	T	USGS-WRD	WG			01106	<	10		DCP02	A				
USGS	341128119034101	1991-08-05	16:00			PDT	T	USGS-WRD	WG			01080		1600		AA038	A				
USGS	341128119034101	1991-08-05	16:00			PDT	T	USGS-WRD	WG			01130		50		AA021	A				
USGS	341128119034101	2002-11-14	08:30			PST	T	USGS-WRD	WG			01005		49.9		PLA11	S	2.7	LRL		
USGS	341128119034101	2002-11-14	08:30			PST	T	USGS-WRD	WG			01046	<	30.0		PLA11	S	30	LRL		
USGS	341128119034101	2002-11-14	08:30			PST	T	USGS-WRD	WG			01056		21.7		PLA11	S	4.8	LRL		
USGS	341128119034101	2002-11-14	08:30			PST	T	USGS-WRD	WG			01080		2330		PLA11	S	1.8	LRL		
USGS	341128119034101	2002-11-14	08:30			PST	T	USGS-WRD	WG			01106	<	1.6		PLM43	S	1.6	LRL		
USGS	341128119034101	2002-11-14	08:30			PST	T	USGS-WRD	WG			01130		65.2		PLA11	S	11.7	LRL		
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01005		39.3	d	PLM43	R	0.1	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01010	<	0.050	d	PLM43	R	0.01	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01025	<	0.150	d	PLM43	R	0.03	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01030	<	2.5	d	PLM10	R	0.5	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01035	<	0.150	d	PLM10	R	0.03	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01040	<	1.0	d	PLM10	R	0.2	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01046		26.8	nd	PLA11	R	10	DLDQC		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01047		2		CL202	R	2	MDL		USGSTMCO
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01048	V	13	c	CL202	R	2	MDL		USGSTMCO
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01049	V	1.42	d	PLM43	R	0.02	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01056		18.2	d	PLM43	R	0.4	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01057	<	0.100	d	PLM40	R	0.02	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01060		15.3	d	PLM43	R	0.05	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01065	<	1.0	d	PLM10	R	0.2	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01075	<	5.00	d	PLM43	R	1	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01080		2090	d	PLM40	R	0.5	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01085		6.2	d	PLM10	R	0.1	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01090	<	10.0	d	PLM10	R	2	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01106	<	15.0	d	PLM43	R	3	DLBLK		USGSNWQL
USGS	341128119034101	2017-06-26	12:00			PDT	K	USGSCAWC	WG			01130		50.1	d	PLM40	R	0.15	DLBLK		USGSNWQL