USGS - science for a changing world

Upper Midwest Environmental Sciences Center

The Long Term Resource Monitoring Program

An element of the Upper Mississippi River Restoration - Environmental Management Program

Water Quality

Upper Mississippi River Restoration - Environmental Management Program U. S. Army Corps of Enineers

Water Quality Database Download Tool

division bar
The Water Quality Database Download Tool provides the most complete access to raw data using the widest variety of query parameters.

Please read the UMESC LTRMP Database Browser Notes before using this browser.

For water component information, read the Component Information Page that contains a description, history, and value ranges of the data.

Please be aware that the quality assurrance flags are downloaded with Water Quality parameters to allow users to remove questionable data. A description of the quality assurrance flags and their use can be found in the document: LTRMP WQ QA Flag Primer. .

Queries made using the Water Quality Database Browser are real time, it may take a few minutes to retrieve your results.
division bar

Query Water Quality Data

division bar
Select a Field Station(s) to query Learn more about river mile ranges
Field Station (required)
Field Station 1 (Lake City, MN)
Field Station 2 (Onalaska, WI)
Field Station 3 (Bellevue, IA)
Field Station 4 (Brighton, IL)
Field Station 5 (Jackson, MO)
Field Station 6 (Havana, IL)
Field Station 7 (Fayette, IA)
division bar
Water data has been collected every year from 1988 to present.
Enter a beginning and ending date to query.
Learn more about water quality date ranges
Date range (Format: mm/dd/yyyy; required)
Beginning:  Ending: 
division bar
A barcode is an eight-digit number that identifies the data sheet where the data were originally recorded. You may use a range of barcodes, a list of barcodes, or a combination of each. Enter the range of barcodes desired.
Barcodes range (not required)
Starting barcode:  Ending barcode: 

Enter the list of barcodes desired. (separate each barcode with a space)
Barcode list (not required)
division bar
The Universal Transverse Mercator (UTM) coordinates are a global grid system similar to latitude and longitude. Rather than using hemispheres, UTM coordinates divide the Earth into 60 north-south zones of 6 degrees longitude each. The UTM coordinates are the distance in meters from the central meridian (Easting) and from the Earth's equator (Northing) for each of these 6 degree zones. A zone's central meridian is the line of longitude from the 6 degree intersection with the equator to the North Pole. The UTM coordinates for all river pools are based from zone 15. Enter a UTM range for the pool(s) selected.
Learn more about UTM ranges for the field stations
UTM range (not required)
UTM Easting Coordinate Range Beginning: Ending:
UTM Northing Coordinate Range Beginning: Ending:
division bar
Another method of locating where the data were collected is by location code which is not as accurate as the UTM coordinates. The format of a location code is rmmm.ma where r designates the river or tributary (Water quality river name abbreviations), mmm.m is the river mile (recorded to the nearest 0.1 mile), and a is an alphabetic code for the relative lateral position across the floodplain (going west to east). The default is "All Location Codes".
Learn more about water quality fixed-site locations
Location code (not required)
division bar
Stratum type is a brief description of the type of river environment in which the data were found. Stratum type pertains to random sampling sites only.
Stratum class (not required)
Contiguous backwater to main channel (BWC)
Impounded (IMP)
Isolated (ISO)
Lake Pepin or Swan Lake (TDL)
Main channel (MC)
Side channel (SC)
division bar
Habitat class is a brief description of the type of river environment in which the data were found. Habitat class pertains to fixed-site sampling only.
Habitat class (not required)
Backwater contiguous (BWC)
Backwater isolated (BWI)
Impounded - Lakelike (IMP-L)
Impounded (IMP)
Main channel (MC)
Side channel (SC)
Tributary (TRIB)
division bar
A brief description of the type of sediment (river bottom) in which the data were found.
Sediment type (not required)
Clay
Hard
Sand
Silt
Silt/Clay/Sand
division bar
Choose the data fields to download by clicking the first desired field then hold down the Control key and click additional fields.
Learn more about water quality database browser field name abbreviations
Learn more about water quality chemical QA/QC flags
Data field list (not required)
division bar
Download type (1) is the default download method and is suitable for importing into MS-Excel, MS-Access, and SAS
Submit query
1. Download Data as Comma Delimited with Field Names In First Row
2. Download Data as Fixed Column Length Format, No Field Names
3. Download Data as Comma Delimited Format, No Field Names
4. Download Data as ArcView Compatible Format, Field Names (e.g., field1, field2)

division bar

Accessibility FOIA Privacy Policies and Notices

Take Pride in America logo USA.gov logo U.S. Department of the Interior | U.S. Geological Survey

URL: http://www.umesc.usgs.gov/data_library/water/water1_query.shtml
Page Contact Information: Contacting the Upper Midwest Environmental Sciences Center
Page Last Modified: September 1, 2010