Data
Nationally designated areas (CDDA)
Go to latest version
European data
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) | -1 |
Definition | Designation type category definition | nvarchar(200) | 0 |
-
cdda_desig_categories_v6.xls (Microsoft Excel spreadsheet)
10.50 KB Download file -
cdda_desig_categories_v6.dbf (dBASE document)
704 Bytes Download file -
cdda_desig_categories_v6.csv (text/comma-separated-values)
456 Bytes Download file
IUCN categories
Table contains the IUCN management categories according to the new system. IUCN (1994), Guidelines for Protected Area Management Categories: http://www.iucn.org/themes/wcpa/pubs/pdfs/iucncategories.pdf
[+] Show table definition (records: 7)
Definition | Definition of IUCN management category | ntext(16) | 0 | |
Iucncat | IUCN management category | nvarchar(4) | -1 | |
Title | Title of the type of site under particular management category | nvarchar(250) | 0 |
-
iucn_categories_v6.xls (Microsoft Excel spreadsheet)
13.00 KB Download file -
iucn_categories_v6.dbf (dBASE document)
4.13 KB Download file -
iucn_categories_v6.csv (text/comma-separated-values)
2.68 KB Download file
Sites data table
Table contains main information (name, location, area, IUCN category etc) of each individual designated area at national level. 78021 records are for EEA member countries.
[+] Show table definition (records: 84531)
Site_code | Unique record identifier within the CDDA data base for nationally designated areas | int(4) | -1 | |
Lat | Latitude, geographical coordinate in decimal degrees | numeric(9,6) | 0 | |
Lon | Longitude, geographical coordinate in decimal degrees | numeric(9,6) | 0 | |
Size | Site surface area in ha | numeric(13,5) | 0 | |
Altitude_min | The minimum altitude (meters) above the sea level within the site boundaries | numeric(5,1) | 0 | |
Altitude_max | The maximum altitude (meters) above sea level within the site boundaries | numeric(5,1) | 0 | |
Nuts | Administrative Region Code according to the coding system of EUROSTAT | nvarchar(5) | 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) | 0 | |
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(3) | 0 | |
Iso3 | ISO 3 characters country code (in case of overseas territories, code of those) | nvarchar(3) | 0 | |
Year | Year of establishment. Year when the site was created under current designation. | smallint(2) | 0 |
-
Ascii delimited (zip) (ZIP archive)
2.24 MB Download file -
Dbase IV format (zip) (ZIP archive)
2.72 MB Download file
CDDA - Microsoft Access database (8 tables)
Database contains all data tables and lookup tables. Includes also simple relation structure (fields in tables are not indexed and keys are not set). Detailed table definitions are displayed in the section with individual tables.
-
Microsoft Access format (zip) (ZIP archive)
4.13 MB Download file
Site habitats table
Table contains data on habitats and habitat cover within the site boundary of each individual designated site.
[+] Show table definition (records: 12397)
Cover | The percentage of the site covered by this habitat class | float(8) | 0 | |
Site_code | Unique record identifier for nationally designated areas | int(4) | -1 | |
Eunis_hab | EUNIS habitat classification class code | the unique code of the EUNIS habitat classification up to the fourth level (see look-up table EUNIS habitat classification). | nvarchar(5) | -1 |
-
cdda_sitehabitats_v6.csv (text/comma-separated-values)
272.16 KB Download file -
cdda_sitehabitats_v6.xls (Microsoft Excel spreadsheet)
802.00 KB Download file -
cdda_sitehabitats_v6.dbf (dBASE document)
557.02 KB Download file
Site relation categories
[+] 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_v6.csv (text/comma-separated-values)
268 Bytes Download file -
cdda_relations_categories_v6.xls (Microsoft Excel spreadsheet)
10.50 KB Download file -
cdda_relations_categories_v6.dbf (dBASE document)
1.28 KB Download file
List of designations by country
Table contains list of designations, references to laws as well as number and total area of sites per designation. 689 records are for EEA member countries.
[+] Show table definition (records: 833)
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 | Title and article of the law designation comes from | ntext(16) | 0 | |
Agency | Name and address of the highest administrative authority responsible for this designation | ntext(16) | 0 | |
Total_area | Total area of sites with that designation from table Sites within CDDA-National | numeric(13,5) | 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(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) | 0 |
-
cdda_designations_v6.xls (Microsoft Excel spreadsheet)
212.00 KB Download file -
cdda_designations_v6.csv (text/comma-separated-values)
149.97 KB Download file -
cdda_designations_v6.dbf (dBASE document)
1.01 MB Download file
Site relations table
Table indicates how each designated site relates to others (overlapping, neighbouring sites, containing each other etc).
[+] Show table definition (records: 9620)
Overlap | Overlapping percentage | the percentage of the described site that is overlapping with the other site. | float(8) | 0 |
Site_code | Unique site reference code | this field can only contain existing site codes as identified in the Sites table. | int(4) | -1 |
Rsite_code | Related site code | the unique record identifier of the related site. | int(4) | -1 |
Rel_code | Relationship code | the type of relationship between two sites (see look-up table Site relation categories). | nvarchar(1) | -1 |
-
cdda_siterelations_v6.csv (text/comma-separated-values)
248.39 KB Download file -
cdda_siterelations_v6.xls (Microsoft Excel spreadsheet)
705.50 KB Download file -
cdda_siterelations_v6.dbf (dBASE document)
582.62 KB Download file
GIS data
Site boundaries
Zipped ESRI shapefile (vector, polygon) of nationally designated area boundaries as reported by countries. It is expected that the quality will improve in future versions.
-
Site boundaries
Download file
Additional information
Tables metadata
File contains metadata definitions of all data tables and look-up tables.
-
Tables metadata (text/comma-separated-values)
4.68 KB Download file
Database relation structure diagram
-
Database relation structure diagram (PNG image)
39.93 KB Download file
Country codes and abbreviations (65 records)
Table contains list of ISO Alpha 3 codes used in CDDA_designations and CDDA_sites tables. Complete and actual list can be found at the following URL: http://unstats.un.org/unsd/methods/m49/m49alpha.htm#ftna (Source: United Nations Statistics Division)
-
Country codes and abbreviations (65 records) (text/comma-separated-values)
1.31 KB Download file
Nationally designated areas (National - CDDA)
Quality control documentation - Public version
-
Nationally designated areas (National - CDDA) (PDF document)
1.00 MB Download file
Metadata
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.
This information is from the European Common Database on Designated Areas established and managed collaboratively by the European Environment Agency, the UNEP-World Conservation Monitoring Centre and the Council of Europe, based on data provided by national sources
Geographical coverage note: the GIS boundary data available above has much less coverage than the Access database. See the map of site boundaries.
Permalinks
- Permalink to this version
- DEAA15D0-C571-437B-A887-75D9FD40D27B
- 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-national-cdda-1 or scan the QR code.
PDF generated on 25 Jan 2021, 05:24 PM
Document Actions
Share with others