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 http://dd.eionet.europa.eu/datasets/latest/CDDA/tables/designations
Name List of National Designation Types
Short Description Table contains the list of designations and references to laws
Definition List of designations for country.
Methodology for obtaining data In the table 'Designations', you will find a list of designations for your country. For EU member countries, the bases 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 bases, the same coding principles are taken over.
As this list contains also 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 requests on designated areas by the partner organisations (UNEP-WCMC and/or Council of Europe). These types have been added to the list with an abbreviation in the code field 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). The complete set should be verified and corrected according to the actual situation.

Elements

Element name Datatype Element type
* Title - Original Language (ODESIGNATE) string Quantitative
* Title - French (Title_French) string Quantitative
* Number of Sites (Number) integer Quantitative
* ISO 3 character code (ISO3) 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
* Desig-id (Desig-id) decimal Quantitative
* CDDA sites (CDDA_sites) string Fixed values
* Remark (Remark) string Quantitative
* Total Area (Total_Area) integer Quantitative
* Law reference (Lawreference) string Quantitative
* Law (Law) string Quantitative
* Agency (Agency) string Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)