WVGES

Oil-Gas Table Descriptions


Dividing Line

Owner/Completion
(for permitted and cancelled wells, only OWNERS data are available; for completed wells, both OWNERS and COMPLETIONS data are available; 1 record per episode of drilling)

Field Name Description Column Type
API API Number NUMBER
Suffix Episode Of Drilling VARCHAR2(14)
Cmp_Dt Completion Date (date episode was completed) DATE(mm/dd/yyyy)
Status Status Of The Permit To Drill The Well CHAR(9)
Surface_Owner Surface Owner VARCHAR2(40)
Well_Num Well Number On The Farm VARCHAR2(6)
Co_Num Company Number (Operator's Number For The Well) VARCHAR2(30)
Lease Lease Name VARCHAR2(30)
Lease_Num Lease Number VARCHAR2(15)
Mineral_Own Mineral Owner (Name Of The Owner Of The Oil And Gas Rights) VARCHAR2(30)
Operator_at_Completion Operator Name at Time of Well Completion VARCHAR2(55)
PVD Proposed Vertical Depth (feet) NUMBER(5)
Prop_Trgt_Fm Proposed Target Formation VARCHAR2(20)
TFm_Est_Pr Target Formation Estimated Pressure NUMBER(5)
Spud_Dt Spud Date (Date Drilling Began) DATE(mm/dd/yyyy)
Elev Elevation, Feet (Surface Of The Well) NUMBER(4)
Datum Elevation Datum VARCHAR2(15)
Field Field Name VARCHAR2(15)
Deepest_Fm Formation At Total Depth VARCHAR2(20)
Deepest_FmT Deepest Formation Tested VARCHAR2(20)
Initial_Class Initial Well Classification (AAPG Well Classification) VARCHAR2(24)
Final_Class Final Well Classification (AAPG Well Classification) VARCHAR2(24)
Type Well Type VARCHAR2(15)
Rig Rig Type VARCHAR2(10)
Cmp_Mthd Completion Method VARCHAR2(10)
TVD Total Vertical Depth, Feet (From The Surface Datum To The Bottom Of The Well) NUMBER(5)
TMD Total Measured Depth, Feet (From The Surface Datum To The Bottom Of The Well) NUMBER(5)
New_Ftg New Footage, Feet (Footage Drilled During This Episode) NUMBER(5)
KOD Kick Off Depth, Feet NUMBER(5)
Volumes
G_Bef    Gas Before Treatment or Natural Open Flow, Thousand Cubic Feet (MCF) / Day NUMBER(6)
G_Aft    Gas After Treatment, Thousand Cubic Feet (MCF) / Day NUMBER(6)
O_Bef    Oil Before Treatment or Natural Open Flow, Barrels / Day (1 Barrel = 42 gallons) NUMBER(4)
O_Aft    Oil After Treatment, Barrels / Day (1 Barrel = 42 gallons) NUMBER(4)
NGL_Bef    NGL Before Treatment or Natural Open Flow, Barrels / Day (1 Barrel = 42 gallons) NUMBER(6)
NGL_Aft    NGL After Treatment, Barrels / Day (1 Barrel = 42 gallons) NUMBER(6)
Rock Pressure
P_Bef    Surface Hole Rock Pressure Before Treatment / Stimulation or Natural Rock Pressure, Pounds Per Square Inch NUMBER(4)
Ti_Bef    Shut-In Time Before Treatment / Stimulation, Hours NUMBER(4)
P_Aft    Surface Hole Rock Pressure After Treatment / Stimulation or Treated Rock Pressure, Pounds Per Square Inch NUMBER(4)
Ti_Aft    Shut-In Time After Treatment / Stimulation, Hours NUMBER(4)
BH_P_Bef    Bottom Hole Rock Pressure Before Treatment / Stimulation or Natural Rock Pressure, Pounds Per Square Inch NUMBER(4)
BH_P_Aft    Bottom Hole Rock Pressure After Treatment / Stimulation or Treated Rock Pressure, Pounds Per Square Inch NUMBER(4)
G_Msrd_By    Gas Measured By (Estimated, Orifice, or Pitot) VARCHAR2(9)
Comment Comment VARCHAR2(100)

Dividing Line

WVGES Main   "Pipeline"   Table Descriptions  


Page Last Revised:   Monday, May 21, 2018 10:09:45 AM

Please send questions, comments, and/or suggestions to webmaster.

Page created and maintained by:
            West Virginia Geological and Economic Survey
  Address:  Mont Chateau Research Center
            1 Mont Chateau Road
            Morgantown, WV  26508-8079
Telephone:  1-800-WV-GEOLOgy (1-800-984-3656) or 304-594-2331
      FAX:  304-594-2575
    Hours:  8:00 a.m. - 5:00 p.m. EST, Monday - Friday

Permission to reproduce this material is granted if acknowledgment is given to the West Virginia Geological and Economic Survey.

Valid XHTML 1.0!