About this Dataset

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

This dataset contains details of all the Species Reports that summarise the conservation status of Species 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 October 2013. The 3rd UK Habitats Directive Report considered the conservation status of all terrestrial and marine species listed under Annexes II, IV and V of the Directive that were present within the UK during the reporting period. This included: *83 terrestrial species within the UK Atlantic region; *42 marine species within the UK Marine Atlantic region; *4 terrestrial species within the Gibraltar Mediterranean region; *18 marine species within the Gibraltar Marine Mediterranean region. This dataset presents the conclusions for each species together with a link to each individual species report (in pdf format). It also contains a range of parameters for each species 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:57Z

Tables

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

@ukgov.third_uk_habitats_directive_report_2013_uk_level_speci_52054056.habitats_directive_a17_2013_uk_reporting_info_species_details

472.84 kB
125 rows
97 columns

CREATE TABLE habitats_directive_a17_2013_uk_reporting_info_species_details (
  "species_code" VARCHAR,
  "scientific_name" VARCHAR,
  "domain_marine_or_terrestrial" VARCHAR  -- Domain (marine Or Terrestrial),
  "vagrant" VARCHAR,
  "geographical_level" VARCHAR,
  "species_code_and_name" VARCHAR,
  "species_common_and_scientific_name" VARCHAR,
  "species_name" VARCHAR,
  "n_1_1_1_distribution_map" VARCHAR  -- 1.1.1 Distribution Map,
  "n_1_1_1_sensitive_species" VARCHAR  -- 1.1.1. Sensitive Species,
  "n_1_1_2_distribution_method" VARCHAR  -- 1.1.2 Distribution Method,
  "n_1_1_3_year_or_period" VARCHAR  -- 1.1.3 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,
  "n_2_1_biogeographical_region_marine_regions" VARCHAR  -- 2.1 Biogeographical Region & Marine Regions,
  "n_2_2_published_sources" VARCHAR  -- 2.2 Published Sources,
  "n_2_3_1_surface_area_range" DOUBLE  -- 2.3.1 Surface Area Range,
  "n_2_3_2_method_used_surface_area_of_range" VARCHAR  -- 2.3.2 Method Used Surface Area Of Range,
  "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_range_short_term_trend_magnitude_a_minimum" DOUBLE  -- 2.3.5 Range Short-term Trend Magnitude A) Minimum,
  "n_2_3_5_range_short_term_trend_magnitude_b_maximum" DOUBLE  -- 2.3.5 Range Short-term Trend Magnitude B) 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_range_long_term_trend_magnitude_min" DOUBLE  -- 2.3.8 Range Long-term Trend Magnitude Min,
  "n_2_3_8_range_long_term_trend_magnitude_max" DOUBLE  -- 2.3.8 Range Long-term Trend Magnitude Max,
  "n_2_3_9a_favourable_reference_range_sq_km" DOUBLE  -- 2.3.9a Favourable Reference Range - Sq Km,
  "n_2_3_9b_favourable_reference_range_operator" VARCHAR  -- 2.3.9b Favourable Reference Range - Operator,
  "n_2_3_9c_favourable_reference_range_is_unknown" VARCHAR  -- 2.3.9c Favourable Reference Range Is Unknown,
  "n_2_3_9d_favourable_reference_range_method" VARCHAR  -- 2.3.9d Favourable Reference Range Method,
  "n_2_3_10_range_reason_for_change_a_genuine" VARCHAR  -- 2.3.10 Range Reason For Change A) Genuine,
  "n_2_3_10_range_reason_for_change_b_improved_knowledge" VARCHAR  -- 2.3.10 Range Reason For Change B) Improved Knowledge,
  "n_2_3_10_range_reason_for_change_c_different_method" VARCHAR  -- 2.3.10 Range Reason For Change C) Different Method,
  "n_2_4_1a_population_size_estimation_units" VARCHAR  -- 2.4.1a Population Size Estimation - Units,
  "n_2_4_1b_population_size_estimation_minimum" DOUBLE  -- 2.4.1b Population Size Estimation - Minimum,
  "n_2_4_1c_population_size_estimation_maximum" DOUBLE  -- 2.4.1c Population Size Estimation - Maximum,
  "n_2_4_2a_population_size_estimation_alternative_units" VARCHAR  -- 2.4.2a Population Size Estimation Alternative Units,
  "n_2_4_2b_population_size_estimation_minimum_based_on_a_01de4137" DOUBLE  -- 2.4.2b Population Size Estimation Minimum Based On Alternative Units,
  "n_2_4_2c_population_size_estimation_based_on_alternative_units" DOUBLE  -- 2.4.2c Population Size Estimation Based On Alternative Units,
  "n_2_4_3_a_population_size_definition_of_locality" VARCHAR  -- 2.4.3 A) Population Size Definition Of Locality,
  "n_2_4_3_b_population_size_estimation_method_to_convert_data" VARCHAR  -- 2.4.3 B) Population Size Estimation Method To Convert Data,
  "n_2_4_3_c_issues_in_pop_size_estimation" VARCHAR  -- 2.4.3 C) Issues In Pop Size Estimation,
  "n_2_4_4_population_size_esitmation_year_or_period" VARCHAR  -- 2.4.4 Population Size Esitmation Year Or Period,
  "n_2_4_5_method_used_population_size" VARCHAR  -- 2.4.5 Method Used Population Size,
  "n_2_4_6_population_size_short_term_trend_period" VARCHAR  -- 2.4.6 Population Size Short-term Trend Period,
  "n_2_4_7_population_size_short_term_trend_direction" VARCHAR  -- 2.4.7 Population Size Short-term Trend Direction,
  "n_2_4_8a_population_size_short_term_trend_magnitude_minumum" DOUBLE  -- 2.4.8a Population Size Short-term Trend Magnitude Minumum,
  "n_2_4_8b_population_size_short_term_trend_magnitude_maximum" DOUBLE  -- 2.4.8b Population Size Short-term Trend Magnitude Maximum,
  "n_2_4_8c_population_size_short_term_trend_magnitude_co_4df55728" DOUBLE  -- 2.4.8c Population Size Short-term Trend Magnitude Confidence Interval,
  "n_2_4_9_population_size_short_term_trend_method_used" VARCHAR  -- 2.4.9 Population Size Short-term Trend Method Used,
  "n_2_4_10_population_size_long_term_trend_period" VARCHAR  -- 2.4.10 Population Size Long-term Trend Period,
  "n_2_4_11_population_size_long_term_trend_direction" VARCHAR  -- 2.4.11 Population Size Long-term Trend Direction,
  "n_2_4_12a_population_size_long_term_trend_magnitude_minimum" DOUBLE  -- 2.4.12a Population Size Long-term Trend Magnitude Minimum,
  "n_2_4_12b_population_size_long_term_trend_magnitude_maximum" DOUBLE  -- 2.4.12b Population Size Long-term Trend Magnitude Maximum,
  "n_2_4_12c_population_size_long_term_trend_magnitude_co_4ee0e8c1" DOUBLE  -- 2.4.12c Population Size Long-term Trend Magnitude Confidence Interval,
  "n_2_4_13_population_size_long_term_trend_method_used" VARCHAR  -- 2.4.13 Population Size Long Term Trend Method Used,
  "n_2_4_14a_favourable_reference_population_no_of_individuals" DOUBLE  -- 2.4.14a Favourable Reference Population No Of Individuals,
  "n_2_4_14b_favourable_reference_population_operator" VARCHAR  -- 2.4.14b Favourable Reference Population Operator,
  "n_2_4_14c_favourable_reference_population_is_unknown" VARCHAR  -- 2.4.14c Favourable Reference Population Is Unknown,
  "n_2_4_14d_favourable_reference_population_method" VARCHAR  -- 2.4.14d Favourable Reference Population Method,
  "n_2_4_15_population_size_reason_for_change_a_genuine" VARCHAR  -- 2.4.15 Population Size Reason For Change A) Genuine,
  "n_2_4_15_population_size_reason_for_change_b_improved_knowledge" VARCHAR  -- 2.4.15 Population Size Reason For Change B) Improved Knowledge,
  "n_2_4_15_population_size_reason_for_change_c_different_method" VARCHAR  -- 2.4.15 Population Size Reason For Change C) Different Method,
  "n_2_5_1_habitat_for_species_area_estimation" DOUBLE  -- 2.5.1 Habitat For Species Area Estimation,
  "n_2_5_2_habitat_for_species_estimation_year_or_period" VARCHAR  -- 2.5.2 Habitat For Species Estimation Year Or Period,
  "n_2_5_3_method_used_habitat_for_species" VARCHAR  -- 2.5.3 Method Used Habitat For Species,
  "n_2_5_4_quality_of_the_habitat_a" VARCHAR  -- 2.5.4 Quality Of The Habitat A),
  "n_2_5_4b_habitat_quality_estimation_method" VARCHAR  -- 2.5.4b Habitat Quality Estimation Method,
  "n_2_5_5_short_term_trend_period" VARCHAR  -- 2.5.5 Short-term Trend Period,
  "n_2_5_6_short_term_trend_direction" VARCHAR  -- 2.5.6 Short-term Trend Direction,
  "n_2_5_7_long_term_trend_period" VARCHAR  -- 2.5.7 Long-term Trend Period,
  "n_2_5_8_long_term_trend_direction" VARCHAR  -- 2.5.8 Long-term Trend Direction,
  "n_2_5_9a_area_of_suitable_habitat_for_the_species_sq_km" DOUBLE  -- 2.5.9a Area Of Suitable Habitat For The Species (sq Km),
  "n_2_5_10_habitat_for_species_estimation_reason_for_cha_14202b0f" VARCHAR  -- 2.5.10 Habitat For Species Estimation. Reason For Change A) Genuine,
  "n_2_5_10_habitat_for_species_estimation_reason_for_cha_2acf1713" VARCHAR  -- 2.5.10 Habitat For Species Estimation. Reason For Change B) Improved Knowledge,
  "n_2_5_10_habitat_for_species_estimation_reason_for_cha_a03a12b6" VARCHAR  -- 2.5.10 Habitat For Species Estimation. Reason For Change C) Different Method,
  "n_2_6_1_method_used_pressures" VARCHAR  -- 2.6.1 Method Used – Pressures,
  "n_2_7_1_method_used_threats" VARCHAR  -- 2.7.1. Method Used – Threats,
  "n_2_8_1_justification_of_thresholds_for_trends" VARCHAR  -- 2.8.1. Justification Of % Thresholds For Trends,
  "n_2_8_2_other_relevant_information" VARCHAR  -- 2.8.2. Other Relevant Information,
  "n_2_8_3_trans_boundary_assessment" VARCHAR  -- 2.8.3. Trans-boundary Assessment,
  "n_2_9_1_a_range_conclusion" VARCHAR  -- 2.9.1.a Range Conclusion,
  "n_2_9_1_b_range_conclusion_qualifier" VARCHAR  -- 2.9.1.b Range Conclusion Qualifier,
  "n_2_9_2_a_population_conclusion" VARCHAR  -- 2.9.2.a Population Conclusion,
  "n_2_9_2_b_population_conclusion_qualifier" VARCHAR  -- 2.9.2.b Population Conclusion Qualifier,
  "n_2_9_3a_habitat_for_the_species_conclusion" VARCHAR  -- 2.9.3a Habitat For The Species Conclusion,
  "n_2_9_3b_habitat_for_the_species_conclusion_qualifier" VARCHAR  -- 2.9.3b Habitat For The Species Conclusion Qualifier,
  "n_2_9_4a_future_prospects_conclusion" VARCHAR  -- 2.9.4a Future Prospects Conclusion,
  "n_2_9_4b_future_prospects_conclusion_qualifier" VARCHAR  -- 2.9.4b Future Prospects Conclusion Qualifier,
  "n_2_9_5_overall_assessment_of_conservation_status" VARCHAR  -- 2.9.5 Overall Assessment Of Conservation Status,
  "n_2_9_6_overall_trend_in_conservation_status" VARCHAR  -- 2.9.6 Overall Trend In Conservation Status,
  "n_3_1_1a_population_size_within_sac_network" VARCHAR  -- 3.1.1a Population Size Within SAC Network,
  "n_3_1_1b_minimum_population_size_within_sac_network" DOUBLE  -- 3.1.1b Minimum Population Size Within SAC Network,
  "n_3_1_1c_maximum_population_size_within_sac_network" DOUBLE  -- 3.1.1c Maximum Population Size Within SAC Network,
  "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_population_size_within_the_sac_networ_b12dcdce" VARCHAR  -- 3.1.3 Trend Of Population Size Within The SAC Network (short-term Trend),
  "uk_report_hyperlink" VARCHAR
);