Name: Water Quality Analysis 1990 to 2018
Display Field: Station_Name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description: 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 waterinfor@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
Copyright Text: DAERA Water Management Unit, Water Assessment Data & Evidence, waterinfo@daera-ni.gov.uk https://www.daera-ni.gov.uk/contacts/water-management-unit
Min. Scale: 4622325
Max. Scale: 0
Default Visibility: true
Max Record Count: 2000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
Extent:
XMin: 191784
YMin: 312710
XMax: 361647
YMax: 444454
Spatial Reference: 29900 (29902)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"6bf279725cc2cbb64296fac3c24ff03c","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAWCAYAAADwza0nAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABgElEQVQ4jZ2SvU/CQBiHfy+iiV1wQAYHTQxLQ0fW2hgXBxbYZWR35GPARGE0YWTkD6gLg6MUR9kgXRiIg0PTgekUG3sO5GihBzX+pvt67nnz3iXxzySlq823NBZfKvZ+XNwbdjzYGKjgVIHHdCQAcALqFsBh40C5RTPvRsHqqw7fr4OQjlxPUOGxZzQGN6KC5Kq0b1YRkH6WUu6uTk8uz49SE4exQm88nc0XHnx6BHAdgN5nCQRVCAQEALmMovTLWlbrjGwQ0qgOSmgb5hLkXAcFlQlIJJdRlKBsKgIwpV2dOIyFD08cxkLbx0GpBDcMFnrjab+sZXMZRZk4jLVe3j9CjbICEGQDXBd7s/nC0zoj6fsB5Abg/qEJj1XkB0PhcJHwhwHYzLuoD7sA3w0TrPV3BIAHvYuaVZJ+gKXNRuuiJabrXeW8C6KaHORP4ek62DZM1Kxi+DOsbG3D3A6Km4nUyNpGouCmVWKTg5tWiW07KKxi/Gdwhyke3GKKB2PyC0V3lW92WIFVAAAAAElFTkSuQmCC","contentType":"image/png","width":10,"height":16,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- Site_Code (type: esriFieldTypeString, alias: Site_Code, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- Site_Status_21Oct2020 (type: esriFieldTypeString, alias: Site_Status_21Oct2020, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- Station_Name (type: esriFieldTypeString, alias: Station_Name, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- RWB_ID_RBP2 (type: esriFieldTypeString, alias: RWB_ID_RBP2, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- Primary_Basin (type: esriFieldTypeString, alias: Primary_Basin, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- X (type: esriFieldTypeInteger, alias: X, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Y (type: esriFieldTypeInteger, alias: Y, SQL Type: sqlTypeOther, nullable: true, editable: true)
- Date (type: esriFieldTypeDate, alias: Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- Time (type: esriFieldTypeString, alias: Time, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- Depth (type: esriFieldTypeInteger, alias: Depth, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ALK_MGL (type: esriFieldTypeInteger, alias: ALK_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- BOD_MGL (type: esriFieldTypeDouble, alias: BOD_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- COND_USCM (type: esriFieldTypeInteger, alias: COND_USCM, SQL Type: sqlTypeOther, nullable: true, editable: true)
- CUSOL1_MGL (type: esriFieldTypeString, alias: CUSOL1_MGL, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- CUSOL2_UGL (type: esriFieldTypeString, alias: CUSOL2_UGL, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- DO_MGL (type: esriFieldTypeDouble, alias: DO_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- FESOL1_UGL (type: esriFieldTypeString, alias: FESOL1_UGL, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- NO3_N_MGL (type: esriFieldTypeDouble, alias: NO3_N_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NO2_N_MGL (type: esriFieldTypeDouble, alias: NO2_N_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- NH4_N_MGL (type: esriFieldTypeDouble, alias: NH4_N_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- PH (type: esriFieldTypeDouble, alias: PH, SQL Type: sqlTypeOther, nullable: true, editable: true)
- P_SOL_MGL (type: esriFieldTypeDouble, alias: P_SOL_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- SS_MGL (type: esriFieldTypeDouble, alias: SS_MGL, SQL Type: sqlTypeOther, nullable: true, editable: true)
- ZN_SOL_UGL (type: esriFieldTypeString, alias: ZN_SOL_UGL, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
Templates:
Name: Water Quality Analysis 1990 to 2018
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/5/2022 3:50:37 PM
Schema Last Edit Date: 4/5/2022 3:50:37 PM
Data Last Edit Date: 4/5/2022 3:50:37 PM
Supported Operations:
Query
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat