Personal tools

Notifications
Get notifications on new reports and products. Frequency: 3-4 emails / month.
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 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.

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 Note 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
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
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
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
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

GIS data

CDDA boundaries 2009, vector shape file format
  • CDDA boundaries 2009, vector shape file format

Additional information

Look-up tables

File contains all code lists used in the data tables.

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

Tables metadata:

File contains metadata definitions of all data tables.

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.

Metadata

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.

 

Related content

Figures produced

Used in indicators

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