Identification Information:
Citation:
Citation Information:
Originator: Alberta Energy Regulator
Originator: Alberta Geological Survey
Originator: Nakevska, N.
Originator: Lemay, T.G.
Publication Date: 2022
Title:
Distribution of Total Dissolved Solids in the Horseshoe Canyon / St. Mary River Hydrostratigraphic Unit (tabular data, tab-delimited format)
Geospatial Data Presentation Form: tabular digital data
Series Information:
Series Name: Digital Data
Issue Identification: DIG 2022-0023
Publication Information:
Publication Place: Edmonton, Alberta, Canada
Publisher: Alberta Geological Survey
Online Linkage: http://ags.aer.ca/document/DIG/DIG_2022_0023.zip
Description:
Abstract:

This data release contains water chemistry data used to create a total dissolved solids (TDS) map of the Horseshoe Canyon / St. Mary River hydrostratigraphic unit (HSU). The data were acquired from the following public sources:

1. Alberta Environment and Parks' (AEP) Alberta Water Well Information Database (AWWID)

2. Alberta Health Services (AHS)

3. Alberta Energy Research Institute (AERI)

4. Baseline Water Well Test Database (BWWT)

5. Data submissions by industry as required by Alberta Energy Regulator (AER) Directive 044: Requirements for Surveillance of Water Production in Hydrocarbon Wells Completed Above the Base of Groundwater Protection

6. Formation water chemistry data from oil and gas well drillstem tests (DSTs) and production fluids.

Data have been processed, relevant records selected, and outliers removed to compile this dataset.

Purpose: For computer display, query, and modelling of TDS for the Horseshoe Canyon / St. Mary River HSU.
Supplemental Information: Language: In English;
Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 1964
Ending Date: 2013
Currentness Reference: ground condition
Status:
Progress: In work
Maintenance and Update Frequency: None planned
Spatial Domain:
Bounding Coordinates:
West Bounding Coordinate: -116
East Bounding Coordinate: -110
North Bounding Coordinate: 54
South Bounding Coordinate: 49
Keywords:
Theme:
Theme Keyword Thesaurus: none
Theme Keyword: geology
Theme Keyword: groundwater
Theme Keyword: groundwater chemistry
Theme Keyword: horseshoe canyon formation
Theme Keyword: hydrochemistry
Theme Keyword: hydrogeology
Theme Keyword: st. mary river formation
Theme Keyword: total dissolved solids
Place:
Place Keyword Thesaurus: none
Place Keyword: 72e
Place Keyword: 72l
Place Keyword: 72m
Place Keyword: 73d
Place Keyword: 73e
Place Keyword: 82g
Place Keyword: 82h
Place Keyword: 82i
Place Keyword: 82j
Place Keyword: 82o
Place Keyword: 82p
Place Keyword: 83a
Place Keyword: 83b
Place Keyword: 83g
Place Keyword: 83h
Place Keyword: alberta
Place Keyword: canada
Access Constraints: Public
Use Constraints:
Acknowledgement of the Alberta Energy Regulator/Alberta Geological Survey as the originator/source of this information is required as described in the Open Government License - Alberta.
Point of Contact:
Contact Information:
Contact Organization Primary:
Contact Organization: Alberta Geological Survey
Contact Person: AGS Information Manager
Contact Position: AGS Information Manager
Contact Address:
Address Type: mailing and physical
Address: Alberta Energy Regulator
Address: 4th Floor, Twin Atria Building
Address: 4999-98 Avenue NW
City: Edmonton
State or Province: Alberta
Postal Code: T6B 2X3
Country: Canada
Contact Voice Telephone: (780) 638-4491
Contact Facsimile Telephone: (780) 422-1459
Contact Electronic Mail Address: AGS-Info@aer.ca
Hours of Service: 8:00 a.m. to 12:00 p.m. and 1:00 p.m. to 4:30 p.m.
Cross Reference:
Citation Information:
Originator: Alberta Energy Regulator
Originator: Alberta Geological Survey
Originator: Nakevska, N.
Originator: Lemay, T.G.
Publication Date: 2022
Title:
Distribution of Total Dissolved Solids in the Horseshoe Canyon / St. Mary River Hydrostratigraphic Unit
Geospatial Data Presentation Form: map
Series Information:
Series Name: Map
Issue Identification: MAP 625
Publication Information:
Publication Place: Edmonton, Alberta, Canada
Publisher: Alberta Geological Survey
Other Citation Details: ISBN: 978-1-4601-5356-7 scale 1:1 300 000
Online Linkage: https://www.ags.aer.ca
Cross Reference:
Citation Information:
Originator: Alberta Energy Regulator
Originator: Alberta Geological Survey
Originator: Nakevska, N.
Publication Date: 2022
Title:
Distribution of Total Dissolved Solids in the Horseshoe Canyon / St. Mary River Hydrostratigraphic Unit (gridded data, ASCII format)
Geospatial Data Presentation Form: raster digital data
Series Information:
Series Name: Digital Data
Issue Identification: DIG 2022-0019
Publication Information:
Publication Place: Edmonton, Alberta, Canada
Publisher: Alberta Geological Survey
Online Linkage: https://www.ags.aer.ca
Data Quality Information:
Attribute Accuracy:
Attribute Accuracy Report:
Any errors in the original data were carried into this dataset and no systematic checking of attributes from original data sources was undertaken. Some obvious errors in the AWWID were corrected. For example, reversed top and bottom of the screened/perforated intervals were corrected. All attributes for the water wells, monitoring wells, and oil and gas wells are as received from the data source. The total dissolved solids (TDS) values are calculated from other fields, and do not contain any decimal places. Calculation of TDS is dependent on the availability of specific ions at the time of testing and the generally accepted standard for displaying TDS is a whole number.
Logical Consistency Report:

