If you find this page useful and would like to be notified of changes made to this page, start by inputting your email below.
powered by ChangeDetection
(→Table ab_facility) |
(→Tables) |
||
| Line 59: | Line 59: | ||
| − | = | + | =Statistical report table descriptions= |
The following are summaries of the Important tables within the Statistical reports mentioned above: | The following are summaries of the Important tables within the Statistical reports mentioned above: | ||
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
The following are summaries of the Important tables within the Statistical reports mentioned above:
| 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: |
| 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. |
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 |
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 |
| Column Name |
|---|
| LOCATION column |
| OS_DEP_CODE column |
| LICENSE_SEQ column |
| LICENSE_DATA column |
| LICENSE_CODE column |
| FINAL_DRILLING_DATA column |
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) |
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 |