# CODE_LIST_DO_NOT_MODIFY

lu_ShortDescription:
it is not official ISO 3166-1 alpha-3 code


lu_Definition:
Designation types used with the intention to protect fauna, flora, habitats and landscapes (the latter as far as relevant for fauna, flora and for habitat protection)


lu_Definition:
Statutes under sectorial, particularly forestry, legislative and administrative acts providing an adequate protection relevant for fauna, flora and habitat conservation


lu_Definition:
Private statute providing durable protection for fauna, flora or habitats


lu_ShortDescription:
Designation do not create sites (for example protected habitat where it ever appears)


lu_ShortDescription:
Designation creates sites (is measurable and will be also recorded in sites table even if not yet then in future)


lu_ShortDescription:
Designation record is valid and should not be deleted


lu_ShortDescription:
Designation record is not valid anymore and should be deleted


lu_Definition:
Boundaries not relevant for analysis at European scale. Point or line feature.


lu_Definition:
Use resolution information provided in metadata for the spatial dataset


lu_Definition:
Use dissemination instructions provided in metadata for the spatial dataset


lu_Definition:
Vector data can be published for this feature


lu_Definition:
Public dissemination restricted to presence/absence in European raster dataset


lu_Definition:
Public dissemination restricted to European scale maps


lu_Definition:
Dissemination to CDDA partner institutions (WCMP and CoE) for their internal use only. Other interested parties should contact national representative.


lu_Definition:
No dissemination by EEA. Interested parties should contact national representative.


lu_Definition:
Area of land/or sea possessing some outstanding or representative ecosystems, geological or physiological features and/or species, available primarily or scientific research and/or environmental monitoring.

lu_ShortDescription:
Strict Nature Reserve: protected area managed mainly for science


lu_Definition:
Large area of unmodified or slightly modified land and/or sea, retaining its natural character and influence, without permanent or significant habitation, which is protected and managed so as to preserve its natural condition.

lu_ShortDescription:
Strict Nature Reserve: protected area managed mainly for wilderness protection


lu_Definition:
Natural area of land and/or sea, designated to (a) protect the ecological integrity of one or more ecosystems for present and future generations, (b) exclude exploitation or occupation inimical to the purposes of designation of the area and (c) provide a foundation for spiritual, scientific, educational, recreational and visitor opportunities, all of which must be environmentally and culturally compatible.

lu_ShortDescription:
National park: protected area managed mainly for ecosystem protection and recreation


lu_Definition:
Area containing one, or more, specific natural or natural/cultural feature which is of outstanding or unique value because of its inherent rarity, representative or aesthetic qualities or cultural significance.

lu_ShortDescription:
Natural Monument: protected area managed mainly for conservation of specific natural features


lu_Definition:
Area of land and/or sea subject to active intervention for management purposes so as to ensure the maintenance of habitats and/or to meet the requirements of specific species.

lu_ShortDescription:
Habitat/Species Management Area: protected area managed mainly for conservation through management intervention


lu_Definition:
IUCN category will never be available for some reason


lu_Definition:
Area of land, with coast and sea as appropriate, where the interaction of people and nature over time has produced an area of distinct character with significant aesthetic, ecological and/or cultural value, and often with high biological diversity. Safeguarding the integrity of this traditional interaction is vital to the protection, maintenance and evolution of such an area.

lu_ShortDescription:
Protected Landscape/Seascape: protected area managed mainly for landscape/seascape conservation and recreation


lu_Definition:
Area containing predominantly unmodified natural systems, managed to ensure long term protection and maintenance of biological diversity, while providing at the same time a sustainable flow of natural products and services to meet community needs.

lu_ShortDescription:
Managed Resource Protected Area: protected area managed mainly for the sustainable use of natural ecosystems


lu_Definition:
Site designation changed – included elsewhere


lu_Definition:
Site designation ended – area no longer protected


lu_Definition:
EEA to calculate from reported boundary data


lu_ShortDescription:
A field was updated to a more recent value or text


lu_ShortDescription:
Site record is valid and should not be deleted


lu_ShortDescription:
Site record is not valid anymore and should be deleted


# DEFINITIONS_DATASET_DO_NOT_MODIFY

ds_Name:
Common Database on Designated Areas (CDDA)

ds_Definition:
The definition of a protected area adopted by IUCN is:

A clearly defined geographical space, recognised, dedicated and managed, through legal or other effective means, to achieve the long-term conservation of nature with associated ecosystem services and cultural values.

