Data
Nationally designated areas (CDDA)
Go to latest version
European data
EUNIS habitat classification
[+] Show table definition (records: 1659)
Eunis hab | EUNIS habitat classification | the unique code of the EUNIS habitat classification up to the fourth level. | nvarchar(255) | -1 |
Hab level | Habitat level | nvarchar(255) | 0 | |
Scientific name | Scientific name of the habitat | nvarchar(255) | 0 |
-
eunis_habitats_level_4_for_cdda_en_v4.csv (text/comma-separated-values)
86.55 KB Download file
IUCN category
[+] Show table definition (records: 7)
Definition | IUCN category definition | ntext(16) | 0 | |
Iucncat | IUCN management category | nvarchar(4) | 0 | |
Title | Brief text description of habitat class | nvarchar(250) | 0 |
-
iucncategories_en_v4.csv (text/comma-separated-values)
2.55 KB Download file
List of designations by country
The table contains the list of designations and references to laws.
[+] Show table definition (records: 835)
Law | Reference to the legal text | ntext(16) | 0 | |
Lawreference | Reference to the publication in Official Journal | ntext(16) | 0 | |
Agency | Address of the 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 character country code | nvarchar(6) | 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 | nvarchar(1) | 0 |
-
designations_europe_en_v4.dbf (dBASE document)
403.14 KB Download file -
designations_europe_en_v4.mdb (application/msaccess)
360.00 KB Download file -
designations_europe_en_v4.xls (Microsoft Excel spreadsheet)
188.50 KB Download file -
designations_europe_en_v4.csv (text/comma-separated-values)
128.00 KB Download file
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 | IUCN category definition | nvarchar(200) | 0 |
-
cdda_desig_categories_en_v4.csv (text/comma-separated-values)
456 Bytes Download file
Sites data table
The table contains the information on the individual designated areas at national level.
[+] Show table definition (records: 56413)
Lat | Latitude | geographical Co-ordinate in decimal degrees. | float(8) | 0 |
Lon | Longitude | geographical coordinate in decimal degrees. | float(8) | 0 |
Altitude_max | The maximum altitude (meters) above sea level within the site boundaries. | float(8) | 0 | |
Latsec | Latitude seconds | float(8) | 0 | |
Lonsec | Longitude seconds | float(8) | 0 | |
Site_code | Unique record identifier within the CDDA data base for nationally designated areas. | float(8) | 0 | |
Size | Surface area in ha. | float(8) | 0 | |
Altitude_min | The minimum altitude (meters) above sea level within the site boundaries. | float(8) | 0 | |
Lon_ew | Longitude East/West | E or W | nvarchar(1) | 0 |
Nuts | Administrative Region Code according to the coding system of Eurostat. | nvarchar(5) | 0 | |
Year | annual data | year of establishment. The year the site was created under the designation concerned. | nvarchar(4) | 0 |
Lat_ns | Latitude North/South | nvarchar(1) | 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 | nvarchar(4) | 0 | |
Site_code_nat | National site code | unique record identifier in the national source database | nvarchar(12) | 0 |
Parent_iso | ISO 3 caracters country code | nvarchar(3) | 0 | |
Iso3 | ISO 3 character country code | nvarchar(3) | 0 | |
Lonmin | Longitude minutes | smallint(2) | 0 | |
Latdeg | Latitude degrees | smallint(2) | 0 | |
Latmin | Latitude minutes | smallint(2) | 0 | |
Londeg | Longitude degrees | smallint(2) | 0 |
-
ASCII Delimited (zip) (ZIP archive)
1.81 MB Download file -
Excel 2000 (zip) (ZIP archive)
4.18 MB Download file -
DBaseIV (zip) (ZIP archive)
2.10 MB Download file -
Access 2000 (zip) (ZIP archive)
2.32 MB Download file
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 |
-
cdda_relations_categories_en_v4.csv (text/comma-separated-values)
268 Bytes Download file
Site habitats table
The table contains data on habitats and habitat cover within the site boundary.
[+] Show table definition (records: 7800)
Site_code | Unique record identifier for nationally designated areas | float(8) | 0 | |
Cover | The percentage of the site covered by this habitat class | float(8) | 0 | |
Eunis hab | EUNIS habitat classification | the unique code of the EUNIS habitat classification up to the fourth level. | nvarchar(5) | -1 |
-
sitehabitats_europe_en_v4.csv (text/comma-separated-values)
173.14 KB Download file -
sitehabitats_europe_en_v4.mdb (application/msaccess)
340.00 KB Download file -
sitehabitats_europe_en_v4.xls (Microsoft Excel spreadsheet)
520.50 KB Download file -
sitehabitats_europe_en_v4.dbf (dBASE document)
350.52 KB Download file
Site relations table
This table allows to indicate neighbouring sites or sites belonging to different designation types which overlap or neighbour each other.
[+] Show table definition (records: 2180)
Sitecode | Unique site reference code | this field can only contain existing site codes as identified in the Sites table. | float(8) | -1 |
Rsitecode | Related site code | the unique record identifier of the related site. | float(8) | 0 |
Overlap | Overlap | 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. | nvarchar(1) | -1 |
-
siterelations_europe_en_v4.xls (Microsoft Excel spreadsheet)
168.00 KB Download file -
siterelations_europe_en_v4.dbf (dBASE document)
132.15 KB Download file -
siterelations_europe_en_v4.mdb (application/msaccess)
184.00 KB Download file -
siterelations_europe_en_v4.csv (text/comma-separated-values)
52.18 KB Download file
Additional information
Metadata for the data tables
-
Metadata for the data tables (Microsoft Excel spreadsheet)
36.50 KB Download file
Database diagram
-
Database diagram (PNG image)
21.91 KB Download file
Metadata
Additional information
The inventory of nationally designated areas began under the CORINE programe. It is now maintained for EEA by the European Topic Centre on Nature Protection and Biodiversity and is being updated through EIONET.
Permalinks
- Permalink to this version
- 9B55C462-54AE-4588-9864-AC1E1F005B24
- Permalink to latest version
- DAT-24-en
Older versions
Geographic coverage
For references, please go to https://www.eea.europa.eu/data-and-maps/data/nationally-designated-areas-cdda-1 or scan the QR code.
PDF generated on 16 Jan 2021, 11:07 AM
Document Actions
Share with others