Well Bottom Hole Status

456 views (6 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 status view provides information on the current status of the bottom hole

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To display information on well bottom hole status.

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_STATUS_SP

Short Name: BOT_HOL_ST
Comments: BOTTOM HOLE STATUS SP provides non-confidential information about the sub-surface bottom hole location of a well. It provides information on the current status of the bottom hole.

Column Name Short Name Data Type Data Precision Comments
BOTTOM_HOLE_STATUS_ID BH_STAT_ID NUMBER 10 BOTTOM HOLE STATUS 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 a 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.
WELL_ACTIVITY ACTIVITY VARCHAR2 4 WELL ACTIVITY is the current well status.
BORE_FLUID_TYPE FLUID_TYPE VARCHAR2 4 BORE FLUID TYPE is the well bore fluid which defines well status.
OPERATION_TYPE OPS_TYPE VARCHAR2 4 OPERATION TYPE is the operation type. Indicates if the well is producing.
WELL_BOTTOM_LOCATION BOTTOM_LOC VARCHAR2 16 WELL BOTTOM LOCATION is either the NTS or DLS bottom location of the well.
WELL_SURFACE_LOC SURF_LOC VARCHAR2 17 WELL SURFACE LOC is either the NTS or DLS surface location of the well.
STATUS_EFFECTIVE_DATE STATUS_EFF DATE 7 STATUS EFFECTIVE DATE is the status effective date.
STATUS_TERMINATION_DATE STAT_TERM DATE 7 STATUS TERMINATION DATE is status termination date.
CONFIDENTIAL_FLAG CONF_FLAG VARCHAR2 1 CONFIDENTIAL FLAG is 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.
OPERATOR_ABBREVIATION OPER_ABBRE VARCHAR2 16 OPERATOR ABBREVIATION is the standard abbreviation of a company in the well name.
OPERATOR_ABBREVIATION2 OPER_ABBR2 VARCHAR2 18 OPERATOR ABBREVIATION2 is the second well operator abbreviation in the well name.
WELL_AREA_NAME AREA_NAME VARCHAR2 20 WELL AREA NAME is the field or area name the well falls within.
OPTIONAL_WELL_NAME OPTNL_NAME VARCHAR2 5 OPTIONAL WELL NAME is an optional well name descriptor.
WELL_NAME_EFFECTIVE_DATE NAME_EFF DATE 7 WELL NAME EFFECTIVE DATE is the Date the well name becomes effective.
WELL_NAME WELL_NAME VARCHAR2 80 WELL NAME identifies the well operator, the field or area name and the surface location of the well.
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.