OGC Geophysical Ancillary Features (Public Version)
376 views (3 recent)Published by the BC Agency - Oil and Gas Commission
Licensed under Access Only
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
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.
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.
|Name||Krista Zens (pointOfContact)|
|Sub-Organization||Oil and Gas Commission|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-09-05|
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.|