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

Fisheries

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

Fisheries Database Browser

division bar
Fish data from the Long Term Resource Monitoring Program (LTRMP) are available through two database browser tools:

  1. Fisheries Database Browser, which provides the most complete access to raw data using the widest variety of query parameters. (below Query Fisheries Data)
  2. The Graphical Fish Database Browser, which provides summaries of the data as graphs and tables by species, gear, and location is available at http://www.umesc.usgs.gov/data_library/fisheries/graphical/fish_front.html
For fish metadata, read the Federal Geographic Data Committee/National Biological Information Infrastructure, Fish metadata page.

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

Queries made using the Fisheries Database Browser are real time, it may take a few minutes to retrieve your results.
If you want to download the entire fish data set it is available here. Entire Fisheries Data Setdivision bar

Query Fisheries 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)
Upper Pool 04 (If checked, only Upper Pool 4 Data will be downloaded)
Lower Pool 04 (If checked, only Lower Pool 4 Data will be downloaded)
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)
division bar
The LTRMP fish collections began in 1989. Standard collections are made between June 15 and October 31 each year.
Learn more about starting years for the field stations
Date range (Format: mm/dd/yyyy; required)
Date range: Beginning: Ending:
division bar
The LTRMP fisheries data is collected historically during three separate time period during the year:
Sampling Time Period (required)
Sampling Time Period 1 (June 15th to July 31st)
Sampling Time Period 2 (August 1st to September 15th)
Sampling Time Period 3 (September 16th to October 31st)
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. Please 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 primary format for river mile is rmmm.ma where r designates the river (M = Mississippi and I = Illinois), 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 fisheries fixed sites location codes
Fixed location code (not required)
division bar
Stratum class describes the type of river environment in which the data were collected.
Stratum class (not required)
division bar
Various gears and methods are used to collect fish and can be searched separately.
Learn more about gear year ranges
Gear (not required)
division bar
Substrate type describes the characteristics of sediment type (river bottom) at a sampling site.
Sediment (not required)
Gravel/Rock/Hard Clay
Sand/Mostly Sand
Silt
Silt/Clay/Little Sand
division bar
Data can be retreived for all species, or species can be selected individually or a combination by pressing the Control key while selecting species desired.
Learn more about fish species names
Fish species (not required)
division bar
Fish lengths are recorded in millimeters (1 inch is approximately equal to 25 mm).
Fish lengths (valid range: 5-2000; not required)
Length range Minimum: Maximum:
division bar
Data fields may be specified by clicking the first desired field, pressing the Control key and clicking additional fields.
Learn more about fisheries field name abbreviations
Data field list
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

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/fisheries/fish1_query.shtml
Page Contact Information: Contacting the Upper Midwest Environmental Sciences Center
Page Last Modified: April 4, 2011