View table

• Create an MS Excel template for this table

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	Geographical co-ordinates: The geographical co-ordinates can be stored in two different ways: decimal degrees (LAT, LON) or degrees, minutes and seconds in separate fields (LAT_NS, LATDEG, LATMIN, LATSEC, LON_EW, LONDEG, LONMIN, LONSEC). You are free to choose whatever system is easier for you. Any point within the boundary of the designated area is considered to be correct. In the case of "multi-polygon" areas, expert judgement should provide the best location of the central point, usually within the largest sub-area, but always within site boundaries. The use of GIS data to fill those fields is highly recommended, especially for countries that have already boundary information in a GIS format available.

Elements

Element name	Datatype	Element type
* To be deleted (To_be_deleted)	string	Fixed values
* Altitude minimum (ALTITUDE_MIN)	integer	Quantitative
* Administrative Region Code (NUTS)	string	Quantitative
* Longitude minutes (LONMIN)	integer	Quantitative
* EIONET institute (EIONET_INSTITUTE)	string	Quantitative
* Longitude degrees (LONDEG)	integer	Quantitative
* Latitude seconds (LATSEC)	integer	Quantitative
* SITE_CODE (SITE_CODE)   (FK)	integer	Quantitative
* Designation type (DESIGNATE)	string	Quantitative
* Latitude minutes (LATMIN)	integer	Quantitative
* Site name (AREANAME)	string	Quantitative
* National designation type code (DESIG_ABBR)   (FK)	string	Quantitative
* Longitude EW (LON_EW)	string	Quantitative
* Latitude NS (LAT_NS)	string	Quantitative
* Longitude seconds (LONSEC)	integer	Quantitative
* EIONET change type (EIONET_CHNG_TYPE)	string	Fixed values
* Longitude (LON)	decimal	Quantitative
* National Site Code (SITE_CODE_NAT)	string	Quantitative
* EIONET edited by (EIONET_EDITED_BY)	string	Quantitative
* Year (YEAR)	string	Quantitative
* EIONET change date (EIONET_CHNG_DATE)	date	Quantitative
* Size (SIZE)	decimal	Quantitative
* ISO3 code (ISO3)	string	Quantitative
* Altitude maximum (ALTITUDE_MAX)	integer	Quantitative
* Latitude degrees (LATDEG)	integer	Quantitative
* Remark (Remark)	string	Quantitative
* Latitude (LAT)	decimal	Quantitative
* IUCN category (IUCNCAT)	string	Fixed values
* Parent ISO code (PARENT_ISO)	string	Quantitative