OGC Geophysical Misfired Charges

166 views (2 recent)

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

Explosive material set during geophysical exploration that fails, on initiation, to completely detonate or to function in accordance with the manufacturer's specifications. Information on misfired charges is submitted through the Oil and Gas Commission geophysical web portal by geophysical operators and their representatives.

Data and Resources

Dataset Extent

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

Additional Information

Purpose

The Oil and Gas Commission requires that all misfired charges associated with a geophysical program be reported to the Commission via the Geophysical Portal.

More Information

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-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_MINERAL_TENURE.OG_GEO_MISFIRED_CHARGES_SP

Short Name: MISFRD_CHR

Column Name Short Name Data Type Data Precision Comments
OG_GEO_MISFIRED_CHARGE_ID MISFIRE_ID NUMBER 10 OG GEO MISFIRED CHARGE ID is a system generated identifier to ensure row uniqueness.
GEOPHYSICAL_PROGRAM_NUMBER GEO_NUM VARCHAR2 8 GEOPHYSICAL PROGRAM NUMBER contains the number provided by the Oil and Gas Commission and assigned to the geophysical program. The number is included on the application permit and all operations and final plan documentation. E.g., 2010-005
OGC_FILE_NUMBER FILE_NUM VARCHAR2 8 OGC FILE NUMBER contains the file number assigned to each application for tracking purposes within the Oil and Gas Commission. E.g., 9632012
GEOPHYSICAL_PROGRAM_NAME PROG_NAME VARCHAR2 30 GEOPHYSICAL PROGRAM NAME contains the program name provided by the operator to the Oil and Gas Commission. The name is included on the application permit and all operations and final plan documentation. E.g., Cheves Creek 3D
PROPONENT PROPONENT VARCHAR2 40 PROPONENT contains the organization name of the oil and gas operator.
SHOT_POINT_NUMBER SHOT_NUM VARCHAR2 6 SHOT POINT NUMBER contains the identifying number of each shot point. E.g., 363
LINE_NUMBER LINE_NUM VARCHAR2 6 LINE NUMBER contains the identifying number of the cutline made by hand or machine in the course of geophysical exploration. E.g., 112
LAND_TYPE LAND_TYPE VARCHAR2 1 LAND TYPE indicates whether the oil and gas application is on Private or Crown land. E.g., C (Crown)
UTM_ZONE UTM_ZONE VARCHAR2 2 UTM ZONE contains the UTM zone in which the misfired charge falls within. E.g., 10
UTM_NORTHING NORTHING NUMBER 8 UTM NORTHING contains the NAD83 Northing coordinate as submitted through the geophysical web portal.
UTM_EASTING EASTING NUMBER 6 UTM EASTING contains the NAD83 Easting coordinate as submitted through the geophysical web portal.
DRILL_DATE DRILL_DATE DATE 7 DRILL DATE is the date the shot hole containing the misfired charge was drilled.
MISFIRE_DATE MISFIRE_DT DATE 7 MISFIRE DATE is the date that the explosive charge failed to detonate.
HOLE_DEPTH HOLE_DEPTH NUMBER 5 HOLE DEPTH contains the depth of the shot hole measured in meters.
CHARGE_DEPTH CHRG_DEPTH NUMBER 5 CHARGE DEPTH contains the depth of the explosive charge within the shot hole measured in meters.
CHARGE_SIZE CHRG_SIZE NUMBER 5 CHARGE SIZE contains the size of the explosive charge measured in kilograms.
NUMBER_OF_CAPS CAP_NUM NUMBER 3 NUMBER OF CAPS contains the number of blasting caps used to initiate an explosion. E.g., 1
CHARGE_TYPE CHRG_TYPE VARCHAR2 30 CHARGE TYPE contains the type of explosive charge as submitted by the proponent. E.g., Dynamite
PLUGGED_DATE PLUG_DATE DATE 7 PLUGGED DATE is the date the shot hole is plugged.
PLUG_TYPE PLUG_TYPE VARCHAR2 30 PLUG TYPE contains the type of material used to plug the shot hole. E.g., Bentonite
SHOT_POINT_OFFSET_IND SHT_OFFSET VARCHAR2 1 SHOT POINT OFFSET IND indicates whether the location of the shot hole is offset from the seismic line (Y or N).
DIRECTION_OFFSET DRC_OFFSET NUMBER 5 DIRECTION OFFSET contains the direction measured in degrees from the seismic line to the shot hole.
DISTANCE_OFFSET DIS_OFFSET NUMBER 5 DISTANCE OFFSET contains the distance measured in meters from the centre of the seismic line to the shot hole.
FEATURE_CODE F_CODE 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.