Nationally designated areas (CDDA)

Data
Prod-ID: DAT-24-en
expired Created 20 Dec 2005 Published 20 Dec 2005 Last modified 28 Jun 2016
10 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

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) -1
Definition Designation type category definition nvarchar(200) 0
IUCN categories

Table contains the IUCN management categories according to the new system. IUCN (1994), Guidelines for Protected Area Management Categories: http://www.iucn.org/themes/wcpa/pubs/pdfs/iucncategories.pdf

[+] Show table definition (records:   7)

Definition Definition of IUCN management category ntext(16) 0
Iucncat IUCN management category nvarchar(4) -1
Title Title of the type of site under particular management category nvarchar(250) 0
Sites data table

Table contains main information (name, location, area, IUCN category etc) of each individual designated area at national level. 78021 records are for EEA member countries.

[+] Show table definition (records:   84531)

Site_code Unique record identifier within the CDDA data base for nationally designated areas int(4) -1
Lat Latitude, geographical coordinate in decimal degrees numeric(9,6) 0
Lon Longitude, geographical coordinate in decimal degrees numeric(9,6) 0
Size Site surface area in ha numeric(13,5) 0
Altitude_min The minimum altitude (meters) above the sea level within the site boundaries numeric(5,1) 0
Altitude_max The maximum altitude (meters) above sea level within the site boundaries numeric(5,1) 0
Nuts Administrative Region Code according to the coding system of EUROSTAT nvarchar(5) 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) 0
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(3) 0
Iso3 ISO 3 characters country code (in case of overseas territories, code of those) nvarchar(3) 0
Year Year of establishment. Year when the site was created under current designation. smallint(2) 0
CDDA - Microsoft Access database (8 tables)

Database contains all data tables and lookup tables. Includes also simple relation structure (fields in tables are not indexed and keys are not set). Detailed table definitions are displayed in the section with individual tables.

Site habitats table

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

[+] Show table definition (records:   12397)

Cover The percentage of the site covered by this habitat class float(8) 0
Site_code Unique record identifier for nationally designated areas int(4) -1
Eunis_hab EUNIS habitat classification class code the unique code of the EUNIS habitat classification up to the fourth level (see look-up table EUNIS habitat classification). nvarchar(5) -1
Site relation categories

[+] 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
List of designations by country

Table contains list of designations, references to laws as well as number and total area of sites per designation. 689 records are for EEA member countries.

[+] Show table definition (records:   833)

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 Title and article of the law designation comes from ntext(16) 0
Agency Name and address of the highest administrative authority responsible for this designation ntext(16) 0
Total_area Total area of sites with that designation from table Sites within CDDA-National numeric(13,5) 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(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) 0
Site relations table

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

[+] Show table definition (records:   9620)

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

GIS data

Site boundaries

Zipped ESRI shapefile (vector, polygon) of nationally designated area boundaries as reported by countries. It is expected that the quality will improve in future versions.

  • Site boundaries
    Download file

Additional information

Tables metadata

File contains metadata definitions of all data tables and look-up tables.

Database relation structure diagram
Country codes and abbreviations (65 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)

Nationally designated areas (National - CDDA)

Quality control documentation - Public version

Metadata

information.png Reporting obligations (ROD)
information.png Geographic coverage:
, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
information.png Tags:
, , , , ,
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. Simple relation structure was added. 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: 13/10/2006.

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.
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 note: the GIS boundary data available above has much less coverage than the Access database. See the map of site boundaries.

 

Related content

Produced Indicators

Produced figures

Share of designated areas per country in the following categories: only under national designation, only under EU Habitats Directive designation and both at national and EU Habitats Directive designation The figure shows the share of designated areas per country in the following categories: only under national designation, only under EU Habitats Directive designation and both at national and EU Habitats Directive designation:
Share of designated areas per country following the categories: only under national designation, only under EU Birds Directive designation and both at national and EU Birds Directive designation The figure shows the share of designated areas per country following the categories: only under national designation, only under EU Birds Directive designation and both at national and EU Birds Directive designation
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
Transboundary Environmental Protection Zone: Lithuanian-Polish border This map shows protected sites (Natura 2000 and designated sites) and green background (10 km radius) together with Urban Morphological Zones and main roads
Distribution of Nationally designated areas (CDDA) - site boundaries. The map is intended to show the distribution of site boundaries reported for nationally designated areas
Cumulative surface area of sites designated for EC birds directive over time (special protection areas - SPAs) The figure shows the cumulative surface area of sites designated for EC birds directive over time (special protection areas - SPAs)
Document Actions

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

PDF generated on 06 Jun 2020, 06:47 PM

EEA Page URL QR
The EEA is an agency of the European Union

Engineered by: EEA Web Team

Software updated on 28 May 2020 11:25 from version 20.4.28

Software version: EEA Plone KGS 20.5.27

Code for developers

Systems Status

Legal notice

Creative commons license

CMS login