OGC Sump Locations

402 views (3 recent)

Published by the BC Agency - Oil and Gas Commission
Licensed under Access Only

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.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

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.

Contact Information

NameKrista Zens (pointOfContact)
EmailKrista.Zens@bcogc.ca
OrganizationBC Agency
Sub-OrganizationOil and Gas Commission

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2014-12-11
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

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.