Personal tools

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

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

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

[+] Show table definition (records:   710)

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 numeric(9) 0
Parent_iso ISO 3 characters country code nvarchar(3) -1
Iso3 ISO 3 character country code nvarchar(3) -1
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
Odesignate Title in original language nvarchar(100) 0
Designate Title in English nvarchar(100) 0
Title_french Title in French nvarchar(255) 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
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
CDDA - Microsoft Access database (6 tables)

Database contains all data tables and lookup tables. 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:   11591)

Site_code Unique record identifier for nationally designated areas int(4) -1
Cover The percentage of the site covered by this habitat class float(8) 0
Parent_ISO ISO 3 characters country code nvarchar(3) -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
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:   8)

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(255) 0
EUNIS habitat classification:

Table contains EUNIS habitat classification level 1 to level. 4 If needed, any additional information can be obtained from ETC/BD or from EUNIS at http://eunis.eea.europa.eu.

[+] Show table definition (records:   1622)

Hab_level Habitat level in classification tinyint(1) 0
Eunis_hab EUNIS habitat classification class code the unique code of the EUNIS habitat classification up to the fourth level. nvarchar(10) -1
Scientific_name Scientific name of the habitat nvarchar(255) 0

GIS data

CDDA_boundaries2008, vector shape file format
  • CDDA_boundaries2008, vector shape file format

Additional information

Country codes and abbreviations (47 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

Tables metadata:

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

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 theWorld 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 7.5: data for seven countries(FI, IS, ES, CH, CZ, LT, TR) were updated based on new national deliveries summary totals in designations table were updated for all countries designation and sites which were marked to be deleted by countries in the latest delivery but were still available in the version 7 have been removed from the dataset dataset now contains only Eionet countries data
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 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.

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