DBO.sask_drillhole_db

SDE Feature Class

Thumbnail Not Available

Tags
drill hole


Summary

This dataset contains information extracted from the Saskatchewan Drillhole Database and includes basic location and downhole data. 

Description

            

Description:

This dataset comprises information about drillholes collared in Saskatchewan. Its data has been derived from drilling projects associated with exploration, development, production and/or research of the provinces resources, including the drilling for metallic or industrial minerals, precious stones, building materials, coal, peat, petroleum, gas or geoscience purposes. This layer (feature class) has been symbolized on the basis of where the drillcore is stored. Government of Saskatchewan (GOS) assets stored at the ‘Regina Subsurface Laboratory’ and the ‘La Ronge Precambrian Lab’ may be accessed by the public.  Note that some drilling methods are not designed for core recovery and although these records will not have a storage location defined in the “Storage Location” field, they are included in this dataset and part of the ‘other’ symbol category.

This drillhole dataset is extracted quarterly from the Saskatchewan Drillhole Database, which undergoes continuous updates as a result of additions due to the expiry of confidentiality periods, additions of historic datasets, as well as updates and corrections to previous entries as part of quality assurance and quality controls processes. Generally, only non-licensed potash and petroleum and gas wells are present in this dataset. For information related to licensed wells (GOS, IRIS database), refer to the Oil and Gas section of the Saskatchewan Mining and Petroleum GeoAtlas.

Credits

Saskatchewan Geological Survey

Use limitations

Extent

West  -111.764941    East  -100.611347
North  60.007658    South  48.888816

Scale Range
Maximum (zoomed in)  1:5,000
Minimum (zoomed out)  1:150,000,000

ArcGIS Metadata 

Topics and Keywords 

Themes or categories of the resource  geoscientificInformation


*Content type  Downloadable Data
Export to FGDC CSDGM XML format as Resource Description No

Citation 

*Title DBO.sask_drillhole_db


Presentation formats* digital map


Citation Contacts 

Responsible party
Individual's name Saskatchewan Geological Survey
Organization's name Government of Saskatchewan
Contact's role  custodian


Contact information
Phone
Voice 855-219-9373

Address
Type both
Delivery point 610-1945 Hamilton Street
City Regina
Administrative area Saskatchewan
Postal code S4P2C7
Country CA
e-mail addresser.servicedesk@gov.sk.ca



Locales 

Locale English (UNITED STATES)


Resource Details 

Dataset languages* English (UNITED STATES)
Dataset character set  utf8 - 8 bit UCS Transfer Format


Spatial representation type* vector


*Processing environment  Version 6.2 (Build 9200) ; Esri ArcGIS 10.9.1.28388


Credits
Saskatchewan Geological Survey

ArcGIS item properties
*Name DBO.sask_drillhole_db
*Location Server=itovmw565p; Service=sde:sqlserver:itovmw565p; Database=GEOLOGY; User=GEOLOGY; Version=sde.DEFAULT
*Access protocol ArcSDE Connection

Extents 

Extent
Vertical extent
*Minimum value 0.000000
*Maximum value 1071.000000


Extent
Geographic extent
Bounding rectangle
Extent type  Extent used for searching
*West longitude -111.764941
*East longitude -100.611347
*North latitude 60.007658
*South latitude 48.888816
*Extent contains the resource Yes

Extent in the item's coordinate system
*West longitude 121213.000000
*East longitude 745152.060000
*South latitude 5427984.000000
*North latitude 6652264.000000
*Extent contains the resource Yes

Resource Points of Contact 

Point of contact
Individual's name Saskatchewan Geological Survey
Organization's name Government of Saskatchewan
Contact's role  custodian


Contact information
Phone
Voice 855-219-9373

Address
Type both
Delivery point 610-1945 Hamilton Street
City Regina
Administrative area Saskatchewan
Postal code S4P2C7
Country CA
e-mail addresser.servicedesk@gov.sk.ca



Resource Maintenance 

