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"=>"21011186740000", "count"=>2} (), {"value"=>"21025216760000", "count"=>2} (), {"value"=>"21107141550000", "count"=>2} (), {"value"=>"21107027440100", "count"=>2} (), {"value"=>"21123107720000", "count"=>2} (), {"value"=>"21079361010000", "count"=>2} (), {"value"=>"21123133540000", "count"=>2} (), {"value"=>"21121002110000", "count"=>2} (), {"value"=>"21005061550000", "count"=>2} (), {"value"=>"21123101440000", "count"=>2} ()
  • permit_no
    Text
    {"value"=>"668-812-425", "count"=>7} (), {"value"=>"46490", "count"=>5} (), {"value"=>"57451", "count"=>5} (), {"value"=>"55153", "count"=>5} (), {"value"=>"57588", "count"=>4} (), {"value"=>"47248", "count"=>4} (), {"value"=>"103", "count"=>4} (), {"value"=>"30664", "count"=>3} (), {"value"=>"39", "count"=>3} (), {"value"=>"56955", "count"=>3} ()
  • cnty_fips
    Number
    1 to 165
  • CNTY_NAME
    Text
    {"value"=>"IRON", "count"=>2054} (), {"value"=>"OTSEGO", "count"=>1256} (), {"value"=>"MANISTEE", "count"=>1059} (), {"value"=>"GRAND TRAVERSE", "count"=>1031} (), {"value"=>"PRESQUE ISLE", "count"=>1007} (), {"value"=>"KALKASKA", "count"=>878} (), {"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"=>"PIC 1957 Exploration", "count"=>295} (), {"value"=>"STATE BRILEY", "count"=>254} (), {"value"=>"Drummond Core Hole", "count"=>207} (), {"value"=>"ANR STORAGE CO", "count"=>61} (), {"value"=>"PIC 1967 Exploration", "count"=>53} (), {"value"=>"PIC 1962 Exploration", "count"=>49} (), {"value"=>"EAST AUSTIN", "count"=>42} (), {"value"=>"Alpha-Porter Exploration", "count"=>38} (), {"value"=>"NORWICH UNIT TRACT 5", "count"=>25} (), {"value"=>"B Series", "count"=>23} ()
  • well_no
    Text
    {"value"=>"2", "count"=>4250} (), {"value"=>"1-28", "count"=>236} (), {"value"=>"1-24", "count"=>230} (), {"value"=>"1-10", "count"=>214} (), {"value"=>"A-2", "count"=>137} (), {"value"=>"2-17", "count"=>61} (), {"value"=>"B-3", "count"=>42} (), {"value"=>"3-32", "count"=>35} (), {"value"=>"3-20", "count"=>33} (), {"value"=>"D4-15", "count"=>32} ()
  • op_no
    Number
    3 to 7854
  • co_name
    Text
    {"value"=>"RIVERSIDE ENERGY MICHIGAN LLC", "count"=>3216} (), {"value"=>"TERRA ENERGY LTD", "count"=>1110} (), {"value"=>"UNION OIL CO OF CALIFORNIA", "count"=>679} (), {"value"=>"MARATHON OIL COMPANY", "count"=>630} (), {"value"=>"MILLER BROTHERS", "count"=>510} (), {"value"=>"COPPER RANGE COMPANY - WHITE PINE MINE", "count"=>456} (), {"value"=>"MCCLURE OIL CO", "count"=>385} (), {"value"=>"Consolidated Coal Company", "count"=>327} (), {"value"=>"MERIT ENERGY CO", "count"=>317} (), {"value"=>"SMITH PETROLEUM CO", "count"=>290} ()
  • surf_owner
    Text
    {"value"=>"ANDERSON, STEPHEN & MARY/WILLIAMS, GARY & KATHLEEN", "count"=>36} (), {"value"=>"MILLER, HERMAN", "count"=>15} (), {"value"=>"EBLING, VIRGINIA", "count"=>13} (), {"value"=>"TRENDWELL OIL CORPORATION", "count"=>12} (), {"value"=>"OTSEGO COUNTY ROAD COMMISSION", "count"=>10} (), {"value"=>"CAMP DOMINO", "count"=>9} (), {"value"=>"C/O WEBER, RAYMOND", "count"=>8} (), {"value"=>"LAKE ARROWHEAD PROP. OWNERS AS", "count"=>8} (), {"value"=>"DAVID PEASE", "count"=>7} (), {"value"=>"WISTRAND, W. H. & H.", "count"=>7} ()
  • 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"=>"CHESTER", "count"=>348} (), {"value"=>"CRYSTAL FALLS", "count"=>348} (), {"value"=>"CHARLTON", "count"=>304} (), {"value"=>"MONITOR", "count"=>250} (), {"value"=>"GRANT", "count"=>242} (), {"value"=>"KALKASKA", "count"=>236} (), {"value"=>"MAYFIELD", "count"=>220} (), {"value"=>"GARFIELD", "count"=>213} ()
  • TRS
    Text
    {"value"=>"43N-32W-", "count"=>184} (), {"value"=>"25N-12W-", "count"=>146} (), {"value"=>"33N-8E-2", "count"=>133} (), {"value"=>"14N-4E-1", "count"=>121} (), {"value"=>"26N-11W-", "count"=>113} (), {"value"=>"24N-13W-", "count"=>102} (), {"value"=>"25N-13W-", "count"=>94} (), {"value"=>"24N-12W-", "count"=>69} (), {"value"=>"30N-2W-1", "count"=>68} (), {"value"=>"21N-17W-", "count"=>67} ()
  • qqqs
    Text
    {"value"=>"SW", "count"=>4317} (), {"value"=>"NW", "count"=>4225} (), {"value"=>"SE", "count"=>4174} (), {"value"=>"NE", "count"=>4122} (), {"value"=>"CN", "count"=>195} (), {"value"=>"S2", "count"=>45} (), {"value"=>"N2", "count"=>43} (), {"value"=>"W2", "count"=>40} (), {"value"=>"E2", "count"=>36} (), {"value"=>"CS", "count"=>2} ()
  • qqs
    Text
    {"value"=>"SE", "count"=>4470} (), {"value"=>"SW", "count"=>4446} (), {"value"=>"NE", "count"=>4424} (), {"value"=>"NW", "count"=>4418} (), {"value"=>"CN", "count"=>25} (), {"value"=>"E2", "count"=>13} (), {"value"=>"S2", "count"=>11} (), {"value"=>"N2", "count"=>10} (), {"value"=>"W2", "count"=>10} (), {"value"=>"W ", "count"=>2} ()
  • qs
    Text
    {"value"=>"NW", "count"=>4674} (), {"value"=>"SW", "count"=>4486} (), {"value"=>"NE", "count"=>4441} (), {"value"=>"SE", "count"=>4353} (), {"value"=>"CN", "count"=>10} (), {"value"=>"E2", "count"=>7} (), {"value"=>"W2", "count"=>3} (), {"value"=>"S2", "count"=>3} ()
  • well_type
    Text
    {"value"=>"DH", "count"=>22841} (), {"value"=>"OIL", "count"=>15061} (), {"value"=>"GAS", "count"=>13389} (), {"value"=>"TH", "count"=>12658} (), {"value"=>"LOC", "count"=>8111} (), {"value"=>"GS", "count"=>3093} (), {"value"=>"BDW", "count"=>1648} (), {"value"=>"GSO", "count"=>1017} (), {"value"=>"WIW", "count"=>863} (), {"value"=>"BR", "count"=>426} ()
  • well_stat
    Text
    {"value"=>"Plugging Approved", "count"=>38583} (), {"value"=>"Producing", "count"=>13671} (), {"value"=>"Unknown", "count"=>8124} (), {"value"=>"Terminated Permit", "count"=>7958} (), {"value"=>"Active", "count"=>4144} (), {"value"=>"Plugging Completed", "count"=>3227} (), {"value"=>"Shut_In", "count"=>544} (), {"value"=>"Temporarily Abandoned", "count"=>469} (), {"value"=>"Permitted Well", "count"=>135} (), {"value"=>"Drilling Completed", "count"=>77} ()
  • Slant
    Text
    {"value"=>"V", "count"=>71215} (), {"value"=>"D", "count"=>6754} (), {"value"=>"H", "count"=>1827} (), {"value"=>" ", "count"=>32} ()
  • bore_type
    Text
    {"value"=>"Oil and Gas Test", "count"=>65372} (), {"value"=>"Mineral (Non-Confidential)", "count"=>14246} (), {"value"=>"Pre-Permit", "count"=>478} (), {"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"=>33033} (), {"value"=>"G", "count"=>22840} (), {"value"=>"D", "count"=>3929} (), {"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"=>"Six Lakes Gas Storage Field", "count"=>793} (), {"value"=>"West Branch", "count"=>669} (), {"value"=>"Mount Pleasant", "count"=>635} (), {"value"=>"Alcona County - Antrim", "count"=>533} (), {"value"=>"Oscoda County - Antrim", "count"=>487} (), {"value"=>"Manistee County - Antrim", "count"=>412} (), {"value"=>"Salem", "count"=>357} ()
  • fieldtype
    Text
    {"value"=>"O", "count"=>16332} (), {"value"=>"G", "count"=>14164} (), {"value"=>"GS", "count"=>4290} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>38} (), {"value"=>"OG", "count"=>2} ()
  • PRUNumber
    Number
    1 to 21772
  • deep_fm_cd
    Text
    {"value"=>"TRVR4", "count"=>15677} (), {"value"=>"DUND", "count"=>10261} (), {"value"=>" ", "count"=>10094} (), {"value"=>"NGRN2", "count"=>5208} (), {"value"=>"DRRV", "count"=>2257} (), {"value"=>"MCGN1", "count"=>2135} (), {"value"=>"TRVR", "count"=>2040} (), {"value"=>"NGRN", "count"=>1846} (), {"value"=>"TRVR2", "count"=>1737} (), {"value"=>"ANRM", "count"=>1612} ()
  • deep_fm
    Text
    {"value"=>"TRAVERSE LIMESTONE", "count"=>15677} (), {"value"=>"DUNDEE", "count"=>10261} (), {"value"=>"NIAGARAN GRAY", "count"=>5208} (), {"value"=>"DETROIT RIVER", "count"=>2257} (), {"value"=>"MICHIGAN STRAY", "count"=>2135} (), {"value"=>"TRAVERSE", "count"=>2040} (), {"value"=>"NIAGARAN", "count"=>1846} (), {"value"=>"TRAVERSE FORMATION", "count"=>1737} (), {"value"=>"ANTRIM", "count"=>1612} (), {"value"=>"NIAGARAN BROWN", "count"=>1591} ()
  • prod_fm_cd
    Text
    {"value"=>"O", "count"=>16332} (), {"value"=>"G", "count"=>14164} (), {"value"=>"GS", "count"=>4290} (), {"value"=>"GC", "count"=>41} (), {"value"=>"UNK", "count"=>38} (), {"value"=>"OG", "count"=>2} ()
  • prod_fm
    Text
    {"value"=>"ANTRIM(G)", "count"=>11341} (), {"value"=>"DUNDEE(O)", "count"=>5209} (), {"value"=>"TRAVERSE GROUP(O)", "count"=>4425} (), {"value"=>"MICHIGAN STRAY(GS)", "count"=>2851} (), {"value"=>"NIAGARAN(O)", "count"=>2319} (), {"value"=>"RICHFIELD(O)", "count"=>1243} (), {"value"=>"TRENTON(O)", "count"=>1236} (), {"value"=>"NIAGARAN(GS)", "count"=>870} (), {"value"=>"NIAGARAN(G)", "count"=>773} (), {"value"=>"DETROIT RIVER(O)", "count"=>709} ()
  • 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"=>"SIX LAKES PROJECT", "count"=>440} (), {"value"=>"CRANBERRY LAKE PROJECT", "count"=>173} (), {"value"=>"STATE", "count"=>128} (), {"value"=>"STATE CHESTER VENTURE 29-2 (S10-118)", "count"=>71} (), {"value"=>"ASE #6 UNIT", "count"=>44} (), {"value"=>"MID-CHARLTON UNIT II", "count"=>35} (), {"value"=>"BRILEY 29 UNIT", "count"=>31} (), {"value"=>"Central Lake 28", "count"=>30} (), {"value"=>"NORTH STARMIRA (NADV) #4 UNIT", "count"=>29} (), {"value"=>"Echo 26 Antrim", "count"=>29} ()

Related Datasets