Emerald - Tabular data

Data Table

12 min read

This is an old version, kept for reference only.

Go to latest version

This page was archived on 20 May 2022 with reason: Other (New version data-and-maps/data/emerald-network-data-1/emerald-tabular-data was published)

Data and maps

Menu

Category

European data

Table definition

BIOREGION
DESIGNATIONSTATUS
EMERALDSITE
HABITATCLASS
HABITATS
IMPACT
MANAGEMENT
OTHERSPECIES
SPECIES
METADATA

BIOREGION (3839 records)

Indicates for each site in which Biogeographical Region(s) it occurs, according to the Biogeographical Regions Map as adopted by the Standing Committee of the Bern Convention. Paragraph 2.6 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
BIOGEOGRAPHICREG	Indicate in witch biogeographic region the site is falling.
PERCENTAGE	Percentage of the surface of the site affected by the biogeographic region where the site is falling.

DESIGNATIONSTATUS (5145 records)

Indicates the protection status of each site according to the agreed look-up table for national and sub-national designation types as defined in the Nationally designated areas inventory (CDDA) managed by the European Environment Agency. Paragraph 5 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code and the remaining seven characters, which serve to create a unique alphanumeric code for each site.
DESIGNATIONCODE	Designation code at regional or national level.
DESIGNATEDSITENAME	Name of the sites related with the described site.
OVERLAPCODE	Relationship code.	=: types are coincident; +: the described site includes another site completely; -: the other site includes the described site completely; *: the two sites partially overlap
OVERLAPPERC	The percentage of the described site that is overlapping with the other site.

EMERALDSITE (3729 records)

Contains all other information of the SDF not listed in the other tables (sections 1, 2 and descriptive fields from section 4, 5 and 6).

Element name	Element definition	Value definitions
COUNTRY_CODE	Two digit country code the site belongs to.
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
SITENAME	Site name in the local language.
SITETYPE	Type of classification for the site.	A: SPAs (Special Protection Areas - sites designated under the Birds Directive); B: SCIs and SACs (Sites of Community Importance and Special Areas of Conservation - sites designated under the Habitats Directive); C: where SPAs and SCIs/SACs boundaries are identical (sites designated under both directives).
SITESTATUS	The status of the site in relation to the designation process within the Emerald Network	Proposed, Candidate or Adopted
DATE_COMPILATION	The date information has been recorded in the Standard Data Form. The data field takes the form of the year (four digits) followed by the month in numeric form (two digits).
DATE_UPDATE	The date when the information reported for the site was last changed. The data field takes the form of the year (four digits) followed by the month in numeric form (two digits).
DATE_PROP_ASCI	The date a site is proposed as an Emerald Network site
DATE_CONF_CAND_ASCI	The date the site is accepted as a Candidate Emerald Network site by the Standing Committee of the Bern Convention
DATE_CONF_ASCI	The date the site is adopted as an Emerald Network site by the Standing Committee of the Bern Convention
DATE_DESIG_ASCI	the date the site was designated nationally with reference to the Emerald Network
EXPLANATIONS	Additional explanations given by the country to support the dates designations.
AREAHA	Surface area of a site in hectares. Although it is an obligatory field, the value -99 is given for sites for witch the areas is unknown. A value of 0 cab be correct if the site is a cave or cliff. In this case the field 2.3 is obligatory.
LENGTHKM	Site length is entered in kilometers.
MARINE_AREA_PERCENTAGE	Percentage of the site considered as marine.
DOCUMENTATION	Additional documentation existing as a reference for the site.
QUALITY	Description of the site in terms of ecological quality.
DESIGNATION	The local name of the official designation of the site.
OTHERCHARACT	Additional description in the local language about the site.
LATITUDE	The geographic coordinate in decimals of the site centre. (ETRS89 projection).
LONGITUDE	The geographic coordinate in decimals of the site centre. (ETRS89 projection).
DATE_SPA	Date site classified as SPA.	This is not an intrinsic Emerald data field. In case a country is leaving the EU and is transposing it's Natura2000 sites into the Emerald Network, this field will contain the information as recorded under the Natura2000 Network
SPA_LEGAL_REFERENCE	The legal statement by the national authority in which the site was amended as SPA.	This is not an intrinsic Emerald data field. In case a country is leaving the EU and is transposing it's Natura2000 sites into the Emerald Network, this field will contain the information as recorded under the Natura2000 Network
DATE_PROP_SCI	Date site proposed as eligible for identification as a Site of Community importance (SCI).	This is not an intrinsic Emerald data field. In case a country is leaving the EU and is transposing it's Natura2000 sites into the Emerald Network, this field will contain the information as recorded under the Natura2000 Network
DATE_CONF_SCI	Date site has been confirmed as a Site of Community importance (SCI).	This is not an intrinsic Emerald data field. In case a country is leaving the EU and is transposing it's Natura2000 sites into the Emerald Network, this field will contain the information as recorded under the Natura2000 Network
DATE_SAC	Date site designated as SAC.	This is not an intrinsic Emerald data field. In case a country is leaving the EU and is transposing it's Natura2000 sites into the Emerald Network, this field will contain the information as recorded under the Natura2000 Network
SAC_LEGAL_REFERENCE	The legal statement by the national authority in which the site was amended as SAC.	This is not an intrinsic Emerald data field. In case a country is leaving the EU and is transposing it's Natura2000 sites into the Emerald Network, this field will contain the information as recorded under the Natura2000 Network