Resource maintenance
Update frequency  irregular


Spatial Reference 

ArcGIS coordinate system
*Type Projected
*Geographic coordinate reference GCS_North_American_1983_CSRS
*Projection NAD_1983_CSRS_UTM_Zone_13N
*Coordinate reference details
Projected coordinate system
Well-known identifier 2151
X origin -5120900
Y origin -9998100
XY scale 10000
Z origin -100000
Z scale 10000
M origin 0
M scale 1
XY tolerance 0.001
Z tolerance 0.001
M tolerance 0.001
High precision true
Latest well-known identifier 2957
VCSWKID  115757
LatestVCSWKID  115757
Well-known text PROJCS["NAD_1983_CSRS_UTM_Zone_13N",GEOGCS["GCS_North_American_1983_CSRS",DATUM["D_North_American_1983_CSRS",SPHEROID["GRS_1980",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.0174532925199433]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000.0],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-105.0],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0.0],UNIT["Meter",1.0],AUTHORITY["EPSG",2957]],VERTCS["North_American_1983_CSRS",DATUM["D_North_American_1983_CSRS",SPHEROID["GRS_1980",6378137.0,298.257222101]],PARAMETER["Vertical_Shift",0.0],PARAMETER["Direction",1.0],UNIT["Meter",1.0],AUTHORITY["Esri",115757]]

Reference system identifier
*Value 2957
*Codespace EPSG
*Version 6.11(9.3.0.0)


Spatial Data Properties 

Vector
*Level of topology for this dataset  geometry only


Geometric objects
Feature class name DBO.sask_drillhole_db
*Object type  point
*Object count 28593



ArcGIS Feature Class Properties
Feature class name DBO.sask_drillhole_db
*Feature type Simple
*Geometry type Point
*Has topology FALSE
*Feature count 28593
*Spatial index TRUE
*Linear referencing FALSE



Distribution 

Distribution format
*Name SDE Feature Class


Fields 

Details for object DBO.sask_drillhole_db 
*Type Feature Class
*Row count 28593


Field OBJECTID
 
*Alias OBJECTID
*Data type OID
*Width 4
*Precision 10
*Scale 0
*Field description
Internal feature number.

*Description source
Esri

*Description of values
Sequential unique whole numbers that are automatically generated.





Field Shape
 
*Alias SHAPE
*Data type Geometry
*Width 4
*Precision 0
*Scale 0
*Field description
Feature geometry.

*Description source
Esri

*Description of values
Coordinates defining the features.





Field GOS_Unique_Drillhole_ID
 
*Alias GOS_Unique_Drillhole_ID
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Drillhole identification number specific to Government of Saskatchewan. 



Field DrillHole_Name
 
*Alias DrillHole_Name
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Name of drillhole supplied by company



Field Source
 
*Alias Source
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Source of the drill hole's information. 



Field Company
 
*Alias Company
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Name of company that did the drilling. 



Field Project_or_Property_Name
 
*Alias Project_or_Property_Name
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Project name or Property Name.



Field Date_Drilled
 
*Alias Date_Drilled
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Date of drilling



Field Easting_UTM
 
*Alias Easting_UTM
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
UTM Easting NAD83 Zone 13



Field Northing_UTM
 
*Alias Northing_UTM
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
UTM Northing NAD83 Zone13



Field Original_Collar_Elevation_m
 
*Alias Original_Collar_Elevation_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Original collar elevation in meters



Field Elev_Corrected_1arcsec_DEM_m
 
*Alias Elev_Corrected_1arcsec_DEM_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Corrected collar elevation using DEM surface in meters.



Field Total_DH_Length_m
 
*Alias Total_DH_Length_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Total drill hole length in meters



Field DH_Inclination
 
*Alias DH_Inclination
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Inclination of drill hole



Field DH_Azimuth
 
*Alias DH_Azimuth
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Azimuth of drill hole



Field Disposition
 
*Alias Disposition
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Mineral disposition number



Field DH_Core_Size
 
