Upper Mississippi River Water Quality Assessment
Upper Mississippi River Water Quality data supplement which includes some tributary water quality data up to 2005 is now available.
- Zipped Excel spreadsheet [ umr_wq_update_2005.zip (1.32 Mb)]
Upper Mississippi River Water Quality Assessment Report distributed in March 2002
US
EPA Region 5 and the Upper
Mississippi River Conservation Committee
are pleased to distribute this report, which is the product of a multi-agency
work group. Our mission was to identify, compile, and analyze the available
Upper Mississippi River (UMR) water quality data for scientists, public
health officials, businesses, citizens, and decision-makers at all levels,
for evaluation and management of the river in the future. Beginning in
1999, available UMR water quality data were collected from federal, state,
and local agencies that conducted monitoring on the river. The major objectives
were to increase coordination and cooperation among monitoring agencies,
to develop a unified database of relevant water quality information, and
to use these data to begin a systematic assessment of the water quality
of the UMR. The river reach included in this evaluation extends from Anoka,
Minnesota (just upstream of Minneapolis/St. Paul) to the Ohio River --
a distance of 872 river miles (RM). The data submitted were collected
at a total of 106 monitoring stations.
We compiled three databases. The first ("mainstem water quality universe") includes inorganic chemistry data from samples collected near or in the main channel of the river during the years 1953 through 1999. The primary focus of the current assessment was on summer (June 1 to September 15) water quality data, collected over the twenty-year period, 1980 through 1999. Consequently, our second database is a summer data subset extracted from the complete database (universe). The third database consists of fish tissue contaminant data on polychlorinated biphenyls (PCBs), chlordane, and mercury collected throughout the UMR during the years 1970 through 1998.
Temporal and spatial (longitudinal) evaluation of 11 water quality parameters was conducted by plotting the entire summer data set by river mile over four, 5-year intervals. Data were segmented into 15 river reaches by utilizing hydrologic unit codes. Boxplots were prepared of the segmented data to broadly compare water quality differences over different reaches of the river. Several parameters exhibit distinct longitudinal profiles and changes over time.
The report is available below in PDF file format either as a single file ("Complete Report") or by individual sections. You will need the free Adobe Reader to view some of the files on this page. See EPA's PDF page to learn more. The accompanying data files are available in multiple formats. A summary of the Assessment was presented as a poster in May 2002.
Report
- Complete Report
[ umr_wqa_full (PDF) (198 pp, 5 Kb)]
- Complete Report
- Table of Contents, Summary, Introduction, Data and Methods
[ umr_wqa_1_intro (PDF) (23 pp, 404 Kb)]
- Results and Discussion, pgs 10 - 16
[ umr_wqa_2a_results (PDF) (7 pp, 1430 Kb)]
- Results and Discussion, pgs 17 - 40
[ umr_wqa_2b_results (PDF) (24 pp, 2509 Kb)]
- Results and Discussion, pgs 41 - 55
[ umr_wqa_2c_results (PDF) (15 pp, 744 Kb)]
- Results and Discussion, pgs 56 - 66
[ umr_wqa_2d_results (PDF) (11 pp, 1213 Kb)]
- Recommendations, References, Appendixes
[ umr_wqa_3_recs-refs-apps (PDF) (118 pp, 601 Kb)]
-
Data Files
- Mainstem water quality data universe (1953-1999) compiled for
this assessment
- Zipped comma-delimited text [ mainstem_wq_universe_csv.zip (470 Kb)]
- Zipped Excel spreadsheet [ mainstem_wq_universe_xls.zip
(3,000 Kb)]
- Summer water quality data subset (1980-1999) upon which this
assessment was based
- Comma-delimited text [ summer_wq_80-99.csv (890 Kb)]
- Zipped Excel spreadsheet [ summer_wq_80-99_xls.zip
(670 Kb)]
- Fish tissue contaminant data (1970-1998) compiled for this
assessment
- Comma-delimited text [ fish_tissue.csv (390 Kb)]
- Zipped Excel spreadsheet [ fish_tissue_xls.zip
(280 Kb)]
- Combined archive of all three databases
- Zipped comma-delimited text [ umr_wqa_alldata_csv.zip (690 Kb)]
- Mainstem water quality data universe (1953-1999) compiled for
this assessment
A Note on the Data File FormatsComma-delimited text (or comma-separated values): A simple ASCII text format universally used for transferring data between spreadsheet (e.g., Lotus 1-2-3, Microsoft Excel, Quattro Pro) and database management (e.g., Lotus Approach, Microsoft Access, dBase) applications. Each data row from the original table is expressed as a line in the text file, with individual values separated by commas and set off with quotes when necessary. The example applications above, and most others that handle data, can readily open or import files in this format. Zipped: A common compressed format that can incorporate a single or multiple files. Zipping removes redundant information and reduces file sizes (and download times), but retains all of the original data. After downloading, files in this format must be expanded ("unzipped") using any one of several widely available utilities (e.g., Winzip, Zipmagic). |
One
of the coauthors presented a brief summary of the above report, as a poster
entitled, "Results from Upper Mississippi River Water Quality Assessment,"
at the third National Monitoring Conference, in Madison, Wisconsin, May
20-23, 2002. The conference was sponsored by the National
Water Quality Monitoring Council
and was attended by several hundred water quality professionals from local,
State, and Federal agencies, as well as by university staff, consultants,
and equipment manufacturers. The Council provides a national forum to
coordinate consistent and scientifically defensible water quality monitoring
methods and strategies. An abstract
of the report (PDF) is available, as well as the complete
conference proceedings (PDF), both as PDF files.
![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif)