Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
Data
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 |
sitehabitats_europe_en_v5.xls
(Microsoft Excel spreadsheet)
sitehabitats_europe_en_v5.csv
(text/comma-separated-values)
sitehabitats_europe_en_v5.mdb
(application/msaccess)
sitehabitats_europe_en_v5.dbf
(dBASE document)
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 |
designations_europe_en_v5.mdb
(application/msaccess)
designations_europe_en_v5.dbf
(dBASE document)
designations_europe_en_v5.csv
(text/comma-separated-values)
designations_europe_en_v5.xls
(Microsoft Excel spreadsheet)
[+] 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 |
cdda_relations_categories_en_v5.csv
(text/comma-separated-values)
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 |
siterelations_europe_en_v5.dbf
(dBASE document)
siterelations_europe_en_v5.xls
(Microsoft Excel spreadsheet)
siterelations_europe_en_v5.csv
(text/comma-separated-values)
siterelations_europe_en_v5.mdb
(application/msaccess)
[+] 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 |
cdda_desig_categories_en_v5.csv
(text/comma-separated-values)
[+] 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 |
iucncategories_en_v5.csv
(text/comma-separated-values)
[+] 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 |
eunis_habitats_level_4_for_cdda_en_v5.csv
(text/comma-separated-values)
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 |
Access 2000 (zip)
(ZIP archive)
Dbase IV (zip)
(ZIP archive)
sites_europe_en_v5.csv
(text/comma-separated-values)
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)
Countries codes and abbreviations
(Plain Text)
Tables metadata
(text/comma-separated-values)
Database diagram
(PNG image)
Quality control documentation
Nationally designated areas (National - CDDA)
(Microsoft Word Document)
Reporting obligations (ROD)
Rights:
Data sources
European Topic Centre on Biological Diversity (ETC/BD). Date of delivery: 02/09/2005.
Owners:
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.
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 01 Apr 2023, 10:32 PM
Engineered by: EEA Web Team
Software updated on 12 March 2023 21:56 from version 23.1.28
Software version: EEA Plone KGS 23.3.11
Document Actions
Share with others