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

249.14 KB
77 rows
73 columns


CREATE TABLE habitats_directive_a17_2013_uk_reporting_info_habitat_details (
  "habitat_code" VARCHAR,
  "domain_marine_or_terrestrial" VARCHAR,
  "habitat_code_and_name" VARCHAR,
  "habitat_name" VARCHAR,
  "geographical_level" VARCHAR,
  "n_1_1_1_distribution_map" VARCHAR,
  "n_1_1_2_method_used_map" VARCHAR,
  "n_1_1_3_map_data_year_or_period" VARCHAR,
  "n_1_1_4_additional_distribution_map" VARCHAR,
  "n_1_1_5_range_map" VARCHAR,
  "biogeographic_region" VARCHAR,
  "n_2_2_published_sources" VARCHAR,
  "n_2_3_1_range_surface_area_sq_km" DOUBLE,
  "n_2_3_2_range_method_used" VARCHAR,
  "n_2_3_3_range_short_term_trend_period" VARCHAR,
  "n_2_3_4_range_short_term_trend_direction" VARCHAR,
  "n_2_3_5_a_range_short_term_trend_magnitude_minimum" VARCHAR,
  "n_2_3_5_b_range_short_term_trend_magnitude_maximum" VARCHAR,
  "n_2_3_6_range_long_term_trend_period" VARCHAR,
  "n_2_3_7_range_long_term_trend_direction" VARCHAR,
  "n_2_3_8_a_range_long_term_trend_magnitude_minimum" VARCHAR,
  "n_2_3_8_b_range_long_term_trend_magnitude_maximum" VARCHAR,
  "n_2_3_9_a_favourable_reference_range_sq_km" DOUBLE,
  "n_2_3_9_b_favourable_reference_range_operator" VARCHAR,
  "n_2_3_9_c_favourable_reference_range_is_unknown" VARCHAR,
  "n_2_3_9_d_favourable_reference_range_method" VARCHAR,
  "n_2_3_10_a_range_reason_for_change_genuine" VARCHAR,
  "n_2_3_10_b_range_reason_for_change_improved_knowledge" VARCHAR,
  "n_2_3_10_c_range_reason_for_change_different_method" VARCHAR,
  "n_2_4_1_surface_area_sq_km" DOUBLE,
  "n_2_4_2_surface_area_year_or_period" VARCHAR,
  "n_2_4_3_method_used_area_covered_by_habitat" VARCHAR,
  "n_2_4_4_surface_area_short_term_trend_period" VARCHAR,
  "n_2_4_5_surface_area_short_term_trend_direction" VARCHAR,
  "n_2_4_6_a_surface_area_short_term_trend_magnitude_minimum" VARCHAR,
  "n_2_4_6_b_surface_area_short_term_trend_magnitude_maximum" VARCHAR,
  "n_2_4_6_c_surface_area_short_term_trend_magnitude_conf_2fdbb39f" VARCHAR,
  "n_2_4_7_surface_area_short_term_trend_method_used" VARCHAR,
  "n_2_4_8_surface_area_long_term_trend_period" VARCHAR,
  "n_2_4_9_surface_area_long_term_trend_direction" VARCHAR,
  "n_2_4_10_a_surface_area_long_term_trend_magnitude_minimum" VARCHAR,
  "n_2_4_10_b_surface_area_long_term_trend_magnitude_maximum" VARCHAR,
  "n_2_4_10_c_surface_area_long_term_trend_magnitude_conf_547ce644" VARCHAR,
  "n_2_4_11_surface_area_long_term_trend_method_used" VARCHAR,
  "n_2_4_12_a_favourable_reference_area" DOUBLE,
  "n_2_4_12_b_favourable_reference_area_operator" VARCHAR,
  "n_2_4_12_c_favourable_reference_area_is_unknown" VARCHAR,
  "n_2_4_12_d_favourable_reference_area_method" VARCHAR,
  "n_2_4_13_a_surface_area_reason_for_change_genuine" VARCHAR,
  "n_2_4_13_b_surface_area_reason_for_change_improved_knowledge" VARCHAR,
  "n_2_4_13_c_surface_area_reason_for_change_different_method" VARCHAR,
  "n_2_5_1_method_used_pressures" VARCHAR,
  "n_2_6_1_method_used_threats" VARCHAR,
  "n_2_7_2_typical_species_method_used" VARCHAR,
  "n_2_7_3_justification_of_thresholds_for_trends" VARCHAR,
  "n_2_7_4_structure_and_functions_methods_used" VARCHAR,
  "n_2_7_5_other_relevant_information" VARCHAR,
  "n_2_8_1_a_range_conclusion" VARCHAR,
  "n_2_8_1_b_range_conclusion_qualifier" VARCHAR,
  "n_2_8_2_a_area_conclusion" VARCHAR,
  "n_2_8_2_b_area_conclusion_qualifier" VARCHAR,
  "n_2_8_3_aspecific_structures_and_functions_incl_typica_44f0b9ed" VARCHAR,
  "n_2_8_3_b_specific_structures_and_functions_incl_typic_029ae880" VARCHAR,
  "n_2_8_4_a_future_prospects_conclusion" VARCHAR,
  "n_2_8_4_b_future_prospects_conclusion_qualifier" VARCHAR,
  "n_2_8_5_overall_assessment_of_conservation_status_conclusion" VARCHAR,
  "n_2_8_6_overall_trend_in_conservation_status_conclusio_9314dd8f" VARCHAR,
  "n_3_1_1_a_surface_area_within_sac_network_minimum" DOUBLE,
  "n_3_1_1_b_surface_area_within_sac_network_maximum" DOUBLE,
  "n_3_1_2_method_used_for_3_1_1" VARCHAR,
  "n_3_1_3_trend_of_surface_area_within_the_sac_network" VARCHAR,
  "n_2_7_1_typical_species" VARCHAR,
  "uk_report_hyperlink" VARCHAR
);