dnr_hydrography_stream_trout_lakes - feature class table (DNR Fisheries)| 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 |
| 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 | | |
| Sewage Pond/Filtration Bed | | |
| Tailings Pond | | |
| Wetland | | |
| 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 | 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 |
| OUTSIDE_MN | enumerated | Identifies border waters | |
| Y | Polygon (portion of border lake) that is outside of MN | |
| N | Lake is not a border lake (outside of MN) | |
| DELINEATED_BY | - | Person/unit/source of polygon delineation | |
| DELINEATION_DATE | - | Date of polygon delineation or shape update. | |
| DELINEATION_SRC | enumerated | Photo imagery source used for digitizing polygon feature | DNR Fisheries |
| 1991 DOQ | 1991 black & white digital ortho photoquad | |
| 2004 FSA | 004 color Farm Service Adminstration photo | |
| 2005 FSA | 2005 color Farm Service Adminstration photo | |
| 2006 FSA | 2006 color Farm Service Adminstration photo | |
| 2008 FSA | 2008 color Farm Service Adminstration photo | |
| 2009 FSA | 2009 color Farm Service Adminstration photo | |
| 2010 FSA | 2010 color Farm Service Adminstration photo | |
| 2011 FSA | 2011 color Farm Service Adminstration photo | |
| LAM | DNR Lands and Minerals polygon | |
| ORIG DLG | Original USGS DLG 100K polygon | |
| PWI | Public Water (PWI) polygon representing the Ordinary High Water Level (OHWL) | |
| DELINEATION_NOTES | - | Any notes related to the delineation. | |
| APPROVED_BY | - | | |
| APPROVAL_DATE | - | | |
| APPROVAL_NOTES | - | | |
| PUBLISH_DATE | - | Date the lake polygon source layer was re-published following updates. | DNR Fisheries |
| STREAM_TROUT | enumerated | Flag indicating whether the lake is a stream trout lake. | DNR Fisheries |
| Y | Yes, the lake is a stream trout lake | |
| CONTENT_DATE | - | Date the layer-specific attributes were last updated | DNR Fisheries |