Oil and Gas Commission Changes In and About a Stream Permits

159 views (3 recent)

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

Point locations for approved activities for changes in and around a stream. Common changes in and about a stream activities include the construction, maintenance and removal of watercourse crossings and crossing structures. Other types of works that comprise changes in and about a stream include stream diversion, stream bank erosion protection and/or stabilization, debris removal, beaver dam management, etc. This dataset contains spatial data collected on or after October 30, 2006.

Data and Resources

Dataset Extent

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

Additional Information

Lineage Statement

Permitted data approved between October 30, 2006 and July 11, 2016 collected through the Commission's electronic Petroleum Application Submission System (ePass). Spatial data for applications received by the Commission after July 11, 2016 collected through the 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-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.OG_STREAM_IMPACT_PERMIT_SP

Short Name: OG_STR_I_P
Comments: Point locations for approved activities for changes in and around a stream. Common changes in and about a stream activities include the construction, maintenance and removal of watercourse crossings and crossing structures. Other types of works that comprise changes in and about a stream include stream diversion, stream bank erosion protection and/or stabilization, debris removal, beaver dam management, etc. This dataset contains spatial data collected on or after October 30, 2006.

Column Name Short Name Data Type Data Precision Comments
OG_STREAM_IMPACT_PERMIT_ID STR_I_P_ID NUMBER 10 OG_STREAM_IMPACT_PERMIT_ID is a system generated unique identifier number.
CHANGE_INABOUT_NUMBER CIAS_NUM VARCHAR2 14 CHANGE_INABOUT_NUMBER is a business identifier for all changes in and about a stream within an activity, e.g., 0003293.
LOCATION_ID LOC_ID NUMBER 10 LOCATION_ID is a system generated identification number assigned to each stream impact point location, e.g., 2.
LOCATION_TYPE LOC_TYPE VARCHAR2 8 LOCATION_TYPE is a code indicating the watercourse crossing type, e.g., CBRD (Clearspan Bridge).
LOCATION_TYPE_DESC LOC_DESC VARCHAR2 80 LOCATION_TYPE_DESC is a description indicating the watercourse crossing type, e.g., Clearspan Bridge (CBRD).
STREAM_WATERCOURSE_NAME WC_NAME VARCHAR2 80 STREAM_WATERCOURSE_NAME is the name of the proposed crossing, e.g., Pingel Creek.
STREAM_RIPARIAN_CLASS_CODE RIP_CLASS VARCHAR2 8 STREAM_RIPARIAN_CLASS_CODE is the riparian classification of the watercourse to be crossed, e.g., S1.
BANK_FULL_STREAM_WIDTH STRM_WIDTH NUMBER 38 BANK_FULL_STREAM_WIDTH is the bank full width in metres of the stream at the location of the proposed works.
IMPACT_DURATION IMPACT_DUR VARCHAR2 60 IMPACT_DURATION is the duration for which a crossing will impact the stream, e.g., Temporary.
STATUS STATUS VARCHAR2 18 STATUS is the status of the activity during the approval process, e.g., Approved.
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.
ACTIVITY_APPROVAL_DATE APPRV_DATE DATE 7 ACTIVITY_APPROVAL_DATE is the date the activity was approved by the Oil and Gas Commission.
ACTIVITY_CANCEL_DATE CANC_DATE DATE 7 ACTIVITY_CANCEL_DATE is the date the activity was cancelled by the Oil and Gas Commission.
LEGACY_OGC_FILE_NUMBER LEGACY_OGC VARCHAR2 16 LEGACY_OGC_FILE_NUMBER is the legacy OGC file number used for referencing applications submitted prior to July 11, 2016, e.g., 9631141.
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.
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 A_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.