Oil and Gas Commission Short Term Water Use Applications

117 views (6 recent)

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

Point locations indicating proposed applications for short term water use for oil and gas development. This dataset contains spatial data for proposed applications collected through the BC Oil and Gas Commission's Application Management System (AMS).

Data and Resources

Dataset Extent

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

Additional Information

Lineage Statement

Spatial data collected through the BC Oil and Gas Commission's Application Management System (AMS).

Contact Information

NameKrista Zens (custodian)
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 2016-12-19
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.OG_WATER_SOURCE_APPL_SP

Short Name: OG_WTR_S_A
Comments: Point locations indicating proposed applications for short term water use for oil and gas development. This dataset contains spatial data for proposed applications collected through the BC Oil and Gas Commission's Application Management System (AMS).

Column Name Short Name Data Type Data Precision Comments
OG_WATER_SOURCE_APPL_ID WTR_S_A_ID NUMBER 10 OG_WATER_SOURCE_APPL_ID is a system generated unique identifier number.
SHORT_TERM_WATER_USE_NUM STWU_NUM VARCHAR2 14 SHORT_TERM_WATER_USE_NUM is a business identifier for all short term use of water locations within an activity e.g., 0004119.
POD_NUMBER POD_NUM VARCHAR2 40 POD_NUMBER is a system generated identification number assigned to each point of diversion location, e.g., 9.
WATER_SOURCE_TYPE WS_TYPE VARCHAR2 8 WATER_SOURCE_TYPE is a code indicating the type of water source, e.g., LKPD (Lake/Pond).
WATER_SOURCE_TYPE_DESC WS_DESC VARCHAR2 60 WATER_SOURCE_TYPE_DESC is a description of the type of water source, e.g., Lake/Pond (LKPD).
WATER_SOURCE_NAME WS_NAME VARCHAR2 40 WATER_SOURCE_NAME is the name or a clear description of the water supply source, e.g., Halfway River.
PURPOSE PURPOSE VARCHAR2 8 PURPOSE is a code describing the primary purpose for which the withdrawn water will be used, e.g., ROAD.
PURPOSE_DESC PURP_DESC VARCHAR2 200 PURPOSE_DESC is a description of the primary purpose for which the withdrawn water will be used, e.g., Road Maintenance.
PROPOSED_VOLUME_PER_DAY VOL_DAY_M3 NUMBER 38 PROPOSED_VOLUME_PER_DAY is the proposed volume of water withdrawal each day measured in cubic metres.
PROPOSED_TOTAL_VOLUME VOL_TTL_M3 NUMBER 10 PROPOSED_TOTAL_VOLUME is the proposed total voume of water withdrawal measured in cubic metres.
APPLICATION_NUMBER APPL_NUM NUMBER 10 APPLICATION_NUMBER is a unique application number that is generated automatically for each application submitted in the Commission's Application Management System, e.g., 100100067.
APPLICATION_TYPE APPL_TYPE VARCHAR2 80 APPLICATION_TYPE is the type of application submitted by the applicant to the Commission's Automated Management System, e.g., New OGAA.
APPLICATION_STATUS APPL_STAT VARCHAR2 80 APPLICATION_STATUS is the status of the application prior to Approval, e.g., In Review.
APPLICATION_SUBMITTED_DATE APPL_DATE DATE 7 APPLICATION_SUBMITTED_DATE is the date the application is submitted to the Commission by the applicant.
REVISION_NUMBER REV_NUM NUMBER 5 REVISION_NUMBER is the number of times the application has been altered prior to approval.
APPLICATION_DETERMINATION_NUM AD_NUM VARCHAR2 18 APPLICATION_DETERMINATION_NUM is a number assigned to an approved or permitted activity or to a set of activities included in a multi-activity application, e.g., 100082189.
PROPONENT PROPONENT VARCHAR2 120 PROPONENT is the organization name of the oil and gas operator, e.g., ARC Resources Ltd.
AUTHORITY_TYPE AUTH_TYPE VARCHAR2 8 AUTHORITY_TYPE is the type of authorization issued by the Commission. Authorizations are issued either under the Oil and Gas Activities Act (OGAA) or the National Energy Board (NEB), e.g., OGAA.
LAND_TYPE LAND_TYPE VARCHAR2 8 LAND_TYPE is a value indicating whether the oil and gas application is on Private or Crown land, i.e., PRIV, CRWN.
DATA_SOURCE DATA_SRC VARCHAR2 10 DATA_SOURCE is the data capture method used to collect the spatial application data submitted to the Commission, i.e., GPSD (GPS-Differential), GPSND (GPS-Non Differential), ORTHO (Ortho Photography), CGWC (Coordinate Geometry With Control), SNK (Source Not Known).
SHAPE SHAPE SDO_GEOMETRY 1 SHAPE 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.