View table

There are 1 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
Name Sites Data
Short Description The table contains the information on individual designated sites 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 An appointed national Reportnet user (NFP, NRC for biodiversity) can allocate codes for new sites on site code distribution web page (

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.


Element name Datatype Element type
* SITE_CODE (SITE_CODE) C  (PK) integer Quantitative
* National Site Code (SITE_CODE_NAT) C string Quantitative
* Parent ISO code (PARENT_ISO) C string Fixed values
* ISO 3 character code (ISO3) C string Fixed values
* National designation type code (DESIG_ABBR) C string Quantitative
* Site name (SITE_NAME) string Quantitative
* Site area (SITE_AREA) decimal Quantitative
* Major ecosystem type (Major_ecosystem_type) string Fixed values
Percentage of Marine area (Marine_area_perc) float Quantitative
* IUCN category (IUCNCAT) string Fixed values
Administrative Region Code (NUTS) string Quantitative
* Year (YEAR) string Quantitative
Year of last legal change (Last_leg_chng_year) string Quantitative
Code of last legal change (Last_leg_chng_code) string Fixed values
Latitude (LAT) decimal Quantitative
Longitude (LON) decimal Quantitative
* Coordination derivation code (CDDA_Coordinates_code) C string Fixed values
* Spatial resolution code (CDDA_Resolution_code) C string Fixed values
* Dissemination instruction code (CDDA_Dissemination_code) C string Fixed values
EIONET change date (EIONET_CHNG_DATE) date Quantitative
EIONET change type (EIONET_CHNG_TYPE) string Fixed values
EIONET edited by (EIONET_EDITED_BY) string Quantitative
EIONET institute (EIONET_INSTITUTE) string Quantitative
Notes (NOTES) string Quantitative
* To be deleted (To_be_deleted) boolean Fixed values
(an asterisk in front of element name indicates that the element is mandatory in this table)
(the C sign marks a common element)