Well Surface Hole Event

452 views (13 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 event view provides general well information and location information for the surface hole

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Display general information and location for 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_EVENT_SP

Short Name: SUR_HOL_EV
Comments: SURFACE HOLE EVENT SP provides non-confidential information about the surface location of a well. It provides general well information and location information for the surface hole.

Column Name Short Name Data Type Data Precision Comments
SURFACE_HOLE_EVENT_ID SH_EVNT_ID NUMBER 10 SURFACE 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.
SURFACE_RIGHTS_OWNER SURF_OWNER VARCHAR2 100 SURFACE RIGHTS OWNER is the owner of the surface rights.
GROUND_ELEVATION GROUNDELEV NUMBER 8 GROUND ELEVATION is the Elevation above mean sea level.
DIRECTIONAL_FLAG DIRCTLN_FL VARCHAR2 1 DIRECTIONAL FLAG is the directional flag. Y = directional, N = Not directional
CASING_CUT_OFF_FLAG CSNGCUTOFF VARCHAR2 1 CASING CUT OFF FLAG indicates whether the casing has been cut off in order to do the surface abandonment.
TENURE_HOLDER_REQMNT_MET TENURE_REQ VARCHAR2 1 TENURE HOLDER REQMNT MET is the tenure indicator. "Y" indicates the operator has sub-surface rights.
CASING_REQMNT_MET_FLAG CASING_REQ VARCHAR2 1 CASING REQMNT MET FLAG is the minimum surface casing depth requirement met indicator.
SPECIAL_WELL_CLASS_CODE SPCLWLLCLS VARCHAR2 4 SPECIAL WELL CLASS CODE is a code indicating whether the well is a special sour well. Options are REP (Reduced ERP), SITE (Site Specific), SPC (Special), or NO.
BLOW_OUT_PREVNT_CLASS_MET_FLAG BOP_FLAG VARCHAR2 1 BLOW OUT PREVNT CLASS MET FLAG indicates whether blow-out prevention classifications are met.
CERT_OF_RESTORATION_FLAG COR_FLAG VARCHAR2 1 CERT OF RESTORATION FLAG is the certificate of restoration indicator. "Y " indicates that surface restoration of the well site has been completed.
EMERG_REVW_PLAN_REVIEW_FLAG ERP_REVIEW VARCHAR2 1 EMERG REVW PLAN REVIEW FLAG indicates whether the Emergency Review Plan has been reviewed and accepted.
COAL_BED_METHANE_FLAG CBM_FLAG VARCHAR2 3 COAL BED METHANE FLAG is the coal-bed methane indicator. "Y" indicates that the gas objective is coal-bed methane.
TEST_HOLE_FLAG TH_FLAG VARCHAR2 1 TEST HOLE FLAG is the Test Hole indicator. "Y" indicates Test Hole. A test hole is drilled to obtain information about petroleum and natural gas resources without the production of those resources.
SURFACE_NORTH SURF_NORTH NUMBER 11 SURFACE NORTH is the distance north/south from the nearest corner spacing unit.
SURFACE_EAST SURF_EAST NUMBER 11 SURFACE EAST is the distance east/west from the nearest corner spacing unit.
SURFACE_REF_CORNER REF_CORNER VARCHAR2 2 SURFACE REF CORNER is the location in which the surface reference corner is located.
SURFACE_REF_LOCATION REF_LOCATN VARCHAR2 14 SURFACE REF LOCATION is the corner of the spacing unit from which the Surface North and Surface East distances are measured.
LWBC_FILE_NUMBER LWBC_FILE VARCHAR2 8 LWBC FILE NUMBER is the Land and Water British Columbia code. These codes were used prior to the creation of the Oil and Gas Commission.
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.