About this Dataset

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

This dataset comprises the Country specific source data used to compile the individual Species reports that formed a major part of the 3rd UK Habitats Directive Report for 2013. 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. The report submitted by the UK was an amalgamation of data from each of the four UK Countries and the offshore environment (> 12 nautical miles from the coast). This dataset presents the source data provided from the above five sources. It 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-Country-and-offshore-reporting-info-Species-details

@ukgov.third_uk_habitats_directive_report_2013_species_detail_d77c1462.habitats_directive_a17_2013_country_and_offshore_repor_79527cb4

445.25 kB
247 rows
84 columns

CREATE TABLE habitats_directive_a17_2013_country_and_offshore_repor_79527cb4 (
  "country" VARCHAR,
  "agency" VARCHAR,
  "species_code" VARCHAR,
  "species_name" VARCHAR,
  "species_name_common_and_scientifiec" VARCHAR,
  "uk_map" 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" DOUBLE  -- 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_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)
);