The National Geotechnical Properties Database (NGPD) primarily holds data and information from commercial site investigations carried out for civil engineering purposes. This includes borehole details, lithological description, field and laboratory geotechnical tests, engineering and environmental chemical testing. A full description of the database structure and field can be found in our report, ‘The structure and operation of the BGS National Geotechnical Properties Database V2’.
The final investigation data and information are supplied to BGS by clients, consultants and contractors either as final paper records or as Association of Geotechnical and Geoenvironmental Specialists (AGS) digital data transfer format files. AGS digital data transfer format files are the preferred method of receiving data because they can be added to the database much more quickly and accurately than adding data by hand from paper records. Much of the data are from site investigations for major trunk road construction schemes, often provided by Highways England (formerly the Highways Agency) and other major engineering projects. A small proportion of the data are from BGS laboratory test results. Please contact enquiries for advice on depositing your data. (Also see below for protocol.)
The distribution of our data holdings (Figure 1) often follows major UK infrastructure developments and the coverage of our research including UK Rocks and Soils Engineering Geology studies or the areas covered by Ground Information for Sustainable Development and Geohazards projects. Our engineering geology studies include collation and analysis of the geotechnical properties in to technical reports covering formations important to strategic UK development and construction. These can be downloaded from this site and include:
In the mid-1980s to the early 1990s data were stored in a series of flat file geotechnical datasets (paper then spreadsheet) generated for the applied geology mapping projects of urban areas; funded by the then Department of the Environment. These were inefficient to use and difficult to manage. The availability of personal computers and networking enabled the decision to create and populate a relational database. This is now the National Geotechnical Properties Database with 54 data tables and 33 dictionary tables. The dictionary tables are used to define and constrain fields in the database that describe the project, boreholes, core and any in-hole or laboratory test information relating to the material investigated.
Figure 2 outlines the design of the database, which is a hierarchical structure currently based on the AGS industry standard for Electronic Transfer of Geotechnical and Geoenvironmental Data version 3.1. The database contains data relating to the project, the boreholes and pits within the report (including British National Grid Reference), in-situ measurements (including geology with full text description) and laboratory results of tests on samples.
The database contains records for 7370 projects (Site Investigation Reports). Linked to the reports are 178 436 Holes. There are a total of 3 617 186 in situ field records linked to the Holes. There are 879 293 samples linked to the Holes with a total of 5 180 330 laboratory test data records.
Lithology and lithostratigraphy codes are populated for the geological interval in the geology table (incorporated within the database structure – ‘GEOLOGY’ in Figure 2). They are extracted from the AGS files where available, or added by BGS geologists where not available. Some of the original codes supplied by contractors may be changed in the geology table by BGS geologists as part of our QA procedures, ensuring standard formats are maintained and promoting property attribution to geological stratigraphy.
The information within the database forms the basis for the geotechnical attribution of 2D and 3D digital geological models and underpins our core and commissioned engineering geology research.
Statistical analysis is performed on the data, for example to assess property variation with depth, which are provided in our technical reports in the form of geotechnical property distributions across different depositional basins of some of the UK’s key formations. (For details of the statistical analysis techniques see HALLAM, J R. 1990. The statistical analysis and summarisation of geotechnical databases. British Geological Survey Technical Report, WN/90/16.) Presentation of the data from the NGPD can be customised for each specific application, as in Figure 3, which shows:
- property distribution summaries in box and whisker form;
- index property classifications on standard charts (A-Line-Plasticity; Particle Size)
- interpreted geological sections
The data has been used for:
- engineering geology of British rocks and soils;
- ground information for sustainable development primarily in Glasgow, London and Manchester;
- geohazards projects;
- regional geotechnical and hydrogeological assessments;
- BGS ground conditions (resistivity, pipe leakage impacts, corroded asset failure and BGS Civils – bulking volume, corrosivity, engineered fill, foundation conditions, strength, sulfate/sulfide);
- georeports and enquiries.
In order to further improve the national coverage of the database and its usefulness, BGS would be very grateful to receive site investigation data in AGS file format. Deposit your AGS data using the Data Deposit Portal. In order to increase the usefulness of the data even further there is an option when depositing the data for it to be deposited as Open Access to allow it to be shared with 3rd parties.
You may also be interested in:
Research undertaken within BGS may require unique equipment that is not available commercially, often because the application is entirely novel and provides an innovative solution. The R&D Engineering Facility fills this gap with its conceptualising, designing, testing and manufacturing services based on the BGS campus at Keyworth.