Well Surface Hole Status

802 views (16 recent)

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

Provides non-confidential information about the surface location of a well. The status view provides information on the current status of the surface hole

Data and Resources

Dataset Extent

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

Additional Information

Purpose

To provide information on the status of surface 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_SURFACE_HOLE_STATUS_SP

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

Column Name Short Name Data Type Data Precision Comments
SURFACE_HOLE_STATUS_ID SH_STAT_ID NUMBER 10 SURFACE 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.
OPERATOR_ABBREVIATION OPER_ABRRE 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_SURFACE_LOCATION LOCATION VARCHAR2 20 WELL SURFACE LOCATION is either the NTS or DLS surface location of 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. It indicates if the well is producing.
STATUS_EFFECTIVE_DATE STATUS_EFF DATE 7 STATUS EFFECTIVE DATE is the Status effective date.
WELL_AUTHORIZATION_GRANT_DATE WAG_DATE DATE 7 WELL AUTHORIZATION GRANT DATE is the Date of well authorization.
CONFIDENTIAL_FLAG CONF_FLAG VARCHAR2 1 CONFIDENTIAL FLAG is a confidential flag used to determine if record can be shown to the public.
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 the 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.
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.