Urban Borehole 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
Simple
- Date (Creation)
- 2015-11-16
- Status
- On going
- Point of contact
-
Organisation name Individual name Electronic mail address Role GNS Science
Point of contact
- Maintenance and update frequency
- As needed
- Keywords
-
-
Borehole
-
Drill hole
-
Geotechnical
-
New Zealand Geotechnical Database
-
Ground water
-
Shear wave velocity
-
Lithology
-
Ground shaking
-
Urban mapping
-
3D modelling
-
- Classification
- Restricted
- Use constraints
- Restricted
- Other constraints
-
Significant interpretation and data-mining has been applied to publicly available borehole records that constitutes IP for GNS Science.
This database includes confidential borehole records that are not publicly available and that have been provided to GNS Science for research purposes only.
This database cannot be made publicly available without considering these notes.
- Denominator
- 5000
- Distance
- 0.5 0.5 m
- Language
- English
- Topic category
-
- Geoscientific information
- Environment
))
- Begin date
- 1927-01-07
- Distribution format
-
Name Version csv
Microsoft Access
PostgreSQL
- Hierarchy level
- Dataset
- Statement
-
• Boreholes are downloaded from the NZGD (www.nzgd.org.nz) as PDF files. These are for areas of interest for geological or hazard modelling.
• Data in the PDF are manually digitised (typed out) into an Excel template.
• The Excel template of new data is appended to the master database
• A variety of checking routines are run on data entry or update to check for common errors. For more details see:
Hill MP. 2019. Borehole database for urban geological mapping, southern Auckland area, New Zealand. Lower Hutt (NZ): GNS Science. 34 p. (GNS Science report; 2019/12). doi:10.21420/EZ5W-5K59.
Metadata
- File identifier
- 7bfca038-97e4-4f32-8071-a03847d75cc7 XML
- Metadata language
- English
- Character set
- UTF8
- Hierarchy level
- Dataset
- Hierarchy level name
-
Dataset
- Date stamp
- 2024-06-20T02:45:21.931276Z
- Metadata standard name
-
ISO 19115:2003/19139
- Metadata standard version
-
1.0
- Metadata author
-
Organisation name Individual name Electronic mail address Role GNS Science
Point of contact