Water chemistry data used in this dataset from the AWWID and other compiled sources have been collected over decades, by different parties, and using different methods. There may be more than one record for a Source_ID if the water well was sampled more than once. This will be reflected in the ChemAnal_ID field. Geographic coordinates (latitude/longitude) may be the same for different wells, often because the AWWID wells have been located as being in the middle of a quarter section or section.

Formation water analysis from oil and gas wells have been collected over decades, by different parties, and using different methods.

Completeness Report:
All data records within the Horseshoe Canyon / St. Mary River HSU with sufficient information were selected from described sources. Null values are reported as -9999.
Positional Accuracy:
Horizontal Positional Accuracy:
Horizontal Positional Accuracy Report:

A majority of the AWWID wells are located to the middle of the Alberta Township System (ATS) quarter section (occasionally to the middle of the section). Therefore, there can be up to approximately 566 m (or up to approximately 1131 m if the well is located in the middle of a section) of error in the well location and subsequent maps derived from the well records. These sources of error are not unique to this study and are encountered in any hydrogeological study that uses the AWWID, unless further refinement of well locations is undertaken.

The locations of the oil and gas wells may be accurate to within millimetres depending on surveying standards at the time of drilling.

Vertical Positional Accuracy:
Vertical Positional Accuracy Report:

The potential for up to approximately 566 m (sometimes approximately 1131 m) of horizontal accuracy error for water wells may also introduce errors in the surface elevation, which is derived from the provincial 25 m DEM, based on the location of the well. This error is likely on the order of plus/minus 5 m, but may be 10's of metres in areas where there are large changes in elevation. Any error in elevation may influence the allocation of the well as well as sampling location. These sources of error are not unique to this study and are encountered in any hydrogeological study that uses the AWWID, unless further refinement of well locations is undertaken.

The mid-point of the sampled interval is a calculated value and its accuracy is dependent on the accuracy of the measured depths and elevations provided in the well header. These values are somewhat inconsistent for the water wells because many of them are not surveyed. For the oil and gas wells, the well elevations and locations are surveyed in, so accuracy will be to the same significant digits provided by the source, even though there may be considerable uncertainty as to where the sample actually came from.

The location of the sampled interval in oil and gas wells may be accurate to within millimetres in accordance with surveying standards at the time of drilling.

