# Begin METADATA documentation ------------------------------------------------------------------------------------------------------ # DATASET_NAME: MRB4A.explanatory.100.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: January 24, 2007 # 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 nutrient sources and landscpape characteristics for the # full drainage area for each site. 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: # # To use the data for nutrient sources and landscape characteristics in weighted least-squares # regression, a single number representing the change in a given data series over time was # generated. When a data series had more than two observations (for example, an annual data # series for fertilizer), the Sen slope estimate for that series was determined for each site. # The Sen slope estimate was calculated as the median of all possible pairwise slopes (Helsel # and Hirsch, 1992). When a data series had only two observations (for example, 1990 and 2000 # estimates of population density), the percentage change between the first year and the last # year was determined for each site. # # The data in this file (for all fields except pointsc.n.100.slope) were obtained from one of # 2 NAWQA websites (http://water.wr.usgs.gov/pnsp/gis/data/swancil/mrb.html, or # http://water.wr.usgs.gov/pnsp/gis/data/swancil/cycle2.html). These two websites contained # data that had originally been compiled from other external sources, which are listed below # in the field descriptions and further described in Sprague and others, 2006 (SIR 2006-5231). # Data processing procedures are also described in Sprague and others, 2006 (SIR 2006-5231). # # All data were obtained from the website # http://water.wr.usgs.gov/pnsp/gis/data/swancil/mrb.html for these sites: # 06088500 # 06089000 # 06115200 # 06130500 # 06154410 # 06178000 # 06274300 # 06338490 # 06341410 # 06341800 # 06441500 # 06452000 # 06461500 # 06463500 # 06468250 # 06610000 # 06817700 # 06818000 # 06821190 # 06889000 # 06902000 # 06905500 # 06926510 # 06930800 # 06934500 # # Data were obtained from http://water.wr.usgs.gov/pnsp/gis/data/swancil/cycle2.html for # these sites: # 06192500 # 06329500 # 06436180 # 06713500 # 06714000 # 06720500 # 06752260 # 06752280 # 06753990 # 06754000 # 06758500 # 06768000 # 06775900 # 06800000 # 06805500 # 06921070 # # Original data for point sources of nitrogen (pointsc.n.100.slope) were obtained from # http://www.epa.gov/enviro/html/pcs/. Data were processed as described in Appendix 1 of # Sprague and others, 2006 (SIR 2006-5231). Total N from all point sources within each site # basin were aggregated and summed to provide an annual time series of point source N for # each site. These data are in the archive file MRB4A.ptsrc.N.txt. # # # 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 # Nutrient sources and landscape characteristics: # MRB4A.explanatory.10.txt, MRB4A.explanatory.100.txt, MRB4A.ptsrc.N.txt, # MRB4A.spsed.txt, MRB4A.drainagebasins.txt # # ------------------------------------------------------------------------------------------------------ # METADATA Basic documentation of dataset elements: # # DATA FIELD LABELS: # # STAID # atmdep.n.100.slope # fert.n.100.slope # fert.p.100.slope # manure.n.100.slope # manure.p.100.slope # pointsc.n.100.slope # popden.100.%change # consprac.100.%change # irrigation.100.%change # 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 Number # Data Field Length/Type: 15s # Data Source: USGS National Water Information System (NWIS) # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: atmdep.n.100.slope # Data Field Description: change in nitrogen input from atmospheric deposition # in kilograms per square kilometer per year # Data Field Length/Type: 6n # Data Source: http://pubs.usgs.gov/sir/2006/5012/ # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: fert.n.100.slope # Data Field Description: change in nitrogen input from fertilizer in kilograms # per square kilometer per year # Data Field Length/Type: 6n # Data Source: http://pubs.usgs.gov/sir/2006/5012/ # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: fert.p.100.slope # Data Field Description: change in phosphorus input from fertilizer in kilograms # per square kilometer per year # Data Field Length/Type: 6n # Data Source: http://pubs.usgs.gov/sir/2006/5012/ # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: manure.n.100.slope # Data Field Description: change in nitrogen input from manure in kilograms # per square kilometer per year # Data Field Length/Type: 6n # Data Source: http://pubs.usgs.gov/sir/2006/5012/ # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: manure.p.100.slope # Data Field Description: change in phosphorus input from manure in kilograms # per square kilometer per year # Data Field Length/Type: 6n # Data Source: http://pubs.usgs.gov/sir/2006/5012/ # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: pointsc.n.100.slope # Data Field Description: change in nitrogen input from point sources in kilograms # per square kilometer per year # Data Field Length/Type: 6n # Data Source: http://www.epa.gov/enviro/html/pcs/ # MRB4A.ptsrc.N.txt # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: popden.100.%change # Data Field Description: change in population density # Data Field Length/Type: 6n # Data Source: http://www.census.gov/main/www/cen1990.html # http://www.census.gov/main/www/cen2000.html # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: consprac.100.%change # Data Field Description: percent change in acreage in conservation practices # Data Field Length/Type: 6n # Data Source: http://www.nrcs.usda.gov/TECHNICAL/NRI/ # Retrieval Date: June 1, 2006 # # # DATA FIELD LABEL: irrigation.100.%change # Data Field Description: percent change in irrigated acreage # Data Field Length/Type: 6n # Data Source: http://www.nrcs.usda.gov/TECHNICAL/NRI/ # Retrieval Date: June 1, 2006 # # # End METADATA documentation # # BEGIN DATA: MRB4A.EXPLANATORY.100.txt # ------------------------------------------------------------------------------------------------------ STAID atmdep.n.100.slope fert.n.100.slope fert.p.100.slope manure.n.100.slope manure.p.100.slope pointsc.n.100.slope popden.100.%change consprac.100.%change irrigation.100.%change 15s 6n 6n 6n 6n 6n 6n 6n 6n 6n 06088500 -0.357 -89.722 -18.876 -65.037 -19.064 0.000 -33.333 -100.000 0.184 06089000 -0.584 -21.110 -3.980 -13.744 -9.008 0.000 0.000 -100.000 -0.434 06115200 -0.660 -11.572 -1.867 -19.459 -6.410 0.394 50.000 -80.490 1.957 06130500 0.522 -7.418 -1.489 -27.354 -5.864 -0.028 0.000 -99.878 2.462 06154410 -0.113 0.000 0.000 -2.731 -0.522 0.000 0.000 -100.000 -3.433 06178000 3.425 0.790 0.142 0.236 0.093 0.000 0.000 0.000 8.333 06274300 -0.585 4.620 0.279 -14.918 -3.222 0.000 0.000 -100.000 8.475 06329500 1.204 -3.575 -0.686 -19.217 -4.784 1.047 0.000 -8.611 9.159 06338490 1.349 4.936 0.685 -8.428 -2.464 0.548 0.000 -56.819 4.846 06341410 0.675 116.764 20.888 -0.743 1.434 0.000 0.000 -100.000 -1.512 06341800 -1.671 28.874 6.644 20.745 8.024 0.000 0.000 -100.000 -1.477 06436180 3.059 10.186 2.290 -25.476 -6.354 0.098 -19.444 -100.000 5.000 06441500 -2.623 43.114 7.168 -31.883 -14.152 0.000 0.000 -100.000 -3.667 06452000 -0.645 30.716 5.064 13.910 -5.529 0.013 100.000 -71.410 -12.166 06461500 -1.365 14.905 4.552 -16.880 -6.744 0.000 0.000 -16.096 -0.662 06463500 2.105 -25.389 10.621 45.817 2.467 -0.115 -66.667 0.000 -22.388 06468250 -1.752 -96.423 -11.927 -22.686 -7.454 0.000 -50.000 -85.551 6.241 06713500 -0.279 1.735 0.869 -44.534 -15.387 -0.051 47.205 -71.390 -5.588 06714000 -1.875 0.180 -0.020 -18.604 -5.906 -0.116 32.927 -72.122 -20.149 06752260 -0.766 -3.796 -0.283 -30.819 -10.517 -0.263 20.000 0.000 3.460 06752280 0.059 -5.804 -0.468 -38.811 -12.913 -0.539 14.815 0.000 3.378 06753990 2.557 -42.026 -0.738 -99.861 -42.481 0.000 0.000 55.671 9.206 06754000 1.003 -20.039 -0.494 -84.308 -29.185 -1.574 30.682 0.497 7.212 06758500 0.501 -24.150 -0.072 -77.897 -29.213 -1.147 29.851 -0.720 6.052 06775900 3.420 -2.442 0.182 4.192 0.573 0.000 0.000 -100.000 192.010 06800000 -6.917 -18.905 29.301 -127.848 -50.367 0.345 0.000 1.989 5.966 06805500 -1.114 -20.053 5.200 -4.667 -11.358 1.368 28.571 -16.558 2.919 06817700 -2.448 12.088 3.728 -180.067 -92.037 -0.275 0.000 13.766 -85.541 06818000 0.281 0.000 5.597 -7.697 -5.131 0.695 16.667 -6.250 3.026 06902000 -1.157 26.007 6.466 32.870 4.480 -0.026 0.000 -25.189 -48.228 06905500 -5.131 19.201 4.043 40.984 12.929 -0.037 0.000 -21.943 -21.190 06921070 -6.969 -1.283 0.263 106.393 45.597 0.000 28.571 -100.000 -31.763 06926510 -3.914 11.897 3.652 82.736 28.605 0.000 16.667 -30.721 -13.450 06930800 -4.165 14.720 3.169 27.206 19.155 0.000 8.333 -100.000 20.833 06934500 -1.803 18.232 6.179 -0.298 -0.095 0.484 14.286 -2.024 3.129