*Alias DH_Core_Size
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Core size of drill hole



Field Drill_Type
 
*Alias Drill_Type
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Drill type. 



Field Wedge_Hole
 
*Alias Wedge_Hole
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Wedge Hole



Field Underground_Hole
 
*Alias Underground_Hole
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Underground Hole



Field Base_of_Quaternary_Depth_m
 
*Alias Base_of_Quaternary_Depth_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Base of quaternary depth in meters



Field Base_of_Quaternary_Elev_m
 
*Alias Base_of_Quaternary_Elev_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Base of quaternary elevation in meters



Field Base_of_Phanerozoic_Depth_m
 
*Alias Base_of_Phanerozoic_Depth_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Base of the Phanerozoic depth in meters



Field Base_of_Phanerozoic_Elev_m
 
*Alias Base_of_Phanerozoic_Elev_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Base of the Phanerozoic Elevation in meters



Field Base_of_Athabasca_SG_Depth_m
 
*Alias Base_of_Athabasca_SG_Depth_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Base of the Athabasca Super Group depth in meters



Field Base_of_Athabasca_SG_Elev_m
 
*Alias Base_of_Athabasca_SG_Elev_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Base of the Athabasca Super Group elevation in meters



Field Top_Crystalline_Bsmt_Depth_m
 
*Alias Top_Crystalline_Bsmt_Depth_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Top of the crystalline basement depth in meters



Field Top_Crystalline_Bsmt_Elev_m
 
*Alias Top_Crystalline_Bsmt_Elev_m
*Data type Double
*Width 8
*Precision 38
*Scale 8
Field description
Top of the Crystalline Basement elevation in meters.



Field Commodity_of_Interest
 
*Alias Commodity_of_Interest
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Commodity of interest



Field Storage_Locations
 
*Alias Storage_Locations
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Storage locations



Field Storage_Locations_Legend
 
*Alias Storage_Locations_Legend
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Storage location field for symbology



Field CoreStorageDetails
 
*Alias CoreStorageDetails
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Core storage details



Field CoreAvailability
 
*Alias CoreAvailability
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Core availability



Field AddedToLibrary
 
*Alias AddedToLibrary
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Added to the core library



Field Core_Library_m
 
*Alias Core_Library_m
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Core library depth in meters



Field Core_Library_ft
 
*Alias Core_Library_ft
*Data type String
*Width 255
*Precision 0
*Scale 0
Field description
Core library depth in feet.





Metadata Details 

*Metadata language English (UNITED STATES)
Metadata character set  utf8 - 8 bit UCS Transfer Format


Metadata identifier C94F1702-FD13-43A6-B10C-AB273943BF64


Scope of the data described by the metadata* dataset
Scope name* dataset


*Last update 2026-03-25


ArcGIS metadata properties
Metadata format ArcGIS 1.0
Metadata style North American Profile of ISO19115 2003
Standard or profile used to edit metadata NAP


Created in ArcGIS for the item 2023-09-30 09:13:16
Last modified in ArcGIS for the item 2026-03-25 95:44:60


Automatic updates
Have been performed Yes
Last update 2023-08-31 13:34:13


Metadata Contacts 

Metadata contact
Individual's name Saskatchewan Geological Survey
Organization's name Government of Saskatchewan
Contact's role  custodian


Contact information
Phone
Voice 855-219-9373

Address
Type both
Delivery point 610-1945 Hamilton Street
City Regina
Administrative area Saskatchewan
Postal code S4P2C7
Country CA
e-mail addresser.servicedesk@gov.sk.ca



Metadata Maintenance 

Maintenance
Update frequency  annually


FGDC Metadata (read-only) 

Entities and Attributes 

Detailed Description
Entity Type
Entity Type LabelDBO.sask_drillhole_db

Attribute
Attribute LabelOBJECTID
Attribute Definition
Internal feature number.
Attribute Definition SourceEsri
Attribute Domain Values
Unrepresentable Domain
Sequential unique whole numbers that are automatically generated.

