Nationally designated areas (CDDA)

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

Site habitats table

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

[+] Show table definition (records:   7915)

Cover % of site affected float(8) 0
Eunis hab EUNIS habitat classification the unique code of the EUNIS habitat classification up to the fourth level. nvarchar(5) -1
Site_code Unique record identifier within the CDDA data base for nationally designated areas float(8) -1
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:   838)

Total area Total area of sites with that designation from table Sites within CDDA-National float(8) 0
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 Reference to the publication in Official Journal ntext(16) 0
Agency Name and address of the highest administrative authority responsible for this designation ntext(16) 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 caracters 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) -1
Site relations

[+] 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
Site relations table

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

[+] Show table definition (records:   3228)

Site_code Unique site reference code this field can only contain existing site codes as identified in the Sites table. float(8) -1
Rsite_code Related site code the unique record identifier of the related site. float(8) 0
Overlap Overlapping percentage the percentage of the described site that is overlapping with the other site. float(8) 0
Rel_code Relationship code the type of relationship between two sites (see look-up table Site relation categories). nvarchar(1) -1
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) 0
Definition Designation type category definition nvarchar(200) 0
IUCN category

[+] Show table definition (records:   7)

Definition Designation type category definition ntext(16) 0
IUCNCAT IUCN management category nvarchar(4) -1
Title Brief text description of habitat class nvarchar(250) 0
EUNIS habitat classification

[+] Show table definition (records:   1622)

Eunis hab EUNIS habitat classification class code the unique code of the EUNIS habitat classification up to the fourth level. nvarchar(10) -1
Hab level Habitat level in classification nvarchar(1) 0
Scientific name Scientific name of the habitat nvarchar(255) 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:   75792)

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

Additional information

Countries codes and abbreviations

ISO Alpha-3 code 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

Metadata

Reporting obligations (ROD)
Last upload:
07 Dec 2005
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).
Data sources

European Topic Centre on Biological Diversity (ETC/BD). Date of delivery: 02/09/2005.

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.

 

Permalinks

Document Actions

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

PDF generated on 27 May 2017, 06:59 AM

European Environment Agency (EEA)
Kongens Nytorv 6
1050 Copenhagen K
Denmark
Phone: +45 3336 7100
The European Environment Agency (EEA) is an agency of the European Union.
Legal notice EU flag
 

engineered by
EEA Web Team

Creative Commons Attribution License CMS login Software updates history Code for developers Refresh this page