- Home
- Support
- Announcements
- 8. New formats and schema for RoFRS and RoFSW
- 1. Data relating to the Environment Agency’s new national flood and coastal erosion risk information
- 2. The datasets we have published
- 3. The datasets we have not initially replaced
- 4. Climate Change Data
- 5. Publishing Timescales
- 6. How to access the data
- 7. Changes to formats and schema for our existing datasets
- 8. New formats and schema for RoFRS and RoFSW
- 9. Detailed data list
8. New formats and schema for RoFRS and RoFSW
Created: 31 October 2024 Updated: 25 March 2025
The Environment Agency has published new national risk information for flooding and coastal erosion. This includes updated versions of some of our existing datasets.
Below we provide detail on the new formats and schema for:
Risk of flooding from rivers and sea (RoFRS)
Risk of flooding from surface water (RoFSW)
Please also read the summary announcement: ‘Data relating to the Environment Agency’s new national flood and coastal erosion risk information’.
If you are a regular user of these datasets, you will need to update your processes. The key things you need to know are:
The data is available via a WMS feed and as a data download.
There are new links for the new versions of datasets. You will need to replace previous links where relevant.
The schema for existing datasets will change. See below for tables displaying the new schema for RoFRS, RoFSW and associated flood depth datasets.
New schema: Risk of Flooding from Rivers and Sea (RoFRS)
File Geodatabase Name: RoFRS_vYYYYMM.gdb
Table showing the new RoFRS schema
Simple Feature Class | Geometry: | Polygon | |||||
| Contains M Values:1 | No | |||||
Contains Z Values:2 | No | ||||||
Field name | Data type | Allow nulls | Default value | Domain | Precision | Scale | Length |
OBJECTID | Object ID |
|
|
|
|
|
|
Shape | Geometry |
|
|
|
|
|
|
Risk_band | Text | No |
|
| 12 | ||
Confidence | Short Integer | No | 5 |
|
| ||
Table showing the new RoFRS schema
Simple Feature Class | Geometry: | Polygon | |||||
| Contains M Values:1 | No | |||||
Contains Z Values:2 | No | ||||||
Field name | Data type | Allow nulls | Default value | Domain | Precision | Scale | Length |
OBJECTID | Object ID |
|
|
|
|
|
|
Shape | Geometry |
|
|
|
|
|
|
Risk_band | Text | No |
|
| 12 | ||
New schema: Risk of Flooding from Surface Water (RoFSW)
File Geodatabase Name: RoFSW_vYYYYMM.gdb
Table showing the new RoFSW schema
Simple Feature Class | Geometry: | Polygon | |||||
| Contains M Values:1 | No | |||||
Contains Z Values:2 | No | ||||||
Field name | Data type | Allow nulls | Default value | Domain | Precision | Scale | Length |
OBJECTID | Object ID |
|
|
|
|
|
|
Shape | Geometry |
|
|
|
|
|
|
Risk_band | Text | No |
|
| 12 | ||
Confidence | Short Integer | No | 5 |
|
| ||
Table showing the new RoFSW schema
Simple Feature Class | Geometry: | Polygon | |||||
| Contains M Values:1 | No | |||||
Contains Z Values:2 | No | ||||||
Field name | Data type | Allow nulls | Default value | Domain | Precision | Scale | Length |
OBJECTID | Object ID |
|
|
|
|
|
|
Shape | Geometry |
|
|
|
|
|
|
Risk_band | Text | No |
|
| 12 | ||
1 Measure length (for linear referencing)
2 Height value
New schema: climate change datasets
We have also published datasets indicating the possible impacts of climate change on future flood and coastal erosion risk.
There are versions of RoFRS and RoFSW, which will follow the same schema as above but with these File Geodatabase Names:
RoFRS_Climate_Change_01_vYYYYMM.gdb
RoFSW_Climate_Change_01_vYYYYMM.gdb