Dataset: Water Framework Directive 2nd Cycle Interim Status

About this Dataset

Water Framework Directive 2nd Cycle Interim Status

This file contains the 2018 overall surface water body status, reported to Europe as a 2nd Cycle interim classification for Water Framework Directive in 2018. It contains the following surface water bodies (river, lakes, coastal and transitional waters) A 2018 classification was not undertaken for groundwater or superficial groundwater.

The European Water Framework Directive was transposed to national legislation through the Water Environment (Water Framework Directive) Regulations (Northern Ireland) 2017 which required data reporting to Europe. The Water (Amendment) (Northern Ireland) (EU Exit) Regulations 2019 ensures that the Water Framework Directive (WFD) (as transposed) and the various supporting pieces of water legislation are implemented in Northern Ireland without a requirement to report data to Europe.

The legislation defines 6 year cycles of monitoring and action to improve or maintain environmental water quality standards.
Publisher name: OpenDataNI
Last updated: 2022-07-01T04:01:53Z

Tables

Table 1

@ukgov.water_framework_directive_2nd_cycle_interim_status3.table_1

82.07 KB
496 rows
18 columns


CREATE TABLE table_1 (
  "objectid_12" BIGINT,
  "objectid_1" BIGINT,
  "objectid" BIGINT,
  "localid" VARCHAR,
  "namespace" VARCHAR,
  "spzonetype" VARCHAR,
  "sizevalue" DOUBLE,
  "shape_leng" DOUBLE,
  "shape_star" DOUBLE,
  "shape_stle" DOUBLE,
  "index" BIGINT,
  "uk_cd" VARCHAR,
  "f2018_statu" VARCHAR,
  "ruleid" BIGINT,
  "override" VARCHAR,
  "globalid" VARCHAR,
  "shape_area" DOUBLE,
  "shape_length" DOUBLE
);