Enviro + Geo Insight - GIS schema: Hydrology
The information below details all definition of each of the layers in the Hydrology 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
Water Networks (OS MasterMap)
Layer name: Hydrology-Surface_Water_Area_Features_OS
This is a portion of OS VectorMap District and includes inland waterway bodies sufficiently wide enough to capture as an area feature, however, small lakes and small islands in waterbodies are not included.
Geometry: Polygon
Coverage: England, Scotland and Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
Layer name: Hydrology-Surface_Water_Line_Features_OS
This is a portion of OS VectorMap District and includes inland waterway bodies not sufficiently wide enough to capture as an area feature.
Geometry: Line
Coverage: England, Scotland and Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
WFD Groundwater bodies
Layer name: Hydrology-WFD_Groundwater_Bodies_EA
This is a polygon based dataset of groundwater bodies (defined as all water which is below the surface of the ground in the saturation zone and in direct contact with the ground or subsoil) at 1:50,000 scale across England, provided by the Environment Agency, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID. Groundwater bodies represent a distinct body of groundwater flow including recharge and discharge areas as well as reflecting hydrogeological characteristics on flow and stage properties, recharge and vulnerability to pollution.
Geometry: Polygon
Coverage: England
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_update | Varchar (10) |
Layer name: Hydrology-WFD_Groundwater_Bodies_NRW
This is a polygon based dataset of groundwater bodies (defined as all water which is below the surface of the ground in the saturation zone and in direct contact with the ground or subsoil) at 1:50,000 scale across Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID. Groundwater bodies represent a distinct body of groundwater flow including recharge and discharge areas as well as reflecting hydrogeological characteristics on flow and stage properties, recharge and vulnerability to pollution.
Geometry: Polygon
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_update | Varchar (10) |
WFD Surface water bodies
Layer name: Hydrology-WFD_Surface_Water_Bodies_Canal_NRW
This is a line based dataset representing the centreline of canal water bodies across Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID.
Geometry: Line
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| opcat_name | Varchar (200) |
| mncat_name | Varchar (200) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_Coastal_NRW
This is a polygon based dataset of coastal water bodies (defined as territorial waters 1 nautical mile from the Mean High Water coastline) across Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID.
Geometry: Polygon
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| opcat_name | Varchar (200) |
| mncat_name | Varchar (200) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_Lake_EA
This is a polygon based dataset of lake water bodies (defined as a body of standing inland surface water) across England, provided by the Environment Agency, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID. Lakes assessed under the WFD include; artificial and modified water bodies, lakes > 50ha unless within protected areas where a minimum size of 0.5ha is used or small when designated as Sites of Special Scientific Interest (SSSI), and any lake judged to be a protected drinking water area.
Geometry: Polygon
Coverage: England
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_update | Varchar (10) |
| rbd_id | Integer |
| rbd_name | Varchar (100) |
| overall_class_2014 | Varchar (200) |
| biological_class_2014 | Varchar (200) |
| chemical_class_2014 | Varchar (200) |
| overall_class_2015 | Varchar (200) |
| biological_class_2015 | Varchar (200) |
| chemical_class_2015 | Varchar (200) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_Lake_NRW
This is a polygon based dataset of lake water bodies (defined as a body of standing inland surface water) across Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID. Lakes assessed under the WFD include; artificial and modified water bodies, lakes > 50ha unless within protected areas where a minimum size of 0.5ha is used or small when designated as Sites of Special Scientific Interest (SSSI), and any lake judged to be a protected drinking water area.
Geometry: Polygon
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_update | Varchar (10) |
| mncat_name | Varchar (200) |
| opcat_name | Varchar (200) |
| rbd_id | integer |
| rbd_name | Varchar (100) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_River_NRW
This is a line based dataset representing the centreline of river water bodies across Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID (wfd_id).
Geometry: Line
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_update | Varchar (10) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_River_Canal_and_Surface_Water_EA
This is a line based dataset representing the centreline of rivers, canals and surface water transfer water bodies across England, provided by the Environment Agency, as defined for the implementation of the Water Framework Directive (WFD). WFD data can be linked using the unique water body ID (wb_id).
Geometry: Line
Coverage: England
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_update | Varchar (10) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_Transitional_NRW
This is a polygon based dataset of transitional water bodies (defined as bodies of surface water in the vicinity of river mouths which are partly saline in character as a result of their proximity to coastal waters but are substantially influenced by freshwater flows) across Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID. Transitional waterbodies were defined from Mean High Water boundaries, taken directly from OS 1:50,000 MeridianTM 2, and NRW estuarine boundaries defined for the Urban Waste Water Treatment Directive (UWWTD).
Geometry: Polygon
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_bio | Varchar (200) |
| mncat_name | Varchar (200) |
Layer name: Hydrology-WFD_Surface_Water_Bodies_Transitional_and_Coastal_EA
This is a polygon based dataset of transitional and coastal water bodies across England, provided by the Environment Agency, as defined for the implementation of the Water Framework Directive (WFD) and can be linked to other WFD data using the unique water body ID.
Geometry: Polygon
Coverage: England
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_update | Varchar (10) |
WFD Surface water body catchments
Layer name: Hydrology-WFD_Surface_Water_Catchments_EA
This is a polygon based dataset of river waterbody catchments within England, provided by the Environment Agency, as defined for the implementation of the Water Framework Directive (WFD). These catchments delineate areas of land from which all surface run-off flows through a series of streams, rivers and, possibly, lakes to a particular point in the water course such as a river confluence. Rivers can be linked with these catchments via the 'WB_ID' attribute. Land which drains into coastal or estuarine waters rather than a river are also included but are named 'Not part of a river WB catchment'.
Geometry: Polygon
Coverage: England
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_update | Varchar (10) |
Layer name: Hydrology-WFD_Surface_Water_Catchments_NRW
This is a polygon based dataset of river waterbody catchments within Wales, provided by Natural Resources Wales, as defined for the implementation of the Water Framework Directive (WFD). These catchments delineate areas of land from which all surface run-off flows through a series of streams, rivers and, possibly, lakes to a particular point in the water course such as a river confluence. Rivers can be linked with these catchments via the 'WB_ID' attribute.
Geometry: Polygon
Coverage: Wales
Schema:
| Column name | Data type |
| gs_id | Integer |
| wb_cat | Varchar (100) |
| wb_name | Varchar (100) |
| wb_id | Varchar (30) |
| latest_overall | Varchar (200) |
| latest_bio | Varchar (200) |
| latest_chem | Varchar (200) |
| latest_update | Varchar (10) |