Link to USGS home page.
U.S. Geological Survey - Biological Resources - UMESC

Fish Database Browser
line-c.gif
Last updated on July 21, 2003

NOTE: Because this is a real-time query of UMESC's Oracle Database, any query submitted may take a while, depending on the complexity of the query, the amount of data in the database tables querying, and the current load on the server.

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

Query parameters are appended to each other using AND logic conditionals only. Using any type of OR logic conditionals greatly complicates the query for both the user and the program logic.

River Pool, Beginning Date, and Ending Date are the only required parameters. If these are the only parameters entered, then all data for this River Pool and Date Range will be retrieved. If additional parameters are entered, the data retrieved will be a subset based on the parameters.

Parameters which are not entered are not used as a criteria to further subset the data query.

Parameters which are a range or a minimum/maximum value require two parameters, one for the start or minimum, and one for the end or maximum. If either of these parameters are not entered, the entire range is cleared and not used as a parameter for the data query.

Enter the criteria you would like to use in your fish query:

Field Station:

Please select the Field Station(s) or Special Project(s) you would like to query (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 (Special Project)
Date Range:

Fish data collection started at various years for the different river pools. It has been collected every year to the present, since these starting years. Fish data are typically collected during the months of June through November, with the exception of Pool 26, which has some December collections, and Open River, which has collections throughout the entire year.

* Field Station 6 (Havana, IL) collected samples from River Pool 26 on October 2, 3, 4 1995.

Starting Years For Each Pool
Field Station River River Pool Starting Year
1 (Lake City, MN) Mississippi Pool 4 1990
2 (Onalaska, WI) Mississippi Pool 8 1989
3 (Bellevue, IA) Mississippi Pool 13 1989
4 (Alton, IL) Mississippi Pool 26 1989
5 (Cape Girardeau, MO) Mississippi Open River 1991
6 (Havana, IL) Illinois, Mississippi La Grange (*) 1990
7 (Special Project) Illinois, Mississippi Pool 25, 26, Lower Illinois 1996

Attention: The four digit date is now being used.

Please enter a beginning and ending date you would like to query with:
(Required) (Format: mm/dd/yyyy):
Date Range: Beginning: Ending:
Barcode:

Barcodes are used to identify the data sheets upon which the data are originally recorded. The barcodes for LTRMP data are an eight digit number. You may use a range of barcodes, a list of barcodes, or a combination of each.

Please enter the range of barcodes desired (Not Required):
Starting Barcode: Ending Barcode:


Please enter the list of barcodes desired (separate each barcode with a space) (Not Required):
Barcode List:
UTM Range:

The usual method of locating where the data were collected is by recording of the UTM coordinates. UTM coordinates are global grid system similar to latitude and longitude. Rather than using hemispheres, UTM coordinates divide the earth into sixty 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. UTM coordinates for all river pools are based from zone 15.

Please enter a UTM range for the pool(s) selected (Not Required):
Valid UTM Ranges For Each Pool
River River Pool Valid UTM Easting Range Valid Northing Range
Mississippi Pool 4 515600 - 597200 4908100 - 4980300
Mississippi Pool 8 633200 - 648700 4825900 - 4868600
Mississippi Pool 13 693400 - 739700 4608400 - 4681900
Mississippi Pool 26 695100 - 751400 4297300 - 4324500
Mississippi Open River 780300 - 834800 4104400 - 4200200
Illinois La Grange 707300 - 786000 4422300 - 4503700
UTM Easting Coordinate Range: Beginning: Ending:
UTM Northing Coordinate Range: Beginning: Ending:
Site Alias:

Another method of locating where the data were collected is by recording what is called a Site Alias. This is simply a name of an area which can vary in both size and shape. It is often used to identify a particular side channel, lake, or slough that can't be easily isolated using UTM coordinates.

Please enter a Site Alias (Not Required):
Site Alias:
Location Code:

Another method of locating where the data were collected is by recording what is called a Location Code. This is never as accurate as the UTM coordinates, and is usually not as accurate as the Site Alias. However, for some applications and parties who want to use a site list or river mile, it can at least get them close to what they are looking for. The format varies, however, the primary format 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).

Please select the Location Code(s) you would like to query with. You may choose from the provided list, type them in, or use a combination of each.(Not Required):

If any Location Codes you are interested in are not in this list, you need to type them in here (seperate each Location Code with a space). You may use * (many characters) and ? (single character) as wildcards in any combination. Example: D*.RS M2??.* would get all Random Sites starting with D, and all Mississippi Fixed Sites for river miles 200 - 299.(Not Required):

Location Code List:
Stratum Class:

A brief description of the type of river environment in which the data were found.

You may select multiple Stratum Classes by holding your control key down while selecting them.

Please select the Stratum Class you would like to query with (Not Required):
Gear:

Various methods and devices are used to temporarily capture fish for identification and analysis before returning them to the river. These methods and devices are referred to as the Gear.

You may select multiple Gears by holding your control key down while selecting them.

Please select the Gear you would like to query with (Not Required):
Sediment:

A brief description of the type of sediment (river bottom) in which the data were found.

Please select the Substrate Type you would like to query with (Not Required):

Gravel/Rock/Hard Clay Sand/Mostly Sand
Silt Silt/Clay/Little Sand
Fish and Turtle Species:
Turtle Species are at the bottom of the list.

You may select multiple Species by holding your control key down while selecting them.

Please select the Species you would like to query with (Not Required):
Fish Lengths:

Lengths of fish are measured in millimeters.

Please enter the length range of fish desired:
(Not Required) (Valid Range: 5 - 2000)
Length Range: Minimum: Maximum:

Choose the data fields you want to download for your query. If you choose "All Fields" (default), all the fields from the data field list will be downloaded. If you want to only download certain fields, select them by first clicking on th e first one, then, while holding down your Control key, click on additional ones. If any fields are selected and you still have the "All Fields" selected, you will only get the selected fields, not all fields. "All Fields" needs to be selected by itself to work.

Data Field List

Note: Download type (1) is the default download method and is suitable for importing into MS-Excel, MS-Access and SAS

Download Data As Comma Delimited With Field Names In First Row
Download Data As Fixed Column Length Format
Download Data As Comma Delimited Format
Download Data As ArcView Compatible Format



Last updated on July 21, 2003 ">July 21, 2003 Questions and comments: web_team@umesc.er.usgs.gov
http://www.umesc.usgs.gov/data_library/fisheries/fish1_query.html

UMESC Homepage