Changes In and About a Stream (Proposed)

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 Energy Regulator's Application Management System (AMS). Column Name: OG_STREAM_IMPACT_APPL_ID Short Name: STR_I_A_ID Data Type: NUMBER Data Precision: 10 Data Comments: OG_STREAM_IMPACT_APPL_ID is a system generated unique identifier number. Column Name: CHANGE_INABOUT_NUMBER Short Name: CIAS_NUM Data Type: VARCHAR2 Data Precision: 14 Data Comments: CHANGE_INABOUT_NUMBER is a business identifier for all changes in and about a stream within an activity,e.g., 0003293. Column Name: LOCATION_ID Short Name: LOC_ID Data Type: NUMBER Data Precision: 10 Data Comments: LOCATION_ID is a system generated identification number assigned to each stream impact point location, e.g., 2. Column Name: LOCATION_TYPE Short Name: LOC_TYPE Data Type: VARCHAR2 Data Precision: 8 Data Comments: LOCATION_TYPE is a code indicating the watercourse crossing type, e.g., CBRD (Clearspan Bridge). Column Name: LOCATION_TYPE_DESC Short Name: LOC_DESC Data Type: VARCHAR2 Data Precision: 80 Data Comments: LOCATION_TYPE_DESC is a description indicating the watercourse crossing type, e.g., Clearspan Bridge (CBRD). Column Name: STREAM_WATERCOURSE_NAME Short Name: WC_NAME Data Type: VARCHAR2 Data Precision: 80 Data Comments: STREAM_WATERCOURSE_NAME is the name of the proposed crossing, e.g., Pingel Creek. Column Name: STREAM_RIPARIAN_CLASS_CODE Short Name: RIP_CLASS Data Type: VARCHAR2 Data Precision: 8 Data Comments: STREAM_RIPARIAN_CLASS_CODE is the riparian classification of the watercourse to be crossed, e.g., S1. Column Name: BANK_FULL_STREAM_WIDTH Short Name: STRM_WIDTH Data Type: NUMBER Data Precision: 38 Data Comments: BANK_FULL_STREAM_WIDTH is the bank full width in metres of the stream at the location of the proposed works. Column Name: IMPACT_DURATION Short Name: IMPACT_DUR Data Type: VARCHAR2 Data Precision: 60 Data Comments: IMPACT_DURATION is the duration for which a crossing will impact the stream, e.g., Temporary. Column Name: APPLICATION_NUMBER Short Name: APPL_NUM Data Type: NUMBER Data Precision: 10 Data Comments: 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. Column Name: APPLICATION_TYPE Short Name: APPL_TYPE Data Type: VARCHAR2 Data Precision: 80 Data Comments: APPLICATION_TYPE is the type of application submitted by the applicant to the Commission's Automated Management System, e.g., New OGAA. Column Name: APPLICATION_STATUS Short Name: APPL_STAT Data Type: VARCHAR2 Data Precision: 80 Data Comments: APPLICATION_STATUS is the status of the application prior to Approval, e.g., In Review. Column Name: APPLICATION_SUBMITTED_DATE Short Name: APPL_DATE Data Type: DATE Data Precision: 7 Data Comments: APPLICATION_SUBMITTED_DATE is the date the application is submitted to the Commission by the applicant. Column Name: REVISION_NUMBER Short Name: REV_NUM Data Type: NUMBER Data Precision: 5 Data Comments: REVISION_NUMBER is the number of times the application has been altered prior to approval. Column Name: APPLICATION_DETERMINATION_NUM Short Name: AD_NUM Data Type: VARCHAR2 Data Precision: 18 Data Comments: 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. Column Name: PROPONENT Short Name: PROPONENT Data Type: VARCHAR2 Data Precision: 120 Data Comments: PROPONENT is the organization name of the oil and gas operator, e.g., ARC Resources Ltd. Column Name: AUTHORITY_TYPE Short Name: AUTH_TYPE Data Type: VARCHAR2 Data Precision: 8 Data Comments: 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. Column Name: DATA_SOURCE Short Name: DATA_SRC Data Type: VARCHAR2 Data Precision: 10 Data Comments: 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).