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	http://dd.eionet.europa.eu/datasets/latest/CDDA/tables/sites
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 (http://dd.eionet.europa.eu/services/siteCodes/view). 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.

Elements

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)