Oil and Gas Commission Changes In and About a Stream Applications

118 views (4 recent)

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

Point locations indicating proposed applications 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 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_STREAM_IMPACT_APPL_SP

Short Name: OG_STR_I_A
Comments: Point locations indicating proposed applications 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 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_STREAM_IMPACT_APPL_ID STR_I_A_ID NUMBER 10 OG_STREAM_IMPACT_APPL_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.
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.
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.