Nationally designated areas (National - CDDA)

The European inventory of nationally designated areas holds information about protected sites and about the national legislative instruments, which directly or indirectly create protected areas

Note: new version is available!

Oct 12, 2011 - Nationally designated areas (National - CDDA)

European data set

EUNIS habitat classification

[+] Show table definition (records: 1622)

Eunis hab	EUNIS habitat classification class code	the unique code of the EUNIS habitat classification up to the fourth level.	nvarchar(10)	-1
Hab level	Habitat level in classification		nvarchar(1)	0
Scientific name	Scientific name of the habitat		nvarchar(255)	0

eunis_habitats_level_4_for_cdda_en_v5.csv (text/comma-separated-values)
84.56 KB Download file

IUCN category

[+] Show table definition (records: 7)

Definition	Designation type category definition	ntext(16)	0
IUCNCAT	IUCN management category	nvarchar(4)	-1
Title	Brief text description of habitat class	nvarchar(250)	0

iucncategories_en_v5.csv (text/comma-separated-values)
2.55 KB Download file

List of designations by country

Table contains list of designations, references to laws as well as number and total area of sites per designation.

[+] Show table definition (records: 838)

Total area	Total area of sites with that designation from table Sites within CDDA-National		float(8)	0
Number	Number of sites with that designation from table Sites within CDDA-National		int(4)	0
Law	Title and article of the law designation		ntext(16)	0
Lawreference	Reference to the publication in Official Journal		ntext(16)	0
Agency	Name and address of the highest 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	the designation type category according to the codes (A, B or C) appendix D of the Natura 2000 and Emerald Standard Data Form (see look-up table National designation type categories)	nvarchar(1)	-1

designations_europe_en_v5.csv (text/comma-separated-values)
144.40 KB Download file
designations_europe_en_v5.dbf (dBASE document)
437.38 KB Download file
designations_europe_en_v5.mdb (application/msaccess)
420.00 KB Download file
designations_europe_en_v5.xls (Microsoft Excel spreadsheet)
206.50 KB Download file

National designation type category

[+] Show table definition (records: 3)

Category	National designation type category	the designation type category according to the codes (A, B or C) appendix D of the Natura 2000 and Emerald Standard Data Form.	nvarchar(1)	0
Definition	Designation type category definition		nvarchar(200)	0

cdda_desig_categories_en_v5.csv (text/comma-separated-values)
456 Bytes Download file

Site habitats table

Table contains data on habitats and habitat cover within the site boundary of each individual designated site.

[+] Show table definition (records: 7915)

Cover	% of site affected		float(8)	0
Eunis hab	EUNIS habitat classification	the unique code of the EUNIS habitat classification up to the fourth level.	nvarchar(5)	-1
Site_code	Unique record identifier within the CDDA data base for nationally designated areas		float(8)	-1

sitehabitats_europe_en_v5.csv (text/comma-separated-values)
170.89 KB Download file
sitehabitats_europe_en_v5.dbf (dBASE document)
355.68 KB Download file
sitehabitats_europe_en_v5.mdb (application/msaccess)
356.00 KB Download file
sitehabitats_europe_en_v5.xls (Microsoft Excel spreadsheet)
506.00 KB Download file

Site relations

[+] Show table definition (records: 6)

Rel_code	Relationship code	the type of relationship between two sites	nvarchar(1)	-1
Relationship	Relationship description		nvarchar(200)	0

cdda_relations_categories_en_v5.csv (text/comma-separated-values)
268 Bytes Download file

Site relations table

Table indicates how each designated site relates to others (overlapping, neighbouring sites, containing each other etc)

[+] Show table definition (records: 3228)

Site_code	Unique site reference code	this field can only contain existing site codes as identified in the Sites table.	float(8)	-1
Rsite_code	Related site code	the unique record identifier of the related site.	float(8)	0
Overlap	Overlapping percentage	the percentage of the described site that is overlapping with the other site.	float(8)	0
Rel_code	Relationship code	the type of relationship between two sites (see look-up table Site relation categories).	nvarchar(1)	-1

