Description

more
S Surface Location - Surface locations (wellhead) of all oil & gas test wells whether directionally drilled or straight (vertical) holes. D Surface locations (wellhead) of all oil & gas test wells whether directionally drilled or straight (vertical) holes. These are extracted from the Michigan DEQ Oil, Gas & Minerals RBDMS database on a nightly basis.More Metadata

Dataset Attributes

  • OBJECTID
    Number
  • Shape
    Number
  • api_wellno
    Text
    {"value"=>"21137500400000", "count"=>1} (), {"value"=>"21127282840000", "count"=>1} (), {"value"=>"21123130470000", "count"=>1} (), {"value"=>"21059222170000", "count"=>1} (), {"value"=>"21025308770000", "count"=>1} (), {"value"=>"21165587337000", "count"=>1} (), {"value"=>"21147273750000", "count"=>1} (), {"value"=>"21127013560000", "count"=>1} (), {"value"=>"21005053170000", "count"=>1} (), {"value"=>"21141613067000", "count"=>1} ()
  • cnty_fips
    Text
    {"value"=>"137", "count"=>6218} (), {"value"=>"119", "count"=>3969} (), {"value"=>"5", "count"=>3497} (), {"value"=>"9", "count"=>2830} (), {"value"=>"101", "count"=>2761} (), {"value"=>"71", "count"=>2318} (), {"value"=>"55", "count"=>2081} (), {"value"=>"147", "count"=>1978} (), {"value"=>"141", "count"=>1934} (), {"value"=>"73", "count"=>1915} ()
  • permit_no
    Text
    {"value"=>"867-782-432", "count"=>29} (), {"value"=>"597-782-371", "count"=>24} (), {"value"=>"479-742-177", "count"=>21} (), {"value"=>"001-922-217", "count"=>15} (), {"value"=>"58068", "count"=>11} (), {"value"=>"58070", "count"=>11} (), {"value"=>"58069", "count"=>9} (), {"value"=>"1430-822-35", "count"=>9} (), {"value"=>"1222-792-35", "count"=>8} (), {"value"=>"192-822-458", "count"=>8} ()
  • sidetrck
    Number
    0 to 90
  • completion
    Number
    0 to 91
  • CNTY_NAME
    Text
    {"value"=>"OTSEGO", "count"=>6218} (), {"value"=>"MONTMORENCY", "count"=>3969} (), {"value"=>"ALLEGAN", "count"=>3497} (), {"value"=>"ANTRIM", "count"=>2830} (), {"value"=>"MANISTEE", "count"=>2761} (), {"value"=>"IRON", "count"=>2318} (), {"value"=>"GRAND TRAVERSE", "count"=>2081} (), {"value"=>"SAINT CLAIR", "count"=>1978} (), {"value"=>"PRESQUE ISLE", "count"=>1934} (), {"value"=>"ISABELLA", "count"=>1915} ()
  • twp_name
    Text
    {"value"=>"CHARLTON", "count"=>1459} (), {"value"=>"STAMBAUGH", "count"=>1357} (), {"value"=>"CHESTER", "count"=>1335} (), {"value"=>"HAYES", "count"=>930} (), {"value"=>"LINCOLN", "count"=>853} (), {"value"=>"VIENNA", "count"=>782} (), {"value"=>"BEAR LAKE", "count"=>748} (), {"value"=>"CARP LAKE", "count"=>711} (), {"value"=>"OSSINEKE", "count"=>706} (), {"value"=>"ADAMS", "count"=>690} ()
  • well_type
    Text
    {"value"=>"DH", "count"=>22313} (), {"value"=>"OIL", "count"=>14724} (), {"value"=>"GAS", "count"=>13281} (), {"value"=>"TH", "count"=>12843} (), {"value"=>"LOC", "count"=>8047} (), {"value"=>"GS", "count"=>3023} (), {"value"=>"BDW", "count"=>1625} (), {"value"=>"WIW", "count"=>843} (), {"value"=>"GSO", "count"=>835} (), {"value"=>"BR", "count"=>425} ()
  • well_stat
    Text
    {"value"=>"Plugging Approved", "count"=>36985} (), {"value"=>"Producing", "count"=>13823} (), {"value"=>"Unknown", "count"=>8296} (), {"value"=>"Terminated Permit", "count"=>7864} (), {"value"=>"Active", "count"=>4263} (), {"value"=>"Plugging Completed", "count"=>2953} (), {"value"=>"Temporarily Abandoned", "count"=>586} (), {"value"=>"Shut_In", "count"=>544} (), {"value"=>"Permitted Well", "count"=>157} (), {"value"=>"Suspended Operations", "count"=>82} ()
  • bore_type
    Text
    {"value"=>"Oil and Gas Test", "count"=>64031} (), {"value"=>"Mineral (Non-Confidential)", "count"=>14195} (), {"value"=>"Pre-Permit", "count"=>477} (), {"value"=>"Brine Disposal", "count"=>159} (), {"value"=>"Unknown", "count"=>3} ()
  • Slant
    Text
    {"value"=>"V", "count"=>70035} (), {"value"=>"D", "count"=>6613} (), {"value"=>"H", "count"=>1785} (), {"value"=>" ", "count"=>4} ()
  • dtd
    Number
    0 to 27242
  • tvd
    Number
    0 to 12373
  • kotvd
    Number
    0 to 8462
  • deep_fm_cd
    Text
    {"value"=>"TRVR4", "count"=>15567} (), {"value"=>" ", "count"=>10071} (), {"value"=>"DUND", "count"=>9978} (), {"value"=>"NGRN2", "count"=>5110} (), {"value"=>"DRRV", "count"=>2185} (), {"value"=>"MCGN1", "count"=>2046} (), {"value"=>"TRVR", "count"=>1997} (), {"value"=>"NGRN", "count"=>1810} (), {"value"=>"TRVR2", "count"=>1721} (), {"value"=>"ANRM", "count"=>1611} ()
  • deep_fm
    Text
    {"value"=>"TRAVERSE LIMESTONE", "count"=>15567} (), {"value"=>"DUNDEE", "count"=>9978} (), {"value"=>"NIAGARAN GRAY", "count"=>5110} (), {"value"=>"DETROIT RIVER", "count"=>2185} (), {"value"=>"MICHIGAN STRAY", "count"=>2046} (), {"value"=>"TRAVERSE", "count"=>1997} (), {"value"=>"NIAGARAN", "count"=>1810} (), {"value"=>"TRAVERSE FORMATION", "count"=>1721} (), {"value"=>"ANTRIM", "count"=>1611} (), {"value"=>"NIAGARAN BROWN", "count"=>1554} ()
  • ref_tops
    Text
    {"value"=>"K", "count"=>32636} (), {"value"=>"G", "count"=>22137} (), {"value"=>"D", "count"=>3836} (), {"value"=>"C", "count"=>18} ()
  • elev_ref
    Number
    0 to 1598
  • fieldname
    Text
    {"value"=>"Otsego County - Antrim", "count"=>3117} (), {"value"=>"Montmorency County - Antrim", "count"=>2659} (), {"value"=>"Antrim County - Antrim", "count"=>1721} (), {"value"=>"Alpena County - Antrim", "count"=>921} (), {"value"=>"Walker Oil", "count"=>791} (), {"value"=>"Six Lakes Gas Storage Field", "count"=>696} (), {"value"=>"West Branch", "count"=>657} (), {"value"=>"Mount Pleasant", "count"=>612} (), {"value"=>"Alcona County - Antrim", "count"=>533} (), {"value"=>"Porter Jasper", "count"=>520} ()
  • prod_fm_cd
    Text
    {"value"=>"O", "count"=>15959} (), {"value"=>"G", "count"=>14106} (), {"value"=>"GS", "count"=>3976} (), {"value"=>"GC", "count"=>41} ()
  • prod_fm
    Text
    {"value"=>"ANTRIM(G)", "count"=>11333} (), {"value"=>"DUNDEE(O)", "count"=>5063} (), {"value"=>"TRAVERSE GROUP(O)", "count"=>4332} (), {"value"=>"MICHIGAN STRAY(GS)", "count"=>2597} (), {"value"=>"NIAGARAN(O)", "count"=>2272} (), {"value"=>"RICHFIELD(O)", "count"=>1228} (), {"value"=>"TRENTON(O)", "count"=>1193} (), {"value"=>"NIAGARAN(GS)", "count"=>856} (), {"value"=>"NIAGARAN(G)", "count"=>761} (), {"value"=>"DETROIT RIVER(O)", "count"=>699} ()
  • fieldtype
    Text
    {"value"=>"O", "count"=>15959} (), {"value"=>"G", "count"=>14106} (), {"value"=>"GS", "count"=>3976} (), {"value"=>"GC", "count"=>41} ()
  • PRUNumber
    Text
  • lease_name
    Text
    {"value"=>"MCGC", "count"=>1066} (), {"value"=>"State of Michigan", "count"=>811} (), {"value"=>"STATE CHARLTON", "count"=>465} (), {"value"=>"STATE ALBERT", "count"=>349} (), {"value"=>"STATE VIENNA", "count"=>313} (), {"value"=>"US Gypsum", "count"=>299} (), {"value"=>"PIC 1957 Exploration", "count"=>295} (), {"value"=>"WHITE PINE", "count"=>286} (), {"value"=>"STATE BRILEY", "count"=>254} (), {"value"=>"STATE ELMER", "count"=>248} ()
  • well_no
    Text
    {"value"=>"1", "count"=>23549} (), {"value"=>"2", "count"=>4118} (), {"value"=>"3", "count"=>1858} (), {"value"=>"4", "count"=>1165} (), {"value"=>"5", "count"=>627} (), {"value"=>"6", "count"=>410} (), {"value"=>"A-1", "count"=>384} (), {"value"=>"7", "count"=>327} (), {"value"=>"1-7", "count"=>253} (), {"value"=>"8", "count"=>250} ()
  • op_no
    Number
    0 to 7565
  • co_name
    Text
    {"value"=>"RIVERSIDE ENERGY MICHIGAN LLC", "count"=>2690} (), {"value"=>"MUSKEGON DEVELOPMENT CO", "count"=>2172} (), {"value"=>"LINN OPERATING LLC", "count"=>1854} (), {"value"=>"SWEPI LP", "count"=>1764} (), {"value"=>"MERIT ENERGY CO", "count"=>1590} (), {"value"=>"BREITBURN OPERATING LIMITED PARTNERSHIP", "count"=>1562} (), {"value"=>"MID MICHIGAN GAS STORAGE CO", "count"=>1547} (), {"value"=>"BELDEN AND BLAKE CORP DBA WARD LAKE ENERGY", "count"=>1540} (), {"value"=>"CONSUMERS ENERGY CO", "count"=>1452} (), {"value"=>"CARTER OIL CO", "count"=>1221} ()
  • surf_owner
    Text
    {"value"=>"FEE", "count"=>4750} (), {"value"=>"STATE OF MICHIGAN", "count"=>4279} (), {"value"=>"TURTLE LAKE CLUB", "count"=>91} (), {"value"=>"KITCHEN FARMS", "count"=>56} (), {"value"=>"STATE OF MICHIGAN/REAL ESTATE", "count"=>40} (), {"value"=>"SURFACE OWNER NOT ON FILE", "count"=>38} (), {"value"=>"IN ST. HELEN UNIT", "count"=>37} (), {"value"=>"ANDERSON, STEPHEN & MARY/WILLIAMS, GARY & KATHLEEN", "count"=>36} (), {"value"=>"LAKE HORICON CORPORATION", "count"=>35} (), {"value"=>"PRIMARK STORAGE LEASING COR", "count"=>34} ()
  • state_land
    Number
    -1 to 0
  • fed_land
    Number
    -1 to 0
  • BH_CNTY
    Text
    {"value"=>"137", "count"=>6218} (), {"value"=>"119", "count"=>3969} (), {"value"=>"5", "count"=>3497} (), {"value"=>"9", "count"=>2830} (), {"value"=>"101", "count"=>2761} (), {"value"=>"71", "count"=>2318} (), {"value"=>"55", "count"=>2081} (), {"value"=>"147", "count"=>1978} (), {"value"=>"141", "count"=>1934} (), {"value"=>"73", "count"=>1915} ()
  • TRS
    Text
    {"value"=>"43N-35W-", "count"=>722} (), {"value"=>"23N-15W-", "count"=>685} (), {"value"=>"25N-11W-", "count"=>521} (), {"value"=>"18N-10W-", "count"=>479} (), {"value"=>"50N-42W-", "count"=>441} (), {"value"=>"10N-16W-", "count"=>404} (), {"value"=>"43N-34W-", "count"=>387} (), {"value"=>"26N-10W-", "count"=>360} (), {"value"=>"1S-14W-1", "count"=>353} (), {"value"=>"25N-12W-", "count"=>338} ()
  • qqqs
    Text
    {"value"=>"NW", "count"=>17520} (), {"value"=>"SE", "count"=>17127} (), {"value"=>"SW", "count"=>16176} (), {"value"=>"NE", "count"=>16139} (), {"value"=>"CN", "count"=>2622} (), {"value"=>"N2", "count"=>1292} (), {"value"=>"S2", "count"=>1259} (), {"value"=>"W2", "count"=>607} (), {"value"=>"E2", "count"=>494} (), {"value"=>"C", "count"=>318} ()
  • qqs
    Text
    {"value"=>"SE", "count"=>18907} (), {"value"=>"NW", "count"=>18494} (), {"value"=>"SW", "count"=>18430} (), {"value"=>"NE", "count"=>18264} (), {"value"=>"CN", "count"=>1116} (), {"value"=>"E2", "count"=>142} (), {"value"=>"N2", "count"=>128} (), {"value"=>"W2", "count"=>115} (), {"value"=>"S2", "count"=>112} (), {"value"=>"C", "count"=>62} ()
  • qs
    Text
    {"value"=>"NW", "count"=>19159} (), {"value"=>"SW", "count"=>19078} (), {"value"=>"SE", "count"=>18987} (), {"value"=>"NE", "count"=>18795} (), {"value"=>"CN", "count"=>15} (), {"value"=>"E2", "count"=>6} (), {"value"=>"W2", "count"=>3} (), {"value"=>"S2", "count"=>3} (), {"value"=>"E", "count"=>1} ()
  • wh_lat
    Number
    36.3609928 to 47.9480148
  • wh_long
    Number
    -89.928814 to 82.43139
  • wh_mgr_x
    Number
    198286.02 to 7668618.03
  • wh_mgr_y
    Number
    -7150936.81 to 826534.62
  • PRUName
    Text
  • PermDate
    Date
  • PlugDate
    Date
    1450396800000 to 1494547200000
  • concen_h2s
    Number
    0 to 347215
  • co_phone
    Text
  • co_phone_ext
    Text

About

Related Datasets