Nationally designated areas (CDDA)

Data

Prod-ID: DAT-24-en

expired Created 30 Oct 2009 Published 30 Oct 2009 Last modified 11 Sep 2015

Note: new version is available!

This content has been archived on 31 Oct 2014, reason: Other (New version data-and-maps/data/nationally-designated-areas-national-cdda-9 was published)

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

European data

CDDA - Microsoft Access database (5 tables)

Database contains all data tables. Detailed table definitions are displayed in the section with individual tables.

Microsoft Access format (zip) (ZIP archive)
8.42 MB 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: 730)

Field name	Field Definition	Data type	Primary key
Number	Number of sites with that designation from table Sites within CDDA-National	int(4)	0
Total_area	Total area of sites with that designation from table Sites within CDDA-National	decimal(9)	0
PARENT_ISO	ISO 3 characters country code	nvarchar(3)	-1
ISO3	Country ISO code	nvarchar(3)	-1
DESIG_ABBR	National designation type code	nvarchar(5)	-1
Category	National designation type category	nvarchar(1)	0
Odesignate	Title - original language	nvarchar(100)	0
Designate	Title in English	nvarchar(100)	0
Law	Reference to the legal text	nvarchar(max)	0
Lawreference	Reference to the publication in Official Journal	nvarchar(max)	0
Agency	Name and address of the highest administrative authority responsible for this designation	nvarchar(max)	0
Remark	Remarks concerning the designation	nvarchar(max)	0

cdda_v8_designations.csv (text/comma-separated-values)
180.04 KB Download file
cdda_v8_designations.xls (Microsoft Excel spreadsheet)
235.50 KB Download file

List of designation boundaries by country:

Table contains list of digital boundaries of protected areas not defined as sites. Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries.

[+] Show table definition (records: 2553)

Field name	Field Definition	Note	Data type	Primary key
PARENT_ISO	ISO 3 characters country code		nvarchar(3)	-1
ISO3	Country ISO code		nvarchar(3)	-1
DESIG_ABBR	National designation type code		nvarchar(5)	-1
CDDA_Availability_code	Availability of boundaries	00 - Boundaries not available, 01 - Boundaries reported to EEA, 02 - Boundaries under preparation, 03 - Boundaries not relevant for analysis at European scale. Point or line feature.	nvarchar(2)	0
CDDA_Resolution_code	Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived.	00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000	nvarchar(2)	0
CDDA_Dissemination_code	Code for instructions to EEA regarding dissemination of geographical data.	00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative	nvarchar(2)	0

cdda_v8_designation_boundaries.csv (text/comma-separated-values)
87.27 KB Download file
cdda_v8_designation_boundaries.xls (Microsoft Excel spreadsheet)
276.50 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: 108692)

Field name	Field Definition	Note	Data type	Primary key
SITE_CODE	Unique record identifier for nationally designated areas		int(2)	-1
SITE_AREA	Surface area in hectares (ha)		float(8)	0
LAT	Latitude	(Y) International Geographical Co-ordinates of the monitoring station in decimal degrees format	float(8)	0
LON	Longitude decimal degrees		float(8)	0
SITE_CODE_NAT	National site code	unique record identifier in the national source database	nvarchar(20)	0
PARENT_ISO	ISO 3 characters country code		nvarchar(3)	-1
ISO3	Country ISO code		nvarchar(3)	-1
DESIG_ABBR	National designation type code		nvarchar(5)	-1
SITE_NAME	Site name as given in local language.		nvarchar(120)	0
IUCNCAT	IUCN management category		nvarchar(4)	0
CDDA_Dissemination_code	Code for instructions to EEA regarding dissemination of geographical data.	00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative	nvarchar(2)	0
Notes	Remarks about the site record		nvarchar(max)	0
NUTS	Administrative Region Code according to the coding system of EUROSTAT		nvarchar(5)	0
Year	Year		nvarchar(4)	0
Last_leg_chng_year	Year of last legal change		nvarchar(4)	0
Last_leg_chng_code	Code of last legal change		nvarchar(2)	0
CDDA_Coordinates_code	Code for derivation of tabular coordinates of sites.	00 - unknown, 01 - national calculation, 02 - EEA to calculate from reported boundary data	nvarchar(2)	0
CDDA_Resolution_code	Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived.	00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000	nvarchar(2)	0

ASCII Delimited (zip) (ZIP archive)
3.66 MB Download file

List of site boundaries by country:

Table contains information whether digital boundaries have been reported for a site reported as tabular data. Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries.

[+] Show table definition (records: 89607)

Field name	Field Definition	Note	Data type	Primary key
SITE_CODE	Unique record identifier for nationally designated areas		int(4)	-1
SITE_CODE_NAT	National site code	unique record identifier in the national source database	nvarchar(20)	0
PARENT_ISO	ISO 3 characters country code		nvarchar(3)	-1
ISO3	Country ISO code		nvarchar(3)	-1
CDDA_Availability_code	Availability of boundaries	00 - Boundaries not available, 01 - Boundaries reported to EEA, 02 - Boundaries under preparation, 03 - Boundaries not relevant for analysis at European scale. Point or line feature.	nvarchar(2)	0
CDDA_Resolution_code	Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived.	00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000	nvarchar(2)	0
CDDA_Dissemination_code	Code for instructions to EEA regarding dissemination of geographical data.	00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative	nvarchar(2)	0