Lineage:
Source Information:
Source Citation:
Citation Information:
Originator: Alberta Energy and Utilities Board
Originator: Alberta Geological Survey
Originator: Lemay, T.G.
Publication Date: 2003
Title:
Chemical and Physical Hydrogeology of Coal, Mixed Coal-Sandstone and Sandstone Aquifers from Coal-Bearing Formations in the Alberta Plains Region, Alberta
Geospatial Data Presentation Form: document
Series Information:
Series Name: Earth Sciences Report
Issue Identification: ESR 2003-04
Publication Information:
Publication Place: Edmonton, Alberta
Publisher: Alberta Geological Survey
Source Scale Denominator: 0
Type of Source Media: online
Source Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 2002
Ending Date: 2005
Source Currentness Reference: ground condition
Source Citation Abbreviation: AERI
Source Contribution: water well chemistry, water level and geological information
Source Information:
Source Citation:
Citation Information:
Originator: Alberta Energy and Utilities Board
Originator: Alberta Geological Survey
Originator: Lemay, T.G.
Originator: Konhauser, K.
Publication Date: 200608
Title: Water Chemistry of Coalbed Methane Reservoirs; Alberta
Geospatial Data Presentation Form: document
Series Information:
Series Name: Special Report
Issue Identification: SPE 081
Publication Information:
Publication Place: Edmonton, Alberta, Canada
Publisher: Alberta Geological Survey
Other Citation Details: Client report provided to AERI. Also AGS Special Report.
Source Scale Denominator: 0
Type of Source Media: online
Source Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 2002
Ending Date: 2005
Source Currentness Reference: ground condition
Source Citation Abbreviation: AERI
Source Contribution: water well chemistry, water level and geological information
Source Information:
Source Citation:
Citation Information:
Originator: Alberta Energy Regulator
Originator: Energy Resources Conservation Board
Originator: Alberta Energy and Utilities Board
Publication Date:
Title: Oil and gas well data from AER corporate database
Geospatial Data Presentation Form: database
Publication Information:
Publication Place: Calgary, Alberta, Canada
Publisher: Alberta Energy Regulator
Online Linkage: Not available online.
Source Scale Denominator: 0
Type of Source Media: online
Source Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 1900
Ending Date: 2013
Source Currentness Reference: recorded drilling dates
Source Citation Abbreviation: DST
Source Contribution: DST from oil and gas wells
Source Information:
Source Citation:
Citation Information:
Originator: Alberta Health Services
Publication Date: 2018/10
Title: Domestic Well Water Quality in Alberta - Routine Chemistry
Geospatial Data Presentation Form: tabular digital data
Publication Information:
Publication Place: Alberta, Canada
Publisher: Alberta Health Services
Other Citation Details:
This dataset contains the raw well water chemistry results from routine chemistry analysis on samples submitted to ACFT between November 2001 and December 2015.
Online Linkage: https://open.alberta.ca/opendata/domestic-well-water-quality-in-alberta-routine-chemistry
Source Scale Denominator: 0
Type of Source Media: online
Source Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 2002
Ending Date: 2015
Source Currentness Reference: ground condition
Source Citation Abbreviation: AHS
Source Contribution: water well chemistry
Source Information:
Source Citation:
Citation Information:
Originator: Government of Alberta
Publication Date: 09/2020
Title: Baseline Water Well Test Database
Geospatial Data Presentation Form: database
Publication Information:
Publication Place: Alberta, Canada
Publisher: Government of Alberta
Online Linkage: http://groundwater.alberta.ca/WaterWells/d/
Source Scale Denominator: 0
Type of Source Media: online
Source Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 2011
Ending Date: 2020
Source Currentness Reference: ground condition
Source Citation Abbreviation: BWWT
Source Contribution: water well chemistry
Source Information:
Source Citation:
Citation Information:
Originator: Government of Alberta
Publication Date:
Title: Alberta Water Well Information Database
Geospatial Data Presentation Form: database
Publication Information:
Publication Place: Edmonton, Alberta, Canada
Publisher: Government of Alberta
Online Linkage: http://groundwater.alberta.ca/WaterWells/d/
Source Scale Denominator: 0
Type of Source Media: online
Source Time Period of Content:
Time Period Information:
Range of Dates/Times:
Beginning Date: 1961
Ending Date: 2013
Source Currentness Reference: recorded drilling dates
Source Citation Abbreviation: AWWID
Source Contribution: Alberta Water Well Information Database.
Process Step:
Process Description:

Process steps for selection of chemical analysis from water wells:

1. Water well records with completion interval and/or total depth information, and complete chemical analysis, were selected;

2. Chemical analyses from completion intervals longer than 15 m were excluded;