HABITATCLASS (7928 records)

Indicates the main habitat classes and the percentage occuring in each site according to a standard list of 22 habitat classes. Paragraph 4.1 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
DESCRIPTION	Name of the general habitat class in English.
HABITATCODE	Code of the general habitat class.
PERCENTAGECOVER	Percentage cover for an habitat class from the total habitats cover for the site.

HABITATS (13483 records)

List the habitats of Resolution Nr. 4 (1996) occuring in the site and for which the site has been designated under the Emerald Network. Paragraph 3.1 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
HABITATCODE	Code for the habitat type listed in Annex I of Directive 92/43/EEC.
DESCRIPTION	Name of the habitat type listed in Annex I of Directive 92/43/EEC.
HABITAT_PRIORITY	When the priority of the habitat is present in the legislation, a "*" indicates a priority habitat.
PRIORITY_FORM_HABITAT_TYPE	For the habitat types that can have a non-priority as well as a priority form; value "1" indicates a priority form.
NON_PRESENCE_IN_SITE	In case that a habitat type no longer exists in the site, a value "1" is entered.
COVER_HA	Area cover in hectares.
CAVES	For caves the number of caves can be entered if estimated surface area is not available.
REPRESENTATIVITY	Degree of representativity of the habitat type on the site.	A: excellent representativity,B: good representativity, C: significant representativity and D: non-significant representativity
RELSURFACE	Area of the site covered by the natural habitat type in relation to the total area covered by that natural habitat type within the national territory.	A: 100 ≥ p > 15 %, B: 15 ≥ p > 2 % and C: 2 ≥ p > 0 %
CONSERVATION	Degree of conservation of the structure and functions of the natural habitat type, concerned and restoration possibilities.	A: excellent conservation, B: good conservation, C: average or reduced conservation
GLOBAL_ASSESSMENT	Global assessment of the value of the site conservation of the natural habitat type concerned.	A: excellent value, B: good value, C: significant value
DATAQUALITY	Assessment of the quality of data provided for habitats.	G: 'Good' (e.g. based on surveys); M: 'Moderate' (e.g. based on partial data with some extrapolation); P: 'Poor' (e.g. rough estimation)
PERCENTAGE_COVER	Percentage cover for an habitat from the total habitats cover for the site.

IMPACT (15044 records)

Indicates the preasures and threats listed for each site corresponding to the standard list of preasures and threats. Paragraph 4.3 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
IMPACTCODE	Human activity and natural process that may have an influence, either positive or negative, on the conservation and management of the site.	The Reference list of Threats, Pressures and Activities can be found in the Emerald Network Reference Portal
DESCRIPTION	Title of the human activity according to the look-up table in the Reference Portal.
INTENSITY	Indicates the rank of the impact.	HIGH, MEDIUM, LOW
POLLUTIONCODE	Code of the type of pollution.	N: Nitrogen input; P: Phosphor/Phosphate input; A: Acidification; T: Toxic inorganic chemicals; O: Toxic organic chemicals; X: Mixed pollution
OCCURRENCE	Indicate whether the threat, pressure or activity occurs/acts inside or outside the site or both as well.	IN = Inside, OUT = Outside
IMPACT_TYPE	Indicate whether the influence is positive (P) or negative (N).	positive (P) or negative (N)

MANAGEMENT (3841 records)

Contains all information of Paragraph 6 of the SDF related to site management

Element name	Element definition	Value definitions
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
ORG_NAME	Name of the body(ies) responsible for the site management.
ORG_EMAIL	E-mail of the body(ies) responsible for the site management.
MANAG_CONSERV_MEASURES	Conservation measures published by the management plan if exists.
MANAG_PLAN	Name of the actual management for the site.
MANAG_PLAN_URL	URL link of the actual management for the site.
MANAG_STATUS	Status of the actual management plan.	Y: Yes; P: No, but in preparation; N: No
ORG_LOCATORNAME	Address locator name (e.g. street) where resides the body responsible of the management.
ORG_DESIGNATOR	Address unit designator where resides the body responsible of the management.
ORG_ADMINUNIT	The local administrative unit where resides the body responsible of the management.
ORG_POSTCODE	Postcode of the address of the body responsible of the management.
ORG_POSTNAME	Postname of the address of the body responsible of the management.
ORG_ADDRESS	Address where resides the body responsible of the management.
ORG_ADDRESS_UNSTRUCTURED	The address of the body responsible of the management.