ASCII Delimited (zip) (ZIP archive)
564.07 KB Download file

National overview of area protected:

Table contains national indicators for amount of national territory that is protected.

[+] Show table definition (records: 75)

Field name	Field Definition	Note	Data type	Primary key
Total_area	Total area protected by designation category.	Areas protected within specified boundaries and areas protected by the designation of a particular habitat should be included if relevant in the national context. Overlapping areas should be excluded from total.	decimal(9)	0
PARENT_ISO	ISO 3 characters country code		nvarchar(3)	-1
ISO3	Country ISO code		nvarchar(3)	-1
Category	National designation type category		nvarchar(5)	-1
Major_ecosystem	Major ecosystem		nvarchar(12)	0
Reference_year	Time reference for area		nvarchar(4)	0
Publication_title	Publication title	Document or indicator where total area was published if available.	nvarchar(50)	0
Publication_url	Publication url		nvarchar(max)	0
Methodology_type	Methodology type	How area was calculated.	nvarchar(2)	0
Methodology_reference_title	Methodology reference title	Documentation of methodology used if available.	nvarchar(50)	0
Methodology_reference_url	Methodology reference url	Nature conservation and biodiversity	nvarchar(max)	0
Remark	Remark	Optional free text comment	nvarchar(max)	0

cdda_v8_national_overview.xls (Microsoft Excel spreadsheet)
18.50 KB Download file
cdda_v8_national_overview.csv (text/comma-separated-values)
6.30 KB Download file

GIS data

CDDA boundaries 2009, vector shape file format

CDDA boundaries 2009, vector shape file format
Download file

Additional information

Look-up tables

File contains all code lists used in the data tables.

Look-up tables (text/comma-separated-values)
5.10 KB Download file

Country codes and abbreviations (63 records)

Table contains list of ISO Alpha 3 codes used in CDDA_designations and CDDA_sites tables. Complete and actual list can be found at the following URL: http://unstats.un.org/unsd/methods/m49/m49alpha.htm#ftna (Source: United Nations Statistics Division).

Country codes and abbreviations (63 records) (text/comma-separated-values)
1.05 KB Download file

Tables metadata:

File contains metadata definitions of all data tables.

Tables metadata: (text/comma-separated-values)
8.47 KB Download file

CDDA - QA/QC documents

Quality asssesment and control reports present results of quality tests performed by the EEA and the ETC-BD on top of the national CDDA data. The ETC-BD assesment is more focused on geographical data and on their relation with tabular data.

CDDA - quality control document - EEA (PDF document)
350.18 KB Download file
CDDA - quality document - ETC-BD (PDF document)
3.77 MB Download file

Metadata

Reporting obligations (ROD)

Nationally designated areas (CDDA)

Temporal coverage:
Last upload:: 30 Oct 2009
Geographic coverage:
Tags:
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).
Methodology:: Used tools: Microsoft SQL Server 2005, Microsoft Access, Microsoft Excel Applied procedures: MDB database was created by export from SQL Server. Text fields were cleared of trailing spaces. Whole database was compacted. XLS, DBF and CSV files was created from MDB database tables. Special features: DBF file - Ntext (Memo) fields were truncated to 255 characters before export. CSV files - text qualifier is ' " ' character, field separator is ',' character, line breaks were changed to string.
Coordinate reference system:: EPSG:3035
Data sources: European Topic Centre on Biological Diversity (ETC/BD). Date of delivery: 28 Oct 2009.
Owners:: European Environment Agency (EEA)

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.
Release note for version 8: 34 countries updated their information on legislative instruments, sites and site boundaries in the 2009 Eionet data collection. Information for European countries outside Eionet has been included from the 2009 version of WDPA. A quality report on version 8 is available, in particular on the quality of data from the Eionet countries. There has been a revision of the data format with the removal of items which it was agreed have little value at the European level. For the first time Eionet countries were asked to report in 2009 on their total protected area (terrestrial and marine). This is a step towards improving comparability between aggregated information published at national and European level and it is expected that the values made available for some countries will be revised in future releases of the data set.
This information is from the European Common Database on Designated Areas established and managed collaboratively by the European Environment Agency, the UNEP-World Conservation Monitoring Centre and the Council of Europe, based on data provided by national sources
Geographical coverage GIS vector boundary data: Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, France, Germany, Hungary, Iceland, Italy, Latvia, Liechtenstein, Lithuania, Malta, Netherlands, Norway, Portugal, Romania, Serbia, Slovakia, Slovenia, Spain, Sweden, Switzerland, Turkey. EEA does not have permission to distribute some or all sites reported by Austria, Estonia, Finland, Great Britain, Greece and the Netherlands. Copyright has to be mentioned for Estonia, Germany and Slovenia.