About this Dataset

Special Protection Areas (SPAs) Bird Data Submitted To The EU

This dataset contains details for each and every qualifying bird species on every Special Protection Area (SPA). Special Protection Areas (SPAs) are strictly protected sites classified in accordance with Article 4 of the EC Birds Directive, which came into force in April 1979. They are classified for rare and vulnerable birds (as listed on Annex I of the Directive), and for regularly occurring migratory species. The EU Commission requires information on each site to be compiled in the form of a Standard Data Form. This dataset is updated every time a new or amended batch of information is submitted to the EU Commission. This dataset contains information drawn from section 3.1 of the Standard Data Form. From December 2015 onwards this included the following fields SITE_CODE SITE_NAME Country LOCAL_AUTHORITY Site_status X_coord (Eastings) Y_coord (Northings) Nowak_code Species Common_name Season Population_count_min Population_count_max Pop_units SPECIES_DATA_QUALITY COUNT_PERIOD IMPORTANCE SPECIES_POPULATION SPECIES_CONSERVATION SPECIES_ISOLATION SPECIES_GLOBAL
Publisher name: Joint Nature Conservation Committee
Last updated: 2024-09-14T19:08:32Z

Tables

Natura2000-tranche50-SPA-interest-features

@ukgov.special_protection_areas_spas_bird_data_submitted_to_the_eu.natura2000_tranche50_spa_interest_features

57.95 KB
1190 rows
21 columns


CREATE TABLE natura2000_tranche50_spa_interest_features (
  "site_code" VARCHAR,
  "site_name" VARCHAR,
  "country" VARCHAR,
  "local_authority" VARCHAR,
  "site_status" VARCHAR,
  "x_coord" BIGINT,
  "y_coord" BIGINT,
  "nowak_code" VARCHAR,
  "species" VARCHAR,
  "common_name" VARCHAR,
  "season" VARCHAR,
  "population_count_min" DOUBLE,
  "population_count_max" DOUBLE,
  "pop_units" VARCHAR,
  "species_data_quality" VARCHAR,
  "count_period" VARCHAR,
  "importance" VARCHAR,
  "species_population" VARCHAR,
  "species_conservation" VARCHAR,
  "species_isolation" VARCHAR,
  "species_global" VARCHAR
);