3. Chemical analyses were allocated to the Horseshoe Canyon / St. Mary River HSU based on the completion interval, or the total depth of the well if completion interval was not available;

4. Chemical analyses from wells with completion intervals straddling the top or bottom of the Horseshoe Canyon / St. Mary River HSU were excluded, unless they were from wells in data-poor areas and it was verified that less than 30% of the completion interval extended into the formation directly above or below the HSU, but not into any other formation;

5. The acceptable charge balance error was constrained to ±10%;

6. Chemical analyses which reported CO3 and pH <8.3 were excluded;

7. The concentration of total dissolved solids (TDS) was determined either by summing the concentration of major constituents (if available), or by using the TDS values as reported in the source dataset (if major constituents were not available);

8. Outliers were manually removed during the mapping process based on substantial difference in screen depth, and unexplained anomalous values.

Process steps for selection of formation water analyses from oil and gas wells:

1. Records containing depth of tested interval information were selected;

2. The tested interval length was constrained to less than or equal to 50 m;

3. The acceptable charge balance error was constrained to ±10%;

4. Samples labelled as “incomplete analysis" were excluded;

5. Records were allocated to the Horseshoe Canyon / St. Mary River HSU based on the depth information for the tested interval;

6. Records with tested intervals straddling the top or bottom of the Horseshoe Canyon / St. Mary River HSU were excluded, unless they were from wells in data-poor areas and it was verified that less than 30% of the tested interval extended into the formation directly above or below the HSU, but not into any other formation;

7. In case of collocated data, the most representative sample was selected, or averaging of TDS values was done;

8. The concentration of total dissolved solids (TDS) was determined either by summing the concentration of major constituents (if available), or by using the TDS values as reported in the source dataset (if major constituents were not available)

The remaining formation water analyses were subjected to additional screening to identify potential contamination of the formation water by drilling fluids such as acid water, corrosion inhibitors, mud filtrates, and alcohols.

Process steps for selection of formation water analyses from compiled sources:

1. Any records where the sampled interval was identified as the Horseshoe Canyon / St. Mary River HSU were included in the initial dataset.

The final dataset includes only those records that were used in the production of the final TDS surface.

Details about the screening process can be found in the following reference: Jensen, G.K.S., Rostron, B., Palombi, D., and Melnik, A. (2013): Saskatchewan Phanerozoic Fluids and Petroleum Systems project: hydrogeological mapping framework; in Summary of investigations 2013, Volume 1, Saskatchewan Geological Survey, Sask. Ministry of the Economy, Misc. Rep. 2013-4.1, Paper A5, 10 p. URL http://publications.gov.sk.ca/details.cfm?p=80100 [October 2014].

