Abstract: Since its inception in 1920, the Alberta Geological Survey (AGS) has drilled several thousand boreholes across the province. Most were drilled only into the unconsolidated sediments overlying the top of bedrock. In 2010, AGS staff began a project to systematically compile all of the borehole log information into a database. This Digital Data product and its companion Open File Report, OFR 2014-06 are the interim results of this initiative. The dataset comprises three tables: Sources.txt, Boreholes.txt and Intervals.txt, as well as metadata. The Sources table gives summary information about the AGS project for which each borehole was drilled. The Boreholes table gives summary information about each borehole, such as location, drilling method, date, and total depth of the hole. The Intervals table gives descriptive geological information about each distinct geological horizon encountered in the borehole, including lithology and colour of the material. The tables have primary keys on them so they may be loaded into a relational database, GIS system, or geological modelling program. This dataset is an interim release of 266 boreholes.
Metadata: 
  File identifier: 
      DIG_2014_0012.xml
  Language: 
      eng; CAN
  Character set: 
    Character set code: 
      utf8
  Hierarchy level: 
    Scope code: 
      dataset
  Metadata author: 
    Responsible party: 
      Organisation name: 
          Alberta Geological Survey
      Position name: 
          AGS Information Manager
      Contact info: 
        Contact: 
          Phone: 
            Telephone: 
              Voice: 
                  (780) 638-4491
              Facsimile: 
                  (780) 422-1918
          Address: 
            Address: 
              Delivery point: 
                  Alberta Energy Regulator
              Delivery point: 
                  4th Floor, Twin Atria Building
              Delivery point: 
                  4999-98 Avenue NW
              City: 
                  Edmonton
              Administrative area: 
                  Alberta
              Postal code: 
                  T6B 2X3
              Country: 
                  Canada
              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.
      Role: 
        Role code: 
          pointOfContact
  Date stamp: 

      2016-03-29
  Metadata standard name: 
      North American Profile of ISO 19115:2003 - Geographic information - Metadata (NAP-Metadata)
  Metadata standard version: 
      ISO 19115-1.1
▲ Return To Top

Spatial representation info:

Vector spatial representation: Geometric objects: Geometric objects: Geometric object type: Geometric object type code: point Geometric object count: 266
▲ Return To Top

Spatial representation info:

Grid spatial representation: Number of dimensions: 2 Axis Dimension Properties: Dimension: Dimension name: Dimension name type code: column Dimension size: unknown Resolution: uom: decimalDegrees 0.00001 Axis Dimension Properties: Dimension: Dimension name: Dimension name type code: row Dimension size: unknown Resolution: uom: decimalDegrees 0.00001 Cell geometry: Cell geometry code: Transformation parameter availability: false
▲ Return To Top

Reference system info:

Reference system:
▲ Return To Top

Reference system info:

Reference system: Reference system identifier: RS Identifier: Code: EPSG:4269 Code Space: http://www.epsg-registry.org/ Version: 8.4.1
▲ Return To Top

Reference system info:

xlink: https://www.ngdc.noaa.gov/docucomp/65f8b220-95ed-11e0-aa80-0800200c9a66 title: North American Datum 1983
▲ Return To Top

Reference system info:

xlink: https://www.ngdc.noaa.gov/docucomp/c3895520-95ed-11e0-aa80-0800200c9a66 title: Geodetic Reference System 1980
▲ Return To Top

Identification info:

Data identification: Citation: Citation: Title: Compilation of Alberta Geological Survey Borehole Data (tabular data, tab delimited format) Date: Date: Date: 2014-06-04 Date type: Date type code: publication Cited responsible party: Responsible party: Organisation name: Alberta Energy Regulator Role: Role code: originator Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: originator Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Contact info: Contact: Address: Address: City: Edmonton Administrative area: Alberta, Canada Role: Role code: publisher Presentation form: Presentation form code: tableDigital Series: Series: Name: Digital Data Issue identification: DIG 2014-0012 Other citation details: Compiled by E.J. Waters and L.D. Andriashek. Abstract: Since its inception in 1920, the Alberta Geological Survey (AGS) has drilled several thousand boreholes across the province. Most were drilled only into the unconsolidated sediments overlying the top of bedrock. In 2010, AGS staff began a project to systematically compile all of the borehole log information into a database. This Digital Data product and its companion Open File Report, OFR 2014-06 are the interim results of this initiative. The dataset comprises three tables: Sources.txt, Boreholes.txt and Intervals.txt, as well as metadata. The Sources table gives summary information about the AGS project for which each borehole was drilled. The Boreholes table gives summary information about each borehole, such as location, drilling method, date, and total depth of the hole. The Intervals table gives descriptive geological information about each distinct geological horizon encountered in the borehole, including lithology and colour of the material. The tables have primary keys on them so they may be loaded into a relational database, GIS system, or geological modelling program. This dataset is an interim release of 266 boreholes. Purpose: For computer display, query and modelling of AGS borehole data. Credit: E.J. Waters Status: Progress code: completed Point of contact: Responsible party: Organisation name: Alberta Geological Survey Position name: AGS Information Manager Contact info: Contact: Phone: Telephone: Voice: (780) 638-4491 Facsimile: (780) 422-1918 Address: Address: Delivery point: Alberta Energy Regulator Delivery point: 4th Floor, Twin Atria Building Delivery point: 4999-98 Avenue NW City: Edmonton Administrative area: Alberta Postal code: T6B 2X3 Country: Canada 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. Role: Role code: pointOfContact Resource maintenance: Maintenance information: Maintenance and update frequency: Maintenance frequency code: irregular Descriptive keywords: Keywords: Keyword: boreholes Keyword: geology Keyword: surficial Type: Keyword type code: theme Thesaurus name: Citation: Title: none Date: unknown Descriptive keywords: Keywords: Keyword: 72e Keyword: 72l Keyword: 72m Keyword: 73d Keyword: 73e Keyword: 73l Keyword: 73m Keyword: 74d Keyword: 74e Keyword: 74l Keyword: 74m Keyword: 82g Keyword: 82h Keyword: 82i Keyword: 82j Keyword: 82n Keyword: 82o Keyword: 82p Keyword: 83a Keyword: 83b Keyword: 83c Keyword: 83d Keyword: 83e Keyword: 83f Keyword: 83g Keyword: 83h Keyword: 83i Keyword: 83j Keyword: 83k Keyword: 83l Keyword: 83m Keyword: 83n Keyword: 83o Keyword: 83p Keyword: 84a Keyword: 84b Keyword: 84c Keyword: 84d Keyword: 84e Keyword: 84f Keyword: 84g Keyword: 84h Keyword: 84i Keyword: 84j Keyword: 84k Keyword: 84l Keyword: 84m Keyword: 84n Keyword: 84o Keyword: 84p Keyword: alberta Keyword: buffalo head hills Keyword: calling lake Keyword: canada Keyword: fort mcmurray Keyword: high level Keyword: peace river Keyword: peerless lake Keyword: pelican river Keyword: red earth Keyword: wabasca Type: Keyword type code: place Thesaurus name: Citation: Title: none Date: unknown Resource constraints: Legal constraints: Access constraints: Restriction code: otherRestrictions Use constraints: Restriction code: otherRestrictions Other constraints: 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. 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. Aggregation Info: AggregateInformation: Aggregate Data Set Name: Citation: Title: Compilation of Boreholes Drilled or Logged by the Alberta Geological Survey Date: Date: Date: 2014-06-10 Date type: Date type code: publication Cited responsible party: Responsible party: Organisation name: Alberta Energy Regulator Role: Role code: originator Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: originator Cited responsible party: Responsible party: Organisation name: Waters, E.J. Role: Role code: originator Cited responsible party: Responsible party: Organisation name: Andriashek, L.D. Role: Role code: originator Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Contact info: Contact: Address: Address: City: Edmonton Administrative area: Alberta, Canada Online Resource: Online Resource: Linkage: URL: http://ags.aer.ca/ Role: Role code: publisher Presentation form: Presentation form code: documentDigital Series: Series: Name: Open File Report Issue identification: OFR 2014-06 Other citation details: ISBN: 978-1-4601-0130-8 Association Type: Association type code: crossReference Spatial representation type: Spatial representation type code: vector Language: eng; CAN Topic category: Topic category code: geoscientificInformation Extent: Extent: Geographic element: Geographic bounding box: West bound longitude: -120 East bound longitude: -110 South bound latitude: 49 North bound latitude: 60 Temporal element: Temporal extent: Extent: Time period: Description: ground condition Begin date: 1964-01-01 End date: 2002-01-01 Supplemental Information: Language: In English;
▲ Return To Top

Content info:

Feature catalogue description: Included with dataset: false Feature catalogue citation: Citation: Title: Entity and Attribute Information Date: Other citation details:
▲ Return To Top

DISTRIBUTION INFO:

Distribution: Distributor: Distributor: Distributor contact: Responsible party: Organisation name: Alberta Geological Survey Position name: AGS Information Manager Contact info: Contact: Phone: Telephone: Voice: (780) 638-4491 Facsimile: (780) 422-1918 Address: Address: Delivery point: Alberta Energy Regulator Delivery point: 4th Floor, Twin Atria Building Delivery point: 4999-98 Avenue NW City: Edmonton Administrative area: Alberta Postal code: T6B 2X3 Country: Canada 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. Role: Role code: distributor Transfer options: Digital transfer options: Online: Online Resource: Linkage: URL: https://static.ags.aer.ca/files/document/DIG/DIG_2014_0012.zip Name: Tabular Data
▲ Return To Top

