Barr Engineering Company
June 2010
Vulnerability of Surface-Water Features to Groundwater Pumping in the Twin Cities Metropolitan Area
Basin_Features
vector digital data
withheld
These data represent surface water features, derived from the Minnesota DNR's Public Waters Inventory and the US Fish and Wildlife Services' National Wetlands Inventory.
1. PWI basins were intersected with NWI wetlands - the area of each unique wetland type within each basin was calculated. Each basin was then assigned that wetland type which covered the greatest proportion of its extent.
2. Approximate depths were assigned to all wetland types present in the study area. The data were saved in tabular form, and joined to the basins feature class by wetland type - thus an approximate depth was derived for each basin.
3. The basin extents were clipped from the wetlands feature class - wetland fragments less than 60 square meters were then removed, as the basin and wetland edges weren't perfectly coincident, and polygon slivers remained after the clip.
4. The depth table was joined to the wetlands by wetland type, and each wetland was assigned an approximate depth. Adjacent wetlands of the same depth were then dissolved together.
5. Basins and wetlands were merged into a single feature class. An ID was assigned to each wetland, based on the county in which the greatest proportion of the wetland is found.
These data were developed as an aid in determining the vulnerability of surface-water features to groundwater pumping.
English
2008
These data are derived from datasets published May and July 2008.
As needed
-96.723837
-92.452463
46.059798
43.568730
211656.887000
542352.329200
4830170.988600
5100691.469700
Public Waters Inventory
National Wetlands Inventory
Anoka
Carver
Chisago
Dakota
Hennepin
Isanti
Ramsey
Scott
Sherburne
Washington
Wright
None
mailing and physical address
Minneapolis
Minnesota
55435
4700 West 77th Street
Suite 200
United States
Barr Engineering Company
952-832-2600
952-832-2601
File Geodatabase Feature Class
ESRI ArcCatalog 9.3.1.1850
None
withheld
None Available
Polygons in this feature class do not overlap. However, because these data are an amalgam of PWI and NWI, two datasets developed by different organizations for different purposes, there may be small slivers missing between features here.
24000
online
PWI
Minnesota Public Waters Inventory Basins
Minnesota Department of Natural Resources, Division of Waters
July 2008
Minnesota Public Waters Inventory Basins
Vector Digital Data
http://deli.dnr.state.mn.us
July 2008
publication date
24000
online
NWI
National Wetlands Inventory Wetlands
United States Fish and Wildlife Service
National Wetlands Inventory Wetlands
http://www.fws.gov/wetlands/
May 2008
Vector Digital Data
May 2008
publication date
PWI basins were intersected with NWI wetlands - the area of each unique wetland type within each basin was calculated. Each basin was then assigned that wetland type which covered the greatest proportion of its extent.
ESRI ArcMap 9.3
2010
ESRI ArcMap 9.3
2010
Approximate depths were assigned to all wetland types present in the study area. The data were saved in tabular form, and joined to the basins feature class by wetland type - thus an approximate depth was derived for each basin.
ESRI ArcMap 9.3
2010
The basin extents were clipped from the wetlands feature class - wetland fragments less than 60 square meters were then removed, as the basin and wetland edges weren't perfectly coincident, and polygon slivers remained after the clip.
ESRI ArcMap 9.3
2010
The depth table was joined to the wetlands by wetland type, and each wetland was assigned an approximate depth. Adjacent wetlands of the same depth were then dissolved together.
ESRI ArcMap 9.3
2010
Basins and wetlands were merged into a single feature class. An ID was assigned to each wetland, based on the county in which the greatest proportion of the wetland is found.
Refer to the Process section for a description of the steps used to create these data. Specifically note step three - wetland fragments less than 60 square meters were removed at that point.
vector
polygon
state
Simple
FALSE
0
TRUE
FALSE
0.000100
0.000100
meters
coordinate pair
NAD83
GRS1980
6378137.000000
298.257222
GCS_North_American_1983
NAD_1983_UTM_Zone_15N
Not Applicable
Not Applicable
Explicit elevation coordinate included with horizontal coordinates
0.000100
Not Applicable
Not Applicable
1.) OBJECTID Internal feature number: Sequential unique whole numbers that are automatically generated. 2.) Shape Feature geometry: Coordinates defining the features. 3.) DOWLKNUM DNR Division of Waters Lake Number
4.) Name DNR Division of Waters Lake Name
5.) Depth Depth of lake or wetland from MN DNR or estimated based on wetland type
5.) Wetland_ID Wetland Identification used for internal processing
6.) Combined_ID Combination of either the DOWLKNUM or wetland ID, with preference given to DOWLKNUM
7.) WT Water table elevation in feet (MSL)
8.) Surf_Elev Ground surface elevation in feet (MSL)
9.) Separation Difference between Bot_Elev and WT (feet). Used to determine connection with groundwater
10) Bot_Elev Elevation of the bottom of the feature (feet, MSL).
11) Shape_Length Length of feature in internal units.
12) Shape_Area Area of feature in internal units squared.
13) THCK_SCORE LPU Score - Part 2 - Thickness Score
14) GW_Connection Connection with groundwater
Connected: Surface-water features less than five feet above the regional water table surface are generally considered well connected to groundwater.
Disconnected: Surface-water features greater than 25 feet above the regional water table are considered to be perched, or disconnected
Indeterminate: The connection between groundwater and surface-water features was considered to be indeterminate for surface water features 5 feet to 25 feet above the regional water table
15) Biota Sensitive Biota (trout streams, calcareous fens)
16) Vulnerability Potential vulnerability of groundwater pumping
17) Geo_Data Geology data available
18) Percent_less_5ft Percent of lake surface area less than 5 feet deep
19) LPU_Score 20) Low Permeability Unit Score (SURF_LPU + BDRK_SCORE + THCK_SCORE )
21) Type Groundwater Connection Type
22) Water_Balance Percent of lake water balance inflow from groundwater
23) Local_Study Local study vulnerability determination
24) Vulnerability_Score Vulnerability Score
25) SIMP_ID Identification number used for internal processing
26) SURF_LPU LPU Score - Part 1: Connection with Surficial Low Permeability Units
27) BDRK_SCORE LPU Score - Part 3: Shallow Bedrock Confining Units
DBO.SurfaceWaterGroundwaterInteractionBasin
Feature Class
0
OBJECTID
OBJECTID
OID
4
10
0
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
Shape
Shape
Geometry
4
0
0
Feature geometry.
ESRI
Coordinates defining the features.
DOWLKNUM
DOWLKNUM
String
8
0
0
DNR Division of Waters Lake Number
DNR Division of Waters
Name
Name
String
50
0
0
DNR Division of Waters Lake Name
Depth
Depth
Double
8
38
8
Depth of lake or wetland from MN DNR or estiamted based on wetland type
Wetland_ID
Wetland_ID
String
8
0
0
Wetland Identification used for internal processing
Combined_ID
Combined_ID
String
8
0
0
Combination of either the DOWLKNUM or wetland ID, with preference given to DOWLKNUM
WT
WT
Double
8
38
8
Water Table Elevation in feet (MSL)
Surf_Elev
Surf_Elev
Double
8
38
8
Ground surface elevation in feet (MSL)
Separation
Separation
Double
8
38
8
Difference between Bot_Elev and WT. Used to determine connection with groundwater
Bot_Elev
Bot_Elev
Double
8
38
8
Elevation of the bottom of the feature (feet, MSL).
THCK_SCORE
THCK_SCORE
Double
8
38
8
LPU Score - Part 2
GW_Connection
GW_Connection
String
50
0
0
Connection with groundwater
Biota
Biota
String
50
0
0
Sensitive Biota (trout streams, calcareous fens)
Vulnerability
Vulnerability
String
50
0
0
Potential vulnerability of groundwater pumping
Geo_Data
Geo_Data
String
50
0
0
Geology data available
Percent_less_5ft
Percent_less_5ft
Double
8
38
8
Percent of lake surface area less than 5 feet deep
LPU_Score
LPU_Score
SmallInteger
2
5
0
Low Permeability Unit Score
Type
Type
String
50
0
0
Groundwater Connection Type
Water_Balance
Water_Balance
SmallInteger
2
5
0
Percent of lake water balance inflow from groundwater
Local_Study
Local_Study
String
50
0
0
Local study vulnerability determination
Vulnerability_Score
Vulnerability_Score
SmallInteger
2
5
0
Vulnerability Score
SIMP_ID
SIMP_ID
Integer
4
10
0
Identification number used for internal processing
SURF_LPU
SURF_LPU
SmallInteger
2
5
0
LPU Score - Part 1: Connection with Surficial Low Permeability Units
BDRK_SCORE
BDRK_SCORE
SmallInteger
2
5
0
LPU Score Part 3: Shallow Bedrock Confining Units
Shape.STArea()
Shape.STArea()
Double
0
0
0
Shape.STLength()
Shape.STLength()
Double
0
0
0
2008-11-10 11:28:37.0
Barr Engineering Company
4700 West 77th Street
Suite 200
Mailing and Physical Address
Minneapolis
Minnesota
55435
United States
Minnesota Geographic Metadata Guidelines
1.2
http://www.gis.state.mn.us/stds/metadata.htm
Minnesota Geographic Metadata Guidelines
English
local time
Esri ArcGIS 10.2.2.3552
DBO.SurfaceWaterGroundwaterInteractionBasin
211656.887
542352.3292
5100691.4697
4830170.9886
1
-96.723837
-92.452463
46.059798
43.56873
1
1
-96.723837
-92.452463
46.059798
43.568730
ISO 19115 Geographic Information - Metadata
DIS_ESRI1.0
dataset
002
withheld
Local Area Network
61.860
File Geodatabase Feature Class
Feature Class
NAD_1983_UTM_Zone_15N
EPSG
8.2.6
0
20160222
08465600
20160222
08465600
{808B5842-54BD-4E8B-8B58-A8F61962FE10}
20100510
13043600
FALSE
DBO.SurfaceWaterGroundwaterInteractionBasin
002
211656.887000
542352.329200
4830170.988600
5100691.469700
1
-
-
Relationship
-
Anno_1_15
Relationship
Projected
GCS_North_American_1983
Linear Unit: Meter (1.000000)
NAD_1983_UTM_Zone_15N
<ProjectedCoordinateSystem xsi:type='typens:ProjectedCoordinateSystem' xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xs='http://www.w3.org/2001/XMLSchema' xmlns:typens='http://www.esri.com/schemas/ArcGIS/10.1'><WKT>PROJCS["NAD_1983_UTM_Zone_15N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-93.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",26915]]</WKT><XOrigin>-5120900</XOrigin><YOrigin>-9998100</YOrigin><XYScale>10000</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>0.001</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><WKID>26915</WKID><LatestWKID>26915</LatestWKID></ProjectedCoordinateSystem>
20160222
952-832-2600
4700 West 77th Street
Suite 200
Mailing and Physical Address
Minneapolis
Minnesota
55435
United States
Barr Engineering Company
952-832-2601
Surface Water Features in the Twin Cities Metropolitan Area