OGC Sump Locations
402 views (3 recent)Published by the BC Agency - 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...
The Waste Disposal application requires that each company maintain an inventory of sump/pit data. A pit is an earthen excavation for purposes of containing drilling waste. A sump is a grouping of one or more pits found at a geographic location.
|Name||Krista Zens (pointOfContact)|
|Sub-Organization||Oil and Gas Commission|
Access & Security
|Who can view this dataset?||Public|
|Who can download this dataset?||Public|
|Record Last Modified||2019-05-04|
Object Name: WHSE_MINERAL_TENURE.OG_SUMP_LOCATIONS_SP
Short Name: OG_SUMP_LC
Comments: Locations of sump sites used for drilling waste disposal. All Operators in British Columbia are required to handle and dispose of drilling waste in accordance with the requirements of the Oil and Gas Waste Regulation and the Oil and Gas Handbook. The Waste Disposal application requires that each company maintain an inventory of sump/pit data. A pit is an earthen excavation for purposes of containing drilling waste. A sump is a grouping of one or more pits found at a geographic location.
|Column Name||Short Name||Data Type||Data Precision||Comments|
|OG_SUMP_LOCATION_ID||GSMPLCTND||NUMBER||10||OG SUMP LOCATION ID: A system generated identifier to ensure row uniqueness.|
|SUMP_NUMBER||SMPNMBR||VARCHAR2||6||SUMP NUMBER: Number generated by the Oil and Gas Commission used to uniquely identify each sump. E.g., 002272|
|PROPONENT||PROPONENT||VARCHAR2||60||PROPONENT: Organization name of the oil and gas operator.|
|WELL_AUTHORITY_NUMBER||WLLTHRTNMB||VARCHAR2||6||WELL AUTHORITY NUMBER: BC well authority number. Unique ID generated by the Oil and Gas Commission. E.g. 25002|
|WELL_NAME||WELL_NAME||VARCHAR2||80||WELL NAME: The well name identifies the well operator, the field or area name and the surface location of the well.|
|PROJECT_NUMBER||PRJCTNMBR||VARCHAR2||9||PROJECT NUMBER: A unique business identifier for a pipeline. E.g., 000021886|
|SUMP_LOCATION||SMPLCTN||VARCHAR2||20||SUMP LOCATION: National Topographic System (NTS) or Dominion Land Survey (DLS) surface location of the sump. E.g., D-083-K/094-O-11|
|SUMP_CLOSURE_DATE||SMPCLSRDT||DATE||7||SUMP CLOSURE DATE: The most recent closure date for all pits associated with the sump.|
|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.|