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
Database contains all data tables. Detailed table definitions are displayed in the section with individual tables.
Microsoft Access format (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: 730)
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| 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 | decimal(9) | 0 | |
| PARENT_ISO | ISO 3 characters country code | nvarchar(3) | -1 | |
| ISO3 | Country ISO code | nvarchar(3) | -1 | |
| DESIG_ABBR | National designation type code | nvarchar(5) | -1 | |
| Category | National designation type category | nvarchar(1) | 0 | |
| Odesignate | Title - original language | nvarchar(100) | 0 | |
| Designate | Title in English | nvarchar(100) | 0 | |
| Law | Reference to the legal text | nvarchar(max) | 0 | |
| Lawreference | Reference to the publication in Official Journal | nvarchar(max) | 0 | |
| Agency | Name and address of the highest administrative authority responsible for this designation | nvarchar(max) | 0 | |
| Remark | Remarks concerning the designation | nvarchar(max) | 0 |
cdda_v8_designations.csv
(text/comma-separated-values)
cdda_v8_designations.xls
(Microsoft Excel spreadsheet)
Table contains list of digital boundaries of protected areas not defined as sites. Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries.
[+] Show table definition (records: 2553)
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| PARENT_ISO | ISO 3 characters country code | nvarchar(3) | -1 | |
| ISO3 | Country ISO code | nvarchar(3) | -1 | |
| DESIG_ABBR | National designation type code | nvarchar(5) | -1 | |
| CDDA_Availability_code | Availability of boundaries | 00 - Boundaries not available, 01 - Boundaries reported to EEA, 02 - Boundaries under preparation, 03 - Boundaries not relevant for analysis at European scale. Point or line feature. | nvarchar(2) | 0 |
| CDDA_Resolution_code | Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived. | 00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000 | nvarchar(2) | 0 |
| CDDA_Dissemination_code | Code for instructions to EEA regarding dissemination of geographical data. | 00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative | nvarchar(2) | 0 |
cdda_v8_designation_boundaries.csv
(text/comma-separated-values)
cdda_v8_designation_boundaries.xls
(Microsoft Excel spreadsheet)
Table contains main information (name, location, area, IUCN category etc) of each individual designated area at national level.
[+] Show table definition (records: 108692)
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| SITE_CODE | Unique record identifier for nationally designated areas | int(2) | -1 | |
| SITE_AREA | Surface area in hectares (ha) | float(8) | 0 | |
| LAT | Latitude | (Y) International Geographical Co-ordinates of the monitoring station in decimal degrees format | float(8) | 0 |
| LON | Longitude decimal degrees | float(8) | 0 | |
| SITE_CODE_NAT | National site code | unique record identifier in the national source database | nvarchar(20) | 0 |
| PARENT_ISO | ISO 3 characters country code | nvarchar(3) | -1 | |
| ISO3 | Country ISO code | nvarchar(3) | -1 | |
| DESIG_ABBR | National designation type code | nvarchar(5) | -1 | |
| SITE_NAME | Site name as given in local language. | nvarchar(120) | 0 | |
| IUCNCAT | IUCN management category | nvarchar(4) | 0 | |
| CDDA_Dissemination_code | Code for instructions to EEA regarding dissemination of geographical data. | 00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative | nvarchar(2) | 0 |
| Notes | Remarks about the site record | nvarchar(max) | 0 | |
| NUTS | Administrative Region Code according to the coding system of EUROSTAT | nvarchar(5) | 0 | |
| Year | Year | nvarchar(4) | 0 | |
| Last_leg_chng_year | Year of last legal change | nvarchar(4) | 0 | |
| Last_leg_chng_code | Code of last legal change | nvarchar(2) | 0 | |
| CDDA_Coordinates_code | Code for derivation of tabular coordinates of sites. | 00 - unknown, 01 - national calculation, 02 - EEA to calculate from reported boundary data | nvarchar(2) | 0 |
| CDDA_Resolution_code | Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived. | 00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000 | nvarchar(2) | 0 |
ASCII Delimited (zip)
(ZIP archive)
Table contains information whether digital boundaries have been reported for a site reported as tabular data. Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries.
[+] Show table definition (records: 89607)
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| SITE_CODE | Unique record identifier for nationally designated areas | int(4) | -1 | |
| SITE_CODE_NAT | National site code | unique record identifier in the national source database | nvarchar(20) | 0 |
| PARENT_ISO | ISO 3 characters country code | nvarchar(3) | -1 | |
| ISO3 | Country ISO code | nvarchar(3) | -1 | |
| CDDA_Availability_code | Availability of boundaries | 00 - Boundaries not available, 01 - Boundaries reported to EEA, 02 - Boundaries under preparation, 03 - Boundaries not relevant for analysis at European scale. Point or line feature. | nvarchar(2) | 0 |
| CDDA_Resolution_code | Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived. | 00 - use resolution information provided in metadata for the spatial dataset, 01 - unknown, 02 - less than 1:1 000 000, 03 - between 1:250 000 and 1:1 000 000, 04 - between 1:100 000 and 1:250 000, 05 - greater than 1:100 000 | nvarchar(2) | 0 |
| CDDA_Dissemination_code | Code for instructions to EEA regarding dissemination of geographical data. | 00 - use dissemination instructions provided in metadata for the spatial dataset, 01 - vector data can be published for this feature, 02 - public dissemination restricted to presence/absence in European raster dataset, 03 - public dissemination restricted to European scale maps, 04 - dissemination to CDDA partner institutions (WCMC and CoE) for their internal use only. Other interested parties should contact national representative, 05 - no dissemination by EEA. Interested parties should contact national representative | nvarchar(2) | 0 |
ASCII Delimited (zip)
(ZIP archive)
Table contains national indicators for amount of national territory that is protected.
[+] Show table definition (records: 75)
| Field name | Field Definition | Note | Data type | Primary key |
|---|---|---|---|---|
| Total_area | Total area protected by designation category. | Areas protected within specified boundaries and areas protected by the designation of a particular habitat should be included if relevant in the national context. Overlapping areas should be excluded from total. | decimal(9) | 0 |
| PARENT_ISO | ISO 3 characters country code | nvarchar(3) | -1 | |
| ISO3 | Country ISO code | nvarchar(3) | -1 | |
| Category | National designation type category | nvarchar(5) | -1 | |
| Major_ecosystem | Major ecosystem | nvarchar(12) | 0 | |
| Reference_year | Time reference for area | nvarchar(4) | 0 | |
| Publication_title | Publication title | Document or indicator where total area was published if available. | nvarchar(50) | 0 |
| Publication_url | Publication url | nvarchar(max) | 0 | |
| Methodology_type | Methodology type | How area was calculated. | nvarchar(2) | 0 |
| Methodology_reference_title | Methodology reference title | Documentation of methodology used if available. | nvarchar(50) | 0 |
| Methodology_reference_url | Methodology reference url | Nature conservation and biodiversity | nvarchar(max) | 0 |
| Remark | Remark | Optional free text comment | nvarchar(max) | 0 |
cdda_v8_national_overview.xls
(Microsoft Excel spreadsheet)
cdda_v8_national_overview.csv
(text/comma-separated-values)
File contains all code lists used in the data tables.
Look-up tables
(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 (63 records)
(text/comma-separated-values)
File contains metadata definitions of all data tables.
Tables metadata:
(text/comma-separated-values)
Quality asssesment and control reports present results of quality tests performed by the EEA and the ETC-BD on top of the national CDDA data. The ETC-BD assesment is more focused on geographical data and on their relation with tabular data.
CDDA - quality control document - EEA
(PDF document)
CDDA - quality document - ETC-BD
(PDF document)
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: 28 Oct 2009.
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 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.
Release note for version 8: 34 countries updated their information on legislative instruments, sites and site boundaries in the 2009 Eionet data collection. Information for European countries outside Eionet has been included from the 2009 version of WDPA. A quality report on version 8 is available, in particular on the quality of data from the Eionet countries. There has been a revision of the data format with the removal of items which it was agreed have little value at the European level. For the first time Eionet countries were asked to report in 2009 on their total protected area (terrestrial and marine). This is a step towards improving comparability between aggregated information published at national and European level and it is expected that the values made available for some countries will be revised in future releases of the data set.
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 boundary 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-4 or scan the QR code.
PDF generated on 30 Mar 2023, 08:50 PM
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