OTHERSPECIES (18473 records)

List other species than those listed in Resolution Nr. 6 (1998) which are important to be mentioned. Paragraph 3,3 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
COUNTRY_CODE	Two digit country code the site belongs to.
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code and the remaining seven characters, which serve to create a unique alphanumeric code for each site.
SPECIESGROUP	Species group.	Amphibians, Birds, Fish, Fungi, Invertebrates, Lichens, Mammals, Plants, Reptiles
SPECIESNAME	Scientific name of an important species of flora and fauna in the site.
SPECIESCODE	Code the species listed in Article 4(1) and 4(2) of the bird directive 79/409/EEC and Annex II of Council Directive 92/43/EEC.
MOTIVATION	Motivation for listing these other important species in the site.	I: Species of Appendix I of the Bern Convention; II: Species of Appendix II of the Bern Convention; III: Species of Appendix III of the Bern Convention;A: National Red List Data; B: Endemics; C: International Conventions (including Berne, Bonn and Biodiversity); D: Other reasons
SENSITIVE	States if a species is sensitive or not for its publication.	0: no sensitive; 1: sensitive
NONPRESENCEINSITE	In case that a species no longer exists in the site a value "1" is entered.
LOWERBOUND	Lower limits for the species population size.
UPPERBOUND	Upper limits for the species population size.
ABUNDANCE_CATEGORY	Species population abundance category.	C: common; R: rare; V: very rare; P: present
COUNTING_UNIT	Units of population, i = individuals, p = pairs or other units according to the standard list of population units and codes in accordance with Article 12 and 17 reporting.

SPECIES (53426 records)

List the species of Resolution Nr. 6 (1998) occuring in the site and for which the site has been designated under the Emerald Network. Paragraph 3.2 of the Emerald Network Standard Data Form (SDF)

Element name	Element definition	Value definitions
COUNTRY_CODE	Two digit country code the site belongs to.
SITECODE	Unique code witch forms the key-item within the database.	The unique code comprises nine characters and consists of two components. The first two codes are the country code the remaining seven characters, which serve to create a unique alphanumeric code for each site.
SPECIESNAME	Scientific name of the protected species.
SPECIESCODE	Code the species listed in Article 4(1) and 4(2) of the bird directive 79/409/EEC and Annex II of Council Directive 92/43/EEC.
REF_SPGROUP	Species Group from the reference ETC lookup species list.	Reptiles, Birds, Amphibians, Mammals, Invertebrates, Fish, Plants
SPGROUP	Species Group.	Reptiles, Birds, Amphibians, Mammals, Invertebrates, Fish, Plants
SENSITIVE	States if a species is sensitive or not for its publication.	0: no sensitive; 1: sensitive
NONPRESENCEINSITE	In case that a species no longer exists in the site a value "1" is entered.
POPULATION_TYPE	Population status for the species.	p: permanent; r: reproducing; c: concentration; w: wintering
LOWERBOUND	Lower limits for the species population size.
UPPERBOUND	Upper limits for the species population size.
COUNTING_UNIT	Units of population, i = individuals, p = pairs or other units according to the standard list of population units and codes in accordance with Article 12 and 17 reporting.
ABUNDANCE_CATEGORY	Species population abundance category.	C: common; R: rare; V: very rare; P: present
DATAQUALITY	Assessment of the quality of data provided for habitats.	G: 'Good' (e.g. based on surveys); M: 'Moderate' (e.g. based on partial data with some extrapolation); P: 'Poor' (e.g. rough estimation)
POPULATION	Size and density of the population of the species present on the site in relation to the populations present within national territory.	A: 100% >= p > 15%; B: 15% >= p > 2%; C: 2% >= p > 0%; D: non-significant population
CONSERVATION	Degree of conservation of the features of the habitat important for the species.	A: conservation excellent; B: good conservation; C: Average or reduced conservation
ISOLATION	Degree of isolation of the population present on the site in relation to the natural range of the species.	A: population (almost) isolated; B: population not-isolated, but on margins of area of distribution; C: population not-isolated within extended distribution range.
GLOBAL	Global assessment if the value of the site for conservation of the species concerned.	A: excellent value; B: good value; C: significant value.

METADATA (4 records)

Creation Date, Version number and database sources used for this Emerald Network Release

Element name	Element definition	Value definitions
DATABASE_CREATED	Date of the creation of the data base version.
DATABASE_VERSION	Version name of the database.
SOURCE_FILES	Files used delivered by the countries for the production of the database version.
DATABASE_TYPES	Provides the type of database, official for internal use (ETC, COMM and EEA and public for publication over the Data and Maps EEA site.