Well Bottom Hole Event

530 views (16 recent)

Published by the BC Agency - Oil and Gas Commission
Licensed under Access Only

Provides non-confidential information about the sub-surface bottom hole location of a well. The event view provides drilling information and the location for each bottom hole

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

To provide drilling information and location of well bottom holes.

More Information

Contact Information

NameKrista Zens (pointOfContact)
EmailKrista.Zens@bcogc.ca
OrganizationBC Agency
Sub-OrganizationOil and Gas Commission

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.OG_BOTTOM_HOLE_EVENT_SP

Short Name: BOT_HOL_EV
Comments: BOTTOM HOLE EVENT SP provides non-confidential information about the sub-surface bottom hole location of a well. It provides drilling information and the location for each bottom hole.

Column Name Short Name Data Type Data Precision Comments
BOTTOM_HOLE_EVENT_ID BH_EVNT_ID NUMBER 10 BOTTOM HOLE EVENT ID is the primary unique numeric identifier for a feature.
WELL_AUTHORITY_NUMBER WA_NUM VARCHAR2 10 WELL AUTHORITY NUMBER is the BC well authority number.
DRILLING_EVENT_SEQUENCE DRILL_EVNT VARCHAR2 2 DRILLING EVENT SEQUENCE is the code indicating the chronological sequence of a significant drilling operation of a drill hole which yields a separate and unique set of geological or production data.
UNIQUE_WELL_IDENTIFIER UWI VARCHAR2 16 UNIQUE WELL IDENTIFIER is a unique well identifier which is the standard 16-character code which defines the bottom hole location and each significant drilling or completion event in the well.
LAHEE_TYPE LAHEE_TYPE VARCHAR2 4 LAHEE TYPE is a geological classification system for drilled wells. Options are DPT (Deeper Pool Test), DEV (Development), NFW (New Field Wildcat), NPW (New Pool Wildcat), N/A (Not Available), OUT (Outpost), SVC (Service Well) and SPT (Shallower Pool Test).
KELLY_BUSHING_ELEV KB_ELEV NUMBER 9 KELLY BUSHING ELEV is the top of kelly bushing to mean sea level.
CASING_FLANGE_ELEV CF_ELEV NUMBER 9 CASING FLANGE ELEV is the elevation above mean level of surface casing flange.
TOP_CUTTNG_DEPTH TOPCUTDEPT NUMBER 9 TOP CUTTNG DEPTH is the depth below the kelly bushing at which the recovery of rock cuttings commenced.
BASE_CUTTNG_DEPTH BASECUTDEP NUMBER 9 BASE CUTTNG DEPTH is the depth at which the recovery of rock cuttings ceased.
TOTAL_DRILLED_DEPTH TD_DEPTH NUMBER 9 TOTAL DRILLED DEPTH is the total drilled depth of the well.
TOTAL_DEPTH_EAST TD_EAST NUMBER 9 TOTAL DEPTH EAST is the distance east/west from nearest spacing area corner for well at total depth.
TOTAL_DEPTH_NORTH TD_NORTH NUMBER 9 TOTAL DEPTH NORTH is the distance north/south from nearest spacing area corner for well at total depth.
TOTAL_DEPTH_REF_CORNER TD_REF_COR VARCHAR2 2 TOTAL DEPTH REF CORNER is the corner of the unit, section or LSD used for locating the total depth of the well.
TOTAL_DEPTH_REF_CORNER_LOCATN TD_REF_LOC VARCHAR2 14 TOTAL DEPTH REF CORNER LOCATN is the location in which the reference corner is located.
CLASSFICATION_CODE CLASS_CODE VARCHAR2 4 CLASSFICATION CODE is the code used to determine release of information based on the distance from recognized pools. Codes are DV (Development), EO (Exploratory Outpost), EW (Exploratory Wildcat) and EX (Experimental). For more information on well classifications, see Section 6.1.2 of the British Columbia Oil and Gas Handbook.
RECLASSFICATION_DATE RCLASSDATE DATE 7 RECLASSFICATION DATE is the date that a well encounters a previously unknown pool and is reclassified to Exploratory Wildcat (EW) for extended confidentiality.
RECLASSFICATION_PENDING_FLAG RCLASSPEND VARCHAR2 1 RECLASSFICATION PENDING FLAG is a flag to indicate that an application to reclassify a well has been received and is being evaluated.
CONTRACTOR CONTRACTOR VARCHAR2 30 CONTRACTOR is the drilling rig operator.
SPUD_DATE SPUD_DATE DATE 7 SPUD DATE is the date that drilling is commenced.
RIG_RELEASE_DATE RIGRELSDAT DATE 7 RIG RELEASE DATE is the date that drilling is completed.
RENTRY_DATE RENTRYDAT DATE 7 RENTRY DATE is the date that a well is re-entered (goes back on production). This may only occur if the well was previously active, abandoned or suspended.
PLUG_BACK_DEPTH PB_DEPTH NUMBER 9 PLUG BACK DEPTH is the plug back depth. The depth to which the drill bore is open.
DIRECTIONAL_FLAG DIRCTLN_FL VARCHAR2 1 DIRECTIONAL FLAG is the directional flag. Y = directional, N = Not directional.
CONFIDENTIAL_FLAG CONF_FLAG VARCHAR2 1 CONFIDENTIAL FLAG is the confidential flag used to determine if record can be shown to the public.
RELEASE_FROM_CONFIDENTIAL_DATE CONF_RELS DATE 7 RELEASE FROM CONFIDENTIAL DATE is the date that the well is no longer confidential.
OIL_SPACING_AREA OIL_SPACNG VARCHAR2 100 OIL SPACING AREA is the area that an oil pool has been divided into. The normal spacing area for an oil well is a quarter section in the Township-Range survey system or one unit in the Petroleum and Natural Gas grid map numbering system.
GAS_SPACING_AREA GAS_SPACNG VARCHAR2 100 GAS SPACING AREA is the area that a gas pool has been divided into. The normal spacing area for a gas well is one section in the Township-Range survey system or four units in the Petroleum and Natural Gas Grid system.
COMMENTS COMMENTS VARCHAR2 4000 COMMENTS stores any additional drilling information.
IMS_CODE IMS_CODE VARCHAR2 12 IMS CODE is the internal IMS code.
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is an ArcSDE spatial column: coordinates defining the features.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase. This attribute is added to a SDE layer that was not previously created as part of a geodatabase but is now being registered with a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE ANNO CAD DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.