Nationally designated areas (CDDA)

This website has limited functionality with javascript off. Please make sure javascript is enabled in your browser.

Created : Nov 13, 2009 Published : Mar 07, 2005 Last modified : Nov 29, 2012 11:56 AM

The dataset contains the geographic location and size of the nationally designated areas

Note: new version is available!

Oct 04, 2012 - Nationally designated areas (CDDA)

European data

EUNIS habitat classification

[+] Show table definition (records: 1659)

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

eunis_habitats_level_4_for_cdda_en_v4.csv (text/comma-separated-values)
86.55 KB Download file

IUCN category

[+] Show table definition (records: 7)

Definition	IUCN category definition	ntext(16)
Iucncat	IUCN management category	nvarchar(4)
Title	Brief text description of habitat class	nvarchar(250)

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

List of designations by country

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

[+] Show table definition (records: 835)

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 character country code		nvarchar(6)	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	nvarchar(1)	0

designations_europe_en_v4.csv (text/comma-separated-values)
128.00 KB Download file
designations_europe_en_v4.dbf (dBASE document)
403.14 KB Download file
designations_europe_en_v4.mdb (application/msaccess)
360.00 KB Download file
designations_europe_en_v4.xls (Microsoft Excel spreadsheet)
188.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	IUCN category definition		nvarchar(200)	0

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

Site habitats table

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

[+] Show table definition (records: 7800)

Site_code	Unique record identifier for nationally designated areas		float(8)	0
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

sitehabitats_europe_en_v4.csv (text/comma-separated-values)
173.14 KB Download file
sitehabitats_europe_en_v4.dbf (dBASE document)
350.52 KB Download file
sitehabitats_europe_en_v4.mdb (application/msaccess)
340.00 KB Download file
sitehabitats_europe_en_v4.xls (Microsoft Excel spreadsheet)
520.50 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_v4.csv (text/comma-separated-values)
268 Bytes Download file

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: 2180)

Sitecode	Unique site reference code	this field can only contain existing site codes as identified in the Sites table.	float(8)	-1
Rsitecode	Related site code	the unique record identifier of the related site.	float(8)	0
Overlap	Overlap	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.	nvarchar(1)	-1

siterelations_europe_en_v4.csv (text/comma-separated-values)
52.18 KB Download file
siterelations_europe_en_v4.dbf (dBASE document)
132.15 KB Download file
siterelations_europe_en_v4.mdb (application/msaccess)
184.00 KB Download file
siterelations_europe_en_v4.xls (Microsoft Excel spreadsheet)
168.00 KB Download file

Sites data table

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

[+] Show table definition (records: 56413)

Lat	Latitude	geographical Co-ordinate in decimal degrees.	float(8)	0
Lon	Longitude	geographical coordinate in decimal degrees.	float(8)	0
Altitude_max	The maximum altitude (meters) above sea level within the site boundaries.		float(8)	0
Latsec	Latitude seconds		float(8)	0
Lonsec	Longitude seconds		float(8)	0
Site_code	Unique record identifier within the CDDA data base for nationally designated areas.		float(8)	0
Size	Surface area in ha.		float(8)	0
Altitude_min	The minimum altitude (meters) above sea level within the site boundaries.		float(8)	0
Lon_ew	Longitude East/West	E or W	nvarchar(1)	0
Nuts	Administrative Region Code according to the coding system of Eurostat.		nvarchar(5)	0
Year	annual data	year of establishment. The year the site was created under the designation concerned.	nvarchar(4)	0
Lat_ns	Latitude North/South		nvarchar(1)	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		nvarchar(4)	0
Site_code_nat	National site code	unique record identifier in the national source database	nvarchar(12)	0
Parent_iso	ISO 3 caracters country code		nvarchar(3)	0
Iso3	ISO 3 character country code		nvarchar(3)	0
Lonmin	Longitude minutes		smallint(2)	0
Latdeg	Latitude degrees		smallint(2)	0
Latmin	Latitude minutes		smallint(2)	0
Londeg	Longitude degrees		smallint(2)	0

sites_europe_en_v4_csv.zip (ZIP archive)
1.81 MB Download file
sites_europe_en_v4_dbf.zip (ZIP archive)
2.10 MB Download file
sites_europe_en_v4_mdb.zip (ZIP archive)
2.32 MB Download file
sites_europe_en_v4_xls.zip (ZIP archive)
4.18 MB Download file

Additional information

Database diagram

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

Metadata for the data tables

cdda tables metadata.xls (Microsoft Excel spreadsheet)
36.50 KB Download file

Metadata

Reporting obligations (ROD)

Nationally designated areas (CDDA-1)

Last upload:: 22 Feb 2005
Geographical coverage:
Tags:: CSI008 | CSI | geospatial data | ETC/NPB | EEA owned data sets | 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 (EEA).
Data sources: European Topic Centre on Nature Protection and Biodiversity. Date of delivery: 08/02/2005.
Owners:: European Environment Agency (EEA)

Permalink to this version: 9B55C462-54AE-4588-9864-AC1E1F005B24
Permalink to latest version: 29430BDF-9AFB-4F1A-A529-7B4EF6D680D7

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.