env_ibi_lakes_fisheries - feature class table (DNR Fisheries)| Field Name | Valid Values | Definition | Definition Source |
|---|
| DOW | - | 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 |
| Lake_Name | - | Public Water (Lake) Name | DNR EWR LAKESDB |
| Watershed_Name | - | HUC08 Watershed Name | DNR EWR LAKESDB |
| Fisheries_Area | - | DNR Fisheries Administrative Areas (Fisheries Office) | bdry_dnr_fisheries_admin.gdb\dnr_fisheries_admin |
| Upcoming_Assessment_Year | - | Upcoming watershed assessment year when lake will be assessed, as established by MPCA | DNR Fisheries IBI Database (J. Bacigalupi) |
| Survey_Year | enumerated | Year of IBI Survey | DNR Fisheries IBI Database (J. Bacigalupi) |
| 1997-Present | Note: There were no IBI surveys in 2000, 2004 | |
| Survey_Date | enumerated | Date of IBI Survey | DNR Fisheries IBI Database (J. Bacigalupi) |
| 6/6/1997 - present | | |
| IBI_Score | 0 to 100 | A total score based on summation of 8 - 15 metrics (dependent upon IBI model used). Higher IBI scores indicate better lake quality (as determined by watershed land use, trophic state and aquatic vegetation). Lake characteristics associated with higher IBI scores are low percent littoral area, high maximum depth, high Secchi depth transparency and high latitude. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Status | enumerated | Status of IBI Score | DNR Fisheries IBI Database (J. Bacigalupi) |
| At or Above Exceptional Use Threshold | IBI score is equal to or greater than the Exceptional Use Threshold | |
| At or Above General Use Impairment Threshold | IBI score is equal to or greater than the General Use Impairment Threshold | |
| Below Exceptional Use Threshold | IBI score is below Exceptional Use Threshold and lake has been designated as Exceptional Use | |
| Below General Use Impairment Threshold | IBI score is below General Use Impairment Threshold and lake has been designated as General Use | |
| Sampled-Wholly Within Tribal Nation | Lake was sampled but is wholly within tribal nation boundary | |
| IBI_Model_Used | enumerated | Indicates which IBI Model was used to generate a score for the lake. The model is based on lake class, and some are adjusted for lake size | DNR Fisheries IBI Database (J. Bacigalupi) |
| 2 shallow | Applied to deep, complex, warm lakes | |
| 2 deep | Applied to deep, complex, cold lakes | |
| 4 shallow | Applied to deep, simple, warm lakes | |
| 4 deep | Applied to deep, simple, warm lakes | |
| 5 | Applied to moderately deep, vegetated lakes | |
| 7 | Applied to shallow, productive lakes | |
| Model_Description | enumerated | Description of IBI model | DNR Fisheries IBI Database (J. Bacigalupi) |
| Deep Complex Warm | Description for lakes scored using IBI Model 2 shallow | |
| Deep Complex Cold | Description for lakes scored using IBI Model 2 deep | |
| Deep Simple Warm | Description for lakes scored using IBI Model 4 shallow | |
| Deep Simple Cold | Description for lakes scored using IBI Model 2 deep | |
| Moderately Deep Vegetated | Description for lakes scored using IBI Model 5 | |
| Shallow Productive | Description for lakes scored using IBI Model 7 | |
| Anchor | enumerated | Stratified random sample of lakes identified for long term trend analysis within each watershed | DNR Fisheries IBI Database (J. Bacigalupi) |
| Yes | Identified as anchor lake | |
| No | Not identified as anchor lake | |
| General_Use_Impairment_Threshold | enumerated | The General Use Impairment Threshold value associated with each IBI Model | DNR Fisheries IBI Database (J. Bacigalupi) |
| 45 | General Use Impairment Threshold for lakes scored with IBI Model 2 | |
| 38 | General Use Impairment Threshold for lakes scored with IBI Model 4 | |
| 24 | General Use Impairment Threshold for lakes scored with IBI Model 5 | |
| 36 | General Use Impairment Threshold for lakes scored with IBI Model 7 | |
| General_Use_Confidence_Interval | enumerated | The 90% confidence interval for the General Use Tier, determined using repeated surveys | DNR Fisheries IBI Database (J. Bacigalupi) |
| 36-54 | 90% Confidence Interval for lakes scored with IBI Model 2 | |
| 30-46 | 90% Confidence Interval for lakes scored with IBI Model 4 | |
| 9-39 | 90% Confidence Interval for lakes scored with IBI Model 5 | |
| 27-45 | 90% Confidence Interval for lakes scored with IBI Model 7 | |
| Exceptional_Use_Threshold | enumerated | When the IBI score is above this value, the fish community may be considered for Exceptional Use designation | DNR Fisheries IBI Database (J. Bacigalupi) |
| 64 | Exceptional Use threshold for IBI Model 2 | |
| 59 | Exceptional Use threshold for IBI Model 4 | |
| <Null> | No Exceptional Use threshold for IBI Models 5 or 7 | |
| Percent_Diff_From_General_Use_Impairment_Threshold | -100 to 316.66666666 | The percent deviation from the General Use impairment threshold value for that IBI Modell (negitive indicates the score is below the threshold) | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Nat_Sp_Raw | - | Raw value: Number of Native Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Int_Sp_Raw | - | Raw value: Number of Intolerant Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Tol_Sp_Raw | - | Raw value: Number of Tolerant Species. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Ins_Sp_Raw | - | Raw value: Number of Insectivore Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Omn_Sp_Raw | - | Raw value: Number of Omnivore Species. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Leu_Sp_Raw | - | Raw value: Number of Leuciscid (formerly Cyprinid) Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Smb_Sp_Raw | - | Raw value: Number of Small Benthic Dwelling Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Veg_Sp_Raw | - | Raw value: Number of Vegetation Dwelling Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Int_NS_Raw | - | Raw value: Proportion of Intolerant Individuals in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Smb_Ns_Raw | - | Raw value: Proportion of Small Benthic Dwelling Individuals in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Veg_Ns_Raw | - | Raw value: Proportion of Vegetation Dwelling Individuals in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Ins_Bm_Raw | - | Raw value: Proportion of Insectivore Biomass in Trapnet. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Omn_Bm_Raw | - | Raw value: Proportion of Omnivore Biomass in Trapnet. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Tol_Bm_Raw | - | Raw value: Proportion of Tolerant Biomass in Trapnet. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Tc_Bm_Raw | - | Raw value: Proportion of Carnivore Biomass in Gillnet. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Int_Bm_Raw | - | Raw value: Proportion of Intolerant Biomass in Gillnet. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Nat_Sp_Std | - | Metric Score: Number of Native Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Int_Sp_Std | - | Metric Score: Number of Intolerant Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Tol_Sp_Std | - | Metric Score: Number of Tolerant Species. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Ins_Sp_Std | - | Metric Score: Number of Insectivore Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Omn_Sp_Std | - | Metric Score: Number of Omnivore Species. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Leu_Sp_Std | - | Metric Score: Number of Leuciscid (formerly Cyprinid) Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Smb_Sp_Std | - | Metric Score: Number of Small Benthic Dwelling Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Num_Veg_Sp_Std | - | Metric Score: Number of Vegetation Dwelling Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Int_Ns_Std | - | Metric Score: Proportion of Intolerant Species in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Smb_Ns_Std | - | Metric Score: Proportion of Small Benthic Dwelling Individuals in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Veg_Ns_Std | - | Metric Score: Proportion of Vegetation Dwelling Individuals in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Ins_Bm_Std | - | Metric Score: Proportion of Insectivore Biomass in Trapnet This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Omn_Bm_Std | - | Metric Score: Proportion of Omnivore Biomass in Trapnet. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Tol_Bm_Std | - | Metric Score: Proportion of Tolerant Biomass in Trapnet. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Tc_Bm_Std | - | Metric Score: Proportion of Carnivore Biomass in Gillnet. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Prop_Int_Bm_Std | - | Metric Score: Presence or absence of intolerant fish species in the Gillnet. This metric is (+) correlated with lake quality. A two (2) indicates that intolerant species were sampled in the gill net. A zero (0) indicates that no intolerants were sampled, but there wasn't an expectation for them to be sampled. A negative one (-1) indicates that no intolerants were sampled and there was an expectation for them to have been sampled. | DNR Fisheries IBI Database (J. Bacigalupi) |
| Display | enumerated | Identifies whether an IBI survey is the most recent or best survey data to display for a lake | DNR Fisheries IBI Database (J. Bacigalupi) |
| No | IBI survey is not the most recent or best survey data to display | |
| Yes | IBI survey is the most recent or best survey data to display | |
| Easting | - | UTM Easting (X) of waterbody center | ESRI auto-calculated |
| Northing | - | UTM Northing (Y) of waterbody center | ESRI auto-calculated |
| Shape_Length | - | Perimeter of polygon | ESRI auto-calculated |
| Shape_Area | - | Area of polygon | ESRI auto-calculated |
