#  Begin METADATA documentation
------------------------------------------------------------------------------------------------------
#  DATASET_NAME: 	MRB4A.baseflow.NOX.txt
#  DATASET_DESCRIPTION:	This data set was used as part of a nutrient, sediment, and streamflow trend 
#			assessment for the Missouri River Basin.
#  DATA_SET FORMAT:	Tab-delimited ascii file
#  DATA_SET URL:
#
#-------------------------------------------------------------------------------------------------------- 
#  REPORT TITLE: 	Nutrient and Suspended-Sediment Trends in the Missouri River Basin, 1993-2003    
#  REPORT SERIES/NUMBER (JOURNAL NAME/VOLUME): USGS Scientific Investigation Report (SIR 2006-5231)     
#  REPORT URL:		http://pubs.usgs.gov/sir/2006/5231/
#
#-------------------------------------------------------------------------------------------------------
#  NAWQA STUDY:		Major River Basin 4
#
#-------------------------------------------------------------------------------------------------------
#
#  METADATA DATE:    	August 7, 2006
#  METADATA CONTACT: 	Lori Sprague
#                    	USGS-WRD, Colorado Water Science Center 
#                    	Major River Basin study  Missouri River Basin
#                    	Denver Federal Center, Bldg. 53, MS 415,
#	 	     	Lakewood, CO 80225	
#                    	voice: 303-236-4882 x262
#                    	fax:   303-236-4912
#                    	email:  lsprague@usgs.gov
#
#  SECONDARY CONTACT:   Jennifer Flynn
#                    	USGS-WRD, Colorado Water Science Center 
#                    	Major River Basin study  Missouri River Basin
#                    	Denver Federal Center, Bldg. 53, MS 415,
#	 	     	Lakewood, CO 80225	
#                    	voice: 303-236-4882 x300
#                    	fax:   303-236-4912
#                    	email:  jlflynn@usgs.gov
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Data Description:  
#
#  ABSTRACT:  This data set contains surface-water nitrate data retrieved from NWISweb in January 2005.  
#	Additional modifications were made to the data in the original retrieval; these modifications
#	are detailed in Sprague and others, 2006 (SIR 2006-5231). The data were used in a report 
#	documenting trends in the Missouri River Basin as part of the U.S. Geological Survey, National
#	Water-Quality Assessment Program.
#
#  SUPPLEMENTAL INFORMATION:
#   	PROCEDURES USED:
#	PROCESS STEP:
#
#     Original concentration and daily mean discharge data were pulled 
#	for three sites included as case studies of base flow NOX loading 
#	in the analysis of nutrient and sediment trends in the Missouri 
#	River Basin. All data retrieved were publicly accessible during 
#	January 2005 through NWISweb.  
#
#	To maximize data coverage, total and dissolved parameters were 
#	 combined with their dissolved counterparts.  Previous comparison 
#	 of paired dissolved and total samples at the USGS National 
#	 Water-Quality Laboratory found that analytical values for 
#	 unfiltered and filtered concentrations were statistically 
#	 indistinguishable (U.S. Geological Survey Office of Water 
#	 Quality Technical Memorandum 93.04).
#
#	If a direct measurement of either dissolved or total NOX was not 
#	 available, it was calculated as the sum of total or dissolved nitrite 
#	 (NO2) and total or dissolved nitrate (NO3) as follows:
#	 - if both NO2 and NO3 were censored, NOX was censored to the maximum of the two censoring levels;
#	 - if NO2 was not censored and NO3 was censored, NOX was set equal to NO2;
#	 - if NO2 was censored and NO3 was not censored, NOX was set equal to NO3;
#	 - if both NO2 and NO3 were not censored, NOX was set equal to the sum of NO2 and NO3.
#
#	Concentrations of NOX were retained in this data set on days when the base flow was greater 
#	 than 80 percent of the total streamflow.  Bae flow was determined using PART (Rutledge, A.T., 
#	 1998, Computer programs for describing the recession of ground-water discharge and for estimating 
#	 mean ground-water recharge and discharge from streamflow records  update: U.S. 
#	 Geological Survey Water-Resources Investigations Report 98-4148, 43 p.) were used 
#
#
#  RELATED SPATIAL AND TABULAR DATA SETS:
#
#	All files listed below were used in the analysis for the report Sprague and others, 2006 
#	 (SIR 2006-5231).  These files	are all being documented and archived for this report.
#
#	Trends from 1993 to 2003:		
#		Streamflow: MRB4A.Q.txt
#		Water quality: MRB4A.TN.txt, MRB4A.NOX.txt, MRB4A.NH3.txt, MRB4A.TP.txt, 
#		MRB4A.OP.txt, MRB4A.SS.txt 
#	Base-flow nitrate loads:
#		MRB4A.baseflow.NOX.txt, MRB4A.baseflow.Q.txt, MRB4A.baseflow.NOX.loads.txt
#	Trends from 1985 to 2003:
#		Streamflow: MRB4A.Q.85.03.txt
#		Water quality: MRB4A.TN.85.03.txt, MRB4A.NOX.85.03.txt, MRB4A.TP.85.03.txt, 
#		MRB4A.OP.85.03.txt, MRB4A.SS.85.03.txt 		
#	Suspended-sediment yields:
#		MRB4A.sussed.loads.calibration.txt, MRB4A.Q.sussed.loads.txt, MRB4A.sussed.loads.txt
#
# ------------------------------------------------------------------------------------------------------
#  METADATA Basic documentation of dataset elements:
#
#     DATA FIELD LABELS:
#
#       STAID
#	DATES
#	TIMES
#	FLOW
#	PNOX
#	RNOX	
#
#     DATA TYPES: Note:  The row in the data file that follows the row of variable names describes the 
#                 width of the field and the data type. 
#			
#			Code:		Variable Type		Variable Length
#                 ----------------------------------------------------------------			
#			S or s 	text variable		numeric value preceding code 
#                       D or d	date variable		numeric value preceding code
#			N or n	numeric variable	numeric value preceding code
#									 
#                 For example: 15s indicates a 0- to 15-character text variable whereas
#                 9N indicates a 0- to 9-digit numeric variable.
#
#--------------------------------------------------------------------------------------------------------
#  METADATA Detailed documentation of dataset elements:
#
#
#       DATA FIELD LABEL:  		STAID
#       Data Field Description:		USGS Station Identifier
#       Data Source: 			USGS National Water Information System (NWIS)
#       Retrieval Date:  		January 1, 2005
#
#
#       DATA FIELD LABEL:  		DATES
#       Data Field Description:		Sample date
#       Data Source: 			USGS National Water Information System (NWIS)
#       Retrieval Date:  		January 1, 2005
#
#
#       DATA FIELD LABEL:  		TIMES
#       Data Field Description:		Dummy sample time (required by S-LOADEST model)
#       Data Source: 			not applicable
#       Retrieval Date:  		not applicable
#
#
#       DATA FIELD LABEL:  		FLOW
#       Data Field Description:		Daily mean discharge on sampling date 
#       Data Units: 			cubic feet per second
#       Data Source: 			USGS National Water Information System (NWIS)
#       Retrieval Date:  		January 1, 2005
#
#
#	DATA FIELD LABEL:  		PNOX 
#       DATA Field Description:		Value of chemical concentration
#       Data Units: 			miiligrams per liter
#       Data Source: 			USGS National Water Information System (NWIS), with modifications as 
#					described above
#       Retrieval Date:  		January 1, 2005
#
#
#	DATA FIELD LABEL:  		RNOX 
#       Data Field Description:		Remark code associated with each parameter value
#       Data Source: 			USGS National Water Information System (NWIS), with modifications 
#					as described above
#       Retrieval Date:  		January 1, 2005
#       Data Field Subdescription:
#       
#	  Code     Description
#       -----    ----------------------------------------------------------------------------------
#          <        Not Detected. Value reported as less than the Maximum Long-Term Method Detection Level.
#                        
#	   E        Detected. Concentration is estimated. Estimated concentration may result from
#                   any of the following reasons:
#                   1. The compound is characterized as a "poor performer" in the method on the 
#                   basis of laboratory QC samples. In general compounds with less than 60 %
#                   recovery, greater than 120 % recovery, or greater than 25 % relative standard
#                   deviation of recovery are considered poor performers. All detections of
#                   these compounds are remarked E.
#                   2. The compound was detected at a concentration less than the reporting level
#                   or less than the lowest calibration standard.
#                   3. The sample was diluted to bring the concentration into the calibration range.
#                           
#
#
#  End METADATA documentation
#
#  MRB4A.baseflow.NOX.txt
# ------------------------------------------------------------------------------------------------------
STAID	DATES	TIMES	FLOW	PNOX	RNOX
15s	10D	4n	10n	9n	1s
06088500	1/15/1993	1200	20.91	4.3	
06088500	3/12/1993	1200	30	5.6	
06088500	4/9/1993	1200	39	3.6	
06088500	5/13/1993	1200	45	3	
06088500	7/29/1993	1200	190.13	2.2	
06088500	11/8/1993	1200	61.62	4.7	
06088500	12/7/1993	1200	35.67	4.9	
06088500	4/13/1994	1200	25	4.5	
06088500	5/26/1994	1200	100.83	0.63	
06088500	6/15/1994	1200	155	1.2	
06088500	9/22/1994	1200	82.09	1.3	
06088500	11/15/1994	1200	45	3.8	
06088500	12/15/1994	1200	31.11	4	
06088500	3/17/1995	1200	27	4.8	
06088500	7/27/1995	1200	225.48	1.6	
06088500	9/5/1995	1200	159.62	0.94	
06088500	10/19/1995	1200	56.56	2.6	
06088500	1/25/1996	1200	23	4.5	
06088500	3/18/1996	1200	45	4.4	
06088500	4/24/1996	1200	36	4	
06088500	5/21/1996	1200	104.74	0.45	
06088500	6/20/1996	1200	148	1.5	
06088500	7/16/1996	1200	230	1.5	
06088500	8/14/1996	1200	184.82	1.4	
06088500	1/8/1997	1200	40.37	4.8	
06088500	7/15/1997	1200	249.49	1.45	
06088500	8/20/1997	1200	246	1.54	
06088500	9/8/1997	1200	154.46	1.02	
06088500	10/21/1997	1200	71.96	2.9	
06088500	12/2/1997	1200	47	3.69	
06088500	4/23/1998	1200	15	1.56	
06088500	6/10/1998	1200	229	1.07	
06088500	7/9/1998	1200	222.75	1.68	
06088500	10/15/1998	1200	78	2.3	
06088500	3/24/1999	1200	32	2.17	
06088500	4/14/1999	1200	25.38	3.08	
06088500	6/3/1999	1200	247.83	0.79	
06088500	6/23/1999	1200	179.86	1.08	
06088500	7/28/1999	1200	252.58	1.61	
06088500	8/24/1999	1200	181.87	1.29	
06088500	11/10/1999	1200	69	0.14	<
06088500	1/20/2000	1200	34	3.92	
06088500	4/5/2000	1200	23	2.73	
06088500	11/2/2000	1200	48	2.04	
06088500	1/9/2001	1200	36.39	3.21	
06088500	4/17/2001	1200	30	2.14	
06088500	6/21/2001	1200	239.74	0.74	
06088500	7/13/2001	1200	225.96	1.13	
06088500	8/8/2001	1200	252.02	1.41	
06088500	9/6/2001	1200	62.95	1.7	
06088500	11/1/2001	1200	35.79	2.08	
06088500	4/17/2002	1200	24	1.82	
06088500	5/28/2002	1200	107.56	0.21	
06088500	6/19/2002	1200	244	1.35	
06088500	7/18/2002	1200	245	1.28	
06088500	8/19/2002	1200	255.18	1.39	
06088500	9/10/2002	1200	209	1.03	
06088500	11/15/2002	1200	62	3.08	
06088500	1/15/2003	1200	29.17	3.95	
06088500	3/19/2003	1200	38.52	2.42	
06088500	4/10/2003	1200	24	1.86	
06088500	6/18/2003	1200	205.47	1.04	
06088500	8/19/2003	1200	124.22	0.856	
06088500	9/10/2003	1200	86	0.779	
06775900	2/23/1993	1200	191	0.62	
06775900	5/3/1993	1200	195.82	0.41	
06775900	6/1/1993	1200	184.8	0.45	
06775900	6/10/1993	1200	182	0.65	
06775900	8/24/1993	1200	185	0.45	
06775900	11/16/1993	1200	230.64	0.51	
06775900	3/11/1994	1200	216	0.54	
06775900	5/26/1994	1200	215	0.44	
06775900	7/29/1994	1200	216.67	0.23	
06775900	11/14/1994	1200	201	0.51	
06775900	3/13/1995	1200	204.63	0.51	
06775900	6/1/1995	1200	243	0.36	
06775900	8/8/1995	1200	209	0.28	
06775900	11/30/1995	1200	216.57	0.56	
06775900	2/14/1996	1200	212.79	0.7	
06775900	1/2/1997	1200	211.71	0.43	
06775900	3/12/1997	1200	244	1.4	
06775900	6/9/1997	1200	228	0.44	
06775900	7/10/1997	1200	208	0.37	
06775900	8/19/1997	1200	226.65	0.44	
06775900	11/6/1997	1200	214.41	0.55	
06775900	4/13/1998	1200	220.49	0.46	
06775900	5/19/1998	1200	225	0.48	
06775900	6/16/1998	1200	219	0.39	
06775900	9/15/1998	1200	213.44	0.51	
06775900	10/19/2000	1200	226	0.52	
06775900	12/21/2000	1200	215.33	0.67	
06775900	3/1/2001	1200	221.05	0.58	
06775900	3/22/2001	1200	240.6	0.51	
06775900	4/10/2001	1200	245	0.47	
06775900	5/10/2001	1200	231	0.44	
06775900	6/6/2001	1200	212	0.53	
06775900	7/12/2001	1200	227.87	0.43	
06775900	8/9/2001	1200	212	0.38	
06775900	9/13/2001	1200	217	0.38	
06775900	10/10/2001	1200	208	0.48	
06775900	11/1/2001	1200	210.67	0.5	
06775900	12/4/2001	1200	210.42	0.58	
06775900	1/7/2002	1200	205.45	0.63	
06775900	2/11/2002	1200	218	0.59	
06775900	3/11/2002	1200	223.8	0.6	
06775900	4/8/2002	1200	222	0.45	
06775900	5/7/2002	1200	216.33	0.45	
06775900	6/13/2002	1200	205	0.41	
06775900	7/9/2002	1200	206	0.49	
06775900	8/13/2002	1200	206	0.43	
06775900	9/4/2002	1200	210	0.44	
06775900	10/7/2002	1200	215.12	0.52	
06775900	11/5/2002	1200	220	0.55	
06775900	12/13/2002	1200	187	0.58	
06775900	1/14/2003	1200	223.25	0.63	
06775900	2/11/2003	1200	195.5	0.58	
06775900	3/11/2003	1200	197.6	0.54	
06775900	4/14/2003	1200	231.78	0.4	
06775900	5/6/2003	1200	240	0.51	
06775900	6/5/2003	1200	220	0.44	
06775900	7/9/2003	1200	216.99	0.43	
06775900	8/11/2003	1200	212.47	0.39	
06775900	9/8/2003	1200	224	0.38	
06921070	3/10/1993	1200	331	0.3	
06921070	11/24/1993	1200	257	0.92	
06921070	12/8/1993	1200	214	0.72	
06921070	3/18/1994	1200	340	0.03	
06921070	4/21/1994	1200	473	0.71	
06921070	5/24/1994	1200	141	0.04	
06921070	5/25/1994	1200	129	0.08	
06921070	6/28/1994	1200	27	0.02	<
06921070	7/28/1994	1200	16	0.09	
06921070	9/21/1994	1200	9.1	0.065	
06921070	9/30/1994	1200	9.9	0.05	
06921070	10/6/1994	1200	9.6	0.04	
06921070	11/23/1994	1200	467	0.95	
06921070	12/20/1994	1200	104	0.1	
06921070	1/11/1995	1200	65.97	0.27	
06921070	2/6/1995	1200	335	0.86	
06921070	7/11/1995	1200	118	0.22	
06921070	8/24/1995	1200	9.8	0.02	<
06921070	9/6/1995	1200	10	0.03	
06921070	10/4/1995	1200	9.65	0.02	
06921070	11/7/1995	1200	7.79	0.02	<
06921070	1/11/1996	1200	25.46	0.05	
06921070	1/16/1996	1200	35.49	0.02	
06921070	2/26/1996	1200	28	0.02	<
06921070	3/19/1996	1200	26	0.02	<
06921070	6/19/1996	1200	34.5	0.18	
06921070	7/29/1996	1200	10.4	0.05	
06921070	8/5/1996	1200	11	0.04	
06921070	9/9/1996	1200	4.9	0.02	
06921070	11/4/1996	1200	222	0.91	
06921070	12/19/1996	1200	198	0.77	
06921070	2/3/1997	1200	171	0.67	
06921070	3/6/1997	1200	417	1.1	
06921070	4/15/1997	1200	197	0.02	<
06921070	5/12/1997	1200	95	0.02	
06921070	6/24/1997	1200	27	0.27	
06921070	7/30/1997	1200	7.25	0.05	
06921070	9/5/1997	1200	6.3	0.15	
06921070	11/4/1997	1200	17	0.67	
06921070	3/12/1998	1200	385	1.07	
06921070	9/1/1998	1200	20	0.05	<
06921070	1/11/1999	1200	172	0.75	
06921070	5/3/1999	1200	341	0.93	
06921070	7/12/1999	1200	54.88	0.23	
06921070	9/13/1999	1200	4.81	0.05	<
06921070	11/3/1999	1200	9.11	0.05	<
06921070	1/11/2000	1200	45.19	0.05	<
06921070	3/22/2000	1200	84.91	0.05	<
06921070	5/22/2000	1200	16	0.13	
06921070	9/5/2000	1200	4.8	0.06	
06921070	11/27/2000	1200	16.77	0.03	E
06921070	1/18/2001	1200	96	1.35	
06921070	3/19/2001	1200	157	0.81	
06921070	9/17/2001	1200	23	0.15	
06921070	11/26/2001	1200	36.14	0.023	<
06921070	1/9/2002	1200	78	1.1	
06921070	3/13/2002	1200	212	0.16	
06921070	5/20/2002	1200	636	0.47	
06921070	7/22/2002	1200	12	0.023	<
06921070	9/9/2002	1200	8.15	0.06	
06921070	11/4/2002	1200	11	0.03	<
06921070	1/23/2003	1200	14	0.09	
06921070	3/18/2003	1200	76	0.09	
06921070	5/14/2003	1200	108.03	0.41	
06921070	7/9/2003	1200	11	0.17	
06921070	9/8/2003	1200	13	0.07	