siterelations_europe_en_v5.csv (text/comma-separated-values)
84.57 KB Download file
siterelations_europe_en_v5.dbf (dBASE document)
195.60 KB Download file
siterelations_europe_en_v5.mdb (application/msaccess)
224.00 KB Download file
siterelations_europe_en_v5.xls (Microsoft Excel spreadsheet)
244.00 KB Download file

Sites data table

Table contains main information (name, location, area, IUCN category etc) of each individual designated area at national level.

[+] Show table definition (records: 75792)

Altitude_max	The maximum altitude (meters) above the sea level within the site boundaries		float(8)	0
Lat	Latitudes, geographical coordinate in decimal degrees		float(8)	0
Lon	Longitudes, geographical coordinate in decimal degrees		float(8)	0
Site_code	Unique record identifier within the CDDA data base for nationally designated areas		float(8)	-1
Size	Site surface area in ha		float(8)	0
Altitude_min	The minimum altitude (meters) above the sea level within the site boundaries		float(8)	0
Nuts	Administrative Region Code according to the coding system of EUROSTAT		nvarchar(5)	0
Year	Year of establishment. Year when the site was created under current designation		nvarchar(4)	0
Desig_abbr	National designation type code		nvarchar(5)	-1
Areaname	Site name as given in local language		nvarchar(120)	0
IUCNCAT	IUCN management category (see look-up table IUCN categories)		nvarchar(4)	-1
Site_code_nat	National site code	unique record identifier in the national source database	nvarchar(12)	0
Parent_iso	ISO 3 characters country code		nvarchar(6)	0
Iso3	ISO 3 characters country code (in case of overseas territories, code of those)		nvarchar(3)	0

sites_europe_en_v5.csv (text/comma-separated-values)
8.13 MB Download file
sites_europe_en_v5_dbf.zip (ZIP archive)
2.20 MB Download file
sites_europe_en_v5_mdb.zip (ZIP archive)
5.30 MB Download file

Additional information

Countries codes and abbreviations

ISO Alpha-3 code can be found at the following URL: http://unstats.un.org/unsd/methods/m49/m49alpha.htm#ftna (Source: United Nations Statistics Division)

iso_alpha3 codes.txt (Plain Text)
200 Bytes Download file

Database diagram

cdda database diagram.png (PNG image)
29.72 KB Download file

Nationally designated areas (National - CDDA)

Quality control documentation

cdda checks version5.doc (Microsoft Word Document)
1.29 MB Download file

Tables metadata

cdda tables metadata.csv (text/comma-separated-values)
4.81 KB Download file

Additional information

The inventory began under the CORINE programme. It is now maintained for EEA by the European Topic Centre on Biological Diversity and is annually updated through Eionet. EEA provides the European inventory of nationally designated areas to the World Database of Protected Areas (WDPA) and to Eurostat. The nationally designated areas data can also be queried online in the European Nature Information System (EUNIS). The inventory is the national module of the Common Database on Designated Areas (CDDA) which also includes information on areas designated under European Community legislation and areas designated under international conventions. A poster describing the CDDA is available at: http://biodiversity-chm.eea.europa.eu/information/document/EEA/1082987029.

Produced maps and graphs

Distribution of reported data of Nationally designated areas (CDDA) - points. The map is intended to show the distribution of point locations reported for nationally designated areas

Reporting obligations (ROD)

Nationally designated areas (CDDA-1)

Publish date:: 20 Dec 2005
Last upload:: 07 Dec 2005
Geographical coverage:: EU25, EU27, EU12, EU15, EFTA4, EEA32, Albania, Andorra, Armenia, Azerbaijan, Belarus, Bosnia and Herzegovina, Croatia, Georgia, Moldova Republic of, Monaco, Montenegro, Russian Federation, Serbia, Ukraine
Tags:: CSI008 | CSI | geospatial data | EEA owned data sets | ETC/NPB | protected area
Rights:: EEA standard re-use policy: unless otherwise indicated, re-use of content on the EEA website for commercial or non-commercial purposes is permitted free of charge, provided that the source is acknowledged (http://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency.
Source:: European Topic Centre on Biological Diversity (ETC/BD). Date of delivery: 02/09/2005.
Owners:: European Environment Agency