Pipeline Segments (Permitted)

Pipeline centre-lines associated with oil and gas pipeline activity and falling within the area representing the pipeline right of way. This dataset contains line features collected on or after July 11, 2016 for approved pipeline centre-line locations. Data is updated nightly. Short Name: OG_PL_S_P Comments: Pipeline centre-lines associated with oil and gas pipeline activity and falling within the area representing the pipeline right of way. This dataset contains line features collected on or after July 11, 2016 for approved pipeline centre-line locations. Column Name: OG_PIPELINE_SEGMENT_PERMIT_ID Short Name: PPL_S_P_ID Data Type: NUMBER Data Precision: 10 Data Comments: OG_PIPELINE_SEGMENT_PERMIT_ID is a system generated unique identifier number. Column Name: PROJECT_NUMBER Short Name: PROJ_NUM Data Type: VARCHAR2 Data Precision: 18 Data Comments: PROJECT_NUMBER is a unique business identifier for a pipeline, e.g., 000021886. Column Name: SEGMENT_NUMBER Short Name: SEG_NUM Data Type: NUMBER Data Precision: 5 Data Comments: SEGMENT_NUMBER is a system generated identification number assigned to each pipeline segment within a pipeline area, e.g., 2. Column Name: LINE_TYPE Short Name: LINE_TYPE Data Type: VARCHAR2 Data Precision: 8 Data Comments: LINE_TYPE is a code indicating the type of pipeline, e.g., TR (Transmission). Column Name: LINE_TYPE_DESC Short Name: LINE_DESC Data Type: VARCHAR2 Data Precision: 60 Data Comments: LINE_TYPE_DESC is a description of the type of pipeline, e.g., Transmission (TR). Column Name: PHYSICAL_PIPE_LENGTH Short Name: PHYS_LEN_M Data Type: NUMBER Data Precision: 38 Data Comments: PHYSICAL_PIPE_LENGTH is the length of the pipeline segment measured in metres. Column Name: STATUS Short Name: STATUS Data Type: VARCHAR2 Data Precision: 38 Data Comments: STATUS is the status of the activity during the approval process, e.g., Approved. 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: ACTIVITY_APPROVAL_DATE Short Name: APPRV_DATE Data Type: DATE Data Precision: 7 Data Comments: ACTIVITY_APPROVAL_DATE is the date the activity was approved by the BC Energy Regulator. Column Name: ACTIVITY_CANCEL_DATE Short Name: CANC_DATE Data Type: DATE Data Precision: 7 Data Comments: ACTIVITY_CANCEL_DATE is the date the activity was cancelled by the BC Energy Regulator. Column Name: LEGACY_BCER_FILE_NUMBER Short Name: LEGACY_BCER Data Type: VARCHAR2 Data Precision: 16 Data Comments: LEGACY_BCER_FILE_NUMBER is the legacy BCER file number used for referencing applications submitted prior to July 11, 2016, e.g., 9631141. 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 BC Energy Regulator. Authorizations are issued either under the Energy Resources Activities Act (ERAA) or the Canada Energy Regulator (CRA), e.g., ERAA. 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).