# Begin METADATA documentation ------------------------------------------------------------------------------------------------------ # DATASET_NAME: MRB4A.baseflow.NOX.loads.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 estimates of total and annual nitrate loads in base flow from 1993 # to 2003 at 3 case study sites in the Missouri River Basin, produced by the S-LOADEST model in 2005. # Details on model specification are provided in an appendix of 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. # # The program S-LOADEST within the statistical software package # S-PLUS was used to estimate loads. # # Daily values of ground-water discharge from the hydrogarph separation program # 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 to estimate loads of NOX in base flow, # along with surface-water concentrations of NOX on days when the base flow # was greater than 80 percent of the total streamflow. # # 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 # WATER_YEARS # METHOD # FLUX # VARIANCE # NDAYS # LOAD # CI_LOWER.95 # CI_UPPER.95 # SEP # # DATA FIELD LENGHT/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 for Constiuent NOX: # # DATA FIELD LABEL: STAID # Data Field Description: USGS Station Identifier # Data Field Length/Type: 12S # Data Source: USGS National Water Information System (NWIS) # Retrieval Date: January 1, 2005 # # # DATA FIELD LABEL: WATER_YEARS # Data Field Description: Time period in USGS water years for sample data. # Year is for Water year ending XXXX. # Data Field Length/Type: 9S # Data Source: NA # Retrieval Date: NA # # # DATA FIELD LABEL: METHOD # Data Field Description: Load calculation method used in software S-LOADEST # Data Field Length/Type: 4S # Data Source: S-LOADEST Software # Retrieval Date: NA # # Codes for METHOD: # AMLE = adjusted maximum likelihood estimation # LAD = least absolute deviation # # # DATA FIELD LABEL: FLUX # Data Field Description: Average daily flux for NOX for the period of NDAYS # Data Field Length/Type: 9n # Data Units: kilograms per day # Data Source: Calculated using software S-LOADEST # Retrieval Date: NA # # # DATA FIELD LABEL: VARIANCE # Data Field Description: Variance of average daily flux for NOX for the period of NDAYS # Data Field Length/Type: 10n # Data Units: kilograms per day # Data Source: Calculated using software S-LOADEST # Retrieval Date: NA # # # DATA FIELD LABEL: NDAYS # Data Field Description: Number of days in flux calculation period # (Note: Input prediction data has only one observation per day # Data Field Length/Type: 4n # Data Units: day # Data Source: NA # Retrieval Date: NA # # # DATA FIELD LABEL: LOAD # Data Field Description: Total load for NOX for the period of NDAYS # Data Field Length/Type: 10n # Data Units: Kilograms per year # Data Source: Calculated using software S-LOADEST # Retrieval Date: NA # # # DATA FIELD LABEL: CI_LOWER.95 # Data Field Description: Lower 95% confidence limit of average daily flux for NOX for the period of NDAYS # Data Field Length/Type: 9n # Data Units: kilograms per day # Data Source: Calculated using software S-LOADEST # Retrieval Date: NA # NOTE: Calculated for AMLE method only # # # DATA FIELD LABEL: CI_UPPER.95 # Data Field Description: Upper 95% confidence limit of average daily flux for NOX for the period of NDAYS # Data Field Length/Type: 10n # Data Units: kilograms per day # Data Source: Calculated using software S-LOADEST # Retrieval Date: NA # NOTE: Calculated for AMLE method only # # # # DATA FIELD LABEL: SEP # Data Field Description: Standard error of prediction of average daily flux for NOX for the period of NDAYS # Data Field Length/Type: 8n # Data Units: kilograms per day # Data Source: Calculated using software S-LOADEST # Retrieval Date: NA # NOTE: Calculated for AMLE method only # # # End METADATA documentation # # BEGIN DATA: MRB4A.baseflow.NOX.loads.txt # ------------------------------------------------------------------------------------------------------ Station Water_Years Method Flux Variance NDAYS Load CI_Lower.95 CI_Upper.95 SEP 12s 9s 4s 9n 10n 4n 10n 9n 10n 8n 06088500 1994 LAD 475.6970 658.8584 365 173629.4 06088500 1995 LAD 463.4988 400.4885 365 169177.1 06088500 1996 LAD 460.7191 416.9244 366 168623.2 06088500 1997 LAD 501.2845 593.4187 365 182968.9 06088500 1998 LAD 440.1890 286.0926 365 160669.0 06088500 1999 LAD 437.1638 286.3483 365 159564.8 06088500 2000 LAD 364.1548 298.9971 366 133280.7 06088500 2001 LAD 318.6478 146.6622 365 116306.4 06088500 2002 LAD 332.8576 170.8924 365 121493.0 06088500 2003 LAD 272.2381 173.9362 365 99366.9 06088500 1994-2003 LAD 415.5633 286.7751 4017 1669318 06775900 1994 LAD 256.5865 343.72131 365 93654.07 06775900 1995 LAD 269.0038 142.92523 365 98186.38 06775900 1996 LAD 260.7633 193.90924 366 95439.37 06775900 1997 LAD 285.5519 935.62855 365 104226.43 06775900 1998 LAD 268.4091 76.81599 365 97969.31 06775900 1999 LAD 273.5550 156.20113 365 99847.59 06775900 2000 LAD 284.8495 621.95235 366 104254.91 06775900 2001 LAD 277.2666 238.07205 365 101202.32 06775900 2002 LAD 261.3113 237.23475 365 95378.63 06775900 2003 LAD 267.7831 77.84556 365 97740.82 06775900 1994-2003 LAD 269.1385 85.96934 4017 1081129 06921070 1994 AMLE 337.22870 13728.08961 365 123088.475 148.43622 662.35002 133.494165 06921070 1995 AMLE 442.49323 25064.06458 365 161510.029 191.47396 879.11786 178.761511 06921070 1996 AMLE 71.38769 515.13723 366 26127.895 29.62620 145.81131 30.263792 06921070 1997 AMLE 580.72086 53877.99894 365 211963.114 227.23262 1232.21517 262.559740 06921070 1998 AMLE 181.97595 2403.64429 365 66421.222 93.50642 320.79980 58.673588 06921070 1999 AMLE 369.83040 12380.11541 365 134988.096 183.88925 667.53120 124.998464 06921070 2000 AMLE 26.34481 40.00572 366 9642.199 13.61045 46.26075 8.426733 06921070 2001 AMLE 111.67811 1286.28459 365 40762.511 43.77247 236.71211 50.402569 06921070 2002 AMLE 355.80412 19564.27282 365 129868.503 140.41658 750.85748 159.411320 06921070 2003 AMLE 55.15517 408.82524 365 20131.637 23.53585 110.60307 22.648926 06921070 1994-2003 AMLE 260.1363 6678.434 4017 1044968 133.7298 458.4337 83.81779