USGS - science for a changing world

Upper Midwest Environmental Sciences Center

Environmental Management ProgramThe Long Term Resource Monitoring Program

An element of the Environmental Management Program

Fisheries

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. division 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)
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
A barcode is an eight-digit number that identifies a single sample. You may use a range of barcodes, a list of barcodes, or a combination of each. Enter the range of barcodes desired.
Barcode 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. 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
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/fisheries/fish1_query.shtml
Page Contact Information: Contacting the Upper Midwest Environmental Sciences Center
Page Last Modified: September 1, 2010