Personal tools

Subscriptions
Sign up to receive our reports (print and/or electronic) and quarterly e-newsletter.
Follow us
Twitter icon Twitter
Facebook icon Facebook
YouTube icon YouTube channel
RSS logo RSS Feeds
More

Write to us Write to us

For the public:


For media and journalists:

Contact EEA staff
Contact the web team
FAQ

Call us Call us

Reception:

Phone: (+45) 33 36 71 00
Fax: (+45) 33 36 71 99


next
previous
items

Skip to content. | Skip to navigation

Sound and independent information
on the environment

You are here: Home / Data and maps / Datasets / Nationally designated areas (CDDA)

Nationally designated areas (CDDA)

Note: new version is available!
Topics: , ,
The dataset contains the geographic location and size of the nationally designated areas

European data

Site habitats table

The table contains data on habitats and habitat cover within the site boundary.

[+] Show table definition (records:   68)

Site_code Site code unique record identifier. Int(4) -1
Cover The percentage of the site covered by this habitat class float(8) 0
Eunis hab EUNIS habitat classification the unique code of the EUNIS habitat classification up to the fourth level. nvarchar(5) -1
Nationally designated areas

The table contains informations on the individual designated areas at national level.

[+] Show table definition (records:   51289)

Altitude_max Altitude maximum the maximum altitude (meters) above sea level within the site boundaries. int(4) 0
Lat Latitude geographical coordinate in decimal degrees. float(8) 0
Lon Longitude geographical coordinate in decimal degrees. float(8) 0
Site_code Site code unique record identifier for nationally designated areas int(4) -1
Size Size area in ha int(4) 0
Altitude_min Altitude minimum the minimum altitude (meters) above sea level within the site boundaries. int(4) 0
Year Year year of establishment. The year the site was created under the designation concerned. nvarchar(4) 0
Lat_ns Latitude North/South nvarchar(1) 0
Lon_ew Longitude East/West nvarchar(1) 0
Desig_abbr National designation type code nvarchar(5) -1
Areaname Site name site name as given in local language. nvarchar(120) 0
Nuts NUTS code administrative Region Code according to the coding system of Eurostat. nvarchar(5) 0
Site_code_nat National site code unique record identifier in the national source database nvarchar(12) 0
Parent_iso Parent ISO code in most countries the Iso3 and Parent_iso codes are identical. For countries, which have so called DOM/TOMs or any kind of over seas territories under their jurisdiction, the Iso3 country code may be different from the parent country code. nvarchar(3) 0
Iso3 ISO3 code ISO 3 characters country code nvarchar(3) 0
Londeg Longitude degrees smallint(2) 0
Lonmin Longitude minutes smallint(2) 0
Lonsec Longitude seconds smallint(2) 0
Latdeg Latitude degrees smallint(2) 0
Latmin Latitude minutes smallint(2) 0
Latsec Latitude seconds smallint(2) 0
IUCNCAT IUCN category nvarchar(4) -1
National designation type category look-up table

[+] Show table definition (records:   3)

Category National designation type category nvarchar(1) -1
Definition IUCN category definition nvarchar(200) 0
Site relations lookup table

[+] Show table definition (records:   6)

Rel_code Relationship code nvarchar(1) -1
Relationship Relationship description nvarchar(200) 0
Site relations table

This table allows to indicate neighbouring sites or sites belonging to different designation types which overlap or neighbour each other.

[+] Show table definition (records:   1075)

Sitecode Site code unique record identifier for nationally designated areas int(4) -1
Rsitecode Related site code the unique record identifier of the related site. int(4) 0
Overlap Overlap the percentage of the described site that is overlapping with the other site. int(4) 0
Rel_code Relationship code the type of relationship between two sites. nvarchar(1) -1
IUCN category look-up table

[+] Show table definition (records:   7)

Definition IUCN category definition ntext(16) 0
Iucncat IUCN category nvarchar(4) -1
Title IUCN category title nvarchar(250) 0
List of designations by country

The table contains the list of designations and references to laws.

[+] Show table definition (records:   845)

Law Reference to the legal text ntext(16) 0
Lawreference Reference to the publication in Official Journal ntext(16) 0
Agency Address of the administrative authority responsible for this designation ntext(16) 0
Odesignate Title in original language nvarchar(100) 0
Designate Title in English nvarchar(100) 0
Title - french Title in French nvarchar(255) 0
Iso3 ISO 3 caracters country code nvarchar(3) 0
Desig_abbr National designation type code nvarchar(5) -1
Category National designation type category nvarchar(1) -1
EUNIS habitat classification

[+] Show table definition (records:   1659)

Eunis hab EUNIS habitat classification nvarchar(5) -1
Hab level Habitat level nvarchar(255) 0
Scientific name Scientific name of the habitat nvarchar(255) 0

Additional information

Metadata

Additional information

The inventory of nationally designated areas began under the CORINE programe. It is now maintained for EEA by the European Topic Centre on Nature Protection and Biodiversity and is being updated through EIONET.

 
Document Actions
European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100