Description

more
S Bottom hole locations for all oil and gas test wells whether directionally drilled or straight (vertical) holes. D Bottom Hole Location - Bottom hole locations for all oil and gas test wells whether directionally drilled or straight (vertical) holes. For a straight (vertical) hole the bottom hole location will be the same as the surface location. 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"=>"21147224100000", "count"=>3} (), {"value"=>"21005097400000", "count"=>2} (), {"value"=>"21121002110000", "count"=>2} (), {"value"=>"21055350950000", "count"=>2} (), {"value"=>"21111035110000", "count"=>2} (), {"value"=>"21073127910000", "count"=>2} (), {"value"=>"21133113980000", "count"=>2} (), {"value"=>"21133088810000", "count"=>2} (), {"value"=>"21011346790000", "count"=>2} (), {"value"=>"21147247990000", "count"=>2} ()
  • permit_no
    Text
    {"value"=>"47823", "count"=>5} (), {"value"=>"52379", "count"=>4} (), {"value"=>"9137", "count"=>3} (), {"value"=>"14155", "count"=>3} (), {"value"=>"53776", "count"=>3} (), {"value"=>"46100", "count"=>3} (), {"value"=>"3", "count"=>3} (), {"value"=>"20831", "count"=>2} (), {"value"=>"1883", "count"=>2} (), {"value"=>"34613", "count"=>2} ()
  • cnty_fips
    Number
    1 to 165
  • CNTY_NAME
    Text
    {"value"=>"IRON", "count"=>2054} (), {"value"=>"OTSEGO", "count"=>1250} (), {"value"=>"MANISTEE", "count"=>1050} (), {"value"=>"GRAND TRAVERSE", "count"=>1023} (), {"value"=>"PRESQUE ISLE", "count"=>1007} (), {"value"=>"KALKASKA", "count"=>875} (), {"value"=>"ONTONAGON", "count"=>753} (), {"value"=>"BAY", "count"=>724} (), {"value"=>"MONTMORENCY", "count"=>530} (), {"value"=>"CRAWFORD", "count"=>456} ()
  • BH_CNTY
    Number
    1 to 165
  • sidetrck
    Number
    0 to 90
  • completion
    Number
    0 to 91
  • lease_name
    Text
    {"value"=>"STATE OTSEGO LAKE", "count"=>154} (), {"value"=>"Empire", "count"=>65} (), {"value"=>"Pfister Lands Exploration", "count"=>52} (), {"value"=>"LAKE HORICON", "count"=>45} (), {"value"=>"STATE GARFIELD (RICHFIELD)", "count"=>31} (), {"value"=>"STEVENS", "count"=>26} (), {"value"=>"PETERSON", "count"=>24} (), {"value"=>"STATE PLEASANTON", "count"=>19} (), {"value"=>"MURPHY", "count"=>18} (), {"value"=>"JAMES", "count"=>18} ()
  • well_no
    Text
    {"value"=>"3", "count"=>1896} (), {"value"=>"1-21", "count"=>240} (), {"value"=>"1-20", "count"=>230} (), {"value"=>"1-14", "count"=>215} (), {"value"=>"1-30", "count"=>214} (), {"value"=>"1-5", "count"=>208} (), {"value"=>"2-20", "count"=>66} (), {"value"=>"2-35", "count"=>51} (), {"value"=>"2-4", "count"=>48} (), {"value"=>"3-16", "count"=>39} ()
  • op_no
    Number
    3 to 7691
  • co_name
    Text
    {"value"=>"BREITBURN OPERATING LIMITED PARTNERSHIP", "count"=>1563} (), {"value"=>"BELDEN AND BLAKE CORP DBA WARD LAKE ENERGY", "count"=>1541} (), {"value"=>"CONSUMERS ENERGY CO", "count"=>1468} (), {"value"=>"CARTER OIL CO", "count"=>1223} (), {"value"=>"D T E GAS COMPANY", "count"=>1185} (), {"value"=>"BRAZOS OIL AND GAS CO", "count"=>563} (), {"value"=>"B P AMERICA PRODUCTION CO", "count"=>556} (), {"value"=>"COPPER RANGE COMPANY - WHITE PINE MINE", "count"=>456} (), {"value"=>"A N R PIPELINE CO", "count"=>437} (), {"value"=>"CLEVELAND CLIFFS IRON CO", "count"=>420} ()
  • surf_owner
    Text
    {"value"=>"RONAN, ARTHUR P", "count"=>31} (), {"value"=>"ARROWHEAD RANCH", "count"=>28} (), {"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"=>"PACKAGING CORP. OF AMERICA", "count"=>11} (), {"value"=>"GOTTLOEB, A. S.", "count"=>11} (), {"value"=>"LIVINGSTON CLUB", "count"=>9} (), {"value"=>"CHARLES, GERALD", "count"=>9} ()
  • state_land
    Number
    -1 to 0
  • fed_land
    Number
    -1 to 0
  • twp_name
    Text
    {"value"=>"STAMBAUGH", "count"=>1276} (), {"value"=>"CARP LAKE", "count"=>711} (), {"value"=>"CRYSTAL FALLS", "count"=>348} (), {"value"=>"CHESTER", "count"=>347} (), {"value"=>"CHARLTON", "count"=>302} (), {"value"=>"MONITOR", "count"=>250} (), {"value"=>"GRANT", "count"=>237} (), {"value"=>"KALKASKA", "count"=>235} (), {"value"=>"MAYFIELD", "count"=>215} (), {"value"=>"GARFIELD", "count"=>212} ()
  • TRS
    Text
    {"value"=>"23N-15W-", "count"=>163} (), {"value"=>"22N-16W-", "count"=>136} (), {"value"=>"14N-4E-1", "count"=>121} (), {"value"=>"23N-14W-", "count"=>94} (), {"value"=>"22N-15W-", "count"=>87} (), {"value"=>"14N-2E-2", "count"=>80} (), {"value"=>"14N-4E-2", "count"=>63} (), {"value"=>"14N-3E-1", "count"=>57} (), {"value"=>"23N-16W-", "count"=>55} (), {"value"=>"28N-6W-1", "count"=>51} ()
  • qqqs
    Text
    {"value"=>"SW", "count"=>4281} (), {"value"=>"NW", "count"=>4199} (), {"value"=>"SE", "count"=>4148} (), {"value"=>"NE", "count"=>4082} (), {"value"=>"CN", "count"=>194} (), {"value"=>"S2", "count"=>45} (), {"value"=>"N2", "count"=>43} (), {"value"=>"W2", "count"=>40} (), {"value"=>"E2", "count"=>36} (), {"value"=>"SS", "count"=>2} ()
  • qqs
    Text
    {"value"=>"SE", "count"=>4435} (), {"value"=>"SW", "count"=>4424} (), {"value"=>"NE", "count"=>4389} (), {"value"=>"NW", "count"=>4380} (), {"value"=>"CN", "count"=>25} (), {"value"=>"E2", "count"=>13} (), {"value"=>"S2", "count"=>11} (), {"value"=>"W2", "count"=>10} (), {"value"=>"N2", "count"=>10} (), {"value"=>"W ", "count"=>2} ()
  • qs
    Text
    {"value"=>"NW", "count"=>4642} (), {"value"=>"SW", "count"=>4459} (), {"value"=>"NE", "count"=>4406} (), {"value"=>"SE", "count"=>4317} (), {"value"=>"CN", "count"=>10} (), {"value"=>"E2", "count"=>7} (), {"value"=>"W2", "count"=>3} (), {"value"=>"S2", "count"=>3} ()
  • well_type
    Text
    {"value"=>"DH", "count"=>22792} (), {"value"=>"OIL", "count"=>15009} (), {"value"=>"GAS", "count"=>13385} (), {"value"=>"TH", "count"=>12841} (), {"value"=>"LOC", "count"=>8075} (), {"value"=>"GS", "count"=>3090} (), {"value"=>"BDW", "count"=>1652} (), {"value"=>"GSO", "count"=>1014} (), {"value"=>"WIW", "count"=>863} (), {"value"=>"BR", "count"=>425} ()
  • well_stat
    Text
    {"value"=>"Plugging Approved", "count"=>38179} (), {"value"=>"Producing", "count"=>13786} (), {"value"=>"Unknown", "count"=>8296} (), {"value"=>"Terminated Permit", "count"=>7905} (), {"value"=>"Active", "count"=>4240} (), {"value"=>"Plugging Completed", "count"=>3085} (), {"value"=>"Temporarily Abandoned", "count"=>535} (), {"value"=>"Shut_In", "count"=>509} (), {"value"=>"Permitted Well", "count"=>143} (), {"value"=>"Suspended Operations", "count"=>82} ()
  • Slant
    Text
    {"value"=>"V", "count"=>71161} (), {"value"=>"D", "count"=>6673} (), {"value"=>"H", "count"=>1804} (), {"value"=>" ", "count"=>12} ()
  • bore_type
    Text
    {"value"=>"Oil and Gas Test", "count"=>65222} (), {"value"=>"Mineral (Non-Confidential)", "count"=>14217} (), {"value"=>"Pre-Permit", "count"=>477} (), {"value"=>"Brine Disposal", "count"=>161} (), {"value"=>"Unknown", "count"=>3} ()
  • dtd
    Number
    0 to 27242
  • tvd
    Number
    0 to 12373
  • kotvd
    Number
    0 to 8462
  • ref_tops
    Text
    {"value"=>"K", "count"=>32993} (), {"value"=>"G", "count"=>22834} (), {"value"=>"D", "count"=>3927} (), {"value"=>"C", "count"=>18} ()
  • elev_ref
    Number
    0 to 1598
  • fieldname
    Text
    {"value"=>"Otsego County - Antrim", "count"=>3118} (), {"value"=>"Montmorency County - Antrim", "count"=>2659} (), {"value"=>"Antrim County - Antrim", "count"=>1721} (), {"value"=>"Alpena County - Antrim", "count"=>921} (), {"value"=>"Six Lakes Gas Storage Field", "count"=>790} (), {"value"=>"Mount Pleasant", "count"=>635} (), {"value"=>"Bloomingdale", "count"=>450} (), {"value"=>"Manistee County - Antrim", "count"=>412} (), {"value"=>"Kawkawlin", "count"=>377} (), {"value"=>"Salem", "count"=>357} ()
  • fieldtype
    Text
    {"value"=>"O", "count"=>16282} (), {"value"=>"G", "count"=>14161} (), {"value"=>"GS", "count"=>4287} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>15} ()
  • PRUNumber
    Number
    1 to 21726
  • deep_fm_cd
    Text
    {"value"=>"TRVR4", "count"=>15676} (), {"value"=>"DUND", "count"=>10251} (), {"value"=>" ", "count"=>10089} (), {"value"=>"NGRN2", "count"=>5189} (), {"value"=>"DRRV", "count"=>2258} (), {"value"=>"MCGN1", "count"=>2134} (), {"value"=>"TRVR", "count"=>2040} (), {"value"=>"NGRN", "count"=>1843} (), {"value"=>"TRVR2", "count"=>1737} (), {"value"=>"ANRM", "count"=>1613} ()
  • deep_fm
    Text
    {"value"=>"TRAVERSE LIMESTONE", "count"=>15676} (), {"value"=>"DUNDEE", "count"=>10251} (), {"value"=>"NIAGARAN GRAY", "count"=>5189} (), {"value"=>"DETROIT RIVER", "count"=>2258} (), {"value"=>"MICHIGAN STRAY", "count"=>2134} (), {"value"=>"TRAVERSE", "count"=>2040} (), {"value"=>"NIAGARAN", "count"=>1843} (), {"value"=>"TRAVERSE FORMATION", "count"=>1737} (), {"value"=>"ANTRIM", "count"=>1613} (), {"value"=>"NIAGARAN BROWN", "count"=>1586} ()
  • prod_fm_cd
    Text
    {"value"=>"O", "count"=>16282} (), {"value"=>"G", "count"=>14161} (), {"value"=>"GS", "count"=>4287} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>15} ()
  • prod_fm
    Text
    {"value"=>"ANTRIM(G)", "count"=>11341} (), {"value"=>"DUNDEE(O)", "count"=>5191} (), {"value"=>"TRAVERSE GROUP(O)", "count"=>4425} (), {"value"=>"MICHIGAN STRAY(GS)", "count"=>2848} (), {"value"=>"NIAGARAN(O)", "count"=>2304} (), {"value"=>"RICHFIELD(O)", "count"=>1243} (), {"value"=>"TRENTON(O)", "count"=>1228} (), {"value"=>"NIAGARAN(GS)", "count"=>870} (), {"value"=>"NIAGARAN(G)", "count"=>772} (), {"value"=>"DETROIT RIVER(O)", "count"=>706} ()
  • PermDate
    Date
    -1333756800000 to 1486684800000
  • PlugDate
    Date
    -1329264000000 to 1487203200000
  • concen_h2s
    Number
    0 to 347215
  • bh_lat
    Number
    41.708579 to 47.9480148
  • bh_long
    Number
    -89.928814 to -82.3908889
  • bh_mgr_x
    Number
    198286.01 to 793367.82
  • bh_mgr_y
    Number
    129535.96 to 826534.61
  • PRUName
    Text
    {"value"=>"MID-CHARLTON UNIT II", "count"=>35} (), {"value"=>"SCOTT CREEK ANTRIM", "count"=>32} (), {"value"=>"CHESTER WEST UNIT", "count"=>31} (), {"value"=>"CHARLTON EAST UNIT", "count"=>31} (), {"value"=>"Milton Bradley Central", "count"=>27} (), {"value"=>"COMSTOCK HILLS ANTRIM", "count"=>26} (), {"value"=>"Hudson Northwest", "count"=>24} (), {"value"=>"CHESTER 22 UNIT", "count"=>24} (), {"value"=>"BRILEY 19 UNIT", "count"=>24} (), {"value"=>"Old Vandy Unit No. 5 Antrim", "count"=>23} ()

About

Related Datasets