cde: Reference list of all output columns

The table below gives information on all the current columns of data retrieved by the different get_... functions of cde; names, what they mean and which functions return them. The EA do modify the format of their data from time to time, so this will be updated as necessary.

Column name Description Output from which functions
river_basin_district Name of the River Basin District. This is the top level in the catchment hierarchy. All get_… functions
management_catchment Name of the Management Catchment, the next level down the hierarchy, see link above. All get_… functions
operational_catchment name of the Operational Catchment, the next level down from Management Catchments. All get_… functions
waterbody_id Waterbodies are the smallest unit in the catchment hierarchy, representing all or part of a river system, lake, estuary etc. Each has a unique ID (WBID). All get_… functions
status WFD status classification (High, Good, Moderate, Poor or Bad). For objectives this represents the target (aimed for) status class. All get_… functions except get_pa
classification_item Broad category of classification level (ecological, chemical or quantitative). get_objectives, get_rnag & get_status
classification_level The level within the range of classification elements that the status class refers to (see details here). get_objectives, get_rnag & get_status
cycle Which cycle of assessment the data come from. The first cycle. The first cycle ran from 2009 to 2015 and cycle 2 to 2015-2021. There were changes in some environmental standards between cycles and for a two year period (2013-2014) where both assessment methods were employed, cde only returns cycle 2 assessments. get_objectives, get_rnag & get_status
water_body Name of the waterbody. get_objectives, get_rnag & get_status
water_body_type Type of waterbody. Values are: River, Lake, CoastalWater, TransitionalWater, GroundWaterBody get_objectives, get_rnag & get_status
year Year to which the data refer to. get_objectives, get_rnag & get_status
easting British National Grid Reference easting, i.e. x coordinate of location. get_objectives & get_status
hydromorphological_designation Hydromorphological designation of the waterbody (e.g. whether the body is artificial or heavily modified). get_objectives & get_status
ngr Ordnance Survey Landranger grid reference of the location. get_objectives & get_status
northing British National Grid Reference northing, i.e. y coordinate of location. get_objectives & get_status
activity Classification of the activity linked to the RNAG identified, for example “Forestry”, “Septic Tanks”. get_rnag
activity_certainty Categorical assessment of the certainty with which the RNAG identified is linked to the activity specifed. get_rnag
business_sector Categorisation of the business sector linked to the activity causing the RNAG, for example “Transport”, “Retail sector”, “Forestry”. get_rnag
category Broad categorisation of the RNAG, for example “Industry”, “Agriculture and rural land management” or “Water Industry”. get_rnag
category_certainty Categorical assessment of the certainty with which the RNAG identified is linked to the category specifed. get_rnag
certainty Categorical assessment of the certainty of the status class assignment. get_status
classification_element Specific quality element or metric linked to the RNAG. get_rnag
confidence Confidence in the status class assignment (0-1 scale). get_status
estimated_start_date Estimated date at which measure specified will begin. get_measures
funding_stream Source of funding for measure specified. get_measures
id Unique numerical code of RNAG (may be linked to measures specified). get_rnag
investigation_outcome Outcome of the investigation into the RNAG. get_rnag
lead_organisation Organisation leading the work on the measure specified. get_measures
linked_rnags Numerical code(s) of RNAGS linked to measures specified (see ‘id’ above). get_measures
measure_category_1 Top level classification of measure specified. get_measures
measure_category_2 Next level down (more detailed) classification of measure specified. get_measures
measure_category_3 Most detailed classification of measure specified. get_measures
measure_reference_code Numerical code of measure type. get_measures
measure_type Classification of type of measure employed. get_measures
national_swmi_header SWMI (Significant Water Management Issue) classification at the national level, for example “Pollution from waste water” or “Physical modifications”. get_rnag
objectivetype Type of objective set, either “Predicted” or “Objective” get_objectives
pressure_tier_1 Detailed classification of the pressure related to the RNAG identified, for example “Irrigation”, “Priority Substances (pesticides)”. get_rnag
pressure_tier_2 Specific substance or pressure associated with RNAG identiifed, for example “Phosphate”, “High temperature”. get_rnag
pressure_tier_3 High level classification of the pressure related to the RNAG identifed, for example “Physical modification”, “Dissolved oxygen (DO)”. get_rnag
protected_area_code Unique code of each protected area. get_pa
protected_area_label Name or code of protected area. get_pa
protected_area_type Designation of protected area, for example “Nitrates Directive” , “Bathing Water Directive”. get_pa
reason_type Type of RNAG, either “RFF” - reason for failure or “RFD” - reason for deterioration. get_rnag
reasons_for_alternative_objectives Detailed text as to why alternative objectives i.e. a status less than good, have been set. get_objectives
rnag_url URL to page on CDE site giving specifics of RNAG. get_rnag
sector_of_lead_organisation Sectoral classification of organisation leading measures work. get_measures
see_also Additional details about the protected area specified. get_pa
swmi SWMI (Significant Water Management Issue) classification of the RNAG, for example “Diffuse source”, “Invasive non-native species”. get_rnag
swmi_certainty Categorical assessment of the certainy with which the RNAG is linked to the SWMI classification specified. get_rnag
title Title of the measures project specified. get_measures