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

Aquatic Vegetation

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

Vegetation Informal Database Browser

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.

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, Begining 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 vegetation informal query:
Field Station:

Please select the Field Stations(s) you would like to query (Required):

Field Station 1 (Lake City, MN)
Pools 4 and 5		 Field Station 2 (Onalaska, WI)
Pools 7 and 8
Field Station 3 (Bellevue, IA)
Pools 12 and 13		 Field Station 4 (Brighton, IL)
Pool 26 & Lower Alton Pool
Field Station 6 (Havana, IL)
Upper Alton Pool & LaGrange
Date Range:

Vegetation Informal data has been collected every year starting in 1992 to 1997, and was collected during the months of May through October.

Starting Years For Each Pool
Field Station River River Pool Starting Year Ending Year
1 (Lake City, MN)
 Mississippi Pool 4
1992
1997
2 (Onalaska, WI)
 Mississippi Pool 8
1992
1997
3 (Bellevue, IA)
 Mississippi Pool 13
1992
1997
4 (Brighton, IL)
 Mississippi Pool 26
1992
1997
6 (Havana, IL)
 Illinois La Grange
1992
1997

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:
Location Code:

Another method of locating where the data was collected is by recording what is called a Location Code. This is never as accurate as the UTM coordinates. 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.m where r designates the river (M = Mississippi and I = Illinois), and mmm.m is the river mile (recorded to the nearest 0.1 mile).

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):

Habitat Class:

A brief description of the type of river environment in which the data were found. Please select the Habitat Class you would like to query with (Not Required):

Backwater Contiguous (BWC) Backwater Isolated (BWI)
Impounded (IMP) Main Channel (MC)
Main Channel Border (MCB) Side Channel (SC)
Tributary (TDL)
Substrate Type:

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):

Predominantly Silt and/or Clay Predominantly Silt with some Sand
Predominantly Sand with some Silt or Clay
Estimated vegetation bed size:
Please select the Bed Size you would like to query with (Not Required):
Small Bed (0-10 meters in length and width) Long-Linear Bed (>10 meters in length and 0-10 meters in width)
Medium Bed (10-100 meters in length and width) Large Bed (>100 meters in length and >10 meters in width)
Water Depth:
Water depth is measured to the nearest 0.1 meter. Please enter the water depth range desired: (Not Required)
(Valid Range: 0 - 10) Water Depth Range: Minimum: Maximum:
Vegetation Species (Common and Scientific):
Scientific Species are listed after the Common Species.

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):

Vegetation Species:

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 the 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
Download Data As Fixed Column Length Format
Download Data As Comma Delimited Format
Download Data As XML Format

 

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/vegetation/informal/veg_informal_1_query.html
Page Contact Information: Contacting the Upper Midwest Environmental Sciences Center
Page Last Modified: February 1, 2011