Do something for our planet, print this page only if needed. Even a small action can make an enormous difference when millions of people do it!
BIOREGIONS (28943 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(255) | |
| PERCENTAGE | Percentage of the surface of the site affected by the biogeographic region where the site is falling. | decimal |
CONTACTS (2614 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 | |
| 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 (70050 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(61) | |
| 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 (140788 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 (140323 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 (132567 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 (29391 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 (27413 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 (313760 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 (406096 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 |
For references, please go to https://eea.europa.eu./data-and-maps/data/natura-6/natura-2000-tabular-data-12-tables or scan the QR code.
PDF generated on 24 Nov 2024, 02:50 AM
Engineered by: EEA Web Team
Software updated on 26 September 2023 08:13 from version 23.8.18
Software version: EEA Plone KGS 23.9.14
Document Actions
Share with others