Compilation of Alberta Geological Survey Borehole Data (tabular data, tab delimited format)

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.

Datasets available for download

Additional Info

Field Value
Last Updated October 22, 2024, 15:43 (UTC)
Created October 1, 2024, 07:29 (UTC)
Domain / Topic
Domain or topic of the dataset being cataloged.
Geoscientific Information
Description
A description of the dataset.

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.
Tags
Keywords/tags categorizing the dataset.
Format (CSV, XLS, TXT, PDF, etc)
File format of the dataset.
Dataset Size
Dataset size in megabytes.
Metadata Identifier
Metadata identifier – can be used as the unique identifier for catalogue entry
Published Date
Published date of the dataset.
2014-06-04
Time Period Data Span (start date)
Start date of the data in the dataset.
Time Period Data Span (end date)
End date of time data in the dataset.
GeoSpatial Area Data Span
A spatial region or named place the dataset covers.
Field Value
Access category
Type of access granted for the dataset (open, closed, service, etc).
License
License used to access the dataset.
Open Government Licence - Alberta
Limits on use
Limits on use of data.
Location
Location of the dataset.
Data Service
Data service for accessing a dataset.
Owner
Owner of the dataset.
Government of Alberta | Gouvernement de l'Alberta
Contact Point
Who to contact regarding access?
Alberta Energy Regulator
Contact Point Email
The email to contact regarding access?
Publisher
Publisher of the dataset.
Publisher Email
Email of the publisher.
AGS-Info@aer.ca
Accessed At
Date the data and metadata was accessed.
Field Value
Identifier
Unique identifier for the dataset.
Language
Language(s) of the dataset
Link to dataset description
A URL to an external document describing the dataset.
Persistent Identifier
Data is identified by a persistent identifier.
Globally Unique Identifier
Data is identified by a persistent and globally unique identifier.
Contains data about individuals
Does the data hold data about individuals?
Contains data about identifiable individuals
Does the data hold identifiable data about individual?
Contains Indigenous Data
Does the data hold data about Indigenous communities?
Field Value
Source
Source of the dataset.
https://open.canada.ca/data/en/dataset/4bf7cf6b-5ac8-4f66-bcff-3d3b56bb1df8
Version notes
Version notes about the dataset.
Is version of another dataset
Link to dataset that it is a version of.
Other versions
Link to datasets that are versions of it.
Provenance Text
Provenance Text of the data.
Provenance URL
Provenance URL of the data.
Temporal resolution
Describes how granular the date/time data in the dataset is.
GeoSpatial resolution in meters
Describes how granular (in meters) geospatial data is in the dataset.
GeoSpatial resolution (in regions)
Describes how granular (in regions) geospatial data is in the dataset.
Field Value
Indigenous Community Permission
Who holds the Indigenous Community Permission. Who to contact regarding access to a dataset that has data about Indigenous communities.
Community Permission
Community permission (who gave permission).
The Indigenous communities the dataset is about
Indigenous communities from which data is derived.
Field Value
Number of data rows
If tabular dataset, total number of rows.
Number of data columns
If tabular dataset, total number of unique columns.
Number of data cells
If tabular dataset, total number of cells with data.
Number of data relations
If RDF dataset, total number of triples.
Number of entities
If RDF dataset, total number of entities.
Number of data properties
If RDF dataset, total number of unique properties used by the triples.
Data quality
Describes the quality of the data in the dataset.
Metric for data quality
A metric used to measure the quality of the data, such as missing values or invalid formats.

0 Comments

Please login or register to comment.