env_ibi_lakes_fisheries - feature class table (DNR Fisheries)Field Name | Valid Values | Definition | Definition Source |
---|
DNR_HYDRO_ID | 1 to 35000 | Unique GIS record number of waterbody features in DNR Hydrography SDE - Open Water Features | DNR Fisheries |
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 | - | Public Water (Lake) Name per DNR Ecological and Water Resources Division's LAKESDB database | DNR EWR LAKESDB |
WATERSHED | - | The Major Watershed (HUC 8) name for the given waterbody | |
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 |
DNR_REGION | enumerated | DNR Administrative Region | bdry_dnr_admin_regions.gdb\dnr_admin_regions |
| 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) | bdry_dnr_fisheries_admin.gdb\dnr_fisheries_admin |
ID | - | A unique ID for each IBI survey (matches original IBI database) | DNR Fisheries IBI Database (J. Bacigalupi) |
SOURCE | enumerated | Source of IBI Survey (DNR Unit that performed the Nearshore components of the FIBI survey) | DNR Fisheries IBI Database (J. Bacigalupi) |
| EWR | DNR Ecological and Water Resources Division | DNR Fisheries IBI Database (J. Bacigalupi) |
| Fisheries | DNR Ecological and Water Resources DivDNR Fisheries Section | DNR Fisheries IBI Database (J. Bacigalupi) |
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 FIBI Tool 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) |
IBI_Tool | - | Indicates which IBI Tool was used to generate a score for the lake. The Tool is based on lake class and some are adjusted for lake size. | DNR Fisheries IBI Database (J. Bacigalupi) |
Status | enumerated | | |
| Below Impairment Threshold | Below the Impairment Threshold for the FIBI Tool | |
| At or Above Impairment Threshold | At or Above the Impairment Threshold for the FIBI Tool | |
| Exceptional | Above an FIBI score such that the fish community is considered exceptional | |
IBI_Score_Conditions | enumerated | Flag describing the double-checked accuracy of the FIBI score | DNR Fisheries IBI Database (J. Bacigalupi) |
| Preliminary | This score has not been checked by multiple staff to confirm accuracy | |
| Confirmed | This score has been checked by multiple staff to confirm accuracy | |
| Final for Assessment | This score has been checked by multiple staff to confirm accuracy and has been considered during assessment | |
Impairment_treshold | enumerated | The impairment threshold value of the FIBI score | DNR Fisheries IBI Database (J. Bacigalupi) |
| 45 | Impairment threshold for lakes scored with FIBI Tool 2 | |
| 38 | Impairment threshold for lakes scored with FIBI Tool 4 | |
| 24 | Impairment threshold for lakes scored with FIBI Tool 5 | |
| 36 | Impairment threshold for lakes scored with FIBI Tool 7 | |
Confidence_Interval | enumerated | The 90% confidence interval determined using repeated surveys | DNR Fisheries IBI Database (J. Bacigalupi) |
| 36-54 | 90% Confidence Interval for lakes scored with FIBI Tool 2 | |
| 30-46 | 90% Confidence Interval for lakes scored with FIBI Tool 4 | |
| 9-39 | 90% Confidence Interval for lakes scored with FIBI Tool 5 | |
| 27-45 | 90% Confidence Interval for lakes scored with FIBI Tool 7 | |
Percent_Diff_from_Impairment_Threshold | -100 to 316.66666666 | The percent deviation from the impairment threshold value for that FIBI Tool (negitive indicates the score is below the threshold) | DNR Fisheries IBI Database (J. Bacigalupi) |
Exceptional_FIBI_score | enumerated | When the FIBI score is above this value the fish community is considered exceptional | DNR Fisheries IBI Database (J. Bacigalupi) |
| 64 | The exceptional value for lakes scored with FIBI Tool 2 | |
| 59 | The exceptional value for lakes scored with FIBI Tool 4 | |
| NA | The FIBI score has not been determined where a fish community is considered exceptional for lakes scored with FIBI Tools 5 and 7 | |
Data_conditions | - | Describes any conditions with data quality or quantity, or limitations for use | 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_INSTVR_RAW | - | Raw value: Number of Insectivores. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_OMNIV_RAW | - | Raw value: Number of Omnivores. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_CYPR_RAW | - | Raw value: Number of Cyprinids. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_SBD_RAW | - | Raw value: Number of Small Benthic Dwellers. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_VEGDW_RAW | - | Raw value: Number of Vegetation Dwellers. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_INT_NS_RAW | - | Raw value: Proportion of Intolerants in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_SBD_NS_RAW | - | Raw value: Proportion of Small Benthic Dwellers in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_VGD_NS_RAW | - | Raw value: Proportion of Vegetation Dwellers 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_OMV_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_CRV_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 fish species biomass in the Gillnet. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_NAT_SP | - | Metric Score: Number of Native Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_INT_SP | - | Metric Score: Number of Intolerant Species. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_TOL_SP | - | Metric Score: Number of Tolerant Species. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_INSTVR | - | Metric Score: Number of Insectivores. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_OMNIV | - | Metric Score: Number of Omnivores. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_CYPR | - | Metric Score: Number of Cyprinids. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_SBD | - | Metric Score: Number of Small Benthic Dwellers. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
NUM_VEGDW | - | Metric Score: Number of Vegetation Dwellers. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_INT_NS | - | Metric Score: Proportion of Intolerants in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_SBD_NS | - | Metric Score: Proportion of Small Benthic Dwellers in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_VGD_NS | - | Metric Score: Proportion of Vegetation Dwellers in Nearshore. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_INS_BM | - | Metric Score: Proportion of Insectivore Biomass in Trapnet This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_OMV_BM | - | Metric Score: Proportion of Omnivore Biomass in Trapnet. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_TOL_BM | - | Metric Score: Proportion of Tolerant Biomass in Trapnet. This metric is (-) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PROP_CRV_BM | - | Metric Score: Proportion of Carnivore Biomass in Gillnet. This metric is (+) correlated with lake quality. | DNR Fisheries IBI Database (J. Bacigalupi) |
PA_INT_BM | - | 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) |
NUM_IBI | - | Number of IBI surveys performed on this lake and in this layer | DNR Fisheries IBI Database (J. Bacigalupi) |
MAX_DATE | enumerated | Flag denoting whether an IBI survey is the most recent for a lake | |
| Y | IBI survey is the most recent survey | |
| N | IBI survey is not the most recent survey | |
MULT_IBI | - | An * indicates whether the lake has more than one IBI score. In ArcMap, click on a lake with the Identify Tool to access records from all years (related table). | |
CONTENT_DATE | - | Date the layer-specific attributes were last updated | |
Display | enumerated | Flag denoting whether an IBI survey is the most recent or best survey data to display for a lake | DNR Fisheries IBI Database (J. Bacigalupi) |
| N | IBI survey is not the most recent or best survey data to display | |
| Y | IBI survey is the most recent or best survey data to display | |