Definitions and details are basing on IUCN publication: "Guidelines for Applying Protected Area Management Categories" that can be found in pdf format at url: 

http://data.iucn.org/dbtw-wpd/edocs/PAPS-016.pdf 

(The document can also be ordered as paper copy)


The definition of a "designated area" within the CDDA is very similar. The "designation types" are grouped according to 3 categories, which clearly reflects the IUCN note above by also identifying designation types in other sectors "or other effective means".

As some of the designation types do not refer to the creation of individual site networks, the definition of the CDDA also includes "area covering" designations such as the protection of the complete distribution of certain habitats. This is an addition to the IUCN "protected area" definition.

ds_Methodology:
Each data collection cycle: the available data provided earlier to EEA on designation types and on sites are loaded into an MS-Access file "CDDA-XX-YYYYMM" for each country generated according to the Data Dictionary format. A feedback report on the quality of the available data is also provided for each country.
National experts are asked to review and correct/update the information and deliver it back to the agreed national data repository. The GIS boundary data relating to the sites and protected areas are also collected and quality checked.

A range of automated quality checks are provided to help countries deliver high quality data.


 
"XX" 	stands for the IS0 2 character country code
"YYYY"	stands for the year in which the file was created
"MM"	stands for the month in which the file was created


# DEFINITIONS_ELEMENTS_DO_NOT_MODIFY

e_Definition:
ISO 3 character code for the reporting country


e_Definition:
The ISO 3 character country code is the only valid code for this field


e_Definition:
This field accumulates codes given in appendix D of the NATURA 2000 Standard Data Form or Emerald Standard Data Form. This code is unique for national designation types in EUNIS.

e_Methodology:
Designation code should always be ISO2 character country code + 2 numbers starting with 00 (indicating designation type "No protection status" and ending with 99 indicating "Others")

For countries which have not yet checked the data through the EIONET data flow process, it is still possible to find designation codes as abbreviations (not like described above) that were present in the CDDA before. If such abbreviations are still present in your country database, they should be marked to be deleted if the designation type does not correspond to an existing type in the law or they should be transformed to the coding principles explained above as new entry. 

For designations that are not yet present, a new code is to be given following the coding principles in the appendix of the NATURA 2000 and Emerald Standard Data Form (described above).


e_Definition:
The designation type category according to the codes (A, B or C) used in appendix D of the Natura 2000 Standard Data Form (Protection status categories in each Member State at national and regional level). The same designation type categories are also used by the Emerald network.


e_Methodology:
To avoid all misunderstandings with translations of titles, each designation type must be identified with its correct title in original language referenced to an official source (Law, decree,….). 

This should guarantee the best link to the real situation in your country. In the case of other character sets you should transliterate the titles (e.g. Greek, Cyrillic).


e_Definition:
English translation of the official title of the designation.

e_Methodology:
For a better understanding in an international context, the official title should be translated into English. 

Please correct or add the necessary translation as you think reflects best the title in original language.


e_Definition:
Flag to indicate whether the designation does or does not create sites (is measurable by area).

e_Methodology:
A "Yes" in this field indicates that the CDDA should contain sites data for this designation, even if no sites are yet recorded in the Sites table.

As explained in the description of the Designations table, some of the designation do not create sites in the classical sense, such as the protection of the complete distribution of a particular habitat or zoning systems in other sectors.

In the case you indicate "No", you are asked to fill an estimate or exact figure of the area covered within the country by this designation in the "Total Area Reference" field. NOTE: from 2008, you are also asked to provide digital GIS information for the areas protected by this kind of designation.


e_Methodology:
Please enter the full reference to the law (including paragraph number(s)) covering the designation type concerned. 

For type C designations this field can be left blank.


e_Definition:
Reference to the publication in Official Journal

e_Methodology:
Please enter the full reference to the Official Journal in which the law was published.

For type C designations this field can be left blank.


e_Definition:
full address of the administrative authority

e_Methodology:
Enter the full address of the administrative authority responsible for this designation


e_Definition:
Number of Sites for this designation within the present version of the CDDA sites table.

e_Methodology:
The number of sites shown in this field is provided by ETC BD just for your information to help you to check the data more easily. 

You should NOT correct the figures in this field. 

It will be updated subsequently by ETC BD from the corrections and additions that you make to the Sites table.


