cde: Reference list of all output columns"
In cde: Download Data from the Catchment Data Explorer Website

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

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