About this Dataset

River Water Quality Monitoring 1990 To 2018

This table provides the raw data from river monitoring sites including Water Framework Directive monitoring sites. It should be noted that, as the data set is in its raw state, it cannot be used to provide a status without processing. The data set does not show Limits of Detection or Limit of Quantitation which would require a value to be treated as a half value for WFD calculation. In addition both altitude and alkalinity affect status calculations for some parameters. The data set may contain results which are erroneous due to typos, sampling error or contamination, such data points are usually several orders or magnitude above expected values.

This is the first in a series of water data sets being made available as Open Data. Other data sets remain available on request via waterinfo@daera-ni.gov.uk

The European Water Framework Directive (2000/60/EC) has been transposed into Northern Ireland regulations through The Water Environment (Water Framework Directive) Regulations (Northern Ireland) 2017. 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 continue to operate here after 1 January 2021. The regulation encourage the active involvement of interested parties and the general public.

The regulations set out the requirement to achieve 'Good Ecological Status' and 'Good Chemical Status' for all ground and surface waters (rivers, lakes, transitional waters, and coastal waters) within Northern Ireland.

Surface waters are assessed according to the following criteria:
Biological quality (fish, invertebrates, flora)
Hydromorphological
Physico-chemical properties like temperature, oxygenation and nutrient conditions.
Chemical quality assessed against environmental quality standards for specific pollutants and priority substances.

The following physio-chemical and chemical parameters are included in the data set:

ALK (mg/l) - Alkalinity
BOD(mg/l) - Biochemical oxygen Demand
COND (uS/cm) - Conductivity
CUSOL1(mg/l) - Copper Dissolved
CUSOL2(ug/l) - Copper Dissolved
DO(mg/l) - Dissolved Oxygen
FESOL1(ug/l) - Iron Dissolved
NO3-N (mg/l) - Nitrate
NO2-N(mg/l) - Nitrite
NH4-N(mg/l) - Ammonia
PHpH - pH
P(SOL)(mg/l) - Phosphorus Soluble
SS(mg/l) - Suspended solids
ZN SOL(ug/l) - Zinc Dissolved
Publisher name: OpenDataNI
Last updated: 2022-07-01T04:01:55Z

Tables

Table 1

@ukgov.river_water_quality_monitoring_1990_to_20182.table_1

7.71 MB
141431 rows
26 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "site_code" VARCHAR,
  "site_status_21oct2020" VARCHAR,
  "station_name" VARCHAR,
  "rwb_id_rbp2" VARCHAR,
  "primary_basin" VARCHAR,
  "x" BIGINT,
  "y" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "depth" BIGINT,
  "alk_mgl" DOUBLE,
  "bod_mgl" DOUBLE,
  "cond_uscm" DOUBLE,
  "cusol1_mgl" DOUBLE,
  "cusol2_ugl" DOUBLE,
  "do_mgl" DOUBLE,
  "fesol1_ugl" DOUBLE,
  "no3_n_mgl" DOUBLE,
  "no2_n_mgl" DOUBLE,
  "nh4_n_mgl" DOUBLE,
  "ph" DOUBLE,
  "p_sol_mgl" DOUBLE,
  "ss_mgl" DOUBLE,
  "zn_sol_ugl" DOUBLE,
  "globalid" VARCHAR
);