Attribute
Attribute LabelShape
Attribute Definition
Feature geometry.
Attribute Definition SourceEsri
Attribute Domain Values
Unrepresentable Domain
Coordinates defining the features.

Attribute
Attribute LabelGOS_Unique_Drillhole_ID
Attribute Definition
Drillhole identification number specific to Government of Saskatchewan.

Attribute
Attribute LabelDrillHole_Name
Attribute Definition
Name of drillhole supplied by company

Attribute
Attribute LabelSource
Attribute Definition
Source of the drill hole's information.

Attribute
Attribute LabelCompany
Attribute Definition
Name of company that did the drilling.

Attribute
Attribute LabelProject_or_Property_Name
Attribute Definition
Project name or Property Name.

Attribute
Attribute LabelDate_Drilled
Attribute Definition
Date of drilling

Attribute
Attribute LabelEasting_UTM
Attribute Definition
UTM Easting NAD83 Zone 13

Attribute
Attribute LabelNorthing_UTM
Attribute Definition
UTM Northing NAD83 Zone13

Attribute
Attribute LabelOriginal_Collar_Elevation_m
Attribute Definition
Original collar elevation in meters

Attribute
Attribute LabelElev_Corrected_1arcsec_DEM_m
Attribute Definition
Corrected collar elevation using DEM surface in meters.

Attribute
Attribute LabelTotal_DH_Length_m
Attribute Definition
Total drill hole length in meters

Attribute
Attribute LabelDH_Inclination
Attribute Definition
Inclination of drill hole

Attribute
Attribute LabelDH_Azimuth
Attribute Definition
Azimuth of drill hole

Attribute
Attribute LabelDisposition
Attribute Definition
Mineral disposition number

Attribute
Attribute LabelDH_Core_Size
Attribute Definition
Core size of drill hole

Attribute
Attribute LabelDrill_Type
Attribute Definition
Drill type.

Attribute
Attribute LabelWedge_Hole
Attribute Definition
Wedge Hole

Attribute
Attribute LabelUnderground_Hole
Attribute Definition
Underground Hole

Attribute
Attribute LabelBase_of_Quaternary_Depth_m
Attribute Definition
Base of quaternary depth in meters

Attribute
Attribute LabelBase_of_Quaternary_Elev_m
Attribute Definition
Base of quaternary elevation in meters

Attribute
Attribute LabelBase_of_Phanerozoic_Depth_m
Attribute Definition
Base of the Phanerozoic depth in meters

Attribute
Attribute LabelBase_of_Phanerozoic_Elev_m
Attribute Definition
Base of the Phanerozoic Elevation in meters

Attribute
Attribute LabelBase_of_Athabasca_SG_Depth_m
Attribute Definition
Base of the Athabasca Super Group depth in meters

Attribute
Attribute LabelBase_of_Athabasca_SG_Elev_m
Attribute Definition
Base of the Athabasca Super Group elevation in meters

Attribute
Attribute LabelTop_Crystalline_Bsmt_Depth_m
Attribute Definition
Top of the crystalline basement depth in meters

Attribute
Attribute LabelTop_Crystalline_Bsmt_Elev_m
Attribute Definition
Top of the Crystalline Basement elevation in meters.

Attribute
Attribute LabelCommodity_of_Interest
Attribute Definition
Commodity of interest

Attribute
Attribute LabelStorage_Locations
Attribute Definition
Storage locations

Attribute
Attribute LabelStorage_Locations_Legend
Attribute Definition
Storage location field for symbology

Attribute
Attribute LabelCoreStorageDetails
Attribute Definition
Core storage details

Attribute
Attribute LabelCoreAvailability
Attribute Definition
Core availability

Attribute
Attribute LabelAddedToLibrary
Attribute Definition
Added to the core library

Attribute
Attribute LabelCore_Library_m
Attribute Definition
Core library depth in meters

Attribute
Attribute LabelCore_Library_ft
Attribute Definition
Core library depth in feet.