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

434.82 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,
  "n_1_1_1_sensitive_species" VARCHAR,
  "n_1_1_2_distribution_method" VARCHAR,
  "n_1_1_3_year_or_period" VARCHAR,
  "n_1_1_4_additional_distribution_map" VARCHAR,
  "n_1_1_5_range_map" VARCHAR,
  "n_2_1_biogeographical_region_marine_regions" VARCHAR,
  "n_2_2_published_sources" VARCHAR,
  "n_2_3_1_surface_area_range" DOUBLE,
  "n_2_3_2_method_used_surface_area_of_range" 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_range_short_term_trend_magnitude_a_minimum" DOUBLE,
  "n_2_3_5_range_short_term_trend_magnitude_b_maximum" DOUBLE,
  "n_2_3_6_range_long_term_trend_period" VARCHAR,
  "n_2_3_7_range_long_term_trend_direction" VARCHAR,
  "n_2_3_8_range_long_term_trend_magnitude_min" DOUBLE,
  "n_2_3_8_range_long_term_trend_magnitude_max" DOUBLE,
  "n_2_3_9a_favourable_reference_range_sq_km" DOUBLE,
  "n_2_3_9b_favourable_reference_range_operator" VARCHAR,
  "n_2_3_9c_favourable_reference_range_is_unknown" VARCHAR,
  "n_2_3_9d_favourable_reference_range_method" VARCHAR,
  "n_2_3_10_range_reason_for_change_a_genuine" VARCHAR,
  "n_2_3_10_range_reason_for_change_b_improved_knowledge" VARCHAR,
  "n_2_3_10_range_reason_for_change_c_different_method" VARCHAR,
  "n_2_4_1a_population_size_estimation_units" VARCHAR,
  "n_2_4_1b_population_size_estimation_minimum" DOUBLE,
  "n_2_4_1c_population_size_estimation_maximum" DOUBLE,
  "n_2_4_2a_population_size_estimation_alternative_units" VARCHAR,
  "n_2_4_2b_population_size_estimation_minimum_based_on_a_01de4137" DOUBLE,
  "n_2_4_2c_population_size_estimation_based_on_alternative_units" DOUBLE,
  "n_2_4_3_a_population_size_definition_of_locality" VARCHAR,
  "n_2_4_3_b_population_size_estimation_method_to_convert_data" VARCHAR,
  "n_2_4_3_c_issues_in_pop_size_estimation" VARCHAR,
  "n_2_4_4_population_size_esitmation_year_or_period" VARCHAR,
  "n_2_4_5_method_used_population_size" VARCHAR,
  "n_2_4_6_population_size_short_term_trend_period" VARCHAR,
  "n_2_4_7_population_size_short_term_trend_direction" VARCHAR,
  "n_2_4_8a_population_size_short_term_trend_magnitude_minumum" DOUBLE,
  "n_2_4_8b_population_size_short_term_trend_magnitude_maximum" DOUBLE,
  "n_2_4_8c_population_size_short_term_trend_magnitude_co_4df55728" DOUBLE,
  "n_2_4_9_population_size_short_term_trend_method_used" VARCHAR,
  "n_2_4_10_population_size_long_term_trend_period" VARCHAR,
  "n_2_4_11_population_size_long_term_trend_direction" VARCHAR,
  "n_2_4_12a_population_size_long_term_trend_magnitude_minimum" DOUBLE,
  "n_2_4_12b_population_size_long_term_trend_magnitude_maximum" DOUBLE,
  "n_2_4_12c_population_size_long_term_trend_magnitude_co_4ee0e8c1" DOUBLE,
  "n_2_4_13_population_size_long_term_trend_method_used" DOUBLE,
  "n_2_4_14a_favourable_reference_population_no_of_individuals" DOUBLE,
  "n_2_4_14b_favourable_reference_population_operator" VARCHAR,
  "n_2_4_14c_favourable_reference_population_is_unknown" VARCHAR,
  "n_2_4_14d_favourable_reference_population_method" VARCHAR,
  "n_2_4_15_population_size_reason_for_change_a_genuine" VARCHAR,
  "n_2_4_15_population_size_reason_for_change_b_improved_knowledge" VARCHAR,
  "n_2_4_15_population_size_reason_for_change_c_different_method" VARCHAR,
  "n_2_5_1_habitat_for_species_area_estimation" DOUBLE,
  "n_2_5_2_habitat_for_species_estimation_year_or_period" VARCHAR,
  "n_2_5_3_method_used_habitat_for_species" VARCHAR,
  "n_2_5_4_quality_of_the_habitat_a" VARCHAR,
  "n_2_5_4b_habitat_quality_estimation_method" VARCHAR,
  "n_2_5_5_short_term_trend_period" VARCHAR,
  "n_2_5_6_short_term_trend_direction" VARCHAR,
  "n_2_5_7_long_term_trend_period" VARCHAR,
  "n_2_5_8_long_term_trend_direction" VARCHAR,
  "n_2_5_9a_area_of_suitable_habitat_for_the_species_sq_km" DOUBLE,
  "n_2_5_10_habitat_for_species_estimation_reason_for_cha_14202b0f" VARCHAR,
  "n_2_5_10_habitat_for_species_estimation_reason_for_cha_2acf1713" VARCHAR,
  "n_2_5_10_habitat_for_species_estimation_reason_for_cha_a03a12b6" VARCHAR,
  "n_2_6_1_method_used_pressures" VARCHAR,
  "n_2_7_1_method_used_threats" VARCHAR,
  "n_2_8_1_justification_of_thresholds_for_trends" VARCHAR,
  "n_2_8_2_other_relevant_information" VARCHAR,
  "n_2_8_3_trans_boundary_assessment" VARCHAR,
  "n_3_1_1a_population_size_within_sac_network" VARCHAR,
  "n_3_1_1b_minimum_population_size_within_sac_network" DOUBLE,
  "n_3_1_1c_maximum_population_size_within_sac_network" DOUBLE,
  "n_3_1_2_method_used_for_3_1_1" VARCHAR,
  "n_3_1_3_trend_of_population_size_within_the_sac_networ_b12dcdce" VARCHAR
);