e_Definition:
Total area in hectares covered within the present version of the CDDA sites table.

e_Methodology:
The total surface area coverage (ha) shown in this field together with number of sites shown in the "Number" is given by ETC BD just for your information to help you to check the data more easily. 
You should NOT correct the figures in these fields. 
The fields will be updated subsequently by ETC BD from the corrections and additions that you make to the Sites table.


e_Definition:
Number of Sites for this designation as indicated by an official source.

e_Methodology:
The value in this field has been taken from an official information source (Environmental reports, biodiversity reports, official websites, â¦.). 
This information is a way of evaluating the completeness and quality of the site data in the CDDA. 
The values in these fields should NOT be changed, unless more recent official statistics are available. Please indicate in this case the sources used in the field "Data Source".


e_Definition:
The total surface area coverage (hectares) as indicated by an official source for non-site based designation types .
It should be filled if the field "CDDA sites" is "No".

e_Methodology:
The statistic for the total surface area covered has been taken from an official information source (Environmental reports, biodiversity reports, official websites, â¦.). 
The value should NOT be changed, unless more recent official statistics are available. Please indicate in this case the sources used in the field "Data Source".


e_Definition:
Official source (Environmental report, biodiversity report, official website,..) of the statistics for the designation.

e_Methodology:
Enter the reference to the documents or other information sources.


e_Definition:
Reference date for the official statistics for the designation.

e_Methodology:
The date mentioned in the official source shown in the field  "Data Source".


e_Methodology:
Any useful remark to understand what this designation is about may be entered in this field.

If the designation is to be deleted from the CDDA, the reason should be explained here.


e_Definition:
Reference to source of information for the remarks


e_Definition:
Flag to indicate that the designation should be deleted.

e_Methodology:
To be able to maintain the central data base, designation types which are not valid any more can be marked for deletion in this field. 
The reason for deletion should be added in the remarks field. 
As long as existing linked data still use those codes they are kept alive in the central data base. As soon as all tables are compatible with this deletion, the record will be actually deleted from the data base. 
As an example we can mention some of the designations from the first version of the NATURA2000 Standard Data Form (appendix D) which are now marked for deletion. But, the present NATURA2000 data base is still using the code and needs updating according to the new list.


e_Definition:
Unique identifier that should NOT be deleted or changed by anyone else than administrator of CDDA.

e_Methodology:
You should NOT change or delete any entry on that field. It is only for internal use on administrative level.


e_Definition:
Codes for spatial resolution of dataset from which geographical data for this feature (boundaries, coordinates) has been derived.


e_Definition:
Code for instructions to EEA regarding dissemination of geographical data (boundaries or coordinates).


e_Definition:
Unique record identifier within the CDDA data base for nationally designated areas.

e_Methodology:
This field may NOT be changed as it forms the link to the source data base. 

For newly created sites, the international data manager will fill this field, when integrating the sites in the central data base management system. After that, the codes will flow back to the national data base.

If sites are to be merged or a site needs to be split in to more different parts, ETC/BD should be consulted on how to proceed with the site codes given at international level.


e_Definition:
The unique record identifier for the site in the national database on designated areas.

e_Methodology:
More and more countries are building up national databases on designated areas, which should be used as the source database for the CDDA.
If links between the unique record identifiers for sites are established, the future updates will be much easier to perform.


e_Methodology:
Some countries still have site names translated in English. They should be corrected to the name in local language! For languages with other than Latin characters, a transliteration should be used (e.g. Greek, Cyrillic)


e_Methodology:
A "0" area value may be given to point objects, like trees, caves or steep cliffs etc. 
This field should contain the latest surface area figure. 
Changes in surface area for a particular site are not recorded.


