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"=>"21017619967000", "count"=>1} (), {"value"=>"21119566990000", "count"=>1} (), {"value"=>"21163000477000", "count"=>1} (), {"value"=>"21101321670000", "count"=>1} (), {"value"=>"21103023777000", "count"=>1} (), {"value"=>"21067161520000", "count"=>1} (), {"value"=>"21139072170000", "count"=>1} (), {"value"=>"21137555470000", "count"=>1} (), {"value"=>"21137432980000", "count"=>1} (), {"value"=>"21113174980000", "count"=>1} ()
  • cnty_fips
    Text
    {"value"=>"137", "count"=>6222} (), {"value"=>"119", "count"=>3969} (), {"value"=>"5", "count"=>3498} (), {"value"=>"9", "count"=>2829} (), {"value"=>"101", "count"=>2765} (), {"value"=>"71", "count"=>2318} (), {"value"=>"55", "count"=>2091} (), {"value"=>"147", "count"=>1978} (), {"value"=>"141", "count"=>1934} (), {"value"=>"73", "count"=>1921} ()
  • permit_no
    Text
    {"value"=>"55140", "count"=>5} (), {"value"=>"46490", "count"=>5} (), {"value"=>"57451", "count"=>5} (), {"value"=>"57588", "count"=>4} (), {"value"=>"47248", "count"=>4} (), {"value"=>"47251", "count"=>3} (), {"value"=>"55932", "count"=>3} (), {"value"=>"58942", "count"=>3} (), {"value"=>"56553", "count"=>3} (), {"value"=>"56955", "count"=>3} ()
  • sidetrck
    Number
    0 to 90
  • completion
    Number
    0 to 91
  • CNTY_NAME
    Text
    {"value"=>"OTSEGO", "count"=>6222} (), {"value"=>"MONTMORENCY", "count"=>3969} (), {"value"=>"ALLEGAN", "count"=>3498} (), {"value"=>"ANTRIM", "count"=>2829} (), {"value"=>"MANISTEE", "count"=>2765} (), {"value"=>"IRON", "count"=>2318} (), {"value"=>"GRAND TRAVERSE", "count"=>2091} (), {"value"=>"SAINT CLAIR", "count"=>1978} (), {"value"=>"PRESQUE ISLE", "count"=>1934} (), {"value"=>"ISABELLA", "count"=>1921} ()
  • twp_name
    Text
    {"value"=>"CHARLTON", "count"=>1461} (), {"value"=>"STAMBAUGH", "count"=>1357} (), {"value"=>"CHESTER", "count"=>1335} (), {"value"=>"HAYES", "count"=>930} (), {"value"=>"LINCOLN", "count"=>851} (), {"value"=>"VIENNA", "count"=>782} (), {"value"=>"BEAR LAKE", "count"=>749} (), {"value"=>"CARP LAKE", "count"=>711} (), {"value"=>"OSSINEKE", "count"=>706} (), {"value"=>"ADAMS", "count"=>693} ()
  • well_type
    Text
    {"value"=>"DH", "count"=>22369} (), {"value"=>"OIL", "count"=>14771} (), {"value"=>"GAS", "count"=>13283} (), {"value"=>"TH", "count"=>12664} (), {"value"=>"LOC", "count"=>8092} (), {"value"=>"GS", "count"=>3025} (), {"value"=>"BDW", "count"=>1612} (), {"value"=>"WIW", "count"=>842} (), {"value"=>"GSO", "count"=>835} (), {"value"=>"BR", "count"=>424} ()
  • well_stat
    Text
    {"value"=>"Plugging Approved", "count"=>37441} (), {"value"=>"Producing", "count"=>13674} (), {"value"=>"Unknown", "count"=>8130} (), {"value"=>"Terminated Permit", "count"=>7928} (), {"value"=>"Active", "count"=>4156} (), {"value"=>"Plugging Completed", "count"=>3157} (), {"value"=>"Shut_In", "count"=>543} (), {"value"=>"Temporarily Abandoned", "count"=>486} (), {"value"=>"Permitted Well", "count"=>145} (), {"value"=>"Drilling Completed", "count"=>74} ()
  • bore_type
    Text
    {"value"=>"Oil and Gas Test", "count"=>64183} (), {"value"=>"Mineral (Non-Confidential)", "count"=>14237} (), {"value"=>"Pre-Permit", "count"=>478} (), {"value"=>"Brine Disposal", "count"=>159} (), {"value"=>"Unknown", "count"=>3} ()
  • Slant
    Text
    {"value"=>"V", "count"=>70097} (), {"value"=>"D", "count"=>6700} (), {"value"=>"H", "count"=>1806} (), {"value"=>" ", "count"=>27} ()
  • dtd
    Number
    0 to 27242
  • tvd
    Number
    0 to 12373
  • kotvd
    Number
    0 to 8462
  • deep_fm_cd
    Text
    {"value"=>"TRVR4", "count"=>15568} (), {"value"=>" ", "count"=>10090} (), {"value"=>"DUND", "count"=>9984} (), {"value"=>"NGRN2", "count"=>5123} (), {"value"=>"DRRV", "count"=>2183} (), {"value"=>"MCGN1", "count"=>2046} (), {"value"=>"TRVR", "count"=>1997} (), {"value"=>"NGRN", "count"=>1811} (), {"value"=>"TRVR2", "count"=>1721} (), {"value"=>"ANRM", "count"=>1610} ()
  • deep_fm
    Text
    {"value"=>"TRAVERSE LIMESTONE", "count"=>15568} (), {"value"=>"DUNDEE", "count"=>9984} (), {"value"=>"NIAGARAN GRAY", "count"=>5123} (), {"value"=>"DETROIT RIVER", "count"=>2183} (), {"value"=>"MICHIGAN STRAY", "count"=>2046} (), {"value"=>"TRAVERSE", "count"=>1997} (), {"value"=>"NIAGARAN", "count"=>1811} (), {"value"=>"TRAVERSE FORMATION", "count"=>1721} (), {"value"=>"ANTRIM", "count"=>1610} (), {"value"=>"NIAGARAN BROWN", "count"=>1562} ()
  • ref_tops
    Text
    {"value"=>"K", "count"=>32670} (), {"value"=>"G", "count"=>22135} (), {"value"=>"D", "count"=>3838} (), {"value"=>"C", "count"=>18} ()
  • elev_ref
    Number
    0 to 1598
  • fieldname
    Text
    {"value"=>"Montmorency County - Antrim", "count"=>2659} (), {"value"=>"Antrim County - Antrim", "count"=>1721} (), {"value"=>"Alpena County - Antrim", "count"=>921} (), {"value"=>"Oscoda County - Antrim", "count"=>487} (), {"value"=>"Bloomingdale", "count"=>445} (), {"value"=>"Manistee County - Antrim", "count"=>411} (), {"value"=>"Buckeye North", "count"=>320} (), {"value"=>"Buckeye South", "count"=>300} (), {"value"=>"East Norwich", "count"=>296} (), {"value"=>"Beaver Creek", "count"=>256} ()
  • prod_fm_cd
    Text
    {"value"=>"O", "count"=>15997} (), {"value"=>"G", "count"=>14108} (), {"value"=>"GS", "count"=>3977} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>38} (), {"value"=>"OG", "count"=>2} ()
  • prod_fm
    Text
    {"value"=>"ANTRIM(G)", "count"=>11333} (), {"value"=>"DUNDEE(O)", "count"=>5079} (), {"value"=>"TRAVERSE GROUP(O)", "count"=>4331} (), {"value"=>"MICHIGAN STRAY(GS)", "count"=>2600} (), {"value"=>"NIAGARAN(O)", "count"=>2277} (), {"value"=>"RICHFIELD(O)", "count"=>1228} (), {"value"=>"TRENTON(O)", "count"=>1205} (), {"value"=>"NIAGARAN(GS)", "count"=>856} (), {"value"=>"NIAGARAN(G)", "count"=>763} (), {"value"=>"DETROIT RIVER(O)", "count"=>703} ()
  • fieldtype
    Text
    {"value"=>"O", "count"=>15997} (), {"value"=>"G", "count"=>14108} (), {"value"=>"GS", "count"=>3977} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>38} (), {"value"=>"OG", "count"=>2} ()
  • PRUNumber
    Text
  • lease_name
    Text
    {"value"=>"STATE PARADISE", "count"=>51} (), {"value"=>"Section 13 Exploration", "count"=>42} (), {"value"=>"BAGLEY EAST", "count"=>35} (), {"value"=>"STATE GARFIELD (RICHFIELD)", "count"=>31} (), {"value"=>"ALBERT", "count"=>25} (), {"value"=>"DAVIS", "count"=>25} (), {"value"=>"REED", "count"=>21} (), {"value"=>"Sun Uphole", "count"=>20} (), {"value"=>"Pennwalt", "count"=>19} (), {"value"=>"GREEN RIVER I", "count"=>18} ()
  • well_no
    Text
    {"value"=>"1-22", "count"=>231} (), {"value"=>"1-10", "count"=>211} (), {"value"=>"2-20", "count"=>66} (), {"value"=>"2-17", "count"=>60} (), {"value"=>"1-20A", "count"=>43} (), {"value"=>"3-12", "count"=>42} (), {"value"=>"3-32", "count"=>35} (), {"value"=>"3-20", "count"=>33} (), {"value"=>"D4-15", "count"=>32} (), {"value"=>"3-22", "count"=>32} ()
  • op_no
    Number
    3 to 7854
  • co_name
    Text
    {"value"=>"BELDEN AND BLAKE CORP DBA WARD LAKE ENERGY", "count"=>1540} (), {"value"=>"CONSUMERS ENERGY CO", "count"=>1455} (), {"value"=>"CARTER OIL CO", "count"=>1221} (), {"value"=>"D T E GAS COMPANY", "count"=>1056} (), {"value"=>"BRAZOS OIL AND GAS CO", "count"=>562} (), {"value"=>"B P AMERICA PRODUCTION CO", "count"=>547} (), {"value"=>"DELTA OIL CO INC", "count"=>536} (), {"value"=>"COPPER RANGE COMPANY - WHITE PINE MINE", "count"=>456} (), {"value"=>"DOW CHEMICAL CO", "count"=>421} (), {"value"=>"A N R PIPELINE CO", "count"=>369} ()
  • surf_owner
    Text
    {"value"=>"BLUE WATER REALTY", "count"=>29} (), {"value"=>"TURTLE LAKE HUNT CLUB", "count"=>29} (), {"value"=>"CANADA CREEK RANCH", "count"=>24} (), {"value"=>"CAMPBELL, WALTER", "count"=>21} (), {"value"=>"UNITED STATES OF AMERICA", "count"=>15} (), {"value"=>"CANCEL & TRANSFER", "count"=>15} (), {"value"=>"TERRA ENERGY LTD", "count"=>14} (), {"value"=>"BROAD, B J & V L & L W & HELEN", "count"=>14} (), {"value"=>"USA", "count"=>13} (), {"value"=>"WEST BAY EXPLORATION", "count"=>12} ()
  • state_land
    Number
    -1 to 0
  • fed_land
    Number
    -1 to 0
  • BH_CNTY
    Text
    {"value"=>"137", "count"=>6222} (), {"value"=>"119", "count"=>3969} (), {"value"=>"5", "count"=>3498} (), {"value"=>"9", "count"=>2829} (), {"value"=>"101", "count"=>2765} (), {"value"=>"71", "count"=>2318} (), {"value"=>"55", "count"=>2091} (), {"value"=>"147", "count"=>1978} (), {"value"=>"141", "count"=>1934} (), {"value"=>"73", "count"=>1921} ()
  • TRS
    Text
    {"value"=>"10N-16W-", "count"=>404} (), {"value"=>"1S-14W-1", "count"=>353} (), {"value"=>"4N-13W-1", "count"=>296} (), {"value"=>"21N-7E-2", "count"=>291} (), {"value"=>"24N-13W-", "count"=>288} (), {"value"=>"14N-11W-", "count"=>261} (), {"value"=>"12N-4E-1", "count"=>253} (), {"value"=>"26N-11W-", "count"=>217} (), {"value"=>"13N-7W-3", "count"=>211} (), {"value"=>"14N-4E-1", "count"=>178} ()
  • qqqs
    Text
    {"value"=>"NW", "count"=>17557} (), {"value"=>"SE", "count"=>17155} (), {"value"=>"SW", "count"=>16218} (), {"value"=>"NE", "count"=>16190} (), {"value"=>"CN", "count"=>2622} (), {"value"=>"N2", "count"=>1291} (), {"value"=>"S2", "count"=>1256} (), {"value"=>"W2", "count"=>607} (), {"value"=>"E2", "count"=>494} (), {"value"=>"C", "count"=>318} ()
  • qqs
    Text
    {"value"=>"SE", "count"=>18936} (), {"value"=>"NW", "count"=>18537} (), {"value"=>"SW", "count"=>18472} (), {"value"=>"NE", "count"=>18305} (), {"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"=>19205} (), {"value"=>"SW", "count"=>19119} (), {"value"=>"SE", "count"=>19023} (), {"value"=>"NE", "count"=>18827} (), {"value"=>"CN", "count"=>15} (), {"value"=>"E2", "count"=>6} (), {"value"=>"W2", "count"=>3} (), {"value"=>"S2", "count"=>3} (), {"value"=>"E", "count"=>1} ()
  • wh_lat
    Number
    41.708579 to 47.9480148
  • wh_long
    Number
    -89.928814 to -82.3908889
  • wh_mgr_x
    Number
    198286.02 to 793367.82
  • wh_mgr_y
    Number
    129535.96 to 826534.62
  • PRUName
    Text
  • PermDate
    Date
    1496188800000 to 1545350400000
  • PlugDate
    Date
    1450396800000 to 1450396800000
  • concen_h2s
    Number
    0 to 347215
  • co_phone
    Text
  • co_phone_ext
    Text

About

Related Datasets