Data quality info:

Data quality: Scope: Scope: Hierarchy level: Scope code: dataset Report: Absolute external positional accuracy: Name of measure: Horizontal Positional Accuracy Measure description: Evaluation method description: Location accuracy of holes varies widely throughout this dataset, ranging from +/- 25 - 400 m. Each hole is tagged with the compiler's estimate of its positional precision, as values in the Boreholes table's [Spatial_Precision] field. Result: Quantitative result: Value unit: Base unit: Identifier: Units system: xlink: http://www.bipm.org/en/si/ Value: Report: Absolute external positional accuracy: Name of measure: Vertical Positional Accuracy Measure description: Evaluation method description: There are many sources of uncertainty associated with depth accuracy of borehole data and a full discussion is beyond the scope of this document. Depth accuracy is a function of drilling method, sampling/drilling interval size, and experience and judgement of the logging geologist. Most of the interval data in this data set is recorded as it appears on the original log with the following exceptions. In instances where the amount of core recovered is greater or less than the drilled depth, adjustments were made to described interval top and bottom depths. This adjustment was made to intervals of data source IDs 2, 3, 4, 5, 6, 7, 33 and 36. Result: Quantitative result: Value unit: Base unit: Identifier: Units system: xlink: http://www.bipm.org/en/si/ Value: Report: Completeness commission: Result: unknown Report: Completeness omission: Evaluation method description: These data comprise approximately 3.5% of the total number of holes drilled by the AGS since 1920. We intend to publish further sets as we complete the digitization of the remaining holes. Result: unknown Report: Conceptual consistency: Measure description: This is a compilation of data from many project sources. Project areas may overlap. Only boreholes that could be located with confidence are included in this dataset, including holes re-drilled at a given location because of drilling difficulties. No attempt has been made to standardize attribute values within and among project datasets. Log data are the observations of many different geologists over many decades. Result: unknown Report: Non quantitative attribute accuracy: Measure description: Attribute values were checked periodically during the digitization process using query tools in MS Access, by spell-checking in MS Excel, and visual inspection of check plots of strip logs produced using ViewLog software. Where possible, constraints were placed on attribute domains to minimize digitizing errors. Result: inapplicable Lineage: Lineage: Statement: These data comprise approximately 3.5% of the total number of holes drilled by the AGS since 1920. We intend to publish further sets as we complete the digitization of the remaining holes. Process step: Process step: Description: Two source data types were processed: 1. Unpublished, paper files: Source data included paper borehole logs and maps on file with AGS staff. Logs were scanned to PDF and named according to borehole number on the log, with prefix "Litholog_". 2. Logs previously published in PDF format: The following SourceIDs have been previously published by AGS or other journals: 2, 3, 4, 5, 7, 58. Individual logs were saved to PDF and named according to borehole number on the log, with prefix "Litholog_". Date and time: 2010-01-01T00:00:00 Process step: Process step: Description: Some borehole data had been digitized before the start of this project for use in other AGS studies. Borehole locations not already in digital format were compiled in ArcGIS from scanned maps, georeferenced using the digital provincial township fabric as a base. In many cases the maps showing hole locations are inaccurate at larger scales, which results in holes plotting in the middle of cultivated fields. In such unlikely cases hole positions were refined by manually placing them at the nearest road intersection, which is logically where a drill rig would have been sited. We also used SPOT 2008 imagery as a backdrop in ArcGIS to better place the hole within an LSD or quarter section. Borehole attribute information was compiled in Excel and loaded into MS Access. Date and time: 2010-01-01T00:00:00 Process step: Process step: Description: Descriptive data of geologic intervals were typed into MS Excel, then uploaded to MS Access. Data were checked and corrected where necessary by plotting strip logs of the interval data using ViewLog software. Date and time: 2012-01-01T00:00:00 Source: Source: Description: Source Contribution: Peace River, 1995 project holesonline Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: Preliminary Stratigraphic Tests to Support Mineral Exploration: Northern Alberta Alternate title: SourceID 5 Date: Date: Date: 1996-01-31 Date type: Date type code: publication Edition: Cited responsible party: Responsible party: Organisation name: Alberta Energy Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Pawlowicz, J.G. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Jean, G.M. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Fenton, M.M. Role: Role code: resourceProvider Presentation form: Presentation form code: documentDigital Series: Series: Name: Open File Report Issue identification: OFR 1995-11 Other citation details: Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 1995-01-01 Source: Source: Description: Source Contribution: High Level, 1993 project holesonline Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: Reconnaissance Till Mineral and Geochemical Survey with Emphasis on Northern Alberta; Project Final Report Alternate title: SourceID 4 Date: Date: Date: 1998-01-01 Date type: Date type code: publication Edition: Cited responsible party: Responsible party: Organisation name: Alberta Energy and Utilities Board Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Fenton, M.M. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Pawlowicz, J.G. Role: Role code: resourceProvider Presentation form: Presentation form code: documentDigital Series: Series: Name: Open File Report Issue identification: OFR 1996-07 Other citation details: Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 1993-01-01 Source: Source: Description: Source Contribution: Red Earth, 1997 project holesonline Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: Auger Core Lithologs from the Wabasca/Red Earth Area, North-Central Alberta Alternate title: SourceID 2 Date: Date: Date: 1998-04-03 Date type: Date type code: publication Edition: Cited responsible party: Responsible party: Organisation name: Alberta Energy and Utilities Board Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Pawlowicz, J.G. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Fenton, M.M. Role: Role code: resourceProvider Presentation form: Presentation form code: documentDigital Series: Series: Name: Open File Report Issue identification: OFR 1998-03 Other citation details: Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 1997-01-01 Source: Source: Description: Source Contribution: Wabasca, 1998 project holesonline Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: Auger Core Descriptions, 1998 Drilling, Peerless Lake Map Sheet (NTS 84B), North-Central Alberta Alternate title: SourceID 7 Date: Date: Date: 1998-12-09 Date type: Date type code: publication Edition: 1.1 Cited responsible party: Responsible party: Organisation name: Alberta Energy and Utilities Board Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Pawlowicz, J.G. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Meeks, J.O. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Fenton, M.M. Role: Role code: resourceProvider Presentation form: Presentation form code: documentDigital Series: Series: Name: Open File Report Issue identification: OFR 1998-09 Other citation details: Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 1998-01-01 Source: Source: Description: Source Contribution: Buffalo Head Hills/Sawn Lake, 2002 project holesonline Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: Auger Core Lithologs, Sawn Lake area, Southern Buffalo Head Hills, Alberta Alternate title: Source ID 3 Date: Date: Date: 2005-01-01 Date type: Date type code: publication Edition: Cited responsible party: Responsible party: Organisation name: Alberta Energy and Utilities Board Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Alberta Geological Survey Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Pawlowicz, J.G. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Fenton, M.M. Role: Role code: resourceProvider Cited responsible party: Responsible party: Organisation name: Weiss, J.A. Role: Role code: resourceProvider Presentation form: Presentation form code: documentDigital Series: Series: Name: Geo-Note Issue identification: GEO 2005-07 Other citation details: Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 2002-01-01 Source: Source: Description: Source Contribution: Fort McMurray Gypsum Testholes, 1968 projectpaper Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: Subsurface Gypsum Deposits Near Fort McMurray, Alberta Alternate title: SourceID 58 Date: Date: Date: 1969-01-01 Date type: Date type code: publication Edition: Cited responsible party: Responsible party: Organisation name: Hamilton, W.N. Role: Role code: resourceProvider Presentation form: Presentation form code: documentDigital Series: Series: Name: Issue identification: Other citation details: CIM Bulletin vol. 62, No. 691, p. 1193-1202. Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 1968-01-01 Source: Source: Description: Source Contribution: Used to refine borehole locations within Township fabric.online Scale: Representative fraction: Denominator: 0 Source citation: Citation: Title: SPOT Imagery Alternate title: SPOT 2008 imagery Date: Date: Date: 2008-01-01 Date type: Date type code: publication Edition: Presentation form: Presentation form code: mapDigital Series: Series: Name: Issue identification: Other citation details: 2.5 m resolution, GeoTiff format Source extent: Extent: Temporal element: Temporal extent: Extent: Time instant: Description: ground condition Time position: 2008-01-01
▲ Return To Top

Metadata constraints:

Legal constraints: Access constraints: Restriction code: otherRestrictions Use constraints: Restriction code: otherRestrictions Other constraints: Metadata Access Constraints: none Metadata Use Constraints: none
▲ Return To Top

Metadata maintenance:

Maintenance information: Maintenance and update frequency: unknown Maintenance note: This metadata was automatically generated from the FGDC Content Standard for Digital Geospatial Metadatastandard version FGDC-STD-001-1998 using the January 2013 version of the FGDC CSDGM to ISO 19115-2 transform. Metadata author: Responsible party: Organisation name: Alberta Geological Survey Position name: AGS Information Manager Contact info: Contact: Phone: Telephone: Voice: (780) 638-4491 Facsimile: (780) 422-1918 Address: Address: Delivery point: Alberta Energy Regulator Delivery point: 4th Floor, Twin Atria Building Delivery point: 4999-98 Avenue NW City: Edmonton Administrative area: Alberta Postal code: T6B 2X3 Country: Canada 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. Role: Role code: custodian
▲ Return To Top