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 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
* Remark (Remark) string Quantitative
* Administrative Region Code (NUTS) string Quantitative
* IUCN category (IUCNCAT) string Fixed values
* EIONET institute (EIONET_INSTITUTE) string Quantitative
* Altitude minimum (ALTITUDE_MIN) integer Quantitative
* Latitude seconds (LATSEC) integer Quantitative
* Longitude minutes (LONMIN) integer Quantitative
* Designation type (DESIGNATE) string Quantitative
* Longitude degrees (LONDEG) integer Quantitative
* Site name (AREANAME) string Quantitative
* SITE_CODE (SITE_CODE)   (FK) integer Quantitative
* Latitude NS (LAT_NS) string Quantitative
* Latitude minutes (LATMIN) integer Quantitative
* EIONET change type (EIONET_CHNG_TYPE) string Fixed values
* National designation type code (DESIG_ABBR)   (FK) string Quantitative
* Longitude EW (LON_EW) string Quantitative
* Parent ISO code (PARENT_ISO) string Quantitative
* Longitude seconds (LONSEC) integer Quantitative
* EIONET change date (EIONET_CHNG_DATE) date Quantitative
* Longitude (LON) decimal Quantitative
* National Site Code (SITE_CODE_NAT) string Quantitative
* EIONET edited by (EIONET_EDITED_BY) string Quantitative
* Year (YEAR) string Quantitative
* Latitude degrees (LATDEG) integer Quantitative
* Size (SIZE) decimal Quantitative
* Latitude (LAT) decimal Quantitative
* Altitude maximum (ALTITUDE_MAX) integer Quantitative
* ISO3 code (ISO3) string Quantitative
(an asterisk in front of element name indicates that the element is mandatory in this table)