---
title: Enviro + Geo Insight - GIS schema: Boreholes
description: Data schema for the borehole group of datasets within Groundsure's Enviro + Geo Insight - GIS product
---
[Skip to content](https://knowledge.groundsure.com/enviro-geo-insight-gis-schema-boreholes#main-content)
[Contact us](https://knowledge.groundsure.com/kb-tickets/new?hsLang=en)
Open main navigation
Close main navigation
- [Contact us](https://knowledge.groundsure.com/kb-tickets/new)
What are you looking for today?
- There are no suggestions because the search field is empty.
1. [Groundsure Knowledge Base](https://knowledge.groundsure.com/?hsLang=en)
2. [Insight Reports User Guide](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en)
3. [Enviro + Geo Insight - GIS](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#enviro-geo-insight-gis)
July 29, 2025
# Enviro + Geo Insight - GIS schema: Boreholes
## The information below details all definition of each of the layers in the Borehole group within the GeoPackage, defining each data layer, the attributes of the data and their data types, as well as the definitions for any values that use look up tables
### BGS Boreholes
#### Layer name: Boreholes-Boreholes\_BGS
This is a point based dataset of the British Geological Survey's Single Onshore Boreholes Index (SOBI) which covers onshore and nearshore boreholes for England, Wales and Scotland. The index includes over one million records of boreholes, shafts and wells from all forms of drilling and site investigation work dating back to at least 1790 and ranging from one to several thousand metres deep. Records include confidentiality status, name, depth and the web link to the online record.
**Geometry:** **Point**
**Coverage:** England, Scotland and Wales
Schema:
| Column Name | Data type |
| --- | --- |
| gs\_id | Integer |
| easting | Integer |
| northing | Integer |
| borehole\_name | Varchar (100) |
| length | Varchar (15) |
| confidenti | Varchar (1) |
| bgs\_weblink | Varchar (255) |
- [Searches User Guide](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#main-content)
- [Introduction](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#introduction)
- [Contaminated Land](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#contaminated-land)
- [Flooding](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#flooding)
- [Radon](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#radon)
- [Energy](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#energy)
- [Transportation](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#transportation)
- [Planning](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#planning)
- [Ground stability](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#ground-stability)
- [Mining](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#mining)
- [Local information](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#local-information)
- [Agricultural](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#agricultural)
- [Climate change](https://knowledge.groundsure.com/searches-user-guide?hsLang=en#climate-change)
- [Order Platforms](https://knowledge.groundsure.com/order-platforms?hsLang=en#main-content)
- [Insights platform (insights.groundsure.io)](https://knowledge.groundsure.com/order-platforms?hsLang=en#insights-platform-insights-groundsure-io)
- [Searches order platform (searches.groundsure.io)](https://knowledge.groundsure.com/order-platforms?hsLang=en#searches-order-platform-searches-groundsure-io)
- [Insight Reports User Guide](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#main-content)
- [Getting started](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#getting-started)
- [Enviro Insight](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#enviro-insight)
- [Geo Insight](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#geo-insight)
- [Map Insight](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#map-insight)
- [Enviro + Geo Insight - GIS](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#enviro-geo-insight-gis)
- [Eco Insight](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#eco-insight)
- [Glossary](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#glossary)
- [Streetworks](https://knowledge.groundsure.com/insight-reports-user-guide?hsLang=en#streetworks)
- [Clauses](https://knowledge.groundsure.com/clauses?hsLang=en#main-content)
- [Climate\_Index](https://knowledge.groundsure.com/clauses?hsLang=en#climate_index)
- [EPC](https://knowledge.groundsure.com/clauses?hsLang=en#epc)
- [Environmental](https://knowledge.groundsure.com/clauses?hsLang=en#environmental)
- [Webinars](https://knowledge.groundsure.com/webinars?hsLang=en)
- [Integrations](https://knowledge.groundsure.com/integrations?hsLang=en#main-content)
- [Hazard alerts](https://knowledge.groundsure.com/integrations?hsLang=en#hazard-alerts)
- [Client care letters](https://knowledge.groundsure.com/client-care-letters?hsLang=en#main-content)
- [Commercial](https://knowledge.groundsure.com/client-care-letters?hsLang=en#commercial)
- [Residential](https://knowledge.groundsure.com/client-care-letters?hsLang=en#residential)
- [Podcasts](https://knowledge.groundsure.com/podcasts?hsLang=en)
- [Factsheets](https://knowledge.groundsure.com/factsheets?hsLang=en#main-content)
- [Conveyancing](https://knowledge.groundsure.com/factsheets?hsLang=en#conveyancing)
- [GIS](https://knowledge.groundsure.com/factsheets?hsLang=en#gis)
- [Natural ground subsidence](https://knowledge.groundsure.com/factsheets?hsLang=en#natural-ground-subsidence)
- [Flood](https://knowledge.groundsure.com/factsheets?hsLang=en#flood)
- [Product Materials](https://knowledge.groundsure.com/product-materials?hsLang=en#main-content)
- [Core commercial](https://knowledge.groundsure.com/product-materials?hsLang=en#core-commercial)
- [Core residential](https://knowledge.groundsure.com/product-materials?hsLang=en#core-residential)
- [Mining searches](https://knowledge.groundsure.com/product-materials?hsLang=en#mining-searches)
- [Methodologies and limitations](https://knowledge.groundsure.com/product-materials?hsLang=en#methodologies-and-limitations)
[](https://www.groundsure.com/)
Copyright © 2026, Groundsure Ltd