OGC Geophysical Ancillary Features (Public Version)

376 views (3 recent)

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

Ancillary features include camp sites, decking sites, drill sites, helipads or staging areas. This dataset contains spatial data collected through the Oil and Gas Commission's electronic Petroleum Application Submission System (ePASS) between October 30, 2006 and July 11, 2016. Ancillary features for final plan geophysical applications with a status of approved are included.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

Geophysical programs study the physical characteristics and properties of subsurface formations relating to oil and gas deposits, derived artificially by explosives or other means to map subsurface structure. Ancillary features include camp sites, decking sites, drill sites, helipads or staging areas.

Data Quality

This is a static dataset containing point locations for geophysical ancillary features collected between October 30, 2006 and July 11, 2016. New geophysical ancillary features are collected as polygons through the BC Oil and Gas Commission's Application Management System (AMS). Spatial data for geophysical ancillary permits collected since July 11, 2016 are available in WHSE_MINERAL_TENURE.OG_ASSOC_ANCILLARY_PERMIT_SP.

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 completed

Object Description

Object Name: WHSE_MINERAL_TENURE.OG_GEOPHSCL_ANCLRY_LOCN_PUB_SP

Short Name: OG_GANC_LC
Comments: Geophysical programs study the physical characteristics and properties of subsurface formations relating to oil and gas deposits, derived artificially by explosives or other means to map subsurface structure. Spatial data is collected through the Oil and Gas Commission's electronic Petroleum Application Submission System (ePASS). ePass submissions for geophysical applications became mandatory October 30, 2006 and so this dataset contains spatial data for applications submitted on or after this date. All ancillary features for final plan geophysical applications with a status of approved are included.

Column Name Short Name Data Type Data Precision Comments
OG_GEOPHSCL_ANCLRY_LOCN_PUB_ID GGPHSCLNCL NUMBER 10 OG GEOPHSCL ANCLRY LOCN PUB ID is a system generated identifier to ensure row uniqueness.
EPASS_TRACKING_NUMBER PSSTRCKNGN NUMBER 8 EPASS TRACKING NUMBER is the tracking number assigned to the spatial data submitted through the electronic Petroleum Application Spatial Submission System (ePASS). E.g., 10025499
OGC_FILE_NUMBER GCFLNMBR VARCHAR2 8 OGC FILE NUMBER is the file number assigned to each application for tracking purposes within the Oil and Gas Commission. E.g., 9632012
GEOPHYSICAL_PROGRAM_NUMBER GPHSCLPRGR VARCHAR2 8 GEOPHYSICAL PROGRAM NUMBER is the number provided by the Oil and Gas Commission and assigned to the geophysical program. The number is included on the application permit and all operations and final plan documentation. E.g., 2001-105
APPLICATION_RECEIVED_DATE PPLCTNRCVD DATE 7 APPLICATION RECEIVED DATE is the date the application is received and recorded into the Commission database.
APPLICATION_TYPE PPLCTNTP VARCHAR2 4 APPLICATION TYPE is the type of application submitted to the Oil and Gas Commission. E.g., GN (Geophysical - New)
ACTIVITY_TYPE CTVTTP VARCHAR2 4 ACTIVITY TYPE indicates whether the spatial data is an original submission, a revision or a final plan for a particular application type. This is the terminology used within the Commission. E.g., ORIG, REV or FPLN
APPLICATION_STATUS PPLCTNSTTS VARCHAR2 10 APPLICATION STATUS indicates the status of the geophysical application during the approval process. E.g., Approved
APPLICATION_APPROVAL_DATE PPLCTNPPRV DATE 7 APPLICATION APPROVAL DATE is the date the application is approved.
GEOPHYSICAL_ANCILLARY_TYPE GPHSCLNCLL VARCHAR2 5 GEOPHYSICAL ANCILLARY TYPE: Indicates the type of ancillary feature. E.g., CAMP (Camp Site)
LAND_TYPE LAND_TYPE VARCHAR2 1 LAND TYPE indicates whether the oil and gas application is on Private or Crown land (P or C).
PROPONENT PROPONENT VARCHAR2 60 PROPONENT is the organization name of the oil and gas operator.
ACCURACY_PERCENTILE CCRCPRCNTL NUMBER 2 ACCURACY PERCENTILE is the data accuracy percentile. Quantifies the percentage of features which are statistically expected to fall within the horizontal accuracy bounds. E.g., 95
ACCURACY_HORIZONTAL CCRCHRZNTL NUMBER 3 ACCURACY HORIZONTAL is the horizontal accuracy bound in meters. E.g., 15
ACCURACY_VERTICAL CCRCVRTCL NUMBER 3 ACCURACY VERTICAL is the vertical accuracy bound in meters. E.g., 10
FEATURE_CODE FTRCD VARCHAR2 10 FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping's (CCSM) system for classification of geographic features. E.g., AR82000110
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in 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.