Description

more
NOTE: THIS DATA DOWNLOAD DOES NOT CONTAIN THE ASSOCIATED LITHOLOGY FILES. TO DOWNLOAD THIS DATA BY COUNTY WITH LITHOLOGY FILE CLICK HERE.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. 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.More Metadata

Dataset Attributes

  • OBJECTID
    Number
  • WELLID
    Text
    {"value"=>"04000001745", "count"=>1} (), {"value"=>"01000001155", "count"=>1} (), {"value"=>"68000001056", "count"=>1} (), {"value"=>"65000001745", "count"=>1} (), {"value"=>"65000003144", "count"=>1} (), {"value"=>"40000001335", "count"=>1} (), {"value"=>"28000013189", "count"=>1} (), {"value"=>"28000002567", "count"=>1} (), {"value"=>"28000001082", "count"=>1} (), {"value"=>"26000004656", "count"=>1} ()
  • COUNTY
    Text
    {"value"=>"Grand Traverse", "count"=>13073} (), {"value"=>"Clare", "count"=>8974} (), {"value"=>"Leelanau", "count"=>6178} (), {"value"=>"Osceola", "count"=>6068} (), {"value"=>"Gladwin", "count"=>5248} (), {"value"=>"Wexford", "count"=>5140} (), {"value"=>"Roscommon", "count"=>5063} (), {"value"=>"Manistee", "count"=>4792} (), {"value"=>"Lake", "count"=>4502} (), {"value"=>"Kalkaska", "count"=>4103} ()
  • PERMIT_NUM
    Text
    {"value"=>"4458", "count"=>4} (), {"value"=>"4122", "count"=>3} (), {"value"=>"3980", "count"=>3} (), {"value"=>"06-086", "count"=>3} (), {"value"=>"08-005", "count"=>3} (), {"value"=>"3644", "count"=>3} (), {"value"=>"5561", "count"=>3} (), {"value"=>"11103", "count"=>3} (), {"value"=>"2639", "count"=>3} (), {"value"=>"09-028", "count"=>3} ()
  • TOWNSHIP
    Text
    {"value"=>"Garfield", "count"=>3128} (), {"value"=>"Hayes", "count"=>2979} (), {"value"=>"Long Lake", "count"=>2223} (), {"value"=>"East Bay", "count"=>2075} (), {"value"=>"Lake", "count"=>2020} (), {"value"=>"Grant", "count"=>1918} (), {"value"=>"Green Lake", "count"=>1472} (), {"value"=>"Blair", "count"=>1377} (), {"value"=>"Peninsula", "count"=>1342} (), {"value"=>"Denton", "count"=>1062} ()
  • TOWN
    Text
    {"value"=>"27N", "count"=>9963} (), {"value"=>"19N", "count"=>8685} (), {"value"=>"17N", "count"=>8569} (), {"value"=>"26N", "count"=>8259} (), {"value"=>"22N", "count"=>8019} (), {"value"=>"23N", "count"=>6780} (), {"value"=>"20N", "count"=>6469} (), {"value"=>"28N", "count"=>6444} (), {"value"=>"18N", "count"=>6055} (), {"value"=>"29N", "count"=>5869} ()
  • RANGE
    Text
    {"value"=>"04W", "count"=>8479} (), {"value"=>"11W", "count"=>8223} (), {"value"=>"10W", "count"=>7911} (), {"value"=>"12W", "count"=>7639} (), {"value"=>"03W", "count"=>7524} (), {"value"=>"08W", "count"=>6029} (), {"value"=>"09W", "count"=>5273} (), {"value"=>"06W", "count"=>4947} (), {"value"=>"05W", "count"=>4758} (), {"value"=>"07W", "count"=>4710} ()
  • SECTION
    Number
    0 to 36
  • OWNER_NAME
    Text
    {"value"=>"Tim Colman", "count"=>10} (), {"value"=>"PORTER BLDRS", "count"=>8} (), {"value"=>"JAMES WRIGHT", "count"=>8} (), {"value"=>"MASINICK, HARRY &JOAN", "count"=>5} (), {"value"=>"Thomas Fulker", "count"=>5} (), {"value"=>"ROGER THOMAS", "count"=>4} (), {"value"=>"EAGLE GLEN GOLF COURSE", "count"=>4} (), {"value"=>"CHARLES MCDOWELL", "count"=>4} (), {"value"=>"RED HOOK PROPERTIES", "count"=>4} (), {"value"=>"Mark Fialek", "count"=>4} ()
  • WELL_ADDR
    Text
    {"value"=>"RIVER ROAD", "count"=>12} (), {"value"=>"LAKE SHORE DR", "count"=>10} (), {"value"=>"WOODRIDGE", "count"=>9} (), {"value"=>"Townline Rd", "count"=>9} (), {"value"=>"50TH AVE.", "count"=>9} (), {"value"=>"M-76", "count"=>8} (), {"value"=>"14 MILE RD", "count"=>8} (), {"value"=>"U.S. 31", "count"=>6} (), {"value"=>"S LAKE LEELANAU DR", "count"=>5} (), {"value"=>"Phelps rd", "count"=>5} ()
  • WELL_CITY
    Text
    {"value"=>" ", "count"=>28680} (), {"value"=>"HARRISON", "count"=>3564} (), {"value"=>"GLADWIN", "count"=>2875} (), {"value"=>"Roscommon", "count"=>1864} (), {"value"=>"MANISTEE", "count"=>1460} (), {"value"=>"HOUGHTON LAKE", "count"=>1436} (), {"value"=>"BEAVERTON", "count"=>1347} (), {"value"=>"ALPENA", "count"=>1346} (), {"value"=>"BALDWIN", "count"=>1328} (), {"value"=>"CADILLAC", "count"=>1321} ()
  • WELL_ZIP
    Text
    {"value"=>" ", "count"=>36233} (), {"value"=>"49684", "count"=>7253} (), {"value"=>"48625", "count"=>3523} (), {"value"=>"48624", "count"=>2725} (), {"value"=>"49759", "count"=>1812} (), {"value"=>"49601", "count"=>1591} (), {"value"=>"49660", "count"=>1442} (), {"value"=>"48653", "count"=>1353} (), {"value"=>"49304", "count"=>1319} (), {"value"=>"48612", "count"=>1318} ()
  • WELL_DEPTH
    Number
    0 to 9999
  • WELL_TYPE
    Text
    {"value"=>"HOSHLD", "count"=>101570} (), {"value"=>"TY2PU", "count"=>4081} (), {"value"=>"OTH", "count"=>1661} (), {"value"=>"IRRI", "count"=>1611} (), {"value"=>"TY3PU", "count"=>1382} (), {"value"=>"UNK", "count"=>912} (), {"value"=>"TY1PU", "count"=>775} (), {"value"=>"TESTW", "count"=>480} (), {"value"=>"HEATP", "count"=>264} (), {"value"=>"INDUS", "count"=>168} ()
  • TYPE_OTHER
    Text
    {"value"=>" ", "count"=>111258} (), {"value"=>"Type Use Unknown", "count"=>497} (), {"value"=>"Public Well Type Unknown", "count"=>227} (), {"value"=>"COMMERCIAL", "count"=>191} (), {"value"=>"closed Type 2", "count"=>106} (), {"value"=>"listed type ii unconfirmed", "count"=>43} (), {"value"=>"MONITORING", "count"=>29} (), {"value"=>"HOUSEHOLD AND TYPE III PUBLIC", "count"=>21} (), {"value"=>"OBSERVATION", "count"=>18} (), {"value"=>"OBSERVATION WELL", "count"=>16} ()
  • WEL_STATUS
    Text
    {"value"=>"ACT", "count"=>76969} (), {"value"=>" ", "count"=>34552} (), {"value"=>"INACT", "count"=>930} (), {"value"=>"PLU", "count"=>345} (), {"value"=>"OTH", "count"=>117} (), {"value"=>"UNK", "count"=>20} ()
  • STATUS_OTH
    Text
    {"value"=>" ", "count"=>112813} (), {"value"=>"Closed Public Supply", "count"=>100} (), {"value"=>"Closed Public System", "count"=>6} (), {"value"=>"OBSERVATION WELL", "count"=>2} (), {"value"=>"WATER CATTLE", "count"=>1} (), {"value"=>"Tank and controls to be instal", "count"=>1} (), {"value"=>"removed by excavation", "count"=>1} (), {"value"=>"Observation pt/test hole only", "count"=>1} (), {"value"=>"HOUSEHOLD & IRRIGATION", "count"=>1} (), {"value"=>"hookup to be comp. spr. 06", "count"=>1} ()
  • WSSN
    Number
    -20427 to 2226824
  • WELL_NUM
    Text
    {"value"=>" ", "count"=>107798} (), {"value"=>"001", "count"=>3366} (), {"value"=>"002", "count"=>479} (), {"value"=>"5", "count"=>92} (), {"value"=>"003", "count"=>89} (), {"value"=>"2", "count"=>86} (), {"value"=>"1", "count"=>85} (), {"value"=>"3", "count"=>46} (), {"value"=>"4", "count"=>31} (), {"value"=>"5\"", "count"=>23} ()
  • DRILLER_ID
    Text
    {"value"=>" ", "count"=>7615} (), {"value"=>"28-1244", "count"=>4774} (), {"value"=>"28-0481", "count"=>4328} (), {"value"=>"45-2030", "count"=>3022} (), {"value"=>"18-0635", "count"=>2736} (), {"value"=>"45-0795", "count"=>2399} (), {"value"=>"35-2136", "count"=>1836} (), {"value"=>"83-1981", "count"=>1781} (), {"value"=>"72-1948", "count"=>1672} (), {"value"=>"35-2137", "count"=>1669} ()
  • DRILL_METH
    Text
    {"value"=>"ROTARY", "count"=>73649} (), {"value"=>"CABTOO", "count"=>15208} (), {"value"=>"AUGBOR", "count"=>9199} (), {"value"=>"HOLROD", "count"=>8151} (), {"value"=>"JETTIN", "count"=>2240} (), {"value"=>"UNK", "count"=>2050} (), {"value"=>"OTH", "count"=>1303} (), {"value"=>"DRIVEN", "count"=>1014} (), {"value"=>" ", "count"=>68} (), {"value"=>"ROTHAM", "count"=>32} ()
  • METH_OTHER
    Text
    {"value"=>" ", "count"=>111631} (), {"value"=>"CABLE TOOL & DRIVEN", "count"=>204} (), {"value"=>"ROTARY & DRIVEN", "count"=>111} (), {"value"=>"CABLE TOOL & AUGER/BORED", "count"=>88} (), {"value"=>"Drilling Method unknown", "count"=>87} (), {"value"=>"cable tool and driven", "count"=>72} (), {"value"=>"AUGER/BORED", "count"=>67} (), {"value"=>"AUGER/BORED & DRIVEN", "count"=>61} (), {"value"=>"CABLE TOOL AND AUGER/BORED", "count"=>45} (), {"value"=>"ROTARY AND DRIVEN", "count"=>40} ()
  • CONST_DATE
    Text
    {"value"=>"2001-10-30 00:00:00.000", "count"=>47} (), {"value"=>"2004-09-08 00:00:00.000", "count"=>44} (), {"value"=>"2002-07-18 00:00:00.000", "count"=>44} (), {"value"=>"2002-08-06 00:00:00.000", "count"=>43} (), {"value"=>"2003-08-18 00:00:00.000", "count"=>42} (), {"value"=>"2004-06-15 00:00:00.000", "count"=>41} (), {"value"=>"2004-07-14 00:00:00.000", "count"=>40} (), {"value"=>"2005-05-03 00:00:00.000", "count"=>40} (), {"value"=>"2002-08-30 00:00:00.000", "count"=>40} (), {"value"=>"2005-05-27 00:00:00.000", "count"=>40} ()
  • CASE_TYPE
    Text
    {"value"=>"PVCPLA", "count"=>61259} (), {"value"=>"UNK", "count"=>26302} (), {"value"=>"STEBLA", "count"=>12537} (), {"value"=>"STEUNK", "count"=>7443} (), {"value"=>"STEGAL", "count"=>4943} (), {"value"=>" ", "count"=>233} (), {"value"=>"OTH", "count"=>199} (), {"value"=>"NONE", "count"=>17} ()
  • CASE_OTHER
    Text
    {"value"=>" ", "count"=>112736} (), {"value"=>"Clay Tile Crock", "count"=>32} (), {"value"=>"Casing Type unknown", "count"=>21} (), {"value"=>"PLASTIC & CERTA LOK", "count"=>9} (), {"value"=>"None", "count"=>8} (), {"value"=>"PLASTIC & CERTA-LOK", "count"=>7} (), {"value"=>"PLASTIC AND CERTA-LOK", "count"=>6} (), {"value"=>"No casing", "count"=>6} (), {"value"=>"Steel & Plastic", "count"=>5} (), {"value"=>"STEEL AND PLASTIC", "count"=>4} ()
  • CASE_DIA
    Number
    0 to 9999
  • CASE_DEPTH
    Number
    0 to 9999
  • SCREEN_FRM
    Number
    -50 to 1441
  • SCREEN_TO
    Number
    0 to 9999
  • SWL
    Number
    0 to 9999
  • FLOWING
    Text
    {"value"=>"N", "count"=>106929} (), {"value"=>"Y", "count"=>5908} (), {"value"=>" ", "count"=>61} (), {"value"=>"U", "count"=>35} ()
  • AQ_TYPE
    Text
    {"value"=>"DRIFT", "count"=>94682} (), {"value"=>"ROCK", "count"=>9300} (), {"value"=>" ", "count"=>8933} (), {"value"=>"UNK", "count"=>18} ()
  • TEST_DEPTH
    Number
    -8 to 2804
  • TEST_HOURS
    Number
    0 to 999
  • TEST_RATE
    Number
    -1 to 9999
  • TEST_METHD
    Text
    {"value"=>"AIR", "count"=>46728} (), {"value"=>"UNK", "count"=>44614} (), {"value"=>"TSTPUM", "count"=>11929} (), {"value"=>"PLUGR", "count"=>5161} (), {"value"=>"BAIL", "count"=>3374} (), {"value"=>"OTH", "count"=>860} (), {"value"=>" ", "count"=>267} ()
  • TEST_OTHER
    Text
    {"value"=>" ", "count"=>112073} (), {"value"=>"AIR & TEST PUMP", "count"=>148} (), {"value"=>"BAILER & TEST PUMP", "count"=>143} (), {"value"=>"AIR AND TEST PUMP", "count"=>87} (), {"value"=>"PLUNGER & BAILER", "count"=>84} (), {"value"=>"PLUNGER & TEST PUMP", "count"=>52} (), {"value"=>"BAILER AND TEST PUMP", "count"=>39} (), {"value"=>"PLUNGER AND BAILER", "count"=>21} (), {"value"=>"BAILER & AIR", "count"=>21} (), {"value"=>"PLUNGER AND TEST PUMP", "count"=>20} ()
  • GROUT
    Text
    {"value"=>"Y", "count"=>103178} (), {"value"=>"N", "count"=>9701} (), {"value"=>" ", "count"=>40} (), {"value"=>"U", "count"=>14} ()
  • PMP_CPCITY
    Number
    -18 to 1800
  • LATITUDE
    Number
    0 to 45.7879482
  • LONGITUDE
    Number
    -86.50453 to 0
  • METHD_COLL
    Text
    {"value"=>"018", "count"=>49206} (), {"value"=>"016", "count"=>22118} (), {"value"=>"001", "count"=>17819} (), {"value"=>"036", "count"=>13090} (), {"value"=>"027", "count"=>6910} (), {"value"=>"014", "count"=>1245} (), {"value"=>"002", "count"=>780} (), {"value"=>"017", "count"=>729} (), {"value"=>"015", "count"=>370} (), {"value"=>"UNK", "count"=>229} ()
  • ELEVATION
    Number
    0 to 3848.43
  • ELEV_METHD
    Text
    {"value"=>" ", "count"=>64463} (), {"value"=>"014", "count"=>44098} (), {"value"=>"005", "count"=>2676} (), {"value"=>"OTH", "count"=>873} (), {"value"=>"006", "count"=>535} (), {"value"=>"007", "count"=>161} (), {"value"=>"UNK", "count"=>61} (), {"value"=>"004", "count"=>27} (), {"value"=>"003", "count"=>16} (), {"value"=>"002", "count"=>8} ()
  • WITHIN_SEC
    Text
    {"value"=>"Y", "count"=>112114} (), {"value"=>"N", "count"=>700} (), {"value"=>" ", "count"=>119} ()
  • LOC_MATCH
    Text
    {"value"=>"Y", "count"=>112814} (), {"value"=>" ", "count"=>119} ()
  • SEC_DIST
    Text
    {"value"=>" ", "count"=>112233} (), {"value"=>"200-NO", "count"=>396} (), {"value"=>"200-YES", "count"=>304} ()
  • ELEV_DEM
    Number
    0 to 1706
  • ELEV_DIF
    Number
    0 to 2683
  • LANDSYS
    Text
    {"value"=>"PROGLACIAL OUTWASH", "count"=>46277} (), {"value"=>"ICE-CONTACT OUTWASH", "count"=>18544} (), {"value"=>"LACUSTRINE COARSE", "count"=>15001} (), {"value"=>"ICE-MARGINAL TILL", "count"=>10707} (), {"value"=>"LODGE TILL OR FINE SUPRAGLACIAL DRIFT", "count"=>10274} (), {"value"=>"LACUSTRINE FINE", "count"=>7039} (), {"value"=>"COASTAL DUNES", "count"=>2937} (), {"value"=>"BEDROCK", "count"=>855} (), {"value"=>"LAKES", "count"=>851} (), {"value"=>"Object reference not set to an instance of an obje", "count"=>245} ()
  • DEPTH_FLAG
    Text
    {"value"=>" ", "count"=>111559} (), {"value"=>"1", "count"=>1057} (), {"value"=>"2", "count"=>317} ()
  • ELEV_FLAG
    Text
    {"value"=>"3", "count"=>65608} (), {"value"=>" ", "count"=>40065} (), {"value"=>"4", "count"=>7260} ()
  • SWL_FLAG
    Text
    {"value"=>" ", "count"=>104551} (), {"value"=>"1", "count"=>6625} (), {"value"=>"3", "count"=>986} (), {"value"=>"2", "count"=>771} ()
  • SPC_CPCITY
    Number
    0 to 304
  • AQ_CODE
    Text
    {"value"=>"D", "count"=>98944} (), {"value"=>" ", "count"=>7920} (), {"value"=>"R", "count"=>5851} (), {"value"=>"N", "count"=>218} ()
  • ROCK_TOP
    Number
    0 to 806
  • AQ_THK_1
    Number
    0 to 338
  • AQ_THK_2
    Number
    0 to 9793
  • AQ_THK_D
    Number
    0 to 806
  • H_COND_1
    Number
    0 to 694
  • H_COND_2
    Number
    -20 to 394.73700526
  • V_COND_1
    Number
  • V_COND_2
    Number
  • TRANSMSV_1
    Number
  • TRANSMSV_2
    Number
  • B_AQ_THK
    Number
  • B_H_COND
    Number
  • B_V_COND
    Number
  • B_TRANS
    Number
  • AQ_THICK_D
    Number
  • H_COND_D
    Number
  • V_COND_D
    Number
  • TRANS_D
    Number
  • AQ_FLAG
    Text
  • SCRN_FLAG
    Text
  • NOTES
    Text
  • Shape
    Number

Related Datasets