Construction Corridors (Proposed)

Applications for spatial areas occurring on Crown land in which oil and gas activities will take place. Construction corridors allow for flexibility in the movement, placement and construction of oil and gas activity. Data is updated nightly. Short Name: OG CNCOR_A Comments: Applications for spatial areas occurring on Crown land in which oil and gas activities will take place. Construction corridors allow for flexibility in the movement, placement and construction of oil and gas activity. Column Name: OG_CONSTR_CORRIDOR_APPL_ID Short Name: CN_CR_A_ID Data Type: NUMBER Data Precision: 10 Data Comments: OG_CONSTR_CORRIDOR_APPL_ID is a system generated unique identifier number. 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, 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, 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: 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: ARCH_PERMIT_NUMBER Short Name: ARCH_PERM Data Type: VARCHAR2 Data Precision: 60 Data Comments: ARCH_PERMIT_NUMBER is the permit to conduct archaeological work under section 14 of the Heritage Conservation Act, e.g., 2009-254. Column Name: ARCH_REQUIREMENT_CODE Short Name: ARCH_REQ Data Type: VARCHAR2 Data Precision: 40 Data Comments: ARCH_REQUIREMENT_CODE is the legislative requirement for the archaeological work being undertaken, e.g., AOA (Archaeology Overview Assessment). Column Name: ARCH_SITE_IDENTIFIED Short Name: ARCH_SITE Data Type: VARCHAR2 Data Precision: 20 Data Comments: ARCH_SITE_IDENTIFIED is an indicator to identify whether an archaeology site was found during the execution of the impact assessment, i.e., Y or N. 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). Column Name: FEATURE_AREA_SQM Short Name: AREA_SQM Data Type: NUMBER Data Precision: 19 Data Comments: FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters. Column Name: FEATURE_LENGTH_M Short Name: LENGTH_M Data Type: NUMBER Data Precision: 19 Data Comments: FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters. Column Name: SHAPE Short Name: SHAPE Data Type: SDO_GEOMETRY Data Precision: 1 Data Comments: SHAPE is the column used to reference the spatial coordinates defining the feature. Column Name: OBJECTID Short Name: OBJECTID Data Type: NUMBER Data Precision: 38 Data Comments: OBJECTID is a required attribute of feature classes and object classes in a geodatabase. Column Name: SE_ANNO_CAD_DATA Short Name: A_CAD_DATA Data Type: BLOB Data Precision: 4000 Data Comments: 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.