Michigan Dept. of Environment, Great Lakes, and EnergyDirectional Line: A line connecting the surface location (wellhead) to the bottom hole location of a directionally drilled oil and gas well. The actual path from the surface location to the bottom hole location is not displayed. Directional lines are not created for straight wells (vertical) since the surface and bottom hole locations are roughly the same for these wells. These are updated on a weekly basis from the GRMD RBDMS database. Except where noted all fields correlate to the bottomhole record. For more information, visit Michigan.gov/EGLE/Maps-Data/GeoWebFace or contact EGLE-GeoWebFace@michigan.gov . Field name Field Description api_number 14 digit API number for well PermitNumber Permit number for well WellName Well Name WellNumber Well Number CompanyNo Operator Number CompanyName Operator Name WellType Type of Well Description WellStatus Status of well description WellboreType Type of Borehole Slant Slant of Borehole: see codes below H: Horizontal V: Vertical D: Directional CountyName County Name TownshipName Township Name TRS Township Range Section QS Quarter Section QQS Quarter Quarter Section QQQS Quarter Quarter Quarter Section wh_lat Surface Location Latitude wh_long Surface Location Longitude bh_lat Bottomhole Location Latitude bh_long Bottomhole Location Longitude wh_mgr_x Surface Michigan GeoRef X wh_mgr_y Surface Michigan GeoRef Y bh_mgr_x Bottomhole Michigan GeoRef X bh_mgr_y Bottomhole Michigan GeoRef Y Sidetrack Part of API Number Completion Part of API Number FieldName Field Name FieldType Type of Field: see codes below OG: Oil and Gas G: Gas O: Oil GS: Gas Storage GC: Gas Condensate UNK: Unknown ProdFormationCode Producing formation code ( see table at the bottom of this page) ProducingFormation Producing formation description County_fips County FIPS code Shape ProdFormationCode Descriptions Formation Code Formation Name ADRD ANDERDON ALPN ALPENA AMBG AMHERSTBURG ANRM ANTRIM ANRM1 ANTRIM DARK ANRM2 ANTRIM LIGHT AONE1 A-1 ANHYDRITE AONE2 A-1 CARBONATE AONE3 A-1 DOLOMITE AONE4 A-1 EVAPORITE AONE5 A-1 SALT ATWO1 A-2 ANHYDRITE ATWO2 A-2 CARBONATE ATWO3 A-2 DOLOMITE ATWO4 A-2 EVAPORITE ATWO5 A-2 LIMESTONE ATWO6 A-2 SALT BBLC BOIS BLANC BBLF BURNT BLUFF BDFD BEDFORD SHALE BELL1 BELL SHALE BERE BEREA SANDSTONE BIG BIG ANHYDRITE BILD BASS ISLANDS BKRV BLACK RIVER BKRV1 BLACK RIVER SHALE BKRV2 BLACK RIVER VAN WERT ZONE BPRT BAYPORT LIMESTONE BRBD BEREA-BEDFORD BRWN BROWN LIMESTONE BYRN BYRON CBHD CABOT HEAD CLCC CLINTON-CATARACT CLDR1 COLDWATER LIMESTONE CLDR2 COLDWATER RED ROCK CLDR3 COLDWATER SHALE CLGD COLLINGWOOD CLNN CLINTON CMBR CAMBRIAN CNCN CINCINNATIAN CTRC CATARACT DRBC DRESBACH DRRV DETROIT RIVER DRRV1 DETROIT RIVER ANHY DRRV2 DETROIT RIVER DOLOMITE DRRV3 DETROIT RIVER GROUP DRRV4 DETROIT RIVER SALT DRRV5 DETROIT RIVER Sour Zone DRRV6 DETROIT RIVER EVAP DUND DUNDEE DVNN DEVONIAN ECLR EAU CLAIRE ELSR ELLSWORTH ELSR1 ELLSWORTH SHALE FILR FILER SANDSTONE FRNC FRANCONIA GCDF GLACIAL DRIFT GDID GARDEN ISLAND GDRP GRAND RAPIDS GDRV GRAND RIVER GLND GLENWOOD GLPH GUELPH GPLK GUELPH-LOCKPORT GRWS GRANITE WASH HKFB HENDRICKS-FIBORN IONI IONIA SANDSTONE JBVL JACOBSVILLE JRDN JORDAN LAC LACHINE LCKP LOCKPORT LKSP LAKE SUPERIOR LMID LIME ISLAND LUCS LUCAS MCGN MICHIGAN FORMATION MCGN1 MICHIGAN STRAY MCGN2 MICHIGAN STRAY SANDSTONE MCGN3 MICHIGAN STRAY DOLOMITE MNLN MANITOULIN MNSG MUNISING MNSM MOUNT SIMON MNSQ MANISTIQUE MONR MONROE MONRU MONROE UPPER MRSL MARSHALL MRSL1 MARSHALL SANDSTONE MRSLL MARSHALL LOWER MRSLU MARSHALL UPPER MSSP MISSISSIPPIAN MSSV MASSIVE ANHYDRITE MSSV1 MASSIVE SALT MVLL MAYVILLE NGRN NIAGARAN NGRN1 NIAGARAN BROWN NGRN2 NIAGARAN GRAY NGRN3 NIAGARAN WHITE NOR NORWOOD NPLN NAPOLEON SANDSTONE NRCM NEW RICHMOND ONOT ONEOTA PARM PARMA SANDSTONE PAX PAXTON PCMB PRECAMBRIAN PCMB3 PRECAMBRIAN GRANITE PRDC PRAIRIE DU CHIEN PSALT POTASSIUM SALT PSLV PENNSYLVANIAN RCFD RICHFIELD RDBD RED BEDS RDCT REED CITY RDCT1 REED CITY ANHYDRITE RDCT2 REED CITY DOLOMITE RGRC ROGERS CITY RRCK REDROCK SCRX ST CROIXAN SGNW SAGINAW SHKP SHAKOPEE SLIN SALINA SLIN1 SALINA B SLIN2 SALINA B ANHYDRITE SLIN3 SALINA B SALT SLIN4 SALINA C SHALE SLIN5 SALINA D SALT SLIN6 SALINA E SLIN7 SALINA F SLIN8 SALINA F SALT SLIN9 SALINA G SLRC ST LAWRENCE SLRN SILURIAN SLVN SYLVANIA SLVN1 SYLVANIA SANDSTONE SNBR1 SUNBURY SHALE SQBY SQUAW BAY SRSR STRAY-STRAY SANDSTONE STPR ST PETER TBRV TRENTON-BLACK RIVER TMPL TREMPEALEAU TRNN TRENTON TRPL TRIPLE GYPSUM TRVR TRAVERSE TRVR2 TRAVERSE FORMATION TRVR3 TRAVERSE GROUP TRVR4 TRAVERSE LIMESTONE UTCLD UTICA-COLLINGWOOD UTIC UTICA VERN VERNE LIMESTONE WDVL WOODVILLE SANDSTONEArcGIS DynamicMapLayerhttps://hub.arcgis.com/datasets/57c62712d823483a95d4b0c9d58465d4_11engState of Michigan Open Data PortalPublicMichigan Oil, Gas, and Mineral Well Directional Lines [Michigan]Web servicesMichiganLast Modified: 2025-09-24