Process Date: 2019
Entity and Attribute Information:
Detailed Description:
Entity Type:
Entity Type Label: DIG_2022_0023
Entity Type Definition:
This dataset contains a compilation of chemistry data used to create the total dissolved solids surface of the Horseshoe Canyon / St. Mary River hydrostratigraphic unit (HSU).
Entity Type Definition Source: Alberta Geological Survey
Attribute:
Attribute Label: Source_ID
Attribute Definition Source: Alberta Geological Survey
Attribute Definition:
Well identifier from the source data. For Alberta Environment and Parks' Alberta Water Well Information Database (AWWID) data this is the GIC_Well_ID identifier of the water well. For oil and gas wells (OGW) data this is the unique well identifier. For the AHS data this is the well identifier used in the database. For the AERI data this is the well identifier used in the database. For the BWWT data this is the well identifier used in the database. For the D044 data this is the well identifier used in the database.
Attribute:
Attribute Label: Lat_NAD83
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Latitude, NAD83 datum, decimal degrees north.
Attribute:
Attribute Label: Long_NAD83
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Longitude, NAD83 datum, decimal degrees east.
Attribute:
Attribute Label: DataSrc
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Source of the data.
Attribute Domain Values:
Enumerated Domain:
Enumerated Domain Value: AWWID
Enumerated Domain Value Definition: Alberta Water Well Information Database.
Enumerated Domain Value Definition Source: Alberta Geological Survey
Enumerated Domain:
Enumerated Domain Value: OGW
Enumerated Domain Value Definition: Oil and gas wells.
Enumerated Domain Value Definition Source: Alberta Geological Survey
Enumerated Domain:
Enumerated Domain Value: BWWT
Enumerated Domain Value Definition: Base of Water Well Testing Database.
Enumerated Domain Value Definition Source: Alberta Geological Survey
Enumerated Domain:
Enumerated Domain Value: AHS
Enumerated Domain Value Definition: Alberta Health Services domestic well water quality monitoring database.
Enumerated Domain Value Definition Source: Alberta Geological Survey
Enumerated Domain:
Enumerated Domain Value: AERI
Enumerated Domain Value Definition: Alberta Energy Research Institute.
Enumerated Domain Value Definition Source: Alberta Geological Survey
Enumerated Domain:
Enumerated Domain Value: D044
Enumerated Domain Value Definition:
Data acquired as a result of AER Directive 044. Requirements for Surveillance of Water Production in Hydrocarbon Wells Completed Above the Base of Groundwater Protection.
Enumerated Domain Value Definition Source: Alberta Geological Survey
Attribute:
Attribute Label: MidInt_m28
Attribute Definition Source: Alberta Geological Survey
Attribute Definition:
Midpoint of tested interval, measured as elevation in metres above sea level, Canadian Geodetic Vertical Datum of 1928. Midpoint
elevation of screened interval for water wells and midpoint elevation of tested or completed interval for oil & gas wells.
Attribute:
Attribute Label: TDS_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Calculated value for total dissolved solids, in milligrams per litre.
Attribute:
Attribute Label: Resid_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition:
Calculated difference, in milligrams per litre, between the modelled distribution of TDS and measured values from wells.
Attribute:
Attribute Label: Ca_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total calcium, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: Mg_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total magnesium, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: Na_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total sodium, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: K_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total potassium, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: HCO3_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total bicarbonate, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: SO4_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total sulfate, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: Cl_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total chloride, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: Fe_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total iron, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: CO3_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total carbonate, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: NO3_mgL
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Measure of total nitrate, in milligrams per litre, from the original analysis.
Attribute:
Attribute Label: Publisher
Attribute Definition Source: Alberta Geological Survey
Attribute Definition: Organization that published the dataset.
Distribution Information:
Distributor:
Contact Information:
Contact Organization Primary:
Contact Organization: Alberta Geological Survey
Contact Person: AGS Information Manager
Contact Position: AGS Information Manager
Contact Address:
Address Type: mailing and physical
Address: Alberta Energy Regulator
Address: 4th Floor, Twin Atria Building
Address: 4999-98 Avenue NW
City: Edmonton
State or Province: Alberta
Postal Code: T6B 2X3
Country: Canada
Contact Voice Telephone: (780) 638-4491
Contact Facsimile Telephone: (780) 422-1459
Contact Electronic Mail Address: AGS-Info@aer.ca
Hours of Service: 8:00 a.m. to 12:00 p.m. and 1:00 p.m. to 4:30 p.m.
Distribution Liability:
The Alberta Energy Regulator / Alberta Geological Survey (AER/AGS) licenses this information under the Open Government License - Alberta. Any references to proprietary software in our documentation, and/or any use of proprietary data formats in our releases, do not constitute endorsement by the AER/AGS of any manufacturer's product.
Metadata Reference Information:
Metadata Date: 20220623
Metadata Contact:
Contact Information:
Contact Organization Primary:
Contact Organization: Alberta Geological Survey
Contact Person: AGS Information Manager
Contact Position: AGS Information Manager
Contact Address:
Address Type: mailing and physical
Address: Alberta Energy Regulator
Address: 4th Floor, Twin Atria Building
Address: 4999-98 Avenue NW
City: Edmonton
State or Province: Alberta
Postal Code: T6B 2X3
Country: Canada
Contact Voice Telephone: (780) 638-4491
Contact Facsimile Telephone: (780) 422-1459
Contact Electronic Mail Address: AGS-Info@aer.ca
Hours of Service: 8:00 a.m. to 12:00 p.m. and 1:00 p.m. to 4:30 p.m.
Metadata Standard Name: FGDC Content Standard for Digital Geospatial Metadata
Metadata Standard Version: FGDC-STD-001-1998
Metadata Time Convention: local time
Metadata Access Constraints: none
Metadata Use Constraints: none