View table

There are 0 QA scripts and 4 conversion scripts registered for this table.
Link to the schema page on XMLCONV
Identifier sites
Short name Sites
Dataset CDDA
Reference URL http://dd.eionet.europa.eu/datasets/latest/CDDA/tables/sites
Name Sites Data
Short Description The table contains the information on the individual designated areas at national level.
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")
Methodology for obtaining data The definition of a ‘protected area’ adopted by IUCN is:
An area of land and/or sea especially dedicated to the protection and maintenance of biological diversity, and of natural and associated cultural resources, and managed through legal or other effective means.
Furthermore, IUCN recognises:
Although all protected areas meet the general purposes contained in this definition, in practice the precise purposes for which protected areas are managed differ greatly. The following are the main purposes of management: Scientific research, Wilderness protection, Preservation of species and genetic diversity, Maintenance of environmental services, Protection of specific natural and cultural features, Tourism and recreation, Education, Sustainable use of resources from natural ecosystems, Maintenance of cultural and traditional attributes.
The definition of a ‘designated area’ within the CDDA is very similar. The ‘designation types’ are grouped according to 3 classes, which clearly reflects the note above by identifying designation types in other sectors (type B). Type C could refer to ‘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.

Elements

Element name Datatype Element type
* National Site Code (SITE_CODE_NAT) string Quantitative
* SITE_CODE (SITE_CODE)   (FK) integer Quantitative
* To be deleted (To_be_deleted) string Fixed values
* ISO3 code (ISO3) string Quantitative
* National designation type code (DESIG_ABBR)   (FK) string Quantitative
* EIONET institute (EIONET_INSTITUTE) string Quantitative
* Latitude (LAT) decimal Quantitative
* Longitude (LON) decimal Quantitative
* Notes (NOTES) string Quantitative
* Administrative Region Code (NUTS) string Quantitative
* Size (SIZE) decimal Quantitative
* Parent ISO code (PARENT_ISO) string Quantitative
* Site name (AREANAME) string Quantitative
* Altitude minimum (ALTITUDE_MIN) integer Quantitative
* EIONET edited by (EIONET_EDITED_BY) string Quantitative
* EIONET change type (EIONET_CHNG_TYPE) string Fixed values
* Year (YEAR) string Quantitative
* Altitude maximum (ALTITUDE_MAX) integer Quantitative
* EIONET change date (EIONET_CHNG_DATE) date Quantitative
* IUCN category (IUCNCAT) string Fixed values
(an asterisk in front of element name indicates that the element is mandatory in this table)