Description

more
S Directional Line - A line connecting the surface location (wellhead) to the bottom hole location of a directionally drilled oil & gas test well. The actual path from the surface location to the bottom hole location is not displayed. D Directional Line - A line connecting the surface location (wellhead) to the bottom hole location of a directionally drilled oil & gas test well. A The actual path from the surface location to the bottom hole location is not displayed. A directional line is only created for directionally drilled oil & gas test wells. They are not created for straight wells (vertically) wells since the surface and bottom hole locations are the same for these wells. These are extracted from the Michigan DEQ Oil, Gas & Minerals RBDMS database on a nightly basis.More Metadata

Dataset Attributes

  • OBJECTID
    Number
  • Shape
    Number
  • Shape.STLength()
    Number
  • api_wellno
    Text
    {"value"=>"21133090600000", "count"=>4} (), {"value"=>"21163255850000", "count"=>2} (), {"value"=>"21137418670300", "count"=>2} (), {"value"=>"21137380640200", "count"=>2} (), {"value"=>"21137351490200", "count"=>2} (), {"value"=>"21133088810000", "count"=>2} (), {"value"=>"21133088520000", "count"=>2} (), {"value"=>"21127609930000", "count"=>2} (), {"value"=>"21123442170100", "count"=>2} (), {"value"=>"21119541790100", "count"=>2} ()
  • permit_no
    Text
    {"value"=>"58070", "count"=>11} (), {"value"=>"58068", "count"=>11} (), {"value"=>"58069", "count"=>9} (), {"value"=>"9060", "count"=>6} (), {"value"=>"58272", "count"=>5} (), {"value"=>"58029", "count"=>5} (), {"value"=>"57451", "count"=>5} (), {"value"=>"57450", "count"=>5} (), {"value"=>"54179", "count"=>5} (), {"value"=>"41908", "count"=>5} ()
  • cnty_fips
    Number
    1 to 165
  • lease_name
    Text
    {"value"=>"STATE CHARLTON", "count"=>90} (), {"value"=>"STATE MAPLE FOREST", "count"=>87} (), {"value"=>"STATE KALKASKA", "count"=>78} (), {"value"=>"STATE ALBERT", "count"=>63} (), {"value"=>"STATE ALLIS", "count"=>56} (), {"value"=>"ANR STORAGE CO", "count"=>56} (), {"value"=>"SIX LAKES", "count"=>55} (), {"value"=>"STATE SPRINGDALE", "count"=>45} (), {"value"=>"STATE COLFAX", "count"=>45} (), {"value"=>"STATE CHESTER", "count"=>42} ()
  • well_no
    Text
    {"value"=>"1", "count"=>71} (), {"value"=>"1-27", "count"=>56} (), {"value"=>"1-2", "count"=>55} (), {"value"=>"1-17", "count"=>49} (), {"value"=>"1-8", "count"=>47} (), {"value"=>"1-14", "count"=>47} (), {"value"=>"1-35", "count"=>45} (), {"value"=>"1-18", "count"=>44} (), {"value"=>"1-6", "count"=>44} (), {"value"=>"1-7", "count"=>43} ()
  • op_no
    Number
    10 to 7565
  • co_name
    Text
    {"value"=>"SWEPI LP", "count"=>624} (), {"value"=>"MERIT ENERGY CO", "count"=>449} (), {"value"=>"SAVOY ENERGY LP", "count"=>300} (), {"value"=>"WEST BAY EXPLORATION COMPANY", "count"=>267} (), {"value"=>"RIVERSIDE ENERGY MICHIGAN LLC", "count"=>219} (), {"value"=>"LINN OPERATING LLC", "count"=>212} (), {"value"=>"BREITBURN OPERATING LIMITED PARTNERSHIP", "count"=>198} (), {"value"=>"JORDAN DEVELOPMENT COMPANY LLC", "count"=>168} (), {"value"=>"MUSKEGON DEVELOPMENT CO", "count"=>158} (), {"value"=>"B P AMERICA PRODUCTION CO", "count"=>142} ()
  • surf_owner
    Text
    {"value"=>"FEE", "count"=>1026} (), {"value"=>"STATE OF MICHIGAN", "count"=>851} (), {"value"=>"ANDERSON, STEPHEN & MARY/WILLIAMS, GARY & KATHLEEN", "count"=>34} (), {"value"=>"LAKE HORICON CORPORATION", "count"=>20} (), {"value"=>"MUSKEGON DEVELOPMENT COMPANY", "count"=>20} (), {"value"=>"CONSUMERS ENERGY", "count"=>19} (), {"value"=>"MICHIGAN CONSOLIDATED GAS COMPANY", "count"=>16} (), {"value"=>"ANR PIPELINE COMPANY", "count"=>15} (), {"value"=>"DRETTMANN, BRIAN", "count"=>13} (), {"value"=>"HURON-CLINTON METROPOLITAN AUTHORITY", "count"=>12} ()
  • state_land
    Number
    -1 to 0
  • fed_land
    Number
    -1 to 0
  • well_type
    Text
    {"value"=>"DH", "count"=>2600} (), {"value"=>"GAS", "count"=>1476} (), {"value"=>"OIL", "count"=>1440} (), {"value"=>"LOC", "count"=>1172} (), {"value"=>"GS", "count"=>341} (), {"value"=>"TH", "count"=>263} (), {"value"=>"BDW", "count"=>64} (), {"value"=>"WIW", "count"=>56} (), {"value"=>"GC", "count"=>54} (), {"value"=>"GSO", "count"=>39} ()
  • Slant
    Text
    {"value"=>"D", "count"=>5575} (), {"value"=>"H", "count"=>1580} (), {"value"=>"V", "count"=>401} ()
  • BH_CNTY
    Number
    1 to 165
  • CNTY_NAME
    Text
    {"value"=>"OTSEGO", "count"=>1009} (), {"value"=>"GRAND TRAVERSE", "count"=>796} (), {"value"=>"MANISTEE", "count"=>771} (), {"value"=>"KALKASKA", "count"=>647} (), {"value"=>"MONTMORENCY", "count"=>418} (), {"value"=>"ANTRIM", "count"=>339} (), {"value"=>"PRESQUE ISLE", "count"=>288} (), {"value"=>"CALHOUN", "count"=>276} (), {"value"=>"IRON", "count"=>263} (), {"value"=>"CRAWFORD", "count"=>231} ()
  • twp_name
    Text
    {"value"=>"CHESTER", "count"=>272} (), {"value"=>"CHARLTON", "count"=>262} (), {"value"=>"KALKASKA", "count"=>191} (), {"value"=>"MAYFIELD", "count"=>181} (), {"value"=>"MANISTEE", "count"=>162} (), {"value"=>"BEAR LAKE", "count"=>148} (), {"value"=>"CRYSTAL FALLS", "count"=>146} (), {"value"=>"GRANT", "count"=>145} (), {"value"=>"HAYES", "count"=>144} (), {"value"=>"BLUE LAKE", "count"=>137} ()
  • qqqs
    Text
    {"value"=>"SE", "count"=>1908} (), {"value"=>"NW", "count"=>1877} (), {"value"=>"SW", "count"=>1819} (), {"value"=>"NE", "count"=>1790} (), {"value"=>"CN", "count"=>46} (), {"value"=>"S2", "count"=>26} (), {"value"=>"N2", "count"=>25} (), {"value"=>"C", "count"=>17} (), {"value"=>"E2", "count"=>12} (), {"value"=>"W2", "count"=>11} ()
  • qqs
    Text
    {"value"=>"SE", "count"=>1942} (), {"value"=>"NW", "count"=>1897} (), {"value"=>"NE", "count"=>1864} (), {"value"=>"SW", "count"=>1826} (), {"value"=>"E2", "count"=>9} (), {"value"=>"CN", "count"=>7} (), {"value"=>"S2", "count"=>6} (), {"value"=>"N2", "count"=>3} (), {"value"=>"W2", "count"=>3} (), {"value"=>"C", "count"=>1} ()
  • qs
    Text
    {"value"=>"SE", "count"=>2016} (), {"value"=>"NW", "count"=>1853} (), {"value"=>"NE", "count"=>1846} (), {"value"=>"SW", "count"=>1844} ()
  • wh_lat
    Number
    41.7508322 to 46.2570353
  • wh_long
    Number
    -88.6662915 to -82.5173
  • bh_lat
    Number
    41.7499442 to 46.1306592
  • bh_long
    Number
    -88.6662937 to -82.51511
  • wh_mgr_x
    Number
    293813.42 to 785225.22
  • wh_mgr_y
    Number
    135055.21 to 636350.48
  • bh_mgr_x
    Number
    293816 to 785412.88
  • bh_mgr_y
    Number
    134854.84 to 623274.99
  • sidetrck
    Number
    0 to 71
  • completion
    Number
    0 to 91
  • bore_type
    Text
    {"value"=>"Oil and Gas Test", "count"=>7287} (), {"value"=>"Mineral (Non-Confidential)", "count"=>273} (), {"value"=>"Unknown", "count"=>2} ()
  • dtd
    Number
    22 to 19972
  • tvd
    Number
    0 to 12373
  • kotvd
    Number
    0 to 8462
  • ref_tops
    Text
    {"value"=>"K", "count"=>6180} (), {"value"=>"G", "count"=>239} (), {"value"=>"D", "count"=>40} (), {"value"=>"C", "count"=>8} ()
  • elev_ref
    Number
    589 to 1509
  • fieldname
    Text
    {"value"=>"Otsego County - Antrim", "count"=>331} (), {"value"=>"Antrim County - Antrim", "count"=>225} (), {"value"=>"Montmorency County - Antrim", "count"=>224} (), {"value"=>"Oscoda County - Antrim", "count"=>59} (), {"value"=>"Napoleon", "count"=>55} (), {"value"=>"Six Lakes Gas Storage Field", "count"=>55} (), {"value"=>"Adrian", "count"=>48} (), {"value"=>"Riverside Gas Storage Field", "count"=>46} (), {"value"=>"Crawford County - Antrim", "count"=>43} (), {"value"=>"Manistee County - Antrim", "count"=>37} ()
  • fieldtype
    Text
    {"value"=>"G", "count"=>1549} (), {"value"=>"O", "count"=>1549} (), {"value"=>"GS", "count"=>378} (), {"value"=>"GC", "count"=>21} ()
  • PRUNumber
    Text
  • TRS
    Text
    {"value"=>"26N-10W-", "count"=>204} (), {"value"=>"25N-11W-", "count"=>181} (), {"value"=>"23N-15W-", "count"=>147} (), {"value"=>"25N-12W-", "count"=>128} (), {"value"=>"22N-16W-", "count"=>126} (), {"value"=>"43N-32W-", "count"=>106} (), {"value"=>"24N-14W-", "count"=>96} (), {"value"=>"24N-13W-", "count"=>89} (), {"value"=>"23N-14W-", "count"=>85} (), {"value"=>"25N-13W-", "count"=>82} ()
  • PRUName
    Text
  • PermDate
    Date
  • PlugDate
    Date
  • concen_h2s
    Number
    0 to 103400
  • deep_fm_cd
    Text
    {"value"=>"NGRN2", "count"=>1978} (), {"value"=>"TRVR4", "count"=>875} (), {"value"=>"NGRN1", "count"=>592} (), {"value"=>"NGRN", "count"=>472} (), {"value"=>"PRDC", "count"=>333} (), {"value"=>" ", "count"=>263} (), {"value"=>"GCDF", "count"=>175} (), {"value"=>"ANRM", "count"=>163} (), {"value"=>"DUND", "count"=>156} (), {"value"=>"BKRV", "count"=>134} ()
  • deep_fm
    Text
    {"value"=>"NIAGARAN GRAY", "count"=>1978} (), {"value"=>"TRAVERSE LIMESTONE", "count"=>875} (), {"value"=>"NIAGARAN BROWN", "count"=>592} (), {"value"=>"NIAGARAN", "count"=>472} (), {"value"=>"PRAIRIE DU CHIEN", "count"=>333} (), {"value"=>"GLACIAL DRIFT", "count"=>175} (), {"value"=>"ANTRIM", "count"=>163} (), {"value"=>"DUNDEE", "count"=>156} (), {"value"=>"BLACK RIVER", "count"=>134} (), {"value"=>"CLINTON", "count"=>119} ()
  • prod_fm_cd
    Text
    {"value"=>"G", "count"=>1549} (), {"value"=>"O", "count"=>1549} (), {"value"=>"GS", "count"=>378} (), {"value"=>"GC", "count"=>21} ()
  • prod_fm
    Text
    {"value"=>"ANTRIM(G)", "count"=>1108} (), {"value"=>"NIAGARAN(O)", "count"=>959} (), {"value"=>"NIAGARAN(G)", "count"=>256} (), {"value"=>"NIAGARAN(GS)", "count"=>208} (), {"value"=>"TRENTON(O)", "count"=>206} (), {"value"=>"MICHIGAN STRAY(GS)", "count"=>147} (), {"value"=>"DUNDEE(O)", "count"=>103} (), {"value"=>"PRAIRIE DU CHIEN(G)", "count"=>89} (), {"value"=>"NIAGARAN BROWN(O)", "count"=>80} (), {"value"=>"TRENTON-BLACK RIVER(O)", "count"=>60} ()
  • well_stat
    Text
    {"value"=>"Plugging Approved", "count"=>3555} (), {"value"=>"Producing", "count"=>1724} (), {"value"=>"Terminated Permit", "count"=>1094} (), {"value"=>"Active", "count"=>444} (), {"value"=>"Unknown", "count"=>263} (), {"value"=>"Temporarily Abandoned", "count"=>145} (), {"value"=>"Plugging Completed", "count"=>113} (), {"value"=>"Shut_In", "count"=>103} (), {"value"=>"Permitted Well", "count"=>71} (), {"value"=>"Well Completed", "count"=>24} ()

About

Related Datasets