The PIN geotechnical borehole database currently includes data from the following published reports:

Chartrand, J; Lysyshyn, K; Couture, R; Robinson, S; Burgess, M. 2002. Digital geotechnical borehole databases and viewers for Norman Wells and Tuktoyaktuk, Northwest Territories. Geological Survey of Canada, Open File 3912, 2002; 1 CD-ROM, https://doi.org/10.4095/213818;

EBA Engineering Consultants Ltd. Canada. 1989. ESEBase borehole/testpit database, north Alaska Highway corridor (km 1748 - km 1966, Alaska Highway, Yukon). Indian and Northern Affairs Canada [Sponsor]. 600 p. http://pubs.aina.ucalgary.ca/gran/33585.pdf;

Smith, S L; Burgess, M M; Chartrand, J; Lawrence, D E. 2005. Digital borehole geotechnical database for the Mackenzie Valley/Delta region. Geological Survey of Canada, Open File 4924, 2005, 30 pages; 1 CD-ROM, https://doi.org/10.4095/220383;

Smith, S L; Chartrand, J; Nguyen, T -N; Riseborough, D W; Ednie, M; Ye, S. 2009. Geotechnical database and descriptions of permafrost monitoring sites established 2006-07 in the central and southern Mackenzie Corridor. Geological Survey of Canada, Open File 6041, 2009, 188 pages; 1 CD-ROM, https://doi.org/10.4095/226435;

Wolfe, S A; Smith, S L; Chartrand, J; Kokelj, S; Palmer, M; Stevens, C W. 2010. Geotechnical database and descriptions of permafrost monitoring sites established 2006-2010 in the northern Mackenzie Corridor, Northwest Territories. Geological Survey of Canada, Open File 6677, 2010, 81 pages; 1 CD-ROM, https://doi.org/10.4095/287167

Her Majesty the Queen in right of Canada, as represented by the Minister of Natural Resources

(""Canada""), does not warrant or guarantee the accuracy or completeness of the information

(""Data"") and does not assume any responsibility or liability with respect to any damage or loss

arising from the use or interpretation of the Data. The Data should not be used for design or construction at any specific location, nor are the Data to be used as a replacement for the types of site-specific geotechnical investigations.

Data sources for PIN database:

Chartrand, J; Lysyshyn, K; Couture, R; Robinson, S; Burgess, M. 2002. Digital geotechnical borehole databases and viewers for Norman Wells and Tuktoyaktuk, Northwest Territories. Geological Survey of Canada, Open File 3912, 2002; 1 CD-ROM, https://doi.org/10.4095/213818

EBA Engineering Consultants Ltd. Canada. 1989. ESEBase borehole/testpit database, north Alaska Highway corridor (km 1748 - km 1966, Alaska Highway, Yukon). Indian and Northern Affairs Canada [Sponsor]. 600 p. http://pubs.aina.ucalgary.ca/gran/33585.pdf

Smith, S L; Burgess, M M; Chartrand, J; Lawrence, D E. 2005. Digital borehole geotechnical database for the Mackenzie Valley/Delta region. Geological Survey of Canada, Open File 4924, 2005, 30 pages; 1 CD-ROM, https://doi.org/10.4095/220383

Smith, S L; Chartrand, J; Nguyen, T -N; Riseborough, D W; Ednie, M; Ye, S. 2009. Geotechnical database and descriptions of permafrost monitoring sites established 2006-07 in the central and southern Mackenzie Corridor. Geological Survey of Canada, Open File 6041, 2009, 188 pages; 1 CD-ROM, https://doi.org/10.4095/226435

Wolfe, S A; Smith, S L; Chartrand, J; Kokelj, S; Palmer, M; Stevens, C W. 2010. Geotechnical database and descriptions of permafrost monitoring sites established 2006-2010 in the northern Mackenzie Corridor, Northwest Territories. Geological Survey of Canada, Open File 6677, 2010, 81 pages; 1 CD-ROM, https://doi.org/10.4095/287167

Processing:

For all source databases:

-Converted UTM coordinates (NAD27) to Lat/Long (NAD83 CSRS) using the NRCan National Transformation tool v2 (http://webapp.geod.nrcan.gc.ca/geod/tools-outils/ntv2.php)

- Standardized all date formats to YYYY-MM-DD in tblWHO, tblTEMP_PROFILE, tblTEMPERATURE_ENVELOPES, tblACTIVE_LAYER

- Added column soil_type_2 to main database. This column is a recoded, standardized version of the original SOIL_TYPE column in the database for visual representation purposes in the online borehole viewer. The original field has been kept to preserve important sample information

Chartrand et al. (2002)

-Added prefix 'TUK' to all Tuktoyaktuk borehole names prior to entry in the main database

-Added prefiex 'NW' to all Norman Wells borehole names prior to entry in the main database

-Converted bulk density field from g/cm3 to kg/m3

-Updated USC for these databases based on the value of soil_type_2

EBA engineering (1989)

-Added suffix "_INAC" to all boreholes

Smith et al. (2005)

-Removed n= XX from PENETRAT field, changed data type to numeric

-Removed character codes in the IND_PLA to leave only numeric values

Wolfe et al. (2010)

-Converted bulk densities from kg/L to kg/m3

Smith et al. (2009)

-Converted Method column from text to Method Codes 1,2,3,4,5,6,G as specified in Smith et al. (2005)

-Removed characters from PLA_LIMIT field, converted field to numeric

If discrepancies other than conversions exist between PIN database entries and the original database source, the original database source should be considered correct.