e_Definition:
The IUCN management categories according to the new system (IUCN (1994), Guidelines for Protected Area Management Categories: http://www.iucn.org/places/medoffice/definicionEN.htm

e_Methodology:
Sites with missing IUCN category are marked with either "NA" stands for "Not available" or "UA" which stands for "Unassigned". First category is mainly for those sites that never will have any IUCN categorisation and latter is especially those records which should be corrected and if possible a category should be given taking in to account the criteria for the application of the categories.

If you have entered one of categories above an explanation should be documented in the NOTES field, to be able to "understand" the reason why IUCN category is not available.


e_Definition:
The Nomenclature of Territorial Units for Statistics (NUTS) is defined only for the Member States of the European Union.
For the candidate countries awaiting accession to the EU, for the other European Economic Area (EEA) countries and for Switzerland, a coding of Statistical Regions has been defined by Eurostat in agreement with the countries concerned.

e_Methodology:
This field is of particular interest for countries with regionalised administrative structure. It enables the splitting of the database in to different regions.

The latest version can be found at:
http://ec.europa.eu/eurostat/ramon/nuts/codelist_en.cfm


e_Definition:
Year of establishment. The year the site was first time designated.

e_Methodology:
Subsequent revisions of the site should not be mentioned here, only the year the site was designated. 

If a site was designated previously under another designation type or site name, but not longer valid, a comment should be made in the NOTES field in the Sites table.


e_Definition:
Geographical Co-ordinate in decimal degrees.

e_Methodology:
Degrees south should be indicated with a minus sign


e_Methodology:
Degrees west should be indicated with a minus sign


e_Definition:
Code for derivation of tabular coordinates of sites.


e_Methodology:
If some fields in the site record are corrected and some are updated, you may choose the most important change type, according to your expert judgement.


e_Definition:
The name of the person who did the actual editing of the data.


e_Definition:
The abbreviation of the institution responsible for editing of the record.


e_Methodology:
Any remark, which is useful to understand the data entered in the other fields of the site record, can be added here.

The reason for flagging a site record for deletion should be given here.


e_Definition:
To be able to maintain the central data base, sites which are not valid any more can be marked for deletion in this field.

e_Methodology:
When a site has been marked for deletion, the NOTES field in the Sites table should be used to indicate the reason for doing so.


e_Definition:
Total area protected by designation category.

e_Methodology:
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.


e_Definition:
Document or indicator where total area was published if available.


e_Definition:
Documentation of methodology used if available.


# DEFINITIONS_TABLES_DO_NOT_MODIFY

tbl_Methodology:
In the table 'Designations', you will find a list of designations for your country.

The complete list should be verified and corrected according to the actual situation.

For EU member countries, the basis for this list were the data submitted for the creation of appendix D of the NATURA 2000 Standard Data Form ("Protection status categories in each Member State at national and regional level"). In this appendix the designation types are classified according to 3 categories:

Category A:	Designation types used with the intention to protect fauna, flora, habitats and landscapes (the latter as far as relevant for fauna, flora and for habitat protection).
Category B:	Statutes under sectorial, particularly forestry, legislative and administrative acts providing an adequate protection relevant for fauna, flora and habitat conservation.
Category C:	Private statute providing durable protection for fauna, flora or habitats

For non-EU countries, the list is based on the data being prepared under the Emerald network of the Bern Convention. As Emerald is being developed on the same scientific and technical basis, the same coding principles are applied.

This list also contains statutes under sectorial, particularly forestry, legislative and administrative acts, many of them do not result in a specific list of sites, but they may be used as a designation within individual areas, identified under other legislation.

In 2008, national reference centres for biodiversity were asked to review and harmonise the CDDA list of designations and the list used for Natura 2000.

tbl_ShortDescription:
Table contains the list of designations and references to laws


tbl_Name:
Spatial coverage of protected areas not defined as sites

tbl_Definition:
Indicates whether digital boundaries have been reported for areas protected by a designation which does not create a network of sites; for example Danish heathlands are protected where ever they occur.
Provides information on resolution of source material from which the boundary has been derived. Instructs EEA regarding dissemination of boundaries.

tbl_Methodology:
There is an offline QA routine for this table that can be run at any time.


tbl_Definition:
Information on the site records for each designation type creating "sites" (the field "CDDA sites" in the Designations table must be set to "Yes")

tbl_Methodology:
Codes for new sites are allocated by the ETC/BD helpdesk.

There is an offline QA routine for this table that can be run at any time.

The digital boundaries for sites larger than 1 hectare should also be delivered. The site code is the unique key for the tabular and the polygons in the spatial data set. GIS delivery instructions are provided separately: see data request letter to EIONET.

tbl_ShortDescription:
The table contains the information on individual designated sites at national level.


tbl_Definition:
Indicates 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.


tbl_Definition:
National indicators for amount of national territory that is protected.

tbl_Methodology:
EEA is particularly interested in national calculations of marine and terrestrial territory area protected under Category A designations. It is sufficient to aggregate as “Other” all areas that are protected by national designations which are not covered by Category A.

NOTE: the totals should only count a protected area once even if it is protected under more than one national designation types.


