About this Dataset

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

This dataset comprises the Country specific source data used to compile the individual Habitats 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 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; 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 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:52Z

Tables

Habitats-Directive-A17-2013-Country-and-offshore-reporting-info-Habitat-details

@ukgov.third_uk_habitats_directive_report_2013_habitat_detail_dbd9477b.habitats_directive_a17_2013_country_and_offshore_repor_2a227544

465.89 kB
236 rows
60 columns

CREATE TABLE habitats_directive_a17_2013_country_and_offshore_repor_2a227544 (
  "habitat_code" VARCHAR,
  "domain_marine_or_terrestrial" VARCHAR  -- Domain (marine Or Terrestrial,
  "habitat_code_and_name" VARCHAR,
  "habitat_name" VARCHAR,
  "n_1_1_1_distribution_map" BIGINT  -- 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" DOUBLE  -- 2.3.5.a Range Short-term Trend Magnitude - Minimum,
  "n_2_3_5_b_range_short_term_trend_magnitude_maximum" DOUBLE  -- 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" DOUBLE  -- 2.3.8.a Range Long-term Trend Magnitude - Minimum,
  "n_2_3_8_b_range_long_term_trend_magnitude_maximum" DOUBLE  -- 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_c_favourable_reference_range_is_unknown" BIGINT  -- 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" DOUBLE  -- 2.4.6.a Surface Area Short-term Trend Magnitude - Minimum,
  "n_2_4_6_b_surface_area_short_term_trend_magnitude_maximum" DOUBLE  -- 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" DOUBLE  -- 2.4.10.a Surface Area Long-term Trend Magnitude - Minimum,
  "n_2_4_10_b_surface_area_long_term_trend_magnitude_maximum" DOUBLE  -- 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_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
);