Petroleum Title Polygons

Published by the Ministry of Natural Gas Development - Tenure and Geoscience
Licensed under Access Only

All tenures recorded in the Integrated Petroleum Tenure System. Status Types: A- active, C- cancelled, N-not issued, P- pending sale, R- unaccepted bid, U- no bid, W- withdrawn.

Data and Resources

Dataset Extent

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

Additional Information


Show the spatial representation of Petroleum, Natural Gas and Geothermal Tenure in the Province.

Data Quality
Lineage Statement

More Information

Contact Information

NameElle Street (pointOfContact)
OrganizationMinistry of Natural Gas Development
Sub-OrganizationTenure and Geoscience

Access & Security

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

Metadata Information

Record Published 2014-12-15
Record Last Modified 2017-04-12
Resource Status onGoing

Object Description


Short Name: PTSA_PT_PY
Comments: PETROLEUM TITLE POLY provides information on active petroleum, natural gas, and geothermal tenures in British Columbia. Three major title types are used in British Columbia:permits, carrying an obligation to conduct exploration; drilling l

Column Name Short Name Data Type Data Precision Comments
TITLE_NUMBER_ID TTLNMBRD NUMBER 10 A unique identifier for specifically referring to this title.
TITLE_STATUS_CODE TTLSTTSCD VARCHAR2 2 Unique Identifier for the title status code
TITLE_TYPE_CODE TTLTPCD VARCHAR2 5 Defines the title type. Example codes - PNG = Petroleum and Natural Gas Tenure - PET= Petroleum Tenure - NG= Natural Gas Tenure - DL= Drilling License - PB = Permit Class B
DATE_OF_ISSUE DTFSS DATE 7 The date where the active energis title registration was issued to the company and/or person.
EFFECTIVE_DATE FFCTVDT DATE 7 The date at which this active energis title registration becomes effective.
TERM TERM NUMBER 4 Length of the lease or license
AREA_IN_HECTARES RNHCTRS NUMBER 38 The area of this title registration tract area measured in hectares.
BONUS_PAID BONUS_PAID NUMBER 13 The amount of bonus paid to the title holder(s) from the profits from mineral usage of this tenure.
DOLLAR_PER_HECTARE DLLRPRHCTR NUMBER 13 The dollar price paid for the tract area measured in dollars per hectare.
EXPIRY_DATE XPRDT DATE 7 Date of expirey of primary title term
CANCEL_DATE CNCLDT DATE 7 Date title was cancelled
ORIGIN_NUMBER RGNNMBR NUMBER 9 Parent title number or sale parcel number
FEE FEE NUMBER 13 Title issuance fee
SPS_REF_NUMBER SPSRFNMBR VARCHAR2 8 Unique id assigned to parcels by Sales Parcel System (SPS)
REMARKS REMARKS VARCHAR2 4000 Notes on history of title
DATE_OF_SALE DTFSL DATE 7 The Date that this parcel is to be put up for sale/auction
ENTRY_USERID NTRSRD VARCHAR2 30 ENTRY USERID is the identification of the user that created the initial record.
ENTRY_TIMESTAMP NTRTMSTMP DATE 7 ENTRY TIMESTAMP is the date and time the information was entered.
UPDATE_USERID PDTSRD VARCHAR2 30 UPDATE USERID is the identification of the user that made the last update to the record.
UPDATE_TIMESTAMP PDTTMSTMP DATE 7 UPDATE TIMESTAMP is the date and time of the last update to the record
FEATURE_CODE FTRCD VARCHAR2 10 A feature code is most importantly a means of linking a feature to its name and definition.
SDGW_SRC_FID SDGWSRCFD NUMBER 9 Identifies the source feature from which this feature was copied. Set to the value of the GEOMETRY attribute of the source feature
SDGW_REPL_TIME SDGWRPLTM DATE 7 The start time of the SDGW replication process. Note that this is not the time at which this particular feature was actually replicated; rather it is the start time of the replication process as a whole
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 NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters


No comments have been posted yet.