Alberta Oil and Gas Data Sources

The source of information for all Alberta Well Data is the website of Alberta Energy Regulator and all The information was extracted from the following reports:

1) Statistical Report ST37 – well list and following fields:

• well identifier

• well name

• license number

• field/pool and/or area/deposit

• operator

• licensee

• total depth

• finished drilling date

• well status

The information about the meaning of each field in the well table is obtained from: http://www.aer.ca/documents/sts/St37-Listofwellslayout.pdf

2) Statistical Report ST103-Pool field codes

http://www.aer.ca/data-and-publications/statistical-reports/st103

3) Statistical Report ST104- Licensee Agent Codes (Operators)

http://www.aer.ca/data-and-publications/statistical-reports/st104

4) Statistical Report ST108- AER Monthly Enforcement Action Summary (Compliance)

http://www.aer.ca/data-and-publications/statistical-reports/st108

5) Statistical Report ST102-Facility List

http://www.aer.ca/data-and-publications/statistical-reports/st102

6) Horizontal Well List

http://www.aer.ca/data-and-publications/activity-and-data/horizontal-well-list

7)Well coordinates are extracted from AGS coordinate converter tool

http://www.ags.gov.ab.ca/gis/map_converters/conversion_tools.html

Tables

The following are summaries of the Important tables within the Statistical reports mentioned above:

Table ab_well

Column Name	Description
LOCATION column	This column in the database represents well id in UWI format. In this id is encoded the location of well. The information on decoding the meaning can be found here dl.ppdm.org/dl/551
WELL_ID column	This column contains the well id in the well DNS format. It encodes the location of the well and the information on the meaning of each digit can be found here: dl.ppdm.org/dl/551
WELL_NAME column
POOL_CODE column	References to ab_pool_code table
OS_DEP_CODE column
FINAL_DRILLING_DATE column
TOTAL_DEPTH column
WELL_STATUS_CODE column	This field encodes the status of the well. The information from this field is decoded and added to the table in the following fields:,FLUID, MODE, TYPE, STRUCTURE. The information is decoded according to: www.aer.ca/documents/sts/St37-Listofwellslayout.pdf
WELL_STATUS_DATE column
FLUID column	Obtained from WELL_STATUS_CODE
MODE column	Obtained from WELL_STATUS_CODE
TYPE column	Obtained from WELL_STATUS_CODE
STRUCTURE column	Obtained from WELL_STATUS_CODE
CONFIGURATION column	Contains information if the well is horizontal. The data was loaded to this table from the list of horizontal well list (see the 6-th resource in the resource section)
HORIZONTAL_WELL column	Contains information if the well is horizontal. The data was loaded to,this table from the list of horizontal well list (see the 6-th resource,in the resource section)
LONGITUDE_DECIMAL column	This information was extracted from the online converter (see the 7-th resource in the resource section)
LATITUDE_DECIMAL column	This information was extracted from the online converter (see the 7-th resource in the resource section). NOTE: extracted information for this column has a positive value. In order to see the actual location of the well in Google Maps, this location has to be turned to negative value. I left this value to be positive in order to be consistent with the source.

Table ab_pool_codes

This Table can be found in the "Field/Pool List" section of the ST103 statistical Report

Column Name	Description
FIELD_NAME column
PRODUCTION_POOL column
FIELD_CODE column
PRODUCTION_POOL_CODE column
GEOLOGICAL_POOL_CODE column
GEOLOGICAL_POOL_NAME column
CONFIDENTIAL column

Table ab_operator

This Table is available in Statistical report 104 (ST104): https://www.aer.ca/data-and-publications/statistical-reports/st104

This table replaces the Company Codes list previously published by the AER. It provides Business Associate (BA) codes for companies and includes licensees and agents but also includes companies (e.g., drilling companies) that have codes but are not registered licensees or agents.

Column Name	Description
BA_CODE column	Code of the business unit
COMPANY column	Company name
ADDRESS column	Address of the company. Initially this column contained the information for the street number, city, province and postal code. This information was extracted and used to populate the corresponding fields. For some cases, this information was incomplete.
CITY column
PROVINCE column
POSTAL_CODE column
PHONE column
COUNTRY column	Country information was populated according to the information in the PROVINCE column. The codes were decoded according USA USPS codes: http://en.wikipedia.org/wiki/List_of_U.S._state_abbreviations#Postal_codes

Table ab_permit

Column Name
LOCATION column
OS_DEP_CODE column
LICENSE_SEQ column
LICENSE_DATA column
LICENSE_CODE column
FINAL_DRILLING_DATA column

Table ab_permit

The table Can be found in Statistical report 108 (ST108) which provides a summary of the regulator's compliance activity.

Column Name	Description
LICENSEE column
NONCOMPLIANCE_DESC column
ENORCEMENT_DATE column
LOCATION column
RISK_CATEGORY column
AER_GROUP column	Information in this column was added from the AER_ACTIONS_AND_LICENSEE_RESPONSE. The original column from source was containing two pieces of information and it was required to be split in two (normalization principle)
COMPLIANCE CATEGORY column	Information in this column was added from the AER_ACTIONS_AND_LICENSEE_RESPONSE. The original column from source was containing two pieces of information and it was required to be split in two (normalization principle)