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
[+] 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)
[+] 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)
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)
designations_europe_en_v4.mdb
(application/msaccess)
designations_europe_en_v4.xls
(Microsoft Excel spreadsheet)
designations_europe_en_v4.csv
(text/comma-separated-values)
[+] 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)
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)
Excel 2000 (zip)
(ZIP archive)
DBaseIV (zip)
(ZIP archive)
Access 2000 (zip)
(ZIP archive)
[+] 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)
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)
sitehabitats_europe_en_v4.mdb
(application/msaccess)
sitehabitats_europe_en_v4.xls
(Microsoft Excel spreadsheet)
sitehabitats_europe_en_v4.dbf
(dBASE document)
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)
siterelations_europe_en_v4.dbf
(dBASE document)
siterelations_europe_en_v4.mdb
(application/msaccess)
siterelations_europe_en_v4.csv
(text/comma-separated-values)
Metadata for the data tables
(Microsoft Excel spreadsheet)
Database diagram
(PNG image)
Reporting obligations (ROD)
Rights:
Data sources
European Topic Centre on Nature Protection and Biodiversity. Date of delivery: 08/02/2005.
Owners:
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.
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 27 Mar 2023, 04:16 AM
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