---
title: "Enviro + Geo Insight - GIS schema: Mining and Ground Workings"
description: Data schema for the mining and ground workings group of datasets within Groundsure's Enviro + Geo Insight - GIS product
---

[Skip to content](https://knowledge.groundsure.com/enviro-geo-insight-gis-schema-mining-and-ground-workings#main-content)

[Contact us](https://knowledge.groundsure.com/kb-tickets/new?hsLang=en)

![KB-banner-test-v16](https://knowledge.groundsure.com/hubfs/KB-banner-test-v16.svg)

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: Mining and Ground Workings

## The information below details all definition of each of the layers in the Mining and ground workings 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

### BritPits

#### Layer name: Mining\_and\_Ground\_Workings-Brit\_Pits\_BGS

This is a point based dataset of mines and quarries across England, Wales and Scotland for currently active and closed surface and underground mineral workings known as the BritPits (an abbreviation of British Pits) database maintained by the British Geological Survey. Details of major mineral handling sites, such as wharfs and rail depots are also held in the database. Where available records include information about operational status, products, lithostratigraphy, chronostratigraphy, pit and operator addresses, and minerals planning authority.

**Geometry:** Point

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| pit\_name | Varchar (254) |
| pit\_address | Varchar (254) |
| commodity\_produced | Varchar (254) |
| status\_description\_long | Varchar (254) |
| type\_description | Varchar (254) |
| status\_description | Varchar (32) |

### Surface ground workings

#### Layer name: Mining\_and\_Ground\_Workings-Surface\_Ground\_Workings\_GS

The data contained within this dataset includes polygonised features from historical Ordnance Survey mapping (1:10,560 and 1:10,000 scales) that involved ground excavation at the surface across England, Scotland and Wales.

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| use | Varchar (150) |
| date | Varchar (20) |
| scale | Varchar (10) |

### Underground workings

#### Layer name: Mining\_and\_Ground\_Workings-Underground\_Workings\_GS

The data contained within this dataset includes polygonised features from historical Ordnance Survey mapping (1:10,560 and 1:10,000 scales) that indicate the presence of underground workings e.g. mine shafts, across England, Scotland and Wales.

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| use | Varchar (150) |
| date | Varchar (20) |
| scale | Varchar (10) |

### Historical Mineral Planning Areas

#### Layer name: Mining\_and\_Ground\_Workings-Historical\_Mineral\_Planning\_Areas\_BGS

This is a polygon based dataset representing boundaries of mineral planning permissions for England and Wales collated between the 1940s (and retrospectively to the 1930s) and the mid 1980s. The data is held by the British Geological Survey and includes permitted, withdrawn and refused permissions as well as details regarding the name, operator, dates and relevant local authority.

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| site\_name | Varchar (200) |
| min\_site\_t | Varchar (200) |
| min\_com | Varchar (200) |
| pln\_status | Varchar (200) |
| grant\_date | Varchar (200) |

### Non-coal mining

#### Layer name: Mining\_and\_Ground\_Workings-Non\_Coal\_Mining\_BGS

This is a polygon based dataset from the British Geological Survey that identifies areas that could have been affected by historical non-coal mining activities across England, Wales and Scotland. The assessment is drawn from expert knowledge and literature in addition to the Digital Geological Map of Britain. Mineral commodities may be divided into seven general categories - vein minerals, chalk, oil shale, building stone, bedded ores, evaporites and ‘other’ commodities (including ball clay, jet, black marble, graphite and chert). The data is categorised on a 5 tier scale;

- A - sporadic underground mining of restricted extent (rare);
- B - localised small scale underground mining may have occurred (highly unlikely);
- C - small scale underground mining may have occurred (unlikely);
- D - underground mining is known or considered likely to have occurred within or close to the area (likely); and
- E - underground mining is known to have occurred within or very close to the area (highly likely).

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| name | Varchar (100) |
| commodity | Varchar (50) |
| class | Varchar (5) |
| legend | Varchar (254) |

### Coal mining

#### Layer name: Mining\_and\_Ground\_Workings-Coal\_Mining\_CA

This dataset includes polygon data provided by the Coal Authority and broadly identifies the extent of coalfields across England, Scotland and Wales which could be affected by past, present or future coal mining. These areas identify where a CON29M should be purchased (Mandatory in England and Wales, but optional in Scotland) as part of a property transaction.

**Geometry:** Polygon

**Coverage:** 

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |

### Brine areas

#### Layer name: Mining\_and\_Ground\_Workings-Brine\_Areas\_CBSCB

This is a polygon based dataset representing the Cheshire Brine Compensation District areas that may be affected by salt and brine extraction in Cheshire and where compensation would be available where damage from this mining has occurred. Damage from salt and brine mining can still occur outside this district, but no compensation will be available.

**Geometry:** Polygon

**Coverage:** England

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| name | Varchar (80) |

### Gypsum areas

#### Layer name: Mining\_and\_Ground\_Workings-Gypsum\_Areas\_BG

This is a polygon based dataset representing generalised areas that may be affected by gypsum extraction. This data is sourced from British Gypsum.

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |

### Tin mining

#### Layer name: Mining\_and\_Ground\_Workings-Tin\_Mining\_GS

This is a polygon based dataset representing generalised areas that may be affected by tin mining. This static dataset may identify tin mining in proximity but do not definitively identify that tin mining took place. This data is sourced from Mining Searches UK/ Groundsure.

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| area\_re\_id | Integer |

### Clay mining

#### Layer name: Mining\_and\_Ground\_Workings-Clay\_Mining\_KBCA

This is a polygon based dataset representing generalised areas that may be affected by kaolin and ball clay extraction.

**Geometry:** Polygon

**Coverage:** England, Scotland and Wales

**Schema:** 

| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |

 

- [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)

[![Groundsure-B-Corp-Logo-Landscape-v1-1](https://knowledge.groundsure.com/hs-fs/hubfs/Groundsure-B-Corp-Logo-Landscape-v1-1.png?width=500&height=89&name=Groundsure-B-Corp-Logo-Landscape-v1-1.png "Groundsure-B-Corp-Logo-Landscape-v1-1")](https://www.groundsure.com/)

<https://www.linkedin.com/company/groundsure/> <https://www.instagram.com/groundsure_/> <https://twitter.com/Groundsure> <https://www.youtube.com/%40GroundSure>

Copyright © 2026, Groundsure Ltd