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"=>"21137442590000", "count"=>1} (), {"value"=>"21009497690000", "count"=>1} (), {"value"=>"21105407730000", "count"=>1} (), {"value"=>"21099227130000", "count"=>1} (), {"value"=>"21079397200000", "count"=>1} (), {"value"=>"21071016097000", "count"=>1} (), {"value"=>"21061005087000", "count"=>1} (), {"value"=>"21009611537000", "count"=>1} (), {"value"=>"21009466480000", "count"=>1} (), {"value"=>"21137560000000", "count"=>1} ()
  • cnty_fips
    Text
    {"value"=>"137", "count"=>6220} (), {"value"=>"119", "count"=>3969} (), {"value"=>"5", "count"=>3497} (), {"value"=>"9", "count"=>2830} (), {"value"=>"101", "count"=>2761} (), {"value"=>"71", "count"=>2318} (), {"value"=>"55", "count"=>2083} (), {"value"=>"147", "count"=>1978} (), {"value"=>"141", "count"=>1934} (), {"value"=>"73", "count"=>1920} ()
  • permit_no
    Text
    {"value"=>"33893", "count"=>5} (), {"value"=>"1107-822-48", "count"=>4} (), {"value"=>"25724", "count"=>4} (), {"value"=>"52379", "count"=>4} (), {"value"=>"55163", "count"=>3} (), {"value"=>"9137", "count"=>3} (), {"value"=>"53776", "count"=>3} (), {"value"=>"3", "count"=>3} (), {"value"=>"19232", "count"=>2} (), {"value"=>"42611", "count"=>2} ()
  • sidetrck
    Number
    0 to 90
  • completion
    Number
    0 to 91
  • CNTY_NAME
    Text
    {"value"=>"OTSEGO", "count"=>6220} (), {"value"=>"MONTMORENCY", "count"=>3969} (), {"value"=>"ALLEGAN", "count"=>3497} (), {"value"=>"ANTRIM", "count"=>2830} (), {"value"=>"MANISTEE", "count"=>2761} (), {"value"=>"IRON", "count"=>2318} (), {"value"=>"GRAND TRAVERSE", "count"=>2083} (), {"value"=>"SAINT CLAIR", "count"=>1978} (), {"value"=>"PRESQUE ISLE", "count"=>1934} (), {"value"=>"ISABELLA", "count"=>1920} ()
  • twp_name
    Text
    {"value"=>"CHARLTON", "count"=>1459} (), {"value"=>"STAMBAUGH", "count"=>1357} (), {"value"=>"CHESTER", "count"=>1336} (), {"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"=>22327} (), {"value"=>"OIL", "count"=>14733} (), {"value"=>"GAS", "count"=>13280} (), {"value"=>"TH", "count"=>12841} (), {"value"=>"LOC", "count"=>8071} (), {"value"=>"GS", "count"=>3025} (), {"value"=>"BDW", "count"=>1624} (), {"value"=>"WIW", "count"=>843} (), {"value"=>"GSO", "count"=>835} (), {"value"=>"BR", "count"=>425} ()
  • well_stat
    Text
    {"value"=>"Plugging Approved", "count"=>37080} (), {"value"=>"Producing", "count"=>13783} (), {"value"=>"Unknown", "count"=>8296} (), {"value"=>"Terminated Permit", "count"=>7901} (), {"value"=>"Active", "count"=>4227} (), {"value"=>"Plugging Completed", "count"=>3057} (), {"value"=>"Temporarily Abandoned", "count"=>535} (), {"value"=>"Shut_In", "count"=>509} (), {"value"=>"Permitted Well", "count"=>143} (), {"value"=>"Suspended Operations", "count"=>82} ()
  • bore_type
    Text
    {"value"=>"Oil and Gas Test", "count"=>64082} (), {"value"=>"Mineral (Non-Confidential)", "count"=>14212} (), {"value"=>"Pre-Permit", "count"=>477} (), {"value"=>"Brine Disposal", "count"=>159} (), {"value"=>"Unknown", "count"=>3} ()
  • Slant
    Text
    {"value"=>"V", "count"=>70064} (), {"value"=>"D", "count"=>6632} (), {"value"=>"H", "count"=>1795} (), {"value"=>" ", "count"=>12} ()
  • 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"=>10088} (), {"value"=>"DUND", "count"=>9978} (), {"value"=>"NGRN2", "count"=>5108} (), {"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"=>5108} (), {"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"=>1560} ()
  • ref_tops
    Text
    {"value"=>"K", "count"=>32644} (), {"value"=>"G", "count"=>22135} (), {"value"=>"D", "count"=>3837} (), {"value"=>"C", "count"=>18} ()
  • elev_ref
    Number
    0 to 1598
  • fieldname
    Text
    {"value"=>"Antrim County - Antrim", "count"=>1721} (), {"value"=>"Alpena County - Antrim", "count"=>921} (), {"value"=>"Alcona County - Antrim", "count"=>533} (), {"value"=>"Bloomingdale", "count"=>445} (), {"value"=>"Buckeye North", "count"=>320} (), {"value"=>"Buckeye South", "count"=>300} (), {"value"=>"East Norwich", "count"=>296} (), {"value"=>"Beaver Creek", "count"=>257} (), {"value"=>"Albion Scipio 5 South", "count"=>245} (), {"value"=>"Austin Gas Storage Field", "count"=>237} ()
  • prod_fm_cd
    Text
    {"value"=>"O", "count"=>15962} (), {"value"=>"G", "count"=>14106} (), {"value"=>"GS", "count"=>3976} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>15} ()
  • 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"=>2274} (), {"value"=>"RICHFIELD(O)", "count"=>1228} (), {"value"=>"TRENTON(O)", "count"=>1195} (), {"value"=>"NIAGARAN(GS)", "count"=>856} (), {"value"=>"NIAGARAN(G)", "count"=>762} (), {"value"=>"DETROIT RIVER(O)", "count"=>700} ()
  • fieldtype
    Text
    {"value"=>"O", "count"=>15962} (), {"value"=>"G", "count"=>14106} (), {"value"=>"GS", "count"=>3976} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>15} ()
  • PRUNumber
    Text
  • lease_name
    Text
    {"value"=>"STATE OTSEGO LAKE", "count"=>154} (), {"value"=>"Empire", "count"=>65} (), {"value"=>"SIX LAKES", "count"=>59} (), {"value"=>"Pfister Lands Exploration", "count"=>52} (), {"value"=>"LAKE HORICON", "count"=>44} (), {"value"=>"STATE GARFIELD (RICHFIELD)", "count"=>31} (), {"value"=>"STEVENS", "count"=>26} (), {"value"=>"Rockport Quarry", "count"=>24} (), {"value"=>"PETERSON", "count"=>24} (), {"value"=>"STATE PLEASANTON", "count"=>19} ()
  • well_no
    Text
    {"value"=>"1-20", "count"=>227} (), {"value"=>"1-30", "count"=>211} (), {"value"=>"1-5", "count"=>208} (), {"value"=>"1-3", "count"=>182} (), {"value"=>"B-1", "count"=>176} (), {"value"=>"17", "count"=>82} (), {"value"=>"2-20", "count"=>66} (), {"value"=>"3-36", "count"=>41} (), {"value"=>"3-29", "count"=>32} (), {"value"=>"D4-35", "count"=>30} ()
  • op_no
    Number
    3 to 7691
  • co_name
    Text
    {"value"=>"BREITBURN OPERATING LIMITED PARTNERSHIP", "count"=>1562} (), {"value"=>"BELDEN AND BLAKE CORP DBA WARD LAKE ENERGY", "count"=>1540} (), {"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"=>"CLEVELAND CLIFFS IRON CO", "count"=>420} (), {"value"=>"A N R PIPELINE CO", "count"=>369} (), {"value"=>"Consolidated Coal Company", "count"=>327} ()
  • surf_owner
    Text
    {"value"=>"RONAN, ARTHUR P", "count"=>31} (), {"value"=>"ARROWHEAD RANCH", "count"=>27} (), {"value"=>"FLETCHER, ALAN M", "count"=>27} (), {"value"=>"MILLER, HERMAN", "count"=>15} (), {"value"=>"WEST BAY EXPLORATION COMPANY", "count"=>14} (), {"value"=>"LAKES OF THE NORTH ASSOC./BRAN", "count"=>12} (), {"value"=>"GOTTLOEB, A. S.", "count"=>11} (), {"value"=>"PACKAGING CORP. OF AMERICA", "count"=>10} (), {"value"=>"LIVINGSTON CLUB", "count"=>9} (), {"value"=>"CHARLES, GERALD", "count"=>9} ()
  • state_land
    Number
    -1 to 0
  • fed_land
    Number
    -1 to 0
  • BH_CNTY
    Text
    {"value"=>"137", "count"=>6220} (), {"value"=>"119", "count"=>3969} (), {"value"=>"5", "count"=>3497} (), {"value"=>"9", "count"=>2830} (), {"value"=>"101", "count"=>2761} (), {"value"=>"71", "count"=>2318} (), {"value"=>"55", "count"=>2083} (), {"value"=>"147", "count"=>1978} (), {"value"=>"141", "count"=>1934} (), {"value"=>"73", "count"=>1920} ()
  • TRS
    Text
    {"value"=>"25N-11W-", "count"=>521} (), {"value"=>"30N-2W-2", "count"=>261} (), {"value"=>"12N-4E-1", "count"=>253} (), {"value"=>"24N-5W-1", "count"=>250} (), {"value"=>"16N-17W-", "count"=>236} (), {"value"=>"10N-17W-", "count"=>224} (), {"value"=>"20N-6W-3", "count"=>222} (), {"value"=>"13N-7W-3", "count"=>211} (), {"value"=>"29N-2W-1", "count"=>210} (), {"value"=>"16N-4W-2", "count"=>160} ()
  • qqqs
    Text
    {"value"=>"NW", "count"=>17535} (), {"value"=>"SE", "count"=>17133} (), {"value"=>"SW", "count"=>16196} (), {"value"=>"NE", "count"=>16148} (), {"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"=>18919} (), {"value"=>"NW", "count"=>18505} (), {"value"=>"SW", "count"=>18446} (), {"value"=>"NE", "count"=>18275} (), {"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"=>19174} (), {"value"=>"SW", "count"=>19096} (), {"value"=>"SE", "count"=>18997} (), {"value"=>"NE", "count"=>18802} (), {"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 1503619200000
  • PlugDate
    Date
    1450396800000 to 1450396800000
  • concen_h2s
    Number
    0 to 347215
  • co_phone
    Text
  • co_phone_ext
    Text

About

Related Datasets