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

The starting point for WellWiki.org’s Alberta well data is publication ST37, “List of

Wells in Alberta.” This publication is updated monthly and is available for download

from the AER website. ST37 includes the following information for all oil and gas wells

in the province:

• 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 available here

We downloaded the tab-delimited text file and imported this file into our MySQL

relational database. As of the May 1, 2015, release this file included 17 fields and

584,588 wells. We also downloaded the shapefiles.

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

ST108, “Monthly Enforcement Action Summary” was published from January 2008

through June 2014, inclusive, a total of 66 monthly reports. Each report provided a

summary of the regulator’s compliance activity. We downloaded all archived copies of

ST108, and incorporated them into our database of Alberta well data. Unfortunately,

these reports were published as PDF files, requiring that we transform them into machine

readable, structured text suitable for insertion into our MySQL database.

The regulator’s compliance activity is now available through the AER’s

"Compliance Dashboard"

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

Statistical Report Table Descriptions

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)

Table ab_facility

The data for the below fields is drawn from ST 102. The report is a complete list of batteries, gas plants, meter stations, and other facilities in the province. Additionally the list has been expanded to include additional information such as operator name and facility sub-type description.

Column Name
FACILITY_ID column
FACILITY_NAME column
OPERATOR_CODE column
OPERATOR_NAME column
SUB_TYPE_CODE column
SUB_TYPE column
LE column
LSD column
Legal Subdivision
SEC column
Section
TWP column
Township
RNG column
Range
MER column
Meridian
LICENSE_NUMBER column
EDCT_CODE column
EDCT_DESCRIPTION column
LICENSE_CODE column
OPERATIONAL_STATUS column