About this Dataset

Third UK Habitats Directive Report (2013) - UK Level Habitat Details

This dataset contains details of all the Habitat Reports that summarise the conservation status of Habitats listed under the Habitats Directive. Every six years, all EU Member States are required (under Article 17 of the Directive) to report on the implementation of the EU Habitats Directive. The 3rd UK Habitats Directive Report was submitted to the European Commission in 2013. The Report considered the conservation status of all terrestrial and marine habitats listed under Annex I of the Directive that were present within the UK during the reporting period (2007-2012). This included: * 69 terrestrial habitats within the UK Atlantic region; * 8 marine habitats within the UK Marine Atlantic region; This dataset presents the conclusions for each habitat together with a link to each individual habitat report (in pdf format). It also contains a range of parameters for each habitat as described in the UK Approach Document. http://jncc.defra.gov.uk/pdf/A17_2013_UKApproach.pdf
Publisher name: Joint Nature Conservation Committee
Last updated: 2024-09-14T19:09:33Z

Tables

Habitats-Directive-A17-2013-UK-reporting-info-Habitat-details

@ukgov.third_uk_habitats_directive_report_2013_uk_level_habit_1472426d.habitats_directive_a17_2013_uk_reporting_info_habitat_details

255.12 kB
77 rows
73 columns

