View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier designations
Short name Designations
Dataset CDDA
Reference URL
Name List of National Designation Types
Short Description Table contains the list of designations and references to laws
Definition List of designations for the country.
Methodology for obtaining data 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 some cases, additional designation types were identified resulting from earlier data requests on designated areas by the CDDA partner organisations (UNEP-WCMC and/or Council of Europe). These types have been added to the list with an abbreviation in the national designation type code when data were already present in the common data base or with a code starting with "XX98" downwards (XX being the ISO 2 character country code).


Element name Datatype Element type
* ISO 3 character code (ISO3) string Quantitative
* Law reference (Lawreference) string Quantitative
* Law (Law) string Quantitative
* Total Area (Total_Area) integer Quantitative
* Title - Original Language (ODESIGNATE) string Quantitative
* Title - French (Title_French) string Quantitative
* Number of Sites (Number) integer Quantitative
* Agency (Agency) string Quantitative
* Reference date (Reference_date) string Quantitative
* National designation type category (Category) string Fixed values
* Remark Source (Remark_Source) string Quantitative
* Number Reference (Number_reference) decimal Quantitative
* Total Area Reference (Total_Area_reference) integer Quantitative
* Title - English (DESIGNATE) string Quantitative
* National designation type code (DESIG_ABBR)   (FK) string Quantitative
* To be deleted (To_be_deleted) string Fixed values
* Data Source (Data_Source) string Quantitative
* Unique ID for designation type (Desig-id) string Quantitative
* CDDA sites (CDDA_sites) string Fixed values
* Remark (Remark) string Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)