# Begin METADATA documentation ------------------------------------------------------------------------------------------------------ # DATASET_NAME: MRB4A.explanatory.10.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 # 10-percent drainage area nearest to 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.10.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.10.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.10.slope # fert.n.10.slope # fert.p.10.slope # manure.n.10.slope # manure.p.10.slope # pointsc.n.10.slope # popden.10.%change # consprac.10.%change # irrigation.10.%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.10.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.10.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.10.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.10.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.10.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.10.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.10.%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.10.%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.10.%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.10.txt # ------------------------------------------------------------------------------------------------------ STAID atmdep.n.10.slope fert.n.10.slope fert.p.10.slope manure.n.10.slope manure.p.10.slope pointsc.n.10.slope popden.10.%change consprac.10.%change irrigation.10.%change 15s 6n 6n 6n 6n 6n 6n 6n 6n 6n 06088500 -0.028 -27.028 -5.237 -45.763 -12.983 0.000 25.000 -100.000 -3.405 06089000 0.207 -38.695 -8.199 -49.437 -13.902 0.000 20.000 -100.000 -3.530 06115200 0.682 -18.397 -3.457 -15.455 -3.686 -0.013 0.000 -100.000 99.766 06130500 1.367 -1.377 -0.258 -25.067 -6.099 0.000 0.000 15.789 0.460 06154410 0.000 0.000 0.000 -3.688 -0.738 0.000 0.000 0.000 0.000 06178000 3.636 20.209 3.619 5.327 2.101 0.000 0.000 0.000 8.333 06274300 -0.329 -12.589 -3.032 -11.713 -2.427 0.000 0.000 -100.000 6.931 06329500 6.693 -2.275 -0.085 18.254 3.638 -0.417 0.000 3.202 5.316 06338490 6.738 52.508 8.832 38.170 5.584 0.000 0.000 -42.825 5.587 06341410 0.575 124.786 22.112 -0.884 1.496 0.000 0.000 0.000 -1.481 06341800 -1.750 27.616 6.441 36.119 13.383 0.000 100.000 -100.000 -1.481 06436180 2.315 -2.940 -0.738 -36.040 -8.855 0.000 11.111 -100.000 3.226 06441500 -1.872 46.019 7.671 -75.763 -25.037 0.000 0.000 -100.000 -10.000 06452000 -0.519 100.196 17.231 84.133 12.729 0.000 0.000 -48.357 -0.405 06461500 -2.743 5.003 2.697 -29.872 -11.623 0.000 0.000 0.000 -1.783 06463500 0.178 -20.850 10.349 45.115 2.954 0.000 100.000 0.000 -22.414 06468250 -1.668 -112.847 -14.910 11.855 -7.287 0.000 0.000 -68.448 6.250 06713500 3.356 1.613 -2.420 -0.081 0.000 0.000 14.494 0.000 0.000 06714000 1.806 9.245 0.172 -35.110 -10.413 -0.221 26.456 -72.422 -1.836 06752260 -0.385 -20.383 -1.549 -79.572 -25.487 0.000 15.217 0.000 3.776 06752280 -0.698 -40.359 -1.923 -130.675 -38.678 0.000 15.232 0.000 3.776 06753990 0.945 -144.500 -3.406 -233.593 -100.194 0.000 42.857 60.262 10.033 06754000 -0.615 -131.161 -3.500 -245.675 -94.384 -12.763 45.283 60.262 9.239 06758500 -0.305 -81.827 -1.291 -57.782 -41.567 -6.330 23.810 58.655 6.549 06775900 4.059 0.000 0.000 92.999 2.629 0.000 -100.000 0.000 0.000 06800000 -7.458 107.255 36.164 -73.633 -43.388 0.000 50.000 25.773 -5.714 06805500 -5.465 -45.346 23.036 -58.998 -44.618 -5.272 10.000 -15.856 4.140 06817700 -1.473 64.573 12.751 -221.255 -87.991 0.000 -40.000 -8.028 -78.353 06818000 0.000 0.000 0.000 0.000 0.000 0.000 -17.625 06902000 -3.078 36.841 6.788 39.246 4.172 0.000 0.000 -70.184 -6.863 06905500 -6.925 -25.091 -3.955 28.150 3.414 0.000 0.000 -100.000 -21.159 06921070 -4.607 -8.162 -0.714 182.230 74.245 0.000 50.000 -52.929 -38.211 06926510 -14.972 12.447 2.191 126.680 48.655 0.000 25.000 0.000 14.569 06930800 -12.864 19.090 3.535 74.987 23.137 0.000 42.308 0.251 20.833 06934500 0.000 0.000 0.000 0.000 0.000 0.000 -100.000