UK Ramsar Qualifying Features (birds) by UK Government | Finance and Economics

About this Dataset

UK Ramsar Qualifying Features (birds)

Ramsar sites are wetlands of international importance designated under the Ramsar Convention. This dataset contains details for all qualifying bird species (of international and national importance) for all designated Ramsar sites within the UK and its Overseas Territories and Crown Dependencies. The majority of UKs sites are established for internationally important populations of non breeding waterfowl though some sites have no qualifying ornithological interest. The dataset presents data used on the Ramsar Information Sheets compiled for all Ramsar sites. This dataset contains the following columns. SITENAME SITECODE COUNTRY SITE STATUS - always classified/designated INTEREST STATUS - either internationally or nationally important NOWAK CODE - standard species code used in international reporting BIRDNAME LAY_TITLE - common name SEASON COUNT UNITS - individuals or pairs Pop UNITS count and unit together eg 4345 i YEAR - count period for bird counts CRITERIA_DESC - description of the population proportion - proportion ie % of total population assemb component - Y = component of assemblage X_COORDINATE - easting Y_COORDINATE - northing Note that Overseas Territories Birds are not included here - details of these are available within the dataset "UK Ramsar sites"
Publisher name: Joint Nature Conservation Committee
Last updated: 2024-09-14T19:07:12Z

Tables

UK-Ramsar-bird-data-201510

@ukgov.uk_ramsar_qualifying_features_birds.uk_ramsar_bird_data_201510

53.21 KB
1326 rows
19 columns


CREATE TABLE uk_ramsar_bird_data_201510 (
  "internal_key" DOUBLE,
  "sitename" VARCHAR,
  "sitecode" VARCHAR,
  "country" VARCHAR,
  "site_status" VARCHAR,
  "interest_status" VARCHAR,
  "nowak_code" VARCHAR,
  "birdname" VARCHAR,
  "lay_title" VARCHAR,
  "season" VARCHAR,
  "count" BIGINT,
  "units" VARCHAR,
  "pop_units" VARCHAR,
  "year" VARCHAR,
  "criteria_desc" VARCHAR,
  "proportion" DOUBLE,
  "assemb_component" VARCHAR,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE
);