All official European Union website addresses are in the europa.eu domain.
See all EU institutions and bodiesDo 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!
Most important facts and figures on the general implementation of the Habitats Directive from Member States (uses greporthash as a primary key, which is common to all other general tables matching the data_g* naming scheme)
Field name | Definition | Note | Data type |
---|---|---|---|
greporthash | General report auto generated primary key | text(32) | |
country | 2-letter ISO country code | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(2) |
achievements | Text in national language | memo | |
achievements_trans | English translation | memo | |
general_information | General information about the Habitats Directive | memo | |
information_on_network | Information about the Natura 2000 network | memo | |
monitoring_schemes | Monitoring schemes (Article 11) | memo | |
protection_of_species | Protection of species (Articles 12-16) | memo | |
transpose_directive | Transposition of the Habitats Directive (legal texts) | memo | |
sites_total_number | Total number of pSCIs, SCIs, SACs | integer | |
sites_total_area | Total surface area of pSCIs, SCIs, SACs (km²) | decimal | |
sac_total_number | Total number of SACs | integer | |
sac_total_area | Total surface area of SACs (km²) | decimal | |
sites_terrestrial_area | Surface area of pSCIs, SCIs, SACs (km²) in terrestrial area of sites (excluding marine areas) | decimal | |
sac_terrestrial_area | Surface area of SACs (km²) in terrestrial area of sites (excluding marine areas) | decimal | |
sites_marine_number | Number of pSCIs, SCIs, SACs in marine area of sites | integer | |
sites_marine_area | Surface area of pSCIs, SCIs, SACs (km²) in marine area of sites | decimal | |
sac_marine_number | Number SACs in marine area of sites | integer | |
sac_marine_area | Surface area of SACs only (km²) in marine area of sites | decimal | |
database_date | Date of latest update of the Natura 2000 database sent to the Commission | text(255) | |
sites_with_plans | Number of sites with management plans | integer | |
coverage | Percentage of the network area covered by management plans | decimal | |
plans_under_prep | Number of sites with management plans under preparation | integer | |
coherence_measures | General description of the main measures taken to ensure coherence of the Natura 2000 Network (Article 10) | memo |
Article 17 compensation measures (data_gmeasures)
Compensation measures details, as found in the 2007-2012 reporting round Member States deliveries under the Arcticle 17 of the Habitats Directive (links to the general report table using greporthash)
Field name | Definition | Note | Data type |
---|---|---|---|
greporthash | Foreign key to data_bgreport | text(32) | |
sitecode | Site code | 2-letter ISO country code plus 7 characters | text(9) |
sitename | Site name | text(255) | |
project_year | Year of project/plan | long | |
project_title | Title of project/plan | text(255) | |
commission_opinion | Commission opinion requested? | yes/no | |
project_impact | Impact of projects in need of compensation measures on conservation status? | memo |
Article 17 reintroduction of Annex IV species (data_greintroduction_of_species)
Provide information on reintroduction of Annex IV species per Member State
Field name | Definition | Note | Data type |
---|---|---|---|
greporthash | Foreign key to data_bgreport | text(32) | |
speciescode | Species code | Codelist: lu_hd_species | long |
speciesname | Name of the species as reported by the Member State | text(255) | |
reintro_period_since | Qualifier: '=' in the year; '<' before the year; '>' after the year given in field reintro_period | text(1) | |
reintro_period | Reintroduction period | text(9) | |
location_number | Reintroduction location and number of individuals reintroduced | text(255) | |
successful | Indicates if natural reproduction has already taken place and/or population is growing | text(255) | |
additional_information | Additional information on the reintroduction | memo |
Article 17 habitats check list (data_habitats_check_list)
ETCBD processed - Member States checklist for habitats data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
country | 2-letters country code | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(2) |
region | Biogeographical region or marine region for which the habitat type is taken into account for the European data set / assessments | Codelist: lu_biogeoreg | text(4) |
region_orig | Biogeographical region or marine region in which the habitat type was reported by the Member State | Codelist: lu_biogeoreg | text(4) |
regionhash | Foreign key to tables such as data_habitats_regions_MS_level | Instead of combined key country, region, habitatcode | text(45) |
habitatcode | Code of the habitat type as in the Habitat Directive Annex I | Codelist: lu_habitattypes | text(4) |
presence | Additionnal information such as scientific reserve. | Codelist: lu_checklist_presence_categories | text(10) |
habitatgroup | Habitat group as defined in the annex of the Habitats Directive | text(255) | |
annex_I_priority | Flag to indicate whether or not it is a priority habitat type as listed in the annex of the Habitats Directive, taking into account exceptions for Member State | text(255) | |
annex_I_priority_comment | Comment on the priority as given in the annex of the Habitats Directive | text(255) |
Article 17 habitats biogeographical regions EU level (data_habitats_regions_EU_level)
European biogeographical level habitats data, providing assessments from the experts based on Member State habitats data.
Field name | Definition | Note | Data type |
---|---|---|---|
country | Identifies an european level assessment by the EU27 code, which is a constant here | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(4) |
region | Biogeographical region or marine region for which the habitat type is taken into account for the European data set / assessments | Codelist: lu_biogeoreg | text(4) |
habitatcode | Code of the habitat type as in the Habitat Directive Annex I | Codelist: lu_habitattypes | text(4) |
range_surface_area | Reference to the total surface area of the range for that biogeographical region in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
range_trend | General trend of the range for that biogeographical region | Codelist: lu_trends | text(1) |
complementary_favourable_range | Reference to the favourable range in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
coverage_surface_area | Reference to the total surface area of the coverage for that biogeographical region in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
coverage_trend | General trend of the coverage for that biogeographical region | Codelist: lu_trends | text(3) |
complementary_favourable_area | Reference to the favourable coverage in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
method_range | Code of the method used to assess the range at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_range | Conclusion for the range state at the biogeographical level (based on method_range) | Codelist: lu_assessments | text(2) |
method_area | Code of the method used to assess the coverage at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_area | Conclusion for the coverage state at the biogeographical level (based on method_area) | Codelist: lu_assessments | text(2) |
method_structure | Code of the method used to assess the structures and functions at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_structure | Conclusion for the structures and functions state at the biogeographical level (based on method_structure) | Codelist: lu_assessments | text(2) |
method_future | Code of the method used to assess the future prospects at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_future | Conclusion for the future prospects state at the biogeographical level (based on method_future) | Codelist: lu_assessments | text(2) |
method_assessment | Code of the method used to calculate the overall assessment at the biogeographical level (always 'MTX' for habitats) | Codelist: lu_assessments_method | text(3) |
conclusion_assessment | Conclusion for the overall assessment at the biogeographical level (based on method_assessment) | Codelist: lu_assessments | text(2) |
conclusion_assessment_trend | Conclusion for the overall assessment trend at the biogeographical level | Codelist: lu_trends_conclusion | text(1) |
conclusion_assessment_prev | Conclusion for the overall assessment from the previous reporting round (2001-2006) | Codelist: lu_assessments | text(3) |
conclusion_assessment_change | Coded values for the nature of change in the overall assessments between the previous and current reporting | Codelist: lu_natureofchange | text(2) |
type_target1 | Evaluation of progress to Target 1 of the EU Biodiversity Strategy | (=) no change, (+) improvement, (-) deterioration, (x) not known (codelist: lu_assessments) | text(3) |
contribution_target1 | Type of change in the conservation status between reporting periods | (A) favourable, (B) improved, (C) deteriorated, (D) unfavourable or unknown assessments that did not change, (E) assessments that became unknown (codelist: lu_assessments) | text(3) |
use_for_statistics | Depending on the purpose of the statistics certain habitats and species reports need to be excluded from the analysis in order to generate useful information. This field can be used to quickly identify the records to keep/exclude. | yes/no |
Article 17 habitats biogeographical regions MS level (data_habitats_regions_MS_level)
ETCBD processed - Member States habitats data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
country | 2-letters country code | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(2) |
region | Biogeographical region or marine region for which the habitat type is taken into account for the European data set / assessments | Codelist: lu_biogeoreg | text(4) |
regionhash | Foreign key to tables such as data_habitats_check_list | Instead of combined key country, region, habitatcode | text(45) |
habitatcode | Code of the habitat type as in the Habitat Directive Annex I | Codelist: lu_habitattypes | text(4) |
range_surface_area | Surface area of the range within the biogeographical region concerned, in km² | double | |
range_change_reason | List of reported change reasons for the range | text(150) | |
percentage_range_surface_area | Percentage of the total area of the range in the biogeographical region across all Member States. | double | |
range_trend | Trend of the range | Codelist: lu_trends | text(1) |
range_trend_magnitude_min | Percentage change in range over the period (minimal value) | decimal | |
range_trend_magnitude_max | Percentage change in range over the period (maximal value) | decimal | |
range_method | Method used to evaluate surface area of range | Codelist: lu_methods_used | text(255) |
range_trend_period | 2001-2012 (rolling 12-year time window) or range trend period as close as possible to it. | text(20) | |
complementary_favourable_range_q | Favourable reference range qualifier | Codelist: lu_favourable_range_operator | text(2) |
complementary_favourable_range | Favourable reference range in km² | double | |
complementary_favourable_range_method | Description of a method used to set Favourable Reference Range; only filled in if numeric FRV is reported. | memo | |
coverage_surface_area | Area covered by habitat type within the range in the biogeographical region concerned, in km² | double | |
coverage_change_reason | List of reported change reasons for the coverage | text(150) | |
percentage_coverage_surface_area | Percentage of the total area of the coverage in the biogeographical region across all Member States. | double | |
coverage_method | Method used to evaluate area covered by habitat | Codelist: lu_methods_used | text(30) |
coverage_date | Year or period | text(20) | |
coverage_trend | Trend of the habitat area | Codelist: lu_trends | text(1) |
coverage_trend_magnitude_min | Percentage change in coverage over the period (minimal value) | decimal | |
coverage_trend_magnitude_max | Percentage change in coverage over the period (maximal value) | decimal | |
coverage_trend_method | Method used to evaluate short-term trend | Codelist: lu_methods_used | text(30) |
coverage_trend_period | 2001-2012 (rolling 12-year time window) or coverage trend period as close as possible to it. | text(20) | |
complementary_favourable_area_q | Favourable reference area - qualifier. | Codelist: lu_favourable_range_operator | text(2) |
complementary_favourable_area | Favourable reference area covered by habitat in km² | double | |
complementary_favourable_area_method | Description of a method used to set Favourable Reference Area; only filled in if numeric FRV is reported. | memo | |
conclusion_range | Conclusions - Range | Codelist: lu_assessments | text(2) |
conclusion_area | Conclusions - Population | Codelist: lu_assessments | text(2) |
conclusion_structure | Conclusions - Habitat for the species | Codelist: lu_assessments | text(2) |
conclusion_future | Conclusions - Future prospects | Codelist: lu_assessments | text(2) |
conclusion_assessment | Overall assessment of conservation status | Codelist: lu_assessments | text(2) |
conclusion_assessment_trend | Overall trend in conservation status | Codelist: lu_trends_conclusion | text(1) |
conclusion_assessment_prev | Overall assessment from the previous reporting round 2001-2006, including the qualifier | Codelists: lu_assessments, lu_trends_conclusion | text(3) |
conclusion_assessment_change | Coded values for the nature of change in the overall assessments between the previous and current reporting | Codelist: lu_natureofchange | text(2) |
complementary_other_information | Complementary information as reported by Member State | memo | |
pressures_method | Code of the method used to assess pressures | Codelist: lu_methods_used_for_pressures | text(1) |
threats_method | Code of the method used to assess threats | Codelist: lu_methods_used_for_threats | text(1) |
range_grid_area | Cumulated range area based on the associated Member State GIS data. | double | |
percentage_range_grid_area | Percentage of the total area of the cumulated range in the biogeographical region across all Member States. | double | |
distribution_grid_area | Cumulated distribution area based on the associated Member State GIS data. | double | |
percentage_distribution_grid_area | Percentage of the total area of the cumulated distribution in the biogeographical region across all Member States. | double | |
natura2000_area_min | Surface area in km² (minimum) | decimal | |
natura2000_area_max | Surface area in km² (maximum) | decimal | |
natura2000_area_trend | Trend of surface area within the network | Codelist: lu_trends | text(30) |
natura2000_area_method | Method used to evaluate surface area | Codelist: lu_methods_used | text(30) |
published_data_sources | List of published sources | Author, year, title of publication, source, volume, number of pages, web address | memo |
structure_and_functions_method | Code of the method used to assess structures and functions | Codelist: lu_methods_used | text(30) |
typical_species_assessment | Method used for the assessment of typical species from that habitat type | memo | |
justification_thresholds | Justification for the use of the different thresholds for trends in the evaluation matrix | memo | |
use_for_statistics | Depending on the purpose of the statistics certain habitats and species reports need to be excluded from the analysis in order to generate useful information. This field can be used to quickly identify the records to keep/exclude. | yes/no |
Article 17 species check list (data_species_check_list)
ETCBD processed - Member States checklist for species data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
country | 2-letters country code | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(2) |
region | Biogeographical region or marine region for which the species is taken into account for the European data set / assessments | Codelist: lu_biogeoreg | text(4) |
region_orig | Biogeographical region or marine region in which the species was reported by the Member State | Codelist: lu_biogeoreg | text(4) |
regionhash | Foreign key to tables such as data_species_regions_MS_level | Instead of combined key country, region, speciescode | text(45) |
speciescode | Species code | Codelist: lu_hd_species | long |
speciesname | Name of the species as reported by the Member State | text(255) | |
assessment_speciescode | Species code corresponding to assessment_speciesname | long | |
assessment_speciesname | Name of the species used for the European assessment | text(60) | |
tax_group | Higher taxonomic group (simplified) | text(20) | |
presence | Additionnal information such as scientific reserve | Codelist: lu_checklist_presence_categories | text(10) |
annex_II_priority | Flag to indicate whether or not this species is listed as a priority species in the annex of the Habitats Directive, taking into account exceptions for Member State / region | text(10) | |
annex_II | Flag to indicate in which annex(es) of the Habitats Directive the species is listed, taking into account exceptions for Member State / region | text(10) | |
annex_IV | Flag to indicate in which annex(es) of the Habitats Directive the species is listed, taking into account exceptions for Member State / region | text(10) | |
annex_V | Flag to indicate in which annex(es) of the Habitats Directive the species is listed, taking into account exceptions for Member State / region | text(10) | |
comments_annex_II | Comments as given in the annex of the Habitats Directive | memo | |
comments_annex_IV | Comments as given in the annex of the Habitats Directive | memo | |
comments_annex_V | Comments as given in the annex of the Habitats Directive | memo |
Article 17 species biogeographical regions EU level (data_species_regions_EU_level)
European biogeographical level species data, providing assessments from the experts based on Member State habitats data.
Field name | Definition | Note | Data type |
---|---|---|---|
country | Identifies an european level assessment by the EU27 code, which is a constant here | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(4) |
region | Biogeographical region or marine region for which the habitat type is taken into account for the European data set / assessments | Codelist: lu_biogeoreg | text(4) |
assessment_speciescode | Species code corresponding to the assessment_speciesname | Codelist: lu_hd_species | long |
assessment_speciesname | Name of the species used for the European assessment | text(60) | |
range_surface_area | Reference to the total surface area of the range for that biogeographical region in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
range_trend | General trend of the range for that biogeographical region | Codelist: lu_trends | text(1) |
complementary_favourable_range | Reference to the favourable range in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
population_size | Reference to the total size of the population for that biogeographical region | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
population_size_unit | Units used for the population size | Codelist: lu_population_units | text(20) |
population_trend | General trend of the population for that biogeographical region | Codelist: lu_trends | text(1) |
complementary_favourable_population | Reference to the favourable population size | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
habitat_surface_area | Reference to the total habitat surface area of the species for that biogeographical region in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
habitat_trend | General trend of the habitat for that biogeographical region | Codelist: lu_trends | text(1) |
complementary_suitable_habitat | Reference to the favourable habitat area in km² | Concatenation of number and qualifier, codelist: lu_favourable_range_operator | text(23) |
method_range | Code of the method used to assess the range at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_range | Conclusion for the range state at the biogeographical level (based on method_range) | Codelist: lu_assessments | text(2) |
method_population | Code of the method used to assess the population at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_population | Conclusion for the population state at the biogeographical level (based on method_area) | Codelist: lu_assessments | text(2) |
method_habitat | Code of the method used to assess the habitat for the species at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_habitat | Conclusion for the state of the habitat for the species at the biogeographical level (based on method_structure) | Codelist: lu_assessments | text(2) |
method_future | Code of the method used to assess the future prospects at the biogeographical level | Codelist: lu_assessments_method | text(3) |
conclusion_future | Conclusion for the future prospects state at the biogeographical level (based on method_future) | Codelist: lu_assessments | text(2) |
method_assessment | Code of the method used to calculate the overall assessment at the biogeographical level (always 'MTX' for habitats) | Codelist: lu_assessments_method | text(3) |
conclusion_assessment | Conclusion for the overall assessment at the biogeographical level (based on method_assessment) | Codelist: lu_assessments | text(2) |
conclusion_assessment_trend | Conclusion for the overall assessment trend at the biogeographical level | Codelist: lu_trends_conclusion | text(1) |
conclusion_assessment_prev | Conclusion for the overall assessment from the previous reporting round (2001-2006) | Codelist: lu_assessments | text(3) |
conclusion_assessment_change | Coded values for the nature of change in the overall assessments between the previous and current reporting | Codelist: lu_natureofchange | text(2) |
type_target1 | Evaluation of progress to Target 1 of the EU Biodiversity Strategy | (=) no change, (+) improvement, (-) deterioration, (x) not known (codelist: lu_assessments) | text(3) |
contribution_target1 | Type of change in the conservation status between reporting periods | (A) favourable, (B) improved, (C) deteriorated, (D) unfavourable or unknown assessments that did not change, (E) assessments that became unknown (codelist: lu_assessments) | text(3) |
use_for_statistics | Depending on the purpose of the statistics certain habitats and species reports need to be excluded from the analysis in order to generate useful information. This field can be used to quickly identify the records to keep/exclude. | yes/no |
Article 17 species biogeographical regions MS level (data_species_regions_MS_level)
ETCBD processed - Member States species data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
country | 2-letters country code | ISO country code for all countries but UK for United Kingdom. Codelist: lu_countries | text(2) |
region | Biogeographical region or marine region for which the habitat type is taken into account for the European data set / assessments | Codelist: lu_biogeoreg | text(4) |
regionhash | Foreign key to tables such as data_species_check_list | Instead of combined key country, region, speciescode | text(45) |
speciescode | Species code | Codelist: lu_hd_species | long |
speciesname | Name of the species as reported by the Member State | text(60) | |
range_surface_area | Surface area of the range within the biogeographical region concerned, in km² | double | |
range_change_reason | List of reported change reasons for the range | text(150) | |
percentage_range_surface_area | Percentage of the total area of the range in the biogeographical region across all Member States. | double | |
range_trend | Trend of the range | Codelist: lu_trends | text(1) |
range_trend_magnitude_min | Percentage change in range over the period (minimal value) | decimal | |
range_trend_magnitude_max | Percentage change in range over the period (maximal value) | decimal | |
range_method | Method used to evaluate surface area of range | Codelist: lu_methods_used | text(255) |
range_trend_period | 2001-2012 (rolling 12-year time window) or range trend period as close as possible to it | text(20) | |
complementary_favourable_range_q | Favourable reference range qualifier | Codelist: lu_favourable_range_operator | text(2) |
complementary_favourable_range | Favourable reference range in km² | double | |
complementary_favourable_range_method | Description of a method used to set Favourable Reference Range; only filled in if numeric FRV is reported. | memo | |
population_size_unit | Unit used to estimate the population size | Codelist: lu_population_units | text(10) |
population_minimum_size | Minimum estimate of the population size | double | |
percentage_population_minimum_size | Percentage of the total population size minimum estimate in the biogeographical region across all Member States. | double | |
population_maximum_size | Maximum estimate of the population size | double | |
percentage_population_maximum_size | Percentage of the total population size maximum estimate in the biogeographical region across all Member States. | double | |
filled_population | Only set for Greece, it indicates how the population size data was treated during aggregation from the 2001-2006 reporting round. | text(3) | |
population_alt_size_unit | Alternative unit used to estimate the population size | Codelist: lu_population_units | text(10) |
population_alt_minimum_size | Minimum estimate of the population size based on alternate unit | double | |
population_alt_maximum_size | Maximum estimate of the population size based on alternate unit | double | |
population_change_reason | List of reported change reasons for the population | text(150) | |
percentage_population_mean_size | Percentage of the total population size average in the biogeographical region across all Member States. | double | |
population_additional_locality | Definition of locality; only filled in if number of locations is used as a population size unit. | memo | |
population_additional_method | Description of a method used to convert population size in local units into population size in recommended units. | memo | |
population_additional_problems | Information on problems encountered to estimate the population size. | memo | |
population_method | Method used to evaluate population size | Codelist: lu_methods_used | text(255) |
population_date | Year (or period) where the data to estimate the population size were collected. | text(255) | |
population_trend | Trend of the population | Codelist: lu_trends | text(1) |
population_trend_magnitude_min | Percentage change over the period (minimal value) | decimal | |
population_trend_magnitude_max | Percentage change over the period (maximal value) | decimal | |
population_trend_method | Method used to evaluate short-term trend | Codelist: lu_methods_used | text(255) |
population_trend_period | 2001-2012 (rolling 12-year time window) or population trend period as close as possible to it. | text(255) | |
complementary_favourable_population_q | Favourable reference population size qualifier | Codelist: lu_favourable_range_operator | text(2) |
complementary_favourable_population | Favourable reference population size, typically in same units as the population size | double | |
complementary_favourable_population_method | Description of a method used to set Favourable Reference Population; only filled in if numeric FRV is reported. | memo | |
habitat_surface_area | Surface area of the habitat for the species in km² | double | |
habitat_change_reason | List of reported change reasons for the habitat | text(150) | |
percentage_habitat_surface_area | Percentage of the total area of the habitat surface in the biogeographical region across all Member States. | double | |
habitat_date | Year (or period) when data to estimate the habitat surface area were collected. | text(255) | |
habitat_method | Method used to evaluate habitat for species | Codelist: lu_methods_used | text(255) |
habitat_trend | Trend of the area of habitat of species | Codelist: lu_trends | text(1) |
habitat_trend_period | 2001-2012 (rolling 12-year time window) or habitat trend period as close as possible to it. | text(255) | |
habitat_quality | Estimated quality of the habitat for the species | text(255) | |
habitat_quality_explanation | Description of a method used to evaluate the quality of habitat. | memo | |
complementary_suitable_habitat | Area of the suitable habitat for the species in km² | double | |
conclusion_range | Conclusions - Range | Codelist: lu_assessments | text(2) |
conclusion_population | Conclusions - Population | Codelist: lu_assessments | text(2) |
conclusion_habitat | Conclusions - Habitat for the species | Codelist: lu_assessments | text(2) |
conclusion_future | Conclusions - Future prospects | Codelist: lu_assessments | text(2) |
conclusion_assessment | Overall assessment of conservation status | Codelist: lu_assessments | text(2) |
conclusion_assessment_trend | Overall trend in conservation status | Codelist: lu_trends_conclusion | text(1) |
conclusion_assessment_prev | Overall assessment from the previous reporting round 2001-2006, including the qualifier | Codelists: lu_assessments, lu_trends_conclusion | text(3) |
conclusion_assessment_change | Coded values for the nature of change in the overall assessments between the previous and current reporting | Codelist: lu_natureofchange | text(2) |
complementary_other_information | Complementary information as reported by Member State | memo | |
range_grid_area | Cumulated range area based on the associated Member State GIS data. | double | |
distribution_grid_area | Cumulated distribution area based on the associated Member State GIS data. | double | |
percentage_range_grid_area | Percentage of the total area of the cumulated range in the biogeographical region across all Member States. | double | |
percentage_distribution_grid_area | Percentage of the total area of the cumulated distribution in the biogeographical region across all Member States. | double | |
pressures_method | Code of the method used to assess pressures | Codelist: lu_methods_used_for_pressures | text(1) |
threats_method | Code of the method used to assess threats | Codelist: lu_methods_used_for_threats | text(1) |
natura2000_population_unit | Natura 2000 Population size unit | Codelist: lu_population_units | text(10) |
natura2000_population_min | Estimation of minimum population size included in the network for annex II species | double | |
natura2000_population_max | Estimation of maximum population size included in the network for annex II species | double | |
natura2000_population_trend | Natura 2000 Trend of population size within network | Codelist: lu_trends | text(1) |
natura2000_population_method | Natura 2000 Method used to evaluate population size | Codelist: lu_methods_used | text(255) |
published_data_sources | List of published sources (author, year, title of publication, source, volume, number of pages, web address). | memo | |
justification_thresholds | Justification for the use of the different thresholds for trends in the evaluation matrix | memo | |
transboundary_assessment | Explanation for a trans-boundary population of a (usually wide-ranging) species, that is where 2 or more Member States have made a joint conservation status assessment. | memo | |
use_for_statistics | Depending on the purpose of the statistics certain habitats and species reports need to be excluded from the analysis in order to generate useful information. This field can be used to quickly identify the records to keep/exclude. | yes/no |
Article 17 habitats typical species (data_htypical_species)
ETCBD processed - Member States habitats typical species data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
regionhash | Foreign key to data_habitats_check_list | text(32) | |
speciesname | Typical species for habitat types in a region | Names are not standardised | text(255) |
Article 17 Pressures & Threats for habitats and species (data_pressures_threats)
Member States Pressures & Threats for habitats and species data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
pressurethreathash | Primary key | text(255) | |
habitat_regionhash | Foreign key to data_habitats_check_list | text(45) | |
species_regionhash | Foreign key to data_species_check_list | text(45) | |
pressurecode | Code for a pressure/threat | Codelist: lu_threats | text(10) |
rankingcode | Code for the rank of the pressure/threat | Codelist: lu_ranking | text(1) |
type_pressure | Pressure/Threat flag | p=pressures; t=threats | text(1) |
Article 17 Pressures & Threats pollution qualifier for habitats and species (data_pressures_threats_pol)
Member States Pressures & Threats pollution qualifier for habitats and species data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
pressurethreathash | Primary key | text(255) | |
pressurecode | Code for a pressure/threat | Codelist: lu_threats | text(10) |
pollution_qualifier | Code for a pollution qualifier | Codelist: lu_pollution | text(1) |
Article 17 Measures for habitats and species (data_measures)
Member States Measures for habitats and species data, accounting for the 2007-2012 reporting round deliveries under the Arcticle 17 of the Habitats Directive.
Field name | Definition | Note | Data type |
---|---|---|---|
measurecode | Code for a measure | Codelist: lu_measures | text(10) |
species_regionhash | Foreign key to data_species_check_list | text(255) | |
habitat_regionhash | Foreign key to data_habitats_check_list | text(255) | |
type_legal | Legal/statutory flag | yes/no | |
type_administrative | Administrative flag | yes/no | |
type_contractual | Contractual flag | yes/no | |
type_recurrent | Recurrent flag | yes/no | |
type_oneoff | Oneoff flag | yes/no | |
rankingcode | Code for the rank of the measure | Codelist: lu_ranking | text(1) |
location_inside | Location flag | True if inside | yes/no |
location_outside | Location flag | True if outside | yes/no |
location_both | Location flag | True if both inside & outside | yes/no |
broad_evaluation_maintain | Broad evaluation flag | True if maintain | yes/no |
broad_evaluation_enhance | Broad evaluation flag | True if enhance | yes/no |
broad_evaluation_longterm | Broad evaluation flag | True if long term | yes/no |
broad_evaluation_noeffect | Broad evaluation flag | True if no effect | yes/no |
broad_evaluation_unknown | Broad evaluation flag | True if unknown | yes/no |
broad_evaluation_notevaluated | Broad evaluation flag | True if not evaluated | yes/no |
Links between Article 17 habitat types and broad ecosystems using MAES typology (habitats_maes)
ETCBD processed - Links between Article 17 habitat types and broad ecosystems using MAES typology differentiated by biogeographical regions
Field name | Definition | Note | Data type |
---|---|---|---|
id | Auto generated unique identifier | long | |
region | Biogeographical or marine region | Codelist: lu_biogeoreg | text(4) |
codeeco | Code ecosystems | Codelist: lu_ecosystems_maes | text(20) |
habitatcode | Code Habitats Directive habitat type | text(10) | |
description | Description Habitats Directive habitat type | text(200) |
Links between Article 17 species and broad ecosystems using MAES typology (species_maes)
ETCBD processed - Links between Article 17 species and broad ecosystems using MAES typology differentiated by biogeographical regions
Field name | Definition | Note | Data type |
---|---|---|---|
id | Auto generated unique identifier | long | |
region | Biogeographical or marine region | Codelist: lu_biogeoreg | text(4) |
codeeco | Code ecosystems | Codelist: lu_ecosystems_maes | text(20) |
speciesname | Species name | text(60) | |
typeasso | Importance of the species relation/link to the MAES classification | Codelist: lu_spec_hab_association | text(10) |
assessment_speciesname | Name of the species considered for the European assessment | text(200) | |
speciesgroup | Higher taxonomic group (simplified) | text(20) | |
HD_name | Species name according to the Annexes of the Habitats Directive | text(255) |
For references, please go to https://www.eea.europa.eu/data-and-maps/data/article-17-database-habitats-directive-92-43-eec-2/article-17-2015-dataset or scan the QR code.
PDF generated on 10 Oct 2024, 09:07 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