# Begin METADATA documentation ------------------------------------------------------------------------------------------------------ # DATASET_NAME: MRB4A.sussed.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: David L. Rus # USGS-WRD, Nebraska Water Science Center # Major River Basin study – Missouri River Basin # 5231 South 19th # Lincoln, NE 68512 # voice: 402-328-4127 # fax: 402-328-4101 # email: dlrus@usgs.gov # # ------------------------------------------------------------------------------------------------------ # METADATA Data Description: # # ABSTRACT: This data set contains estimates of total suspended sediment loads at selected 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: # Suspended sediment concentration and mean daily discharge were retrieved from the US Geological # Survey National Water Information System between December 2004 and February 2005. # # A streamflow record reflecting the average condition at each site was used in place of the actual # streamflow to minimize the effect of hydrologic variability on the load estimates. This median # streamflow data set was derived at each site by: (1) compiling the annual streamflows for each # calendar year of record, (2) identifying the three calendar years closest to the median of the # annual streamflow (with the exception of sites with five or fewer years of streamflow record, # where the 2 years closest to the median were used to avoid high or low bias in the load estimates), # (3) compiling the daily mean streamflow records corresponding to the three (or two) calendar years # identified in the previous step, and (4) replacing the streamflow data during the years corresponding # to the calibration data with this median streamflow data. This approach had the advantage of producing # load estimates with less hydrologic variability between sites, which facilitated identification of # landscape characteristics affecting spatial patterns in load. However, these load estimates are not # representative of real-world conditions; they cannot be interpreted as loads that actually occurred at # any point in time at these sites. The total load estimates ultimately were divided by the number of # days in the record and the contributing drainage area to produce the mean daily sediment yield (MDSY) # at each site. The MDSYs were used in all subsequent analyses in the report. # # # 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 # 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: 15S # Data Source: USGS National Water Information System (NWIS) # Retrieval Date: December 2004 to February 2005 # # # 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 absoluted deviation # # # DATA FIELD LABEL: FLUX # Data Field Description: Average daily flux for suspended sediment 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 suspended sediment 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: USGS National Water Information System (NWIS) # Retrieval Date: NA # # # DATA FIELD LABEL: LOAD # Data Field Description: Total load for suspended sediment 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 suspended sediment 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 suspended sediment 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 suspended sediment 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.sussed.loads.txt # ------------------------------------------------------------------------------------------------------ Station Method Flux Variance NDAYS Load CI_Lower.95 CI_Upper.95 SEP 15s 4s 9n 10n 4n 10n 9n 10n 8n 06130500 AMLE 531374.5 8598248371 1096 582386421 357397.4 761193.7 103445.2 06187915 AMLE 7194.731 4481021 1096 7885425 3817.739 12389.58 2210.258 06191500 AMLE 681450.4 18157949129 1095 746188193 446957 996409.7 140836.4 06208500 LAD 2185681 2.51E+12 1095 2393320460 06214500 AMLE 5714265 4.68E+12 1096 6262834983 2537881 11155579 2237632 06279500 LAD 4483329 3.45E+12 1096 4913728924 06295000 AMLE 4246289 7.14E+11 731 3104037620 2747969 6276621 904744.4 06298000 LAD 10837.09 2060049 1095 11866616 06324970 AMLE 106765.1 6182700750 1096 117014514 19683.02 341061 89197.56 06326500 AMLE 20391349 7.85E+15 1095 22328526643 150507.7 135746486 89703134 06329500 AMLE 31026598 5.24E+15 1095 33974125188 838364.9 177571132 72541251 06441500 AMLE 2155560 7.50E+11 1095 2360338730 728090.5 5009600 1128103 06452000 AMLE 14861352 1.97E+13 1095 16273180692 7592966 26306686 4831756 06705500 LAD 7442.969 5039078 731 5440810 06714000 AMLE 151162.2 1412322880 1095 165522614 87002.44 244947.5 40621.62 06714400 AMLE 1231.399 90568.27 731 900152.8 691.6336 2032.704 345.161 06714800 AMLE 807.6896 21890.1 1096 885227.8 537.161 1167.731 161.5791 06720500 AMLE 85173.8 274512720 1095 93265309 53570.38 128805.5 19303.35 06754000 AMLE 280580.3 947518455 1095 307235406 216657.8 357480.8 35989.58 06759910 AMLE 794363.2 31390344535 1095 869827731 477058.8 1245741 197459 06800000 AMLE 1261053 5.08E+11 1095 1380853183 320556.2 3438978 838915.8 06800500 AMLE 4772727 4.10E+11 1096 5230908640 3414758 6493780 787843.6 06805500 AMLE 10481496 2.48E+12 1095 11477238493 7495572 14267026 1732658 06879100 AMLE 4683480 3.58E+12 1096 5133094354 1954267 9531994 1973317 06882000 AMLE 2360895 5.95E+11 1095 2585180328 1090969 4485842 879983.1 06884025 AMLE 1561318 3.14E+11 1096 1711204299 721885.7 2965461 581542.3 06887000 AMLE 256937.7 5626493478 1095 281346759 138760.8 436748.8 76791.23 06888500 AMLE 3869330 1.12E+14 1096 4240785457 70278.53 23580028 10967696 06891500 AMLE 220617.7 17466975991 1095 241576349 58247.06 589616.8 142502.3 06923150 AMLE 182076.2 9.09E+11 1096 199555539 922.9935 1233432 965520.8 06929315 AMLE 78024.35 2.23E+11 731 57035799 302.0167 531866.4 473954.8 06934500 AMLE 124838142 2.15E+14 1095 1.37E+11 96604660 158753430 15882657