next
previous
items

Natura 2000 - Tabular data (12 tables)

Data Table
12 min read
This is an old version, kept for reference only.

Go to latest version
This page was archived on 12 Apr 2019 with reason: Other (New version data-and-maps/data/natura-10/natura-2000-tabular-data-12-tables was published)
Category
European data
Table definition

BIOREGION (28817 records)

Field nameField definitionNoteData 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 (1929 records)

Field nameField definitionNoteData 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 (81569 records)

Field nameField definitionNoteData 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 nameField definitionNoteData 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 (143108 records)

Field nameField definitionNoteData 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 (148444 records)

Field nameField definitionNoteData 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
INTRODUCTION_CANDIDATE Habitat type referred to in Annex I to Directive 92/43/EEC considered as a candidate for introduction on the site. boolean

IMPACT (201273 records)

Field nameField definitionNoteData 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 (31942 records)

Field nameField definitionNoteData 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 (27758 records)

Field nameField definitionNoteData 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 (334261 records)

Field nameField definitionNoteData 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)
INTRODUCTION_CANDIDATE Other species considered as a candidate for introduction on the site. boolean

SPECIES (399210 records)

Field nameField definitionNoteData 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)
INTRODUCTION_CANDIDATE Species referred to in Article 4 of Directive 2009/147/EC or species listed in Annex II to Directive 92/43/EEC considered as a candidate for introduction on the site. boolean

METADATA (4 parameters)

Parameter nameParameter definition
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 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.
Files
Document Actions