Data
Nationally designated areas (CDDA)
Go to latest version
European data
Site habitats table
The table contains data on habitats and habitat cover within the site boundary.
[+] Show table definition (records: 68)
Site_code | Site code | unique record identifier. | Int(4) | -1 |
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_v3_2.mdb (application/msaccess)
108.00 KB Download file -
sitehabitats_europe_en_v3_2.csv (text/comma-separated-values)
1.81 KB Download file -
sitehabitats_europe_en_v3_2.xls (Microsoft Excel spreadsheet)
16.00 KB Download file -
sitehabitats_europe_en_v3_2.dbf (dBASE document)
3.18 KB Download file
Nationally designated areas
The table contains informations on the individual designated areas at national level.
[+] Show table definition (records: 51289)
Altitude_max | Altitude maximum | the maximum altitude (meters) above sea level within the site boundaries. | int(4) | 0 |
Lat | Latitude | geographical coordinate in decimal degrees. | float(8) | 0 |
Lon | Longitude | geographical coordinate in decimal degrees. | float(8) | 0 |
Site_code | Site code | unique record identifier for nationally designated areas | int(4) | -1 |
Size | Size | area in ha | int(4) | 0 |
Altitude_min | Altitude minimum | the minimum altitude (meters) above sea level within the site boundaries. | int(4) | 0 |
Year | Year | year of establishment. The year the site was created under the designation concerned. | nvarchar(4) | 0 |
Lat_ns | Latitude North/South | nvarchar(1) | 0 | |
Lon_ew | Longitude East/West | nvarchar(1) | 0 | |
Desig_abbr | National designation type code | nvarchar(5) | -1 | |
Areaname | Site name | site name as given in local language. | nvarchar(120) | 0 |
Nuts | NUTS code | administrative Region Code according to the coding system of Eurostat. | nvarchar(5) | 0 |
Site_code_nat | National site code | unique record identifier in the national source database | nvarchar(12) | 0 |
Parent_iso | Parent ISO code | in most countries the Iso3 and Parent_iso codes are identical. For countries, which have so called DOM/TOMs or any kind of over seas territories under their jurisdiction, the Iso3 country code may be different from the parent country code. | nvarchar(3) | 0 |
Iso3 | ISO3 code | ISO 3 characters country code | nvarchar(3) | 0 |
Londeg | Longitude degrees | smallint(2) | 0 | |
Lonmin | Longitude minutes | smallint(2) | 0 | |
Lonsec | Longitude seconds | smallint(2) | 0 | |
Latdeg | Latitude degrees | smallint(2) | 0 | |
Latmin | Latitude minutes | smallint(2) | 0 | |
Latsec | Latitude seconds | smallint(2) | 0 | |
IUCNCAT | IUCN category | nvarchar(4) | -1 |
-
Dbase IV (zip) (ZIP archive)
2.11 MB Download file -
Access 2000 (zip) (ZIP archive)
2.25 MB Download file -
Text file (zip) (ZIP archive)
1.75 MB Download file -
Excel 2000 (zip) (ZIP archive)
3.95 MB Download file
National designation type category look-up table
[+] Show table definition (records: 3)
Category | National designation type category | nvarchar(1) | -1 | |
Definition | IUCN category definition | nvarchar(200) | 0 |
-
cdda_desig_categories_en_v3_2.mdb (application/msaccess)
108.00 KB Download file -
cdda_desig_categories_en_v3_2.xls (Microsoft Excel spreadsheet)
13.50 KB Download file -
cdda_desig_categories_en_v3_2.csv (text/comma-separated-values)
456 Bytes Download file -
cdda_desig_categories_en_v3_2.dbf (dBASE document)
704 Bytes Download file
Site relations lookup table
[+] Show table definition (records: 6)
Rel_code | Relationship code | nvarchar(1) | -1 | |
Relationship | Relationship description | nvarchar(200) | 0 |
-
cdda_relations_categories_en_v3_2.mdb (application/msaccess)
108.00 KB Download file -
cdda_relations_categories_en_v3_2.xls (Microsoft Excel spreadsheet)
13.50 KB Download file -
cdda_relations_categories_en_v3_2.dbf (dBASE document)
1.28 KB Download file -
cdda_relations_categories_en_v3_2.csv (text/comma-separated-values)
268 Bytes 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: 1075)
Sitecode | Site code | unique record identifier for nationally designated areas | int(4) | -1 |
Rsitecode | Related site code | the unique record identifier of the related site. | int(4) | 0 |
Overlap | Overlap | the percentage of the described site that is overlapping with the other site. | int(4) | 0 |
Rel_code | Relationship code | the type of relationship between two sites. | nvarchar(1) | -1 |
-
siterelations_europe_en_v3_2.dbf (dBASE document)
65.25 KB Download file -
siterelations_europe_en_v3_2.csv (text/comma-separated-values)
26.09 KB Download file -
siterelations_europe_en_v3_2.mdb (application/msaccess)
144.00 KB Download file -
siterelations_europe_en_v3_2.xls (Microsoft Excel spreadsheet)
89.00 KB Download file
IUCN category look-up table
[+] Show table definition (records: 7)
Definition | IUCN category definition | ntext(16) | 0 | |
Iucncat | IUCN category | nvarchar(4) | -1 | |
Title | IUCN category title | nvarchar(250) | 0 |
-
iucncategories_en_v3_2.mdb (application/msaccess)
112.00 KB Download file -
iucncategories_en_v3_2.xls (Microsoft Excel spreadsheet)
14.50 KB Download file -
iucncategories_en_v3_2.dbf (dBASE document)
1.94 KB Download file -
iucncategories_en_v3_2.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: 845)
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 caracters country code | nvarchar(3) | 0 | |
Desig_abbr | National designation type code | nvarchar(5) | -1 | |
Category | National designation type category | nvarchar(1) | -1 |
-
designations_europe_en_v3_2.mdb (application/msaccess)
360.00 KB Download file -
designations_europe_en_v3_2.dbf (dBASE document)
407.96 KB Download file -
designations_europe_en_v3_2.csv (text/comma-separated-values)
124.17 KB Download file -
designations_europe_en_v3_2.xls (Microsoft Excel spreadsheet)
185.50 KB Download file
EUNIS habitat classification
[+] Show table definition (records: 1659)
Eunis hab | EUNIS habitat classification | nvarchar(5) | -1 | |
Hab level | Habitat level | nvarchar(255) | 0 | |
Scientific name | Scientific name of the habitat | nvarchar(255) | 0 |
-
eunis_habitats_level_4_for_cdda 200311_en_v3_2.mdb (application/msaccess)
292.00 KB Download file -
eunis_habitats_level_4_for_cdda 200311_en_v3_2.csv (text/comma-separated-values)
86.55 KB Download file -
eunis_habitats_level_4_for_cdda 200311_en_v3_2.xls (Microsoft Excel spreadsheet)
197.00 KB Download file -
eunis_habitats_level_4_for_cdda 200311_en_v3_2.dbf (dBASE document)
1.21 MB Download file
Additional information
CDDA tables metadata
-
CDDA tables metadata (Microsoft Excel spreadsheet)
36.50 KB Download file
CDDA database model
-
CDDA database model (GIF image)
11.68 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
- C1501E08-FA82-4042-AA6B-43AF6CE2FE26
- 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 or scan the QR code.
PDF generated on 06 Mar 2021, 06:39 PM
Document Actions
Share with others