CREATE TABLE habitats_directive_a17_2013_uk_reporting_info_habitat_details (
  "habitat_code" VARCHAR,
  "domain_marine_or_terrestrial" VARCHAR  -- Domain (marine Or Terrestrial,
  "habitat_code_and_name" VARCHAR,
  "habitat_name" VARCHAR,
  "geographical_level" VARCHAR,
  "n_1_1_1_distribution_map" VARCHAR  -- 1.1.1. Distribution Map,
  "n_1_1_2_method_used_map" VARCHAR  -- 1.1.2. Method Used - Map,
  "n_1_1_3_map_data_year_or_period" VARCHAR  -- 1.1.3. Map Data - Year Or Period,
  "n_1_1_4_additional_distribution_map" VARCHAR  -- 1.1.4. Additional Distribution Map,
  "n_1_1_5_range_map" VARCHAR  -- 1.1.5. Range Map,
  "biogeographic_region" VARCHAR,
  "n_2_2_published_sources" VARCHAR  -- 2.2 Published Sources,
  "n_2_3_1_range_surface_area_sq_km" DOUBLE  -- 2.3.1. Range Surface Area (sq Km),
  "n_2_3_2_range_method_used" VARCHAR  -- 2.3.2 Range Method Used,
  "n_2_3_3_range_short_term_trend_period" VARCHAR  -- 2.3.3. Range Short-term Trend Period,
  "n_2_3_4_range_short_term_trend_direction" VARCHAR  -- 2.3.4. Range Short-term Trend Direction,
  "n_2_3_5_a_range_short_term_trend_magnitude_minimum" VARCHAR  -- 2.3.5.a Range Short-term Trend Magnitude - Minimum,
  "n_2_3_5_b_range_short_term_trend_magnitude_maximum" VARCHAR  -- 2.3.5.b Range Short-term Trend Magnitude - Maximum,
  "n_2_3_6_range_long_term_trend_period" VARCHAR  -- 2.3.6. Range Long-term Trend Period,
  "n_2_3_7_range_long_term_trend_direction" VARCHAR  -- 2.3.7 Range Long-term Trend Direction,
  "n_2_3_8_a_range_long_term_trend_magnitude_minimum" VARCHAR  -- 2.3.8.a Range Long-term Trend Magnitude - Minimum,
  "n_2_3_8_b_range_long_term_trend_magnitude_maximum" VARCHAR  -- 2.3.8.b Range Long-term Trend Magnitude - Maximum,
  "n_2_3_9_a_favourable_reference_range_sq_km" DOUBLE  -- 2.3.9.a Favourable Reference Range (sq Km),
  "n_2_3_9_b_favourable_reference_range_operator" VARCHAR  -- 2.3.9.b Favourable Reference Range Operator,
  "n_2_3_9_c_favourable_reference_range_is_unknown" VARCHAR  -- 2.3.9.c Favourable Reference Range Is Unknown,
  "n_2_3_9_d_favourable_reference_range_method" VARCHAR  -- 2.3.9.d Favourable Reference Range Method,
  "n_2_3_10_a_range_reason_for_change_genuine" VARCHAR  -- 2.3.10.a Range Reason For Change - Genuine,
  "n_2_3_10_b_range_reason_for_change_improved_knowledge" VARCHAR  -- 2.3.10.b Range Reason For Change - Improved Knowledge,
  "n_2_3_10_c_range_reason_for_change_different_method" VARCHAR  -- 2.3.10.c Range Reason For Change - Different Method,
  "n_2_4_1_surface_area_sq_km" DOUBLE  -- 2.4.1 Surface Area (sq Km),
  "n_2_4_2_surface_area_year_or_period" VARCHAR  -- 2.4.2 Surface Area Year Or Period,
  "n_2_4_3_method_used_area_covered_by_habitat" VARCHAR  -- 2.4.3 Method Used Area Covered By Habitat,
  "n_2_4_4_surface_area_short_term_trend_period" VARCHAR  -- 2.4.4 Surface Area Short-term Trend Period,
  "n_2_4_5_surface_area_short_term_trend_direction" VARCHAR  -- 2.4.5 Surface Area Short-term Trend Direction,
  "n_2_4_6_a_surface_area_short_term_trend_magnitude_minimum" VARCHAR  -- 2.4.6.a Surface Area Short-term Trend Magnitude - Minimum,
  "n_2_4_6_b_surface_area_short_term_trend_magnitude_maximum" VARCHAR  -- 2.4.6.b Surface Area Short-term Trend Magnitude - Maximum,
  "n_2_4_6_c_surface_area_short_term_trend_magnitude_conf_2fdbb39f" VARCHAR  -- 2.4.6.c Surface Area Short-term Trend Magnitude - Confidence Interval,
  "n_2_4_7_surface_area_short_term_trend_method_used" VARCHAR  -- 2.4.7 Surface Area Short-term Trend Method Used,
  "n_2_4_8_surface_area_long_term_trend_period" VARCHAR  -- 2.4.8 Surface Area Long-term Trend Period,
  "n_2_4_9_surface_area_long_term_trend_direction" VARCHAR  -- 2.4.9. Surface Area Long-term Trend Direction,
  "n_2_4_10_a_surface_area_long_term_trend_magnitude_minimum" VARCHAR  -- 2.4.10.a Surface Area Long-term Trend Magnitude - Minimum,
  "n_2_4_10_b_surface_area_long_term_trend_magnitude_maximum" VARCHAR  -- 2.4.10.b Surface Area Long-term Trend Magnitude - Maximum,
  "n_2_4_10_c_surface_area_long_term_trend_magnitude_conf_547ce644" VARCHAR  -- 2.4.10.c Surface Area Long-term Trend Magnitude - Confidence Interval,
  "n_2_4_11_surface_area_long_term_trend_method_used" VARCHAR  -- 2.4.11 Surface Area Long-term Trend Method Used,
  "n_2_4_12_a_favourable_reference_area" DOUBLE  -- 2.4.12.a Favourable Reference Area,
  "n_2_4_12_b_favourable_reference_area_operator" VARCHAR  -- 2.4.12.b Favourable Reference Area Operator,
  "n_2_4_12_c_favourable_reference_area_is_unknown" VARCHAR  -- 2.4.12.c Favourable Reference Area Is Unknown,
  "n_2_4_12_d_favourable_reference_area_method" VARCHAR  -- 2.4.12.d Favourable Reference Area Method,
  "n_2_4_13_a_surface_area_reason_for_change_genuine" VARCHAR  -- 2.4.13.a Surface Area Reason For Change - Genuine,
  "n_2_4_13_b_surface_area_reason_for_change_improved_knowledge" VARCHAR  -- 2.4.13.b Surface Area Reason For Change - Improved Knowledge,
  "n_2_4_13_c_surface_area_reason_for_change_different_method" VARCHAR  -- 2.4.13.c Surface Area Reason For Change - Different Method,
  "n_2_5_1_method_used_pressures" VARCHAR  -- 2.5.1 Method Used - Pressures,
  "n_2_6_1_method_used_threats" VARCHAR  -- 2.6.1 Method Used - Threats,
  "n_2_7_2_typical_species_method_used" VARCHAR  -- 2.7.2 Typical Species – Method Used,
  "n_2_7_3_justification_of_thresholds_for_trends" VARCHAR  -- 2.7.3 Justification Of % Thresholds For Trends,
  "n_2_7_4_structure_and_functions_methods_used" VARCHAR  -- 2.7.4 Structure And Functions - Methods Used,
  "n_2_7_5_other_relevant_information" VARCHAR  -- 2.7.5 Other Relevant Information,
  "n_2_8_1_a_range_conclusion" VARCHAR  -- 2.8.1.a Range Conclusion,
  "n_2_8_1_b_range_conclusion_qualifier" VARCHAR  -- 2.8.1.b Range Conclusion Qualifier,
  "n_2_8_2_a_area_conclusion" VARCHAR  -- 2.8.2.a Area Conclusion,
  "n_2_8_2_b_area_conclusion_qualifier" VARCHAR  -- 2.8.2.b Area Conclusion Qualifier,
  "n_2_8_3_aspecific_structures_and_functions_incl_typica_44f0b9ed" VARCHAR  -- 2.8.3.aSpecific Structures And Functions (incl. Typical Species) Conclusion,
  "n_2_8_3_b_specific_structures_and_functions_incl_typic_029ae880" VARCHAR  -- 2.8.3.b Specific Structures And Functions (incl. Typical Species) Conclusion Qualifier,
  "n_2_8_4_a_future_prospects_conclusion" VARCHAR  -- 2.8.4.a Future Prospects Conclusion,
  "n_2_8_4_b_future_prospects_conclusion_qualifier" VARCHAR  -- 2.8.4.b Future Prospects Conclusion Qualifier,
  "n_2_8_5_overall_assessment_of_conservation_status_conclusion" VARCHAR  -- 2.8.5. Overall Assessment Of Conservation Status Conclusion,
  "n_2_8_6_overall_trend_in_conservation_status_conclusio_9314dd8f" VARCHAR  -- 2.8.6 Overall Trend In Conservation Status Conclusion Qualifier,
  "n_3_1_1_a_surface_area_within_sac_network_minimum" DOUBLE  -- 3.1.1 (a) Surface Area Within SAC Network - Minimum,
  "n_3_1_1_b_surface_area_within_sac_network_maximum" DOUBLE  -- 3.1.1 (b) Surface Area Within SAC Network Maximum,
  "n_3_1_2_method_used_for_3_1_1" VARCHAR  -- 3.1.2 Method Used For 3.1.1,
  "n_3_1_3_trend_of_surface_area_within_the_sac_network" VARCHAR  -- 3.1.3 Trend Of Surface Area Within The SAC Network,
  "n_2_7_1_typical_species" VARCHAR  -- 2.7.1 Typical Species,
  "uk_report_hyperlink" VARCHAR
);