Lake Plant Eutrophication IBI| Field Name | Valid Values | Definition | Definition Source |
|---|
| FW_ID | enumerated | A unique Fisheries Waterbody ID for joining/linking polygons to DNR Fisheries Lake Survey DB (Oracle). FW_IDs are assigned based on how the waterbody is managed by DNR Fisheries (i.e., an FW_ID may correspond to an entire basin '00' or to a specific sub-basin '01','02',etc. | DNR Fisheries |
| 1-18000 | A valid Fisheries Waterbody ID | DNR Fisheries Lake Survey DB |
| 88888 | A "dummy" Fisheries Waterbody ID representing an alternate representation of a basin (implemented in SDE Dataset only) | |
| 99999 | A "dummy" Fisheries Waterbody ID representing a non-MN portion of a border water | |
| DOWLKNUM | - | Waterbody ID per DNR Ecological and Water Resources (EWR) Division's LAKESDB database; the DOWLKNUM may end in"00" (entire basin) or "01","02", etc. (sub-basin) | DNR EWR LAKESDB |
| PW_BASIN_NAME | - | Lake Name per DNR Ecological and Water Resources Division's LAKESDB database | DNR EWR LAKESDB |
| PW_PARENT_NAME | - | Public Waters Basin parent name (corresponding to DOWLKNUMs ending in '00') per DNR Ecological and Water Resources Division's LAKESDB database | DNR EWR LAKESDB |
| PW_SUB_NAME | - | Public Waters Basin sub-basin name (corresponding to DOWLKNUMs not ending in '00') per DNR Ecological and Water Resources Division's LAKESDB database | DNR EWR LAKESDB |
| SUB-FLAG | enumerated | Identifies whether basin is a sub-basin of a larger complex of basins | DNR EWR LAKESDB |
| Y | Yes, is a sub-basin; DOWLKNUM usually ends in '01', '02, '03, etc. | DNR EWR LAKESDB |
| N | No, is not a sub-basin; DOWLKNUM usually ends in '01', '02, '03, etc. | DNR EWR LAKESDB |
| WB_CLASS | enumerated | Hydrologic feature type; based on original USCLASS attribute from USGS 100K DLG dataset; some polygons have been reclassified to better indicate their current hydrologic state | USGS 100K DLG data |
| Artificial Basin | | |
| Fish Hatchery or Pond | | |
| Industrial Waste Pond | | |
| Innundation Area | | |
| Intermittent Water | | |
| Island or land | | |
| Lake | | |
| Mine or gravel pit | | |
| Riverine polygon | | |
| LAKE_CLASS | - | Lake Class per DNR Fisheries Investigational Report #417 - Schupp 1992 http://files.dnr.state.mn.us/publications/fisheries/investigational_reports/417.pdf | DNR Fisheries |
| ACRES | - | Surface area of waterbody in acres | ESRI auto-calculated |
| SHORE_MI | - | Perimeter of shoreline in miles (includes island shoreline) | ESRI auto-calculated |
| CENTER_UTM_X | - | UTM Easting (X) of waterbody center | ESRI auto-calculated |
| CENTER_UTM_Y | - | UTM Northing (Y) of waterbody center | ESRI auto-calculated |
| CTY_NAME | - | County Name | |
| DNR_REGION | enumerated | DNR Administrative Region | MN DNR |
| 1 | Northwest Region (Bemidji) | |
| 2 | Northeast Region (Grand Rapids) | |
| 3 | Central Region (St. Paul) | |
| 4 | Southern Region (New Ulm) | |
| FSH_OFFICE | - | DNR Fisheries Administrative Areas (Fisheries Office) | DNR Fisheries |
| Ecoregion Class | - | Ecoregion class (as used in Radomski and Perleberg 2012) | DNR Ecological and Water Resources |
| Recent Survey Date | - | Survey date for the most recent survey (compiled from various sources) | DNR Ecological and Water Resources |
| Recent Taxa Richness | - | Taxa richness (number of taxa) for the most recent survey compiled | DNR Ecological and Water Resources |
| Recent FQI | - | Floristic quality index (FQI) for the most recent survey compiled | DNR Ecological and Water Resources |
| Recent PD Richness | - | Percent difference from richness threshold for the most recent survey compiled | DNR Ecological and Water Resources |
| Recent PD FQI | - | Percent difference from FQI threshold for the most recent survey compiled | DNR Ecological and Water Resources |
| FQI Threshold Status | - | IBI status in relation to FQI threshold (based on most recent compiled survey). See Radomski and Perleberg 2012. | DNR Ecological and Water Resources |
| Number Surveys | - | Number of compiled surveys | DNR Ecological and Water Resources |
| Min Taxa Richness | - | Minimum taxa richness | DNR Ecological and Water Resources |
| Max Taxa Richness | - | Maximum taxa richness | DNR Ecological and Water Resources |
| Min FQI | - | Minimum FQI | DNR Ecological and Water Resources |
| Max FQI | - | Maximum FQI | DNR Ecological and Water Resources |
| Min PD Taxa Richness | - | Minimum percent difference from richness threshold | DNR Ecological and Water Resources |
| Max PD Taxa Richness | - | Maximum percent difference from richness threshold | DNR Ecological and Water Resources |
| Min PD FQI | - | Minimum percent difference from FQI threshold | DNR Ecological and Water Resources |
| Max PD FQI | - | Maximum percent difference from FQI threshold | DNR Ecological and Water Resources |
| Year | - | Year of the most recent survey (compiled from various sources) | DNR Ecological and Water Resources |
