---
title: "Enviro + Geo Insight - GIS schema: Flooding"
description: Data schema for the flooding group of datasets within Groundsure's Enviro + Geo Insight - GIS product
---
[Skip to content](https://knowledge.groundsure.com/enviro-geo-insight-gis-schema-flooding#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)
April 2, 2026
# Enviro + Geo Insight - GIS schema: Flooding
## The information below details all definition of each of the layers in the Flooding 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
### Areas Benefiting from Flood Defences
#### Layer name: Flooding-Areas\_Benefiting\_from\_Flood\_Defences\_EA\_NRW
This is a polygon based dataset that identifies areas that benefit from flood defences which offer protection against a 1 in 100 (1%) chance of flooding each year from rivers; or 1 in 200 (0.5 %) chance of flooding each year from the sea across England and Wales. This can include areas that would be protected by other defences for larger events e.g. 1 in 1000 (0.1%), but would only include areas protected against a 1 in 100 (1%) / 1 in 200 (0.5%) chance of occurring in any year. If the defences were not in place, these areas would flood in a 1 in 100 (1%)/ 1 in 200 (0.5 %) or larger flooding incident. In mapping areas benefiting from defences, the EA/NRW assume that flood defences and other operating structures act perfectly and give the same level of protection as when their assessment of the area was made.
**Geometry:** Polygon
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| type | Varchar (30) |
| name | Varchar (30) |
### Flood Defences
#### Layer name: Flooding-Flood\_Defences\_EA\_NRW
This is a line based dataset that shows flood defences constructed across England and Wales which offer protection equal to or better than 1 in 100 (1%) for rivers and 1 in 200 (0.5%) from the sea.
**Geometry:** Line
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| description | Varchar (30) |
### Flood Storage Areas
#### Layer name: Flooding-Flood\_Storage\_Areas\_EA\_NRW
This is a polygon based dataset that shows Flood Storage Areas across England and Wales that act as a balancing reservoir, storage basin or balancing pond. Their purpose is to attenuate an incoming flood peak to a flow level that can be accepted by the downstream channel. It may also delay the timing of a flood peak so that its volume is discharged over a longer time interval. The EA/NRW assume that flood storage areas act perfectly and give the same level of protection as when their assessment of the area was made.
**Geometry:** Polygon
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| description | Varchar (30) |
| type | Varchar (30) |
### Flood Zone 2
#### Layer name: Flooding-Flood\_Zone\_2\_EA\_NRW
This is a polygon based dataset showing the best estimate the EA/NRW provide of the areas of land at risk of flooding, when the presence of flood defences are ignored and covers land between Zone 3 and the extent of the flooding from rivers or the sea with a 1 in 1000 (0.1%) chance of flooding each year. This dataset covers England and Wales, and is designed to support flood risk assessments in line with Planning Practice Guidance and should be used in conjunction with Flood Zone 3.
**Geometry:** Polygon
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| type | Varchar (65) |
| unique\_id | Varchar (10) |
| flood\_plain\_identified | Varchar (35) |
| perimeter | Integer |
| warning1 | Varchar (254) |
| warning2 | Varchar (254) |
| warning3 | Varchar (254) |
| warning4 | Varchar (254) |
### Flood Zone 3
#### Layer name: Flooding-Flood\_Zone\_3\_EA\_NRW
This is a polygon based dataset showing the best estimate the EA/NRW provide of the areas of land at risk of flooding, when the presence of flood defences are ignored and covers land with a 1 in 100 (1%) or greater chance of flooding each year from Rivers or with a 1 in 200 (0.5%) or greater chance of flooding each year from the Sea. This dataset covers England and Wales, and is designed to support flood risk assessments in line with Planning Practice Guidance and should be used in conjunction with Flood Zone 2.
**Geometry:** Polygon
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| type | Varchar (65) |
| unique\_id | Varchar (10) |
| flood\_plain\_identified | Varchar (35) |
| perimeter | Integer |
| warning1 | Varchar (254) |
| warning2 | Varchar (254) |
| warning3 | Varchar (254) |
| warning4 | Varchar (254) |
### Historical Flood Events
#### Layer name: Flooding-Historical\_Flood\_Events\_EA\_NRW
This dataset includes polygonised features that correspond to records the maximum extent of historic flooding from rivers, the sea, groundwater and surface water. Records began in 1946 when predecessor bodies started collecting detailed information about flooding incidents, although limited details may be included on flooding incidents prior to this date. If an area is not covered by the Historic Flood Events dataset it does not mean that the area has never flooded, only that the Environment Agency/Natural Resources Wales do not currently have records of flooding in this area that meet the criteria for inclusion. It is also possible that the pattern of flooding in this area has changed and that this area would now flood or not flood under different circumstances. Outlines that don’t meet this criteria are stored in the Recorded Flood Outlines dataset. Takes into account the presence of defences, structures, and other infrastructure where they existed at the time of flooding, and includes flood extents that may have been affected by overtopping, breaches or blockages. Flooding is shown to the land and does not necessarily indicate that properties were flooded internally. This dataset covers England and Wales.
The Historic Flood Outline dataset from the EA includes some flood records where the date of occurrence is not confirmed. In these cases, records may display placeholder start dates (e.g., years 1001 or 2050), which do not represent the true timing of the events, or may be recorded as “Unknown.”
**Geometry:** Polygon
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| name | Varchar (100) |
| start\_date | Varchar (30) |
| end\_date | Varchar (30) |
| flood\_src | Varchar (50) |
| flood\_caus | Varchar (123) |
| fluvial\_in | Integer |
| tidal\_ind | Integer |
| coastal\_in | Integer |
### Risk of Flooding from Rivers and the Sea (RoFRaS)
#### Layer name: Flooding-Risk\_of\_Flooding\_from\_Rivers\_and\_the\_Sea\_EA\_NRW
This is a national assessment of flood risk for England and Wales produced using local expertise. The dataset shows the chance of flooding from rivers and/or the sea, based on cells (polygons) of 50m squared. Each cell is allocated one of four flood risk categories, taking into account flood defences and their condition:
- Very low (less than 1 in 1000 chance)
- Low (less than 1 in 100 but greater than or equal to 1 in 1000 chance)
- Medium (less than 1 in 30 but greater than or equal to 1 in 100 chance)
- High (greater than or equal to 1 in 30 chance)
**Geometry:** Polygon
**Coverage:** England and Wales
**Schema:**
| **Column name** | **Data type** |
| --- | --- |
| gs\_id | Integer |
| prob\_4band | Varchar (20) |
- [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