The Geotechnical Database contains information about site investigation reports, boreholes and samples. It contains geotechnical measurements taken over borehole intervals and on samples. Some of the data is obtained digitally from AGS files (Association of Geotechnical and Geoenvironmental Specialists - File Transfer Format), some is obtained manually from Site Investigation Reports stored in the National Geoscience Data Centre. The database currently contains geotechnical data from over 450 000 laboratory test samples and core descriptions, borehole observations and in situ tests from over 96 000 boreholes extracted from over 4800 site investigation reports. The database underpins BGS Geo-engineering properties and processes research and is an important information resource for answering enquiries and providing for the data needs of external customers.

The St. Louis area has experienced minor earthquake damage at least 12 times in the past 205 years. The St. Louis metropolitan area, with a population of about 2.8 million, faces earthquake hazard from large earthquakes in the New Madrid and Wabash Valley seismic zones, as well as a closer region of diffuse historical and prehistoric seismicity to its south and east. Also, low attenuation of seismic energy in the region and a substantial number of historic older unreinforced brick and stone buildings make the St. Louis area vulnerable to moderate earthquakes at relatively large distances compared to the western United States. This geotechnical database was compiled by James Palmer and others at the Missouri Department of Natural Resources as the product of a U.S. Geological Survey (USGS) Earthquake Hazards Program external grant through the National Earthquake Hazards Reduction Program (NEHRP) supporting urban seismic hazards mapping efforts for the St Louis metropolitan area (https://earthquake.usgs.gov/cfusion/external_grants/reports/05HQGR0019.pdf). The data in Tables.zip have been exported from the original Microsoft Access database and have been reviewed for completeness. See Appendix A in the aforementioned report for additional details. For archival purposes, the Microsoft Access database is also provided here, but the queries within have not been reviewed and the user assumes all responsibility.

The NGDC Seafloor Sediment Geotechnical Properties Database contains test engineering properties data coded by students at NGDC from primarily U.S. Naval Oceanographic Office laboratory reports, but also from data reports generated by NOAA's Atlantic Oceanographic and Meteorological Laboratory (AOML). These files consist of very few reports coded at NGDC into the historic "074" format which was then incorporated into the historic "073" digital format for physical properties of sediments. Coding was a test case, and full scale development of the data file was never undertaken.

This layer provides geotechnical readings associated with offshore sampling activities. It contains a variety of types of geotechnical measurements; these include shear and compressive strength. Expert advice may be required in the use of these data. Note that this layer contains data at depth. Related data in Offshore Sample Data - Activity & Scan collection.

The term “geotechnical investigation site” refers to locations where geotechnical (surveys and instrumentation) and geophysical data are available. This data includes: - Geotechnical investigation sites (site_inv_geotech_p) : Geotechnical surveys produced by or for the Ministry from the 1990s, from the active database of the Directorate of Geotechnics and Geology (DGG). Data is added as it is validated. - BDG geotechnical investigation sites (site_inv_geotech_bdg_p) : Geotechnical drilling and drilling from an “inactive” database entrusted to the DGG by the Ministry of Energy and Natural Resources (MERN), since the mid-1980s. These are drilling and survey data compiled by the MERN in the 70s and 80s for “predictive” or “geotechnical soil suitability” mapping campaigns.**This third party metadata element was translated using an automated translation tool (Amazon Translate).**

The New Jersey Department of Transportation (NJDOT) soil borings database provides you with the ability to search for boring location plans and boring logs using either a plain text search or interactive map interface. Additionally, you may download the standard submission template, and, if you work with NJDOT, you may submit your completed template for inclusion in the soil borings database.

The Urban Borehole Database (UBHDB) is a digital compilation of borehole records utilised in urban mapping, 3D geological modelling, and ground shaking studies by GNS Science. This database primarily utilises borehole records from the New Zealand Geotechnical Database (NZGD, www.nzgd.org.nz) and other records provided to GNS Science from engineering consulting companies as well as local government records. The UBHDB is a relational database and contains nine tables; eight down-hole data tables linked to a borehole location / collar table. Down-hole data includes: lithology (descriptions from borehole logs and interpretations of local formation for each down-hole interval), geochronology, shear vein tests, SPT (standard penetration test), structure (structural measurements), survey (borehole orientation), velocity (shear wave velocity), water (static water level measurements). Addition of new data is ongoing and the database is regularly maintained and used for hazard and mapping projects at GNS Science. Data from the NZGD are added to the database in areas of mapping and modelling projects; PDF records from the NZGD are digitised and appended to the database for use in GNS Science research projects.

DOI: https://doi.org/10.21420/XHB0-M968

Cite as: GNS Science. (2021). Urban Borehole Database [Data set]. GNS Science. https://doi.org/10.21420/XHB0-M968

The New Zealand Geotechnical Database is a data-sharing platform funded by MBIE and the Earthquake Commission, contributed to and accessed by technical professionals. The collection includes raw data comprising scientific and engineering properties of the ground conditions.

Results of geotechnical testing carried out, at various depth intervals, on shallow cores or boreholes collected by BGS from the UK Continental Shelf (UKCS). The bulk of the data north of 56N are in digital form and result from testing carried out onboard survey vessels using hand-held test equipment (penetrometers and shear vanes). These values are averaged for each test interval, and are expressed in kilopascals (kPa). There are approximately 6,000 test results in the dataset. Some more detailed test information, in non-digital and report form, is held for selected sites. For most sites where digital data are not available, geological descriptions of core material contain semi-quantitative information on the stiffness of the material. Geotechnical knowledge is required to understand and interpret the results if they are to be used as a basis for engineering studies. Core material is managed as part of the BGS materials collection and is available for examination, testing or subsampling. The data are stored as part of the National Geoscience Data Centre (NGDC) and the Marine Environmental Data and Information Network (MEDIN) Data Archive Centre (DAC) for geology and geophysics. Data are delivered via the 'Offshore samples: geotechnical data' layer on the BGS GeoIndex. Reference: Fannin, NGT. (1989) Offshore Investigations 1966-87. British Geological Survey Technical Report WB/89/2, British Geological Survey.

Vector-type georeferenced database, in a precise form, containing the main geotechnical parameters related to the geognostic surveys present in the Database. The geotechnical parameters were acquired from on-site tests during the realisation of the geognostic test, or were acquired following geotechnical analyses carried out on soil samples collected during the geognostic survey. These surveys are acquired throughout the entire regional territory, mainly of the plains, through pre-existing archival material: Regional technical maps with localisation of the evidence, data taken from original documents recovered or available for each test and tests of new realisation commissioned by the Area Geologia Soil and Seismic of the Emilia-Romagna Region.

Geotechnical data comes from investigations performed by geotechnical engineers to obtain information on the physical properties of soil and rock underlying a site for proposed structures. The investigations include surface exploration and subsurface exploration of a site. In addition, site investigations will often include subsurface sampling and laboratory testing of the soil samples retrieved. The digging of test pits and trenching may also be used to learn about soil conditions at depth. Geotechnical data is relevant to our permafrost database as it contains logs of ice encountered at various depths. Yukon Geological Survey has been compiling geotechnical data from various organizations and branches. The main datasets being compiled are the following:Northern Climate ExchangeCommunity Services, Land BranchEnergy Mines and Resources, Abandoned MinesTransportation Engineering BranchAlaska Highway Borehole DatabaseAgriculture soil profilesDistributed from GeoYukon by the Government of Yukon. Discover more digital map data and interactive maps from Yukon’s digital map data collection.For more information: geomatics.help@yukon.ca

Geotechnical investigations conducted in preparation for infrastructure development provide high-quality borehole data in standardised digital formats. In Denmark, such geotechnical borehole data are not required to be reported to the national well database (Jupiter) and are mainly archived in privately owned databases. Accessible interglacial and interstadial terrestrial deposits are rare in Denmark, and these borehole data have the potential to identify interglacial and interstadial deposits, with significant implications for ongoing palaeoclimate, palaeoenvironmental and archaeological research. In this study, we compiled data from six major geotechnical companies, resulting in a database with over 550 000 boreholes. From this database, we identified 1850 boreholes containing samples associated with interglacial and interstadial ages. Through extensive filtering for well-documented lacustrine or palustrine deposits, we selected 161 boreholes and referenced them to 39 different geographical occurrences. Of these 39 occurrences, 36 were either new terrestrial deposits or provided substantial new records to known interglacial and interstadial sites. Our findings demonstrate that access to these privately owned geotechnical borehole data can be a valuable resource for identifying rare near-surface geological deposits, allowing the discovery of several new Pleistocene sedimentary archives that warrant further investigation.

Before building new structures engineering companies carry out a site investigation to find out the quality of the ground (strength and depth of soil and to see if rock and or groundwater is present). These investigations involve digging holes such as trial pits and boreholes. The results are written up in a report. The reports usually contain details of the project, borehole logs, test results, site map with the location of the site, conclusions and recommendations for the design of the structure.A borehole is any hole drilled or dug into the ground. The material (soil and or rock) from the hole is collected and tested in a laboratory to find out the structure and type of the soil and or rock beneath the ground. A borehole record or log is a written description of the material that comes out of the ground as a result of drilling a borehole. Geotechnical boreholes are usually shallow (0-30m). Trial pits are usually very shallow (up to 4m deep) but cover a wider area. They also cost less.This map shows the location of the Geotechnical Site investigations and boreholes carried out in Ireland that have been submitted to the GSI from engineering companies.It is a vector dataset. Vector data portray the world using points, lines, and polygons (areas).The Site investigation data is shown as polygons. Each polygon holds information on: Report number (unique report ID), Title of the report, Town, County, URL (Link to download a PDF of the full report).The borehole data is shown as points. Each point holds information on: the location of the borehole (X and Y coordinates), the depth of the borehole (metres) and whether or not bedrock was found at the bottom of the hole.

Results of geotechnical testing carried out, at various depth intervals, on shallow cores or boreholes collected by BGS from the UK Continental Shelf (UKCS). The bulk of the data north of 56N are in digital form and result from testing carried out onboard survey vessels using hand-held test equipment (penetrometers and shear vanes). These values are averaged for each test interval, and are expressed in kilopascals (kPa). There are approximately 6,000 test results in the dataset. Some more detailed test information, in non-digital and report form, is held for selected sites. For most sites where digital data are not available, geological descriptions of core material contain semi-quantitative information on the stiffness of the material. Geotechnical knowledge is required to understand and interpret the results if they are to be used as a basis for engineering studies. Core material is managed as part of the BGS materials collection and is available for examination, testing or subsampling. The data are stored as part of the National Geoscience Data Centre (NGDC) and the Marine Environmental Data and Information Network (MEDIN) Data Archive Centre (DAC) for geology and geophysics. Data are delivered via the 'Offshore samples: geotechnical data' layer on the BGS GeoIndex. Reference: Fannin, NGT. (1989) Offshore Investigations 1966-87. British Geological Survey Technical Report WB/89/2, British Geological Survey.

Geotechnical data comes from investigations performed by geotechnical engineers to obtain information on the physical properties of soil and rock underlying a site for proposed structures. The investigations include surface exploration and subsurface exploration of a site. In addition, site investigations will often include subsurface sampling and laboratory testing of the soil samples retrieved. The digging of test pits and trenching may also be used to learn about soil conditions at depth. Geotechnical data is relevant to our permafrost database as it contains logs of ice encountered at various depths. Yukon Geological Survey has been compiling geotechnical data from various organizations and branches. The main datasets being compiled are the following: Northern Climate Exchange Community Services, Land Branch Energy Mines and Resources, Abandoned Mines Transportation Engineering Branch Alaska Highway Borehole Database Agriculture soil profiles Distributed from GeoYukon by the Government of Yukon . Discover more digital map data and interactive maps from Yukon's digital map data collection. For more information: geomatics.help@yukon.ca

The Permafrost Information Network (PIN) geotechnical borehole database combines existing database compilations into a standard structure. The standardized database was created to be accessible from the PIN web application as a data layer. Further information regarding data compilation can be accessed from the PIN web application.

Geotechnical reports are indexed within a database maintained by HPW-TEB Geotechnical Unit. Meta data associated to each geotechnical report are captured within this indexing table, including report reference number, title, author, highway and km start and end. The table has been modified to include columns that aid in georeferencing geotechnical reports. Added columns include route ID, Latitude, and Longitude. Transportation Engineering Branch is continually improving its geographical information systems with a major focus on creating linear referencing routes within ArcGIS. Georeferencing geotechnical reports will utilize the linear referencing routes in creating points and line shape files by referencing the highway number and km points or ranges as defined within the indexing table. Distributed from GeoYukon by the Government of Yukon. Discover more digital map data and interactive maps from Yukon’s digital map data collection.For more information: geomatics.help@yukon.ca

The term “geotechnical investigation site” refers to locations where geotechnical (surveys and instrumentation) and geophysical data are available. These data include: - Geotechnical investigation sites (site_inv_geotech_p) : Geotechnical surveys produced by or for the Ministry from the 1990s, from the active database of the Directorate of Geotechnics and Geology (DGG). Data is added as and when validated. - BDG geotechnical investigation sites (site_inv_geotech_bdg_p) : Geotechnical drilling and drilling from an “inactive” database entrusted to the DGG by the Ministry of Energy and Natural Resources (MERN), since the mid-1980s. These are drilling and survey data compiled by the MERN in the 70s and 80s for “predictive” or “geotechnical soil suitability” mapping campaigns.This third party metadata element was translated using an automated translation tool (Amazon Translate).

The CLAY-Cc/6/6203 database (Ching et al. 2022) covers 6 clay parameters, including liquid limit (LL), plasticity index (PI), water content (w), void ratio (e), compression index (Cc), and unloading-reloading index (Cur). This database contains 6203 clay records compiled from 429 studies, covering 55 countries/regions in 6 continents.

Ching, J., Phoon, K. K., and Wu, C. 2022. Data-centric quasi-site-specific prediction for compressibility of clays. Canadian Geotechnical Journal, 59(12), 2033-2049.

This dataset includes geotechnical reports available throughout Auckland Council systems. Geotechnical reports are written by suitably qualified and experienced geotechnical engineers or engineering geologists and include information on ground quality and subsurface geology. They are generally undertaken for infrastructure and building development or land use planningGeotechnical reports are received by council as part of consent applications, and are stored on the related property file. For each legacy council these records were located with the help of the document management team. Although spatial data was generated by property, the final database is not tagged to property parcels. Where feasible, detailed location polygons were generated using site maps available in the individual reports. In addition, some geotechnical reports are received by council for our own projects. These are also provided where available.This database was August 2020. All reports are available either on the Geotechnical Sharepoint or on ACCORD. Editing of this dataset can be done with the approval of Ross Roberts. geotechnical reports (i.e. tag them as Geotech and edit the GIS geometr, or a secondary process mayautomatically created property based geometry). Report data will be stored in OpenText/Accord, and will be flagged in SAPLineage: Data was extracted from legacy council databases sourced from:ACC/FDC Filenet ReportsNSCC Dataworks ReportsWCC Pathway ReportsRDC Pathway ReportsMCC Alchemy ReportsSAP Reports (2015-2019)ACGD Partner Reports (Watercare)These were evaluated to remove duplicate records, and associated with property records. Using property records a process was created for a one off load of the data (Geospatial team) using the property boundaries to create a base geometry. As one area may have several reports a separate related table was created to hold summary details of the reports. (Geotechnical Report Details)As some reports were not property based areas were manually digitised to indicate the extent of the report area.Future updates:As at this date the data is not yet updated - though it is intended that:The database will be updated whenever a new report is received. When a geotechnical report comes into council as part of a resource or building consent, the SAP team will need to follow the SAP protocol for In addition, new consent applications with geotechnical reports will be added, as will geotechnical reports undertaken for Auckland Council projects. Reports from other sources (e.g. CCOs, other crown entities) may be added where appropriate.