Brant Fisher
Drinking Water and Environmental Health Section, Resource Management Division
Environmental Engineer Specialist
517-241-1415
fisherb@mi.gov
20121019
Brant Fisher
Drinking Water and Environmental Health Section, Resource Management Division
Environmental Engineer Specialist
517-241-1415
fisherb@mi.gov
Feature Class
Michigan Waterwells for WELLOGIC dataset
Lansing, MI
Michigan State University, Remote Sensing and GIS Research and Outreach Services
vector digital data
<DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN><SPAN>The data in these six files is derived from Wellogic, the Michigan Department of Environmental Quality statewide ground water database. The six files combined contain information on over 575,000 spatially verified water well records. The six files are intended to provide water well information for wells in counties clustered by geographic region: Upper Peninsula, Northern Lower Peninsula, East Central Lower Peninsula, West Central Lower Peninsula, Southwest Lower Peninsula and the South Central – Southeastern Lower Peninsula. The files are constructed to be easily merged, containing the same number and type of attribute fields.</SPAN></SPAN></P><P><SPAN><SPAN>Although the derived data in these files represents the best readily available data, the six files do not represent a complete database of all wells or well records in existence. Until January 1, 2000 not all water well records for new wells in Michigan were entered into Wellogic. For wells drilled before 2000 the rate of inclusion is highly variable from one county to another. Further, there is a quality control check on location that may exclude a limited number of wells from Wellogic from the six files made available on this site.</SPAN></SPAN></P></DIV></DIV></DIV>
The data has been published to provide regulators, consultants and the public extensive information that can be used in the study, analysis and management of Michigan's ground water resources. The dataset represents the single greatest collection of ground water information available and includes water well construction details and estimates of aquifer hydraulic characteristics based upon that information throughout Michigan.
Brant Fisher
Drinking Water and Environmental Health Section, Resource Management Division
Environmental Engineer Specialist
517-241-1415
fisherb@mi.gov
None
ESRI ArcGIS 10.0.5.4400
-90.407727
-82.450402
41.697367
47.914586
1
-90.500000
-82.415600
48.141935
41.600000
The source data for this dataset comes from Wellogic. Wellogic is an automated database for the entering and storing of ground water data as it relates to the construction of water wells throughout Michigan. The Wellogic program source code has a considerable number of quality assurance and quality control checks on the data as it is entered into the system that assure a basal degree of accuracy, completeness of records and reliability. Some of the data such as that associated with lithologic descriptions is subject to interpretation and may therefore carry with it inherent uncertainty. There has been no check for duplication of geographic elements within the dataset. In fact, random searches of the dataset in the regular course of data utilization and analysis have disclosed the presence of duplicate geographic elements such as the multiple entry of singular well records. Where duplications are disclosed every effort is made to combine the duplicates into one all encompassing record and the subsequent deletion/elimination of duplicate records.
The point data representing individual water well records have been located based upon a variety of methods with varying positional accuracy. Well point locations based upon GPS data can have positional accuracies of + or minus 3 meters. Some well point locations have been established via review and placement of wells on aerial photos. The positional accuracy of this group is considered + or minus 10 meters. Other methods of assigning location such as address matching, classical surveying or the assignment of the well location to the center of a section may be off by as much as 750 meters.
The point data representing individual water well records have been located based upon a variety of methods with varying positional accuracy. Well point locations based upon GPS data can have positional accuracies of + or minus 3 meters. Some well point locations have been established via review and placement of wells on aerial photos. The positional accuracy of this group is considered + or minus 10 meters. Other methods of assigning location such as address matching, classical surveying or the assignment of the well location to the center of a section may be off by as much as 750 meters. Fields are available that describe the method of collection and/or manner of location assignment.
The Wellogic Download Tool Dataset is created through the following sequence of tasks:
0
michigan.WEBMERC.HYD_PT_DEQ_WATERWELLS
Feature Class
0
FLOWING
FLOWING
String
1
0
0
TRANSMSV_2
TRANSMSV_2
Double
8
26
8
Shape
Feature geometry.
ESRI
Coordinates defining the features.
Shape
Geometry
8
0
0
OWNER_NAME
OWNER_NAME
String
30
0
0
RANGE
RANGE
String
3
0
0
SWL
SWL
Double
8
11
2
SCRN_FLAG
SCRN_FLAG
String
1
0
0
ELEV_METHD
ELEV_METHD
String
6
0
0
V_COND_D
V_COND_D
Double
8
26
8
SECTION
SECTION
Integer
4
10
0
WELL_ADDR
WELL_ADDR
String
50
0
0
LOC_MATCH
LOC_MATCH
String
1
0
0
B_V_COND
B_V_COND
Double
8
26
8
WELL_CITY
WELL_CITY
String
30
0
0
TEST_RATE
TEST_RATE
Double
8
10
0
CASE_TYPE
CASE_TYPE
String
6
0
0
DRILL_METH
DRILL_METH
String
6
0
0
AQ_FLAG
AQ_FLAG
String
1
0
0
SPC_CPCITY
SPC_CPCITY
Double
8
26
8
WELL_TYPE
WELL_TYPE
String
6
0
0
ELEV_DEM
ELEV_DEM
Integer
4
10
0
WELL_ZIP
WELL_ZIP
String
9
0
0
PERMIT_NUM
PERMIT_NUM
String
20
0
0
COUNTY
COUNTY
String
30
0
0
STATUS_OTH
STATUS_OTH
String
254
0
0
GROUT
GROUT
String
1
0
0
CASE_DIA
CASE_DIA
Double
8
11
2
TEST_OTHER
TEST_OTHER
String
30
0
0
AQ_TYPE
AQ_TYPE
String
6
0
0
NOTES
NOTES
String
254
0
0
LATITUDE
LATITUDE
Double
8
28
10
TOWN
TOWN
String
3
0
0
PMP_CPCITY
PMP_CPCITY
Double
8
10
0
V_COND_2
V_COND_2
Double
8
26
8
CASE_DEPTH
CASE_DEPTH
Double
8
11
2
H_COND_2
H_COND_2
Double
8
26
8
B_TRANS
B_TRANS
Double
8
26
8
CASE_OTHER
CASE_OTHER
String
30
0
0
WSSN
WSSN
Double
8
10
0
LONGITUDE
LONGITUDE
Double
8
28
10
DEPTH_FLAG
DEPTH_FLAG
String
1
0
0
ELEV_DIF
ELEV_DIF
Integer
4
10
0
AQ_CODE
AQ_CODE
String
1
0
0
WITHIN_SEC
WITHIN_SEC
String
1
0
0
WITHIN_CO
WITHIN_CO
String
1
0
0
WELL_DEPTH
WELL_DEPTH
Double
8
11
2
B_H_COND
B_H_COND
Double
8
26
8
TEST_HOURS
TEST_HOURS
Double
8
10
2
TYPE_OTHER
TYPE_OTHER
String
30
0
0
TRANSMSV_1
TRANSMSV_1
Double
8
26
8
WELL_NUM
WELL_NUM
String
30
0
0
SCREEN_FRM
SCREEN_FRM
Double
8
11
2
LANDSYS
LANDSYS
String
50
0
0
AQ_THK_1
AQ_THK_1
Integer
4
10
0
AQ_THK_2
AQ_THK_2
Integer
4
10
0
SWL_FLAG
SWL_FLAG
String
1
0
0
ROCK_TOP
ROCK_TOP
Integer
4
10
0
SCREEN_TO
SCREEN_TO
Double
8
11
2
DRILLER_ID
DRILLER_ID
String
10
0
0
WEL_STATUS
WEL_STATUS
String
6
0
0
B_AQ_THK
B_AQ_THK
Integer
4
10
0
TEST_DEPTH
TEST_DEPTH
Double
8
11
2
OBJECTID
Internal feature number.
ESRI
Sequential unique whole numbers that are automatically generated.
OBJECTID
OID
4
10
0
SEC_DIST
SEC_DIST
String
8
0
0
METH_OTHER
METH_OTHER
String
30
0
0
V_COND_1
V_COND_1
Double
8
26
8
ELEV_FLAG
ELEV_FLAG
String
1
0
0
TRANS_D
TRANS_D
Double
8
26
8
ELEVATION
ELEVATION
Double
8
12
2
CONST_DATE
CONST_DATE
String
23
0
0
WELLID
WELLID
String
12
0
0
AQ_THK_D
AQ_THK_D
Integer
4
10
0
TEST_METHD
TEST_METHD
String
6
0
0
METHD_COLL
METHD_COLL
String
6
0
0
H_COND_D
H_COND_D
Double
8
26
8
AQ_THICK_D
AQ_THICK_D
Double
8
26
8
H_COND_1
H_COND_1
Double
8
26
8
WELLCODE
WELLCODE
String
254
0
0
TOPAQ
TOPAQ
Double
8
38
8
BOTAQ
BOTAQ
Double
8
38
8
TOWNSHIP
TOWNSHIP
String
50
0
0
WWAT_ID
WWAT_ID
String
20
0
0
Much of the attribute information such as that identified as Wellogic fields are copied directly from the source data and may be considered 100% accurate. However, this exact copying of the data does not preclude the possibility of typographic, transpose or other translation error in the data entry process. New fields added to the dataset as a result of the download execution are generally computational in nature and are accurate within the confines of the assumption and numeric assignment of information to the source data. For a complete data dictionary see; http://www.mcgi.state.mi.us/mgdl/Wellogic_Download_Field_Definitions_Jul2012.txt
dataset
EPSG
8.2.6
Simple
FALSE
0
TRUE
FALSE
WellogicWellsNew
002
-90.407715
-82.415600
41.656000
48.141935
1
Geographic
GCS_WGS_1984
Angular Unit: Degree (0.017453)
<GeographicCoordinateSystem xsi:type='typens:GeographicCoordinateSystem' 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/3.3.0'><WKT>GEOGCS["GCS_WGS_1984",DATUM["D_WGS_1984",SPHEROID["WGS_1984",6378137.0,298.257223563]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433],AUTHORITY["EPSG",4326]]</WKT><XOrigin>-399.99999999999989</XOrigin><YOrigin>-399.99999999999989</YOrigin><XYScale>11258999068426.24</XYScale><ZOrigin>0</ZOrigin><ZScale>1</ZScale><MOrigin>0</MOrigin><MScale>1</MScale><XYTolerance>8.9831528411952133e-09</XYTolerance><ZTolerance>0.001</ZTolerance><MTolerance>0.001</MTolerance><HighPrecision>true</HighPrecision><LeftLongitude>-180</LeftLongitude><WKID>4326</WKID><LatestWKID>4326</LatestWKID></GeographicCoordinateSystem>
20250123
20532600
20250123
20532600
150000000
5000
1.0
FGDC
Updated Monthly from Welllogic