OGC Pool Designation Areas (Public Version)
440 views (6 recent)Published by the Crown Corporations and Agencies - BC Oil and Gas Commission
Licensed under Access Only
Data and Resources
BC Geographic Warehouse Custom Downloadother
WMS getCapabilities requestwms
For use in viewers such as ESRI tools use this truncated link:...
KML Network Linkkml
For use in viewers such as Google Earth Click here for information on how to...
Pool Designation Areas (PDAs) are used to designate the spatial extent within which a geological pool is developed.
Spatial data is based on petroleum natural gas grid unit boundaries.
|Name||Amy-Jade Louie; email subject line: DataBC (pointOfContact)|
|Organization||Crown Corporations and Agencies|
|Sub-Organization||BC Oil and Gas Commission|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2020-10-27|
Object Name: WHSE_MINERAL_TENURE.OG_POOL_DESGNTN_AREA_PUB_SP
Short Name: PL_DSGN_A
Comments: Pool Designation Areas (PDAs) are used to designate the spatial extent within which a geological pool is developed. The size and shape of a PDA is based on the size and shape of the underlying pool and the boundaries of pool gas spacing units (gsu's) and/or oil spacing units (osu's) as represented by Petroleum and Natural Gas (PNG) units. The boundaries of each PDA should align with the units of the PNG grid and may overlap for different pools.
|Column Name||Short Name||Data Type||Data Precision||Comments|
|OG_POOL_DESGNTN_AREA_PUB_ID||GPLDSGNTNR||NUMBER||10||OG POOL DESGNTN AREA PUB ID: a system generated identifier to ensure row uniqueness.|
|POOL_DESIGNATION_NAME||PLDSGNTNNM||VARCHAR2||78||POOL DESIGNATION NAME: The name describing the spatial extent within which a geological pool is developed. It contains the Field Area Name, Formation Name and Pool Sequence. E.g., BUICK CREEK/HALFWAY/A|
|FIELD_AREA_CODE||FLDRCD||VARCHAR2||4||FIELD AREA CODE: A numeric code that represents the area (or field) within which an oil or gas pool has been designated to belong. E.g., 2400|
|FIELD_AREA_NAME||FLDRNM||VARCHAR2||30||FIELD AREA NAME: Name that represents the area (or field) within which an oil or gas pool has been designated to belong. E.g., BUICK CREEK|
|FORMATION_CODE||FRMTNCD||VARCHAR2||4||FORMATION CODE: A numeric code that represents the geologic formation within which an oil or gas pool has been designated to belong. E.g., 4800|
|FORMATION_NAME||FRMTNNM||VARCHAR2||30||FORMATION NAME: Name that represents the geologic formation within which an oil or gas pool has been designated to belong. E.g., HALFWAY|
|POOL_SEQUENCE||PLSQNC||VARCHAR2||16||POOL SEQUENCE: Usually a letter (A to Z) assigned in sequence which uniquely distinguishes the pool from other structurally separated pools within the same area and formation. For pools falling within areas defined as "Other Areas", the pool sequence represents the legal location. E.g., C-075-J/093-P-01|
|FLUID_TYPE||FLUID_TYPE||VARCHAR2||5||FLUID TYPE: Identifies the type of fluid in the pool designation area. E.g., Oil or Gas|
|MAP_DRAFTED_DATE||MPDRFTDDT||DATE||7||MAP DRAFTED DATE: The date the pool designation area map was drafted by the Commission geologist.|
|MAP_SCALE||MAP_SCALE||VARCHAR2||7||MAP SCALE: The scale at which the pool designation area map was produced. E.g., 35000|
|DIGITIZED_DATE||DGTZDDT||DATE||7||DIGITIZED DATE: The date the pool designation area was digitized into the database.|
|FEATURE_CODE||FTRCD||VARCHAR2||10||FEATURE CODE contains a value based on the Canadian Council of Surveys and Mapping's (CCSM) system for classification of geographic features. E.g., AR82000110|
|GEOMETRY||GEOMETRY||SDO_GEOMETRY||1||GEOMETRY 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.|
|FEATURE_AREA_SQM||AREA_SQM||NUMBER||19||FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters|
|FEATURE_LENGTH_M||FEAT_LEN||NUMBER||19||FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters|