UK Ramsar Qualifying Features (birds)

Joint Nature Conservation Committee

@ukgov.uk_ramsar_qualifying_features_birds

Table List

1 table(53.21 KB)

UK-Ramsar-bird-data-201510

@ukgov.uk_ramsar_qualifying_features_birds.uk_ramsar_bird_data_201510

Resource locator

53.21 KB
1326 rows
19 columns

internal_key INTERNAL KEY	sitename SITENAME	sitecode SITECODE	country COUNTRY	site_status SITE STATUS	interest_status INTEREST STATUS	nowak_code NOWAK CODE	birdname BIRDNAME	lay_title LAY TITLE	season SEASON	count COUNT	units UNITS	pop_units Pop UNITS	year YEAR	criteria_desc CRITERIA DESC	proportion Proportion	assemb_component Assemb Component	x_coordinate X COORDINATE	y_coordinate Y COORDINATE
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	125	Fulica atra (North-western Europe - wintering)	Common coot	P	8953	Individuals	8953 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB passage)	5.17514450867052	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	internationally important	050	Anas penelope (Western Siberia/North-western/North-eastern Europe)	Eurasian wigeon	W	2888	Individuals	2888 i		International population (Wintering)	1.69882352941176	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	internationally important	WATR	Waterfowl assemblage	Waterfowl assemblage	W	23787	Individuals	23787 i	5 year peak mean 1998/9-2002/3	Waterfowl assemblage - wintering		N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	164	Tringa nebularia (Europe/Western Africa)	Common greenshank	P	6	Individuals	6 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB passage)	1.00502512562814	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	161	Tringa erythropus (Europe/Western Africa)	Spotted redshank	P	11	Individuals	11 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB passage)	8.08823529411765	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	156	Limosa limosa islandica (Iceland - breeding)	Black-tailed godwit	P	220	Individuals	220 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB passage)	1.42949967511371	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	132	Recurvirostra avosetta (Western Europe/Western Mediterranean - breeding)	Pied avocet	P	38	Individuals	38 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB passage)	1.11929307805596	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	067	Bucephala clangula (North-western/Central Europe)	Common goldeneye	W	515	Individuals	515 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB wintering)	2.06827309236948	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	nationally important	061	Aythya fuligula (North-western Europe)	Tufted duck	P	3243	Individuals	3243 i	5 year peak mean 1998/9-2002/3	Nationally important population (GB passage)	3.59933407325194	N	597597	217145
7000022	Abberton Reservoir	UK11001	E	Classified/designatd	internationally important	059	Aythya ferina (North-western/North-eastern Europe)	Common pochard	P	4373	Individuals	4373 i	5 year peak mean 1998/9-2002/3	International population (passage)	1.24942857142857	N	597597	217145


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
);