Natura 2000 - Tabular data (12 tables)

Data Table

This is an old version, kept for reference only.

Go to latest version

This page was archived on 03 Apr 2018 with reason: Other (New version data-and-maps/data/natura-9/natura-2000-tabular-data-12-tables was published)

Data and maps

Menu

Category

European data

Table definition

BIOREGIONS (28581 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
BIOGEOGRAPHICREG	Indicate in wich beogreograhic region the site is falling.		text(64)
PERCENTAGE	Percentage of the surface of the site affected by the biogeographic region where the site is falling.		decimal

CONTACTS (2279 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
NAME	The name, affiliation of the individual or organization providing the information contained in the record.		memo
EMAIL	The e-mail account of the individual or organization providing the information contained in the record.		text(255)
ADDRESS_UNSTRUCTURED	The address of the individual or organization providing the information contained in the record without a sparation on the different elements that compose an address.		memo
ADMINUNIT	The local administrative unit where resides the individual or organization providing the information contained in the record.		text(255)
THOROUGHFARE	Transportation route where resides the individual or organization providing the information contained in the record		text(255)
DESIGNATOR	Address unit designator where resides the individual or organization providing the information contained in the record		text(255)
POSTCODE	Postcode of the address of the individual or organization providing the information contained in the record		text(255)
POSTNAME	Postname of the address of the individual or organization providing the information contained in the record		text(255)
ADDRESS	Address where resides the individual or organization providing the information contained in the record		text(255)
LOCATORNAME	Address locator name (e.g. street) where resides the individual or organization providing the information contained in the record		text(255)

DESIGNATIONSTATUS (79659 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
DESIGNATIONCODE	Designation code at regional or national level		text(5)
DESIGNATEDSITENAME	Name of the sites related with the described site		text(255)
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	text(1)
OVERLAPPERC	The percentage of the described site that is overlapping with the other site.		decimal

DIRECTIVESPECIES (2315 records)

Field name	Field definition	Note	Data type
DIRECTIVE	Name of the Directive		text(18)
SPECIESNAME	Sientific name of the species in the Annex of the Directive		text(60)
ANNEXII	Species listed in Annex II of the Directive	y=Yes, N=no	text(1)
ANNEXII1	Species listed in Annex II1 of the Directive	y=Yes, N=no	text(1)
ANNEXII2	Species listed in Annex II2 of the Directive	y=Yes, N=no	text(1)
ANNEXIII1	Species listed in Annex III1 of the Directive	y=Yes, N=no	text(1)
ANNEXIII2	Species listed in Annex III2 of the Directive	y=Yes, N=no	text(1)
ANNEXIV	Species listed in Annex IV of the Directive		text(1)
ANNEXV	Species listed in Annex V of the Directive		text(1)
SPBCAX1	Species listed in SPBCAX1 of the Directive		text(1)

HABITATCLASS (142771 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
HABITATCODE	Code of the general habitat class		text(255)
PERCENTAGECOVER	Percentage cover for an habitat class from the total habitats cover for the site		decimal
DESCRIPTION	Name of the general habitat class in English		text(255)

HABITATS (NoOfRecs 146369 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
HABITATCODE	Code for the habitat type listed in AnnexI of Directive 92/43/EEC		text(4)
DESCRIPTION	Name of the habitat type listed in AnnexI of Directive 92/43/EEC		text(255)
HABITAT_PRIORITY	When the priority of the habitat is present in the legislation, a "*" indicates a priority habitat		text(1)
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		integer
NON_PRESENCE_IN_SITE	In case that a habitat type no longer exists in the site, a value "1" is entered		integer
COVER_HA	Area cover in hectares		double
CAVES	% Cover the site is covered by a habitat type of AnnexI		decimal
REPRESENTATIVITY	Ddegree of representativity of the habitat type on the site.		text(1)
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.		text(1)
CONSERVATION	Degree of conservation of the structure and functions of the natural habitat type, concerned and restoration possiblities.		text(1)
GLOBAL_ASSESSMENT	Global assesment of the value of the site conservation of the natural habitat type concerned.		text(1)
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)	text(1)
PERCENTAGECOVER	Percentage cover for an habitat from the total habitats cover for the site		decimal

IMPACT (193941 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
IMPACTCODE	Human activity and natural process that may have an influence, either positive or negative, on the conservation and management of the site.		text(50)
DESCRIPTION	Inside or outside the surounding of the site. The surrounding is the area where the outside impacts and activities may effect the integreity of the site.		text(255)
INTENSITY	Indicates the rank of the impact	HIGH, MEDIUM, LOW	text(6)
POLLUTIONCODE	Code of the type of pollution	Nitrogen input - N, Phosphor/Phosphate input -P, Acidification -A, Toxic inorganic chemicals -T, Toxic organic chemicals -O, Mixed pollution-X	text(50)
OCCURRENCE	Indicate whether the influence is positive (+) or negative (-)		text(4)
IMPACT_TYPE	Indicate whether the influence is positive (P) or negative (N)		text(1)

MANAGEMENT 31702 records)

Field name	Field definition	Note	Data type
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
ORG_NAME	Name of the body(ies) responsible for the site management		memo
ORG_EMAIL	E-mail of the body(ies) responsible for the site management		text(255)
MANAG_CONSERV_MEASURES	Conservation measures published by the management plan if exists		memo
MANAG_PLAN	Name of the actual management for the site		memo
MANAG_PLAN_URL	URL link of the actual management for the site		memo
MANAG_STATUS	Status of the actual management plan	Y: Yes; P: No, but in preparation; N: No	text(1)
ORG_LOCATORNAME	Address locator name (e.g. street) where resides the body responsible of the management		text(255)
ORG_DESIGNATOR	Address unit designator where resides the body responsible of the management		text(255)
ORG_ADMINUNIT	The local administrative unit where resides the body responsible of the management		text(255)
ORG_POSTCODE	Postcode of the address of the body responsible of the management		text(255)
ORG_POSTNAME	Postname of the address of the body responsible of the management		text(255)
ORG_ADDRESS	Address where resides the body responsible of the management		text(255)
ORG_ADDRESS_UNSTRUCTURED	The address of the body responsible of the management		memo

NATURA2000SITES (27527 records)

Field name	Field definition	Note	Data type
COUNTRY_CODE	Two digit country code the site belongs to		text(4)
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
SITENAME	Site name in the local language.		text(240)
SITETYPE	Type of classification for the site.	A: SPA (Special Protection Areas); B: SCI (Special Conservation Interest); C: both SPA and SCI.	text(1)
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/time
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/time
DATE_SPA	Date site classified as SPA		date/time
SPA_LEGAL_REFERENCE	The legal statement by the national authority in which the site was ammended as SPA		memo
DATE_PROP_SCI	Date site proposed as eligible for identification as a Site of Community importance (SCI)		date/time
DATE_CONF_SCI	Date site has been confirmed as a Site of Community importance (SCI)		date/time
DATE_SAC	Date site designated as SAC		date/time
SAC_LEGAL_REFERENCE	The legal statement by the national authority in which the site was ammended as SAC		memo
EXPLANATIONS	Additional explanations given by the country to support the dates designations.		memo
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 unkown. A value of 0 cab be correct if the site is a cave or cliff. In this case the field 2.3 is obligatory.		decimal
LENGTHKM	Site length is entered in kilometers.		decimal
MARINE_AREA_PERCENTAGE	Percentage of the site considwered as marine		decimal
LONGITUDE	The geographic coordinate in decimals of the site centre. (ETRS89 projection)		double
LATITUDE	The geographic coordinate in decimals of the site centre. (ETRS89 projection)		double
DOCUMENTATION	Addtional documentation existing as a reference for the site		memo
QUALITY	Description of the site in terms of ecological quality		memo
DESIGNATION	The local name of the oficial designation of the site		memo
OTHERCHARACT	Additional description in the local language about the site		memo

OTHERSPECIES (314005 records)

Field name	Field definition	Note	Data type
COUNTRY_CODE	Two digit country code the site belongs to		text(2)
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
SPECIESGROUP	Species group	Reptiles, Birds, Amphibians, Mammals, Invertebrates, Fish, Plants	text(20)
SPECIESNAME	Sientific name of an important species of flora and fauna in the site		text(250)
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.		text(4)
MOTIVATION	Motivation for listing these other important species in the site	IV: Species of Annex IV (Habitats Directive); V: Species of Annex V (Habitats Directive); A: National Red List Data; B: Endemics; C: International Conventions (including Berne, Bonn and Biodiversity); D: Other reasons	text(20)
SENSITIVE	States if a species is sensitive or not for its publication	0: no sensitive; 1: sensitive	integer
NONPRESENCEINSITE	In case that a species no longer exists in the site a value "1" is entered		integer
LOWERBOUND	Lower limits for the species population size		long
UPPERBOUND	Upper limits for the species population size		long
COUNTINGT_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		text(50)
ABUNDANCE_CATEGORY	Species population abudance category	C: common; R: rare; V: very rare; P: present	text(1)

SPECIES (406084 records)

Field name	Field definition	Note	Data type
COUNTRY_CODE	Two digit country code the site belongs to		text(2)
SITECODE	Unique code wich 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 unqiue alphanumeric code for each site.	text(9)
SPECIESNAME	Sientific name of the protected species		text(250)
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.		text(4)
REF_SPGROUP	Species Group from the reference ETC lookup species list	Reptiles, Birds, Amphibians, Mammals, Invertebrates, Fish, Plants	text(20)
SPGROUP	Species Group	Reptiles, Birds, Amphibians, Mammals, Invertebrates, Fish, Plants	text(20)
SENSITIVE	States if a species is sensitive or not for its publication	0: no sensitive; 1: sensitive	integer
NONPRESENCEINSITE	In case that a species no longer exists in the site a value "1" is entered		integer
POPULATION_TYPE	Population status for the species	p: permanent; r: reproducing; c: concentration; w: wintering	text(1)
LOWERBOUND	Lower limits for the species population size		long
UPPERBOUND	Upper limits for the species population size		long
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		text(50)
ABUNDANCE_CATEGORY	Species population abudance category	C: common; R: rare; V: very rare; P: present	text(1)
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)	text(2)
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	text(14)
CONSERVATION	Degree of conservation of the features of the habitat importat for the species.	A: conservation excelent; B: good conservation; C: Average or reduced conservation	text(1)
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.	text(1)
GLOBAL	Global assesment if the value of the site for conservation of the species concerened.	A: excellent value; B: good value; C: significant value.	text(1)

METADATA (4 parameters)

Parameter name	Parameter definition
DATABASE_CREATED	Date of the creation of the data base version
DATABASE_VERSION	Version name of the database (end2012)
SOURCE_FILES	Files used delivered by the MS 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