Table name: INFOSTREAMS
Schema is provisional. Based on Wyoming data only.
Field Name |
Data Type |
Description |
Status |
| MWBCODE | Text 255 | Master Waterbody Identification Code, unique code for each waterbody within state | Required |
| STATE | Text 2 | State Postal Code Abbreviation | Required |
| WATERBODYTYPE | Text 1 | 1=Lake, 2=Impoundment, 3=Stream | Required |
| WATERBODYNAME | Text 255 | Geographic Place Name | Required |
| TRIB_TO | Text 255 | Place Names of Downstream Waterbody | Optional |
| MANAGE | Text 8 | State Management Location Code (wildlife district) | Optional |
| LATITUDE_NORTH | Number (Double) | Latitude at northern boundary of reach (decimal degrees) | Optional |
| LONGITUDE_EAST | Number (Double) | Longitude at eastern boundary of reach (decimal degrees) | Optional |
| LATITUDE_SOUTH | Number (Double) | Latitude at southern boundary of reach (decimal degrees) | Optional |
| LONGITUDE_WEST | Number (Double) | Longitude at western boundary of reach (decimal degrees) | Optional |
| LATITUDE_MID | Number (Double) | Latitude at mid-point of reach (decimal degrees) |
Required |
| LONGITUDE_MID | Number (Double) | Longitude at mid-point of reach (decimal degrees) |
Required |
| FIPSCODE | Text 3 | County FIPS Code (3 digits) | Required |
| USGSHYDR | Text 8 | USGS Hydrologic Unit | Optional |
| NHDHYDR | Text 255 | NHD Hydologic Code | Optional |
| SECTION | Text 2 | Section in which lake exists | Optional |
| TOWNSHIP | Text 3 | Township in which lake exists | Optional |
| RANGE | Text 3 | Range in which lake exists | Optional |
| STALENGTH | Number (Single) | Length of sampling reach (m) | Optional |
| MEANWIDTH | Number (Single) | Mean channel depth in reach (m) | Optional |
| MEANDEPTH | Number (Single) | Mean depth of lake (m) | Optional |
| WATERSHED | Number (Double) | Area of watershed upstream of sample reach (hectares) | Optional |
| ELEVATION | Number (Double) | Mean elevation (m) of reach (NAD83, NAVD__) | Optional |
| WATERSHED | Number (Double) | Lake Watershed Area (ha) | Optional |
| SAMPLEDATE | Date/Time | Date of sampling event | Optional |
| SAMP_DATE2 | Double | Alternate representation of sample date | Optional |
| EVENT_ID | Text | Description of sampling event | Optional |
| LINE_SLOPE | Number (Double) | Mean Slope of Sample Reach (%) | Optional |
| AvgWetDepth | Number (Double) | Mean Wetted Depth of Channel (m) | Optional |
| AvgWetWidth | Number (Double) | Mean Wetted Width of Channel (m) | Optional |
| Discharge | Number (Double) | Stream discharge rate during sampling event (cms) | Optional |
| Stage | Number (Double) | Stream stage (m, Vertical Datum?) during sampling event | Optional |
Lake Information | Streams Information | Water Quality - Lakes | Water Quality - Streams | Fish Information - Lakes | Fish Information - Streams | Species Codes | FIPS Codes
Email comments & suggestions to Maris Webmaster
The MARIS project @ the University of Illinois GMS
Lab
NOTICE:
The MARIS project is a prototype.
Data included in the databases are real, but may not be complete.
Contact the appropriate state database contact before
using this data.
Last updated: September 08, 2005