next
previous
items

Data

Nationally designated areas (CDDA)

Data
Prod-ID: DAT-24-en
Created 30 Oct 2009 Published 30 Oct 2009 Last modified 11 Sep 2015
11 min read
This is an old version, kept for reference only.

 Go to latest version
This page was archived on 31 Oct 2014 with 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.

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
    Download file

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

information.png Reporting obligations (ROD)
information.png 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 (https://www.eea.europa.eu/legal/copyright). Copyright holder: European Environment Agency (EEA).
information.png 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.

information.png Coordinate reference system:
EPSG:3035
information.png Data sources

European Topic Centre on Biological Diversity (ETC/BD). Date of delivery: 28 Oct 2009.

information.png 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.

 

Related content

Produced Indicators

Produced figures

Figure Proportion of the surface area of nationally designated sites per type of ecosystem These broad ecosystem‑types represent different ways of clustering CLC units, so there are overlaps between them. For instance, 'grasslands' and part of 'heaths and scrubs' are included in 'agro-ecosystems'. Similarly, 'lakes and rivers' are included in 'wetlands'. This is why the sum of the ecosystems is over 100 %.
Figure
Archived
Growth of the nationally designated protected areas and site number in 39 EEA countries How to read the graph: In 1995 there was more than 40 000 of nationally designated sites within the 39 countries. More than 600 000 km2 were under national designations.
Figure Proportion of mountain protected area within nationally designated areas, Natura 2000 sites, or both The chart shows the proportion of only NDA, only Natura 2000 and their overlaps in Europe Countries for all countries with data
Figure Distribution of nationally-designated areas in mountain areas The map shows the National Designated Areas within each European Mountain Massif
Figure Percentage of area covered by nationally-designated areas inside and outside mountains by country, also indicating the percentage of the national area covered by mountains The chart shows the distribution of NDA in Europe Countries for all countries with data Tags / keywords: National Designated Areas, outside and inside mountain massifs, Europe, biodiversity protection.
Figure Distribution of nationally-designated areas in mountain massifs The chart shows the distribution of nationally-designated areas in mountain massifs across Europe
Figure Percentage of Natura 2000 site area not protected under national instruments per EU Member State Percentage of Natura 2000 site area not protected under national instruments per EU Member State
Figure
Archived
Nationally designated areas (CDDA), 2009 - site boundaries The map is intended to show the distribution of site boundaries reported for nationally designated areas
Figure Nationally designated areas (CDDA), status 2009 - site centre points The map is intended to show the distribution of point locations reported for nationally designated areas

Used in indicators

Permalinks

Older versions

Geographic coverage

Temporal coverage

For references, please go to https://www.eea.europa.eu/data-and-maps/data/nationally-designated-areas-national-cdda-4 or scan the QR code.

PDF generated on 01 Feb 2023, 04:53 PM

EEA Page URL QR

Topics

Document Actions
The EEA is an agency of the European Union

Engineered by: EEA Web Team

Software updated on 30 January 2023 17:43 from version 23.1.17

Software version: EEA Plone KGS 23.1.28

Code for developers

Systems Status

Legal notice

Creative commons license

CMS login