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 main information (name, location, area, IUCN category etc) of each individual designated area at national level.
[+] Show table definition (records: 82771)
| Year | Year of establishment. Year when the site was created under current designation. | smallint(2) | 0 | |
| Site_code | Unique record identifier within the CDDA data base for nationally designated areas | int(4) | -1 | |
| Size | Site surface area in ha | numeric(9) | 0 | |
| Altitude_min | The minimum altitude (meters) above the sea level within the site boundaries | numeric(5) | 0 | |
| Altitude_max | The maximum altitude (meters) above sea level within the site boundaries | numeric(5) | 0 | |
| Lat | Latitude, geographical coordinate in decimal degrees | numeric(9) | 0 | |
| Lon | Longitude, geographical coordinate in decimal degrees | numeric(9) | 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) | -1 | |
| Iso3 | ISO 3 characters country code (in case of overseas territories, code of those) | nvarchar(3) | -1 | |
| 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 | |
| Nuts | Administrative Region Code according to the coding system of EUROSTAT | nvarchar(5) | 0 |
Dbase IV format (zip)
(ZIP archive)
ASCII Delimited (zip)
(ZIP archive)
Table contains list of designations, references to laws as well as number and total area of sites per designation.
[+] Show table definition (records: 710)
| Number | Number of sites with that designation from table Sites within CDDA-National | int(4) | 0 | |
| Total_area | Total area of sites with that designation from table Sites within CDDA-National | numeric(9) | 0 | |
| Parent_iso | ISO 3 characters country code | nvarchar(3) | -1 | |
| Iso3 | ISO 3 character country code | nvarchar(3) | -1 | |
| 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 |
| Odesignate | Title in original language | nvarchar(100) | 0 | |
| Designate | Title in English | nvarchar(100) | 0 | |
| Title_french | Title in French | nvarchar(255) | 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 |
cdda_designations_v7_5.csv
(text/comma-separated-values)
cdda_designations_v7_5.xls
(Microsoft Excel spreadsheet)
cdda_designations_v7_5.dbf
(dBASE document)
[+] 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.dbf
(dBASE document)
cdda_desig_categories.xls
(Microsoft Excel spreadsheet)
cdda_desig_categories.csv
(text/comma-separated-values)
Database contains all data tables and lookup tables. Detailed table definitions are displayed in the section with individual tables.
Microsoft Access format (zip)
(ZIP archive)
Table contains data on habitats and habitat cover within the site boundary of each individual designated site.
[+] Show table definition (records: 11591)
| Site_code | Unique record identifier for nationally designated areas | int(4) | -1 | |
| Cover | The percentage of the site covered by this habitat class | float(8) | 0 | |
| Parent_ISO | ISO 3 characters country code | nvarchar(3) | -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_v7_5.xls
(Microsoft Excel spreadsheet)
cdda_sitehabitats_v7_5.dbf
(dBASE document)
cdda_sitehabitats_v7_5.csv
(text/comma-separated-values)
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: 8)
| 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(255) | 0 |
iucn_categories.dbf
(dBASE document)
iucn_categories.xls
(Microsoft Excel spreadsheet)
iucn_categories.csv
(text/comma-separated-values)
Table contains EUNIS habitat classification level 1 to level. 4 If needed, any additional information can be obtained from ETC/BD or from EUNIS at http://eunis.eea.europa.eu.
[+] Show table definition (records: 1622)
| Hab_level | Habitat level in classification | tinyint(1) | 0 | |
| Eunis_hab | EUNIS habitat classification class code | the unique code of the EUNIS habitat classification up to the fourth level. | nvarchar(10) | -1 |
| Scientific_name | Scientific name of the habitat | nvarchar(255) | 0 |
eunis_habitats_level4.xls
(Microsoft Excel spreadsheet)
eunis_habitats_level4.dbf
(dBASE document)
eunis_habitats_level4.csv
(text/comma-separated-values)
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 (47 records)
(text/comma-separated-values)
Quality control documentation - Public version
Nationally designated areas (National - CDDA)
(PDF document)
File contains metadata definitions of all data tables and look-up tables.
Tables metadata:
(Microsoft Excel spreadsheet)
Database relation structure diagram
(PNG image)
Reporting obligations (ROD)
Rights:
Methodology:
Used tools: Microsoft SQL Server 2005, Microsoft Access, Microsoft Excel Applied procedures: MDB database was created by export from SQL Server. Text fields were cleared of trailing spaces. Whole database was compacted. XLS, DBF and CSV files was created from MDB database tables. Special features: DBF file - Ntext (Memo) fields were truncated to 255 characters before export. CSV files - text qualifier is ' " ' character, field separator is ',' character, line breaks were changed to string.
Coordinate reference system:
Data sources
European Topic Centre on Biological Diversity (ETC/BD). Date of delivery: 5 Aug 2008.
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 theWorld 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. Release note for version 7.5: data for seven countries(FI, IS, ES, CH, CZ, LT, TR) were updated based on new national deliveries summary totals in designations table were updated for all countries designation and sites which were marked to be deleted by countries in the latest delivery but were still available in the version 7 have been removed from the dataset dataset now contains only Eionet countries data
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 GIS vector data: Belgium, Bosnia and Herzegovina, Bulgaria, Croatia, Cyprus, Czech Republic, Denmark, Estonia, France, Germany, Hungary, Iceland, Italy, Latvia, Liechtenstein, Lithuania, Malta, Netherlands, Norway, Portugal, Romania, Serbia, Slovakia, Slovenia, Spain, Sweden, Switzerland, Turkey. EEA does not have permission to distribute some or all sites reported by Austria, Estonia, Finland, Great Britain, Greece and the Netherlands. Copyright has to be mentioned for Estonia, Germany and Slovenia.
For references, please go to https://www.eea.europa.eu/data-and-maps/data/nationally-designated-areas-national-cdda-3 or scan the QR code.
PDF generated on 02 Apr 2023, 06:00 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