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!
Article 17 general report (data_greport)
Most important facts and figures on the general implementation of the Habitats Directive from Member States
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code Corresponding field in the report format: Gen.0. |
Look-up table [ref_countries] |
achievements | Text in national language Corresponding field in the report format: Gen.1.1 |
|
achievements_trans | Translation into English Corresponding field in the report format: Gen.1.2 |
|
general_info | General information on the Habitats Directive Corresponding field in the report format: Gen.2.1 |
|
info_on_network | Information on the network of pSCIs, SCIs and SACs Corresponding field in the report format: Gen.2.2 |
|
monitoring_schemes | Monitoring schemes (Art. 11) Corresponding field in the report format: Gen.2.3 |
|
protection_of_species | Protection of species (Art. 12-16) Corresponding field in the report format: Gen.2.4 |
|
measures_impact | Impact of Natura 2000 measures on the conservation status of Annex I habitats and Annex II species (Art. 17.1) Corresponding field in the report format: Gen.2.5 |
|
transpose_directive | Transposition of the Directive (legal texts) Corresponding field in the report format: Gen.2.6 |
|
sites_total_number | All sites - Number of pSCIs, SCIs, SACs Corresponding field in the report format: Gen.3.1a |
|
sites_total_area | All sites - Surface area of pSCIs, SCIs, SACs Corresponding field in the report format: Gen.3.1b |
|
sac_total_number | All sites - Number of SACs Corresponding field in the report format: Gen.3.1c |
|
sac_total_area | All sites - Surface area of SACs Corresponding field in the report format: Gen.3.1d |
|
sites_terrestrial_area | Terrestrial area of sites (excluding marine area) - Surface area of pSCIs, SCIs, SACs Corresponding field in the report format: Gen.3.2b |
|
sac_terrestrial_area | Terrestrial area of sites (excluding marine area) - Surface area of SACs Corresponding field in the report format: Gen.3.2d |
|
sites_marine_number | Marine sites - Number of pSCIs, SCIs, SACs Corresponding field in the report format: Gen.3.3a |
|
sites_marine_area | Marine sites - Surface area of pSCIs, SCIs, SACs Corresponding field in the report format: Gen.3.3b |
|
sac_marine_number | Marine sites - Number of SACs Corresponding field in the report format: Gen.3.3c |
|
sac_marine_area | Marine sites - Surface area of SACs Corresponding field in the report format: Gen.3.3d |
|
database_date | Date of database used Corresponding field in the report format: Gen.3.4 |
|
measures_applied_number | Number of SACs Corresponding field in the report format: Gen.4.1a |
|
measures_applied_perc | Proportion (% area) of the SACs network Corresponding field in the report format: Gen.4.1b |
|
measures_setout_number | Number SACs Corresponding field in the report format: Gen.4.2a |
|
measures_setout_perc | Proportion (% area) of the SAC network Corresponding field in the report format: Gen.4.2b |
|
coherence_measures | Measures taken to ensure coherence of the Natura 2000 Network (Art. 10) Corresponding field in the report format: Gen.6. |
Article 17 reintroduction of species (data_greintroduction_of_species)
Information on reintroduction of Annex IV species per Member State…
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code Corresponding field in the report format: Gen.0. |
Look-up table [ref_countries] |
speciescode | Species code Corresponding field in the report format: Gen.7.1 |
|
speciesname | Species scientific name Corresponding field in the report format: Gen.7.2 |
|
reintro_alternative_speciesname | Alternative species scientific name Corresponding field in the report format: Gen.7.3 |
|
reintro_common_speciesname | Common name Corresponding field in the report format: Gen.7.4 |
|
reintro_period | Reintroduction period Corresponding field in the report format: Gen.7.5 |
|
location_number | Reintroduction location and number of individuals reintroduced - a) Location and b) number of individuals Corresponding field in the report format: Gen.7.6 |
|
successful | Is the reintroduction successful? Corresponding field in the report format: Gen.7.7 |
Look-up table [ref_yesNoTooEarly] |
additional_info | Additional information on the reintroduction Corresponding field in the report format: Gen.7.8 |
Article 17 measures taken from Member States (data_gmeasures)
Information on Measures taken in relation to approval of plans and projects
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code Corresponding field in the report format: Gen.0. |
Look-up table [ref_countries] |
sitecode | Site code Corresponding field in the report format: Gen.5.1 |
|
sitename | Site name Corresponding field in the report format: Gen.5.2 |
|
project_title | Title of project/plan Corresponding field in the report format: Gen.5.3 |
|
commission_informed_year | Year Commission was informed of compensatory measures Corresponding field in the report format: Gen.5.4 |
|
project_year | Year project/plan was started Corresponding field in the report format: Gen.5.5 |
|
commission_opinion | Commission opinion requested? Corresponding field in the report format: Gen.5.6 |
0: false; -1: true |
project_impact | Impact of projects requiring compensatory measures on conservation status Corresponding field in the report format: Gen.5.7 |
Article 17 habitats check list (habitats_check_list)
Occurrence of the habitat in biogeographical region in Member State
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code | Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat occurs | Look-up table [ref_bioGeoReg] |
habitatcode | Habitat code from the Habitats Directive. | |
habitatname | Description from the Habitats Directive. | |
priority | Flag to indicate whether or not it is a priority habitat type as listed in the annex of the Habitats Directive: 'Y' means yes, 'N' means no. | |
presence | Look-up table [ref_presence_status_habitats] | |
group | Habitat classification from the Habitats Directive. |
Article 17 species check list (species_check_list)
Occurrence of the habitat in biogeographical region in Member State
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code | Look-up table [ref_countries] |
region | Biogeographical or marine region where the species occurs | Look-up table [ref_bioGeoReg] |
speciescode | ||
speciesname | Name of the species reported by Member State. | |
assessment_speciescode | Species code corresponding to the assessment_speciesname | |
assessment_speciesname | Name of the species used for the European assessment | |
presence | Look-up table [ref_presence_status_species] | |
priority | Flag to indicate whether or not this species is listed as a priority species in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. | |
annexII | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. | |
annexIV | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. | |
annexV | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. | |
group | Taxonomical group from the Habitats Directive. |
Article 17 main results on habitats from Member States (data_habitats_regions)
Report format on the 'main results of the surveillance under Article 11' for Annex I habitat types
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code Corresponding field in the report format: Hab.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat occurs Corresponding field in the report format: Hab.3.1 |
Look-up table [ref_bioGeoReg] |
habitatcode | Habitat code Corresponding field in the report format: Hab.1.2 |
|
distribution_date | Year or period Corresponding field in the report format: Hab.2.1 |
|
distribution_map | Distribution map Corresponding field in the report format: Hab.2.2 |
0: false; -1: true |
distribution_grid_area | Area from the EU distribution map. | |
distribution_method | Distribution map Method used. The method is assessed at the MS level and is not relevant at the biogeographical level. Corresponding field in the report format: Hab.2.3 |
Look-up table [ref_methodsUsed] |
additional_distribution_map | Additional maps Corresponding field in the report format: Hab.2.4 |
0: false; -1: true |
published | Sources of information Corresponding field in the report format: Hab.3.2 |
|
range_surface_area | Surface area Corresponding field in the report format: Hab.4.1 |
|
range_trend_period | Short-term trend Period Corresponding field in the report format: Hab.4.2 |
|
range_trend | Short-term trend Direction Corresponding field in the report format: Hab.4.3 |
Look-up table [ref_trends] |
range_trend_magnitude_min | Short-term trend Magnitude - Minimum Corresponding field in the report format: Hab.4.4a |
|
range_trend_magnitude_max | Short-term trend Magnitude - Maximum Corresponding field in the report format: Hab.4.4b |
|
range_trend_method | Short-term trend Method used Corresponding field in the report format: Hab.4.5 |
Look-up table [ref_methodsUsed] |
range_trend_long_period | Long-term trend Period Corresponding field in the report format: Hab.4.6 |
|
range_trend_long | Long-term trend Direction Corresponding field in the report format: Hab.4.7 |
Look-up table [ref_trends] |
range_trend_long_magnitude_min | Long-term trend Magnitude - Minimum Corresponding field in the report format: Hab.4.8a |
|
range_trend_long_magnitude_max | Long-term trend Magnitude - Maximum Corresponding field in the report format: Hab.4.8b |
|
range_trend_long_method | long-term trend Method used Corresponding field in the report format: Hab.4.9 |
Look-up table [ref_methodsUsed] |
complementary_favourable_range | Favourable reference range - In km² Corresponding field in the report format: Hab.4.10a |
|
complementary_favourable_range_q | Favourable reference range - Indicate if operators were used (using symbols ≈, >, >>) or is unknown, indicate by using ‘x’ Corresponding field in the report format: Hab.4.10b,c |
Look-up table [ref_favourableOperator] |
complementary_favourable_range_method | Favourable reference range - Indicate method used to set reference value if other than operators Corresponding field in the report format: Hab.4.10d |
|
range_info | Additional information Corresponding field in the report format: Hab.4.12 |
|
coverage_date | Year or period Corresponding field in the report format: Hab.5.1 |
|
coverage_surface_area_min | Surface area - Minimum Corresponding field in the report format: Hab.5.2a |
|
coverage_surface_area_max | Surface area - Maximum Corresponding field in the report format: Hab.5.2b |
|
coverage_surface_area | Surface area - Best single value Corresponding field in the report format: Hab.5.2c |
|
coverage_estimate_type | Type of estimate Corresponding field in the report format: Hab.5.3 |
Look-up table [ref_typeEstimate] |
coverage_method | Surface area Method used Corresponding field in the report format: Hab.5.4 |
Look-up table [ref_methodsUsed] |
coverage_trend_period | Short-term trend Period Corresponding field in the report format: Hab.5.5 |
|
coverage_trend | Short-term trend Direction Corresponding field in the report format: Hab.5.6 |
Look-up table [ref_trends] |
coverage_trend_magnitude_min | Short-term trend Magnitude - Minimum Corresponding field in the report format: Hab.5.7a |
|
coverage_trend_magnitude_max | Short-term trend Magnitude - Maximum Corresponding field in the report format: Hab.5.7b |
|
coverage_trend_magnitude_ci | Short-term trend Magnitude - Confidence interval Corresponding field in the report format: Hab.5.7c |
|
coverage_trend_method | Short-term trend Method used Corresponding field in the report format: Hab.5.8 |
Look-up table [ref_methodsUsed] |
coverage_trend_long_period | Long-term trend Period Corresponding field in the report format: Hab.5.9 |
|
coverage_trend_long | Long-term trend Direction Corresponding field in the report format: Hab.5.10 |
Look-up table [ref_trends] |
coverage_trend_long_magnitude_min | Long-term trend Magnitude - Minimum Corresponding field in the report format: Hab.5.11a |
|
coverage_trend_long_magnitude_max | Long-term trend Magnitude - Maximum Corresponding field in the report format: Hab.5.11b |
|
coverage_trend_long_magnitude_ci | Long-term trend Magnitude - Confidence interval Corresponding field in the report format: Hab.5.11c |
|
coverage_trend_long_method | Long-term trend Method used Corresponding field in the report format: Hab.5.12 |
Look-up table [ref_methodsUsed] |
complementary_favourable_area | Favourable reference area - In km² Corresponding field in the report format: Hab.5.13a |
|
complementary_favourable_area_q | Favourable reference area - Indicate if operators were used (≈, >, >> ) or is unknown indicate by using ‘x’ Corresponding field in the report format: Hab.5.13b,c |
Look-up table [ref_favourableOperator] |
complementary_favourable_area_method | Favourable reference area - Indicate method used to set reference value if other than operators Corresponding field in the report format: Hab.5.13d |
|
coverage_info | Additional information Corresponding field in the report format: Hab.5.15 |
|
hab_condition_good_min | Habitat condition - Area in good condition - Minimum in km2 Corresponding field in the report format: Hab.6.1a1 |
|
hab_condition_good_max | Habitat condition - Area in good condition - Maximum in km2 Corresponding field in the report format: Hab.6.1a2 |
|
hab_condition_good | Average of min/max reported values. | |
hab_condition_notgood_min | Habitat condition - Area in not-good condition - Minimum in km2 Corresponding field in the report format: Hab.6.1b1 |
|
hab_condition_notgood_max | Habitat condition - Area in not-good condition - Maximum in km2 Corresponding field in the report format: Hab.6.1b2 |
|
hab_condition_notgood | Average of min/max reported values. | |
hab_condition_unknown_min | Habitat condition - Area where condition is not known - Minimum in km2 Corresponding field in the report format: Hab.6.1c1 |
|
hab_condition_unknown_max | Habitat condition - Area where condition is not known - Maximum in km2 Corresponding field in the report format: Hab.6.1c2 |
|
hab_condition_unknown | Average of min/max reported values. | |
hab_condition_method | Condition of habitat Method used Corresponding field in the report format: Hab.6.2 |
Look-up table [ref_methodsUsed] |
hab_condition_period | Short-term trend of habitat area in good condition Period Corresponding field in the report format: Hab.6.3 |
|
hab_condition_trend | Short-term trend of habitat area in good condition Direction Corresponding field in the report format: Hab.6.4 |
Look-up table [ref_trends] |
hab_condition_trend_method | Short-term trend of habitat area in good condition Method used Corresponding field in the report format: Hab.6.5 |
Look-up table [ref_methodsUsed] |
typical_species_change | Typical species - Has the list of typical species changed in comparison to the previous reporting period Corresponding field in the report format: Hab.6.6a |
|
typical_species_method | Typical species Method used Corresponding field in the report format: Hab.6.7 |
|
hab_condition_info | Additional information Corresponding field in the report format: Hab.6.8 |
|
future_range | Future prospects - Range Corresponding field in the report format: Hab.9.1a |
|
future_area | Future prospects - Area Corresponding field in the report format: Hab.9.1b |
|
future_structure | Future prospects - Structure and functions Corresponding field in the report format: Hab.9.1c |
|
future_info | Additional information Corresponding field in the report format: Hab.9.2 |
|
conclusion_range | Conclusions - Range Corresponding field in the report format: Hab.10.1 |
Look-up table [ref_assessments] |
conclusion_area | Conclusions - Area Corresponding field in the report format: Hab.10.2 |
Look-up table [ref_assessments] |
conclusion_structure | Conclusions - Specific structure and functions (incl. typical species) Corresponding field in the report format: Hab.10.3 |
Look-up table [ref_assessments] |
conclusion_future | Conclusions - Future prospects Corresponding field in the report format: Hab.10.4 |
Look-up table [ref_assessments] |
conclusion_assessment | Conclusions - Overall assessment of Conservation Status Corresponding field in the report format: Hab.10.5 |
Look-up table [ref_assessments] |
conclusion_assessment_trend | Conclusions - Overall trend in Conservation Status Corresponding field in the report format: Hab.10.6 |
Look-up table [ref_trendsConclusion] |
main_reason_status_etc | Reasonf for change based on infomration from fields [conclusion_assessment_trend], [conclusion_assessment_trend_prev] and [report_field], [no_change] and [main_reason] in [data_changes] table | Look-up table [ref_reasonChange] and select 'MS only' in field permission |
main_reason_trend_etc | Reasonf for change based on infomration from fields [conclusion_assessment], [conclusion_assessment_prev] and [report_field], [no_change] and [main_reason] in [data_changes] table | Look-up table [ref_reasonChange] and select 'MS only' in field permission |
conclusion_assessment_prev | Assessment of conservation status from the previous reporting cycle 2007-2012. | Look-up table [ref_assessments] |
conclusion_assessment_trend_prev | Trend in conservation status from the previous reporting cycle 2007-2012. | Look-up table [ref_trendsConclusion] |
conclusion_info | Additional information Corresponding field in the report format: Hab.10.8 |
|
natura2000_area_min | Surface area of the habitat type inside the pSCIs, SCIs and SACs network - Minimum Corresponding field in the report format: Hab.11.1a |
|
natura2000_area_max | Surface area of the habitat type inside the pSCIs, SCIs and SACs network - Maximum Corresponding field in the report format: Hab.11.1b |
|
natura2000_area | Surface area of the habitat type inside the pSCIs, SCIs and SACs network - Best single value Corresponding field in the report format: Hab.11.1c |
|
natura2000_area_estimate_type | Type of estimate Corresponding field in the report format: Hab.11.2 |
Look-up table [ref_typeEstimate] |
natura2000_area_method | Surface area of the habitat type inside the network Method used Corresponding field in the report format: Hab.11.3 |
Look-up table [ref_methodsUsed] |
natura2000_area_trend | Short-term trend of habitat area in good condition within the network Direction Corresponding field in the report format: Hab.11.4 |
Look-up table [ref_trends] |
natura2000_area_trend_method | Short-term trend of habitat area in good condition within network Method used Corresponding field in the report format: Hab.11.5 |
Look-up table [ref_methodsUsed] |
natura2000_info | Additional information Corresponding field in the report format: Hab.11.6 |
|
justification | Justification of % thresholds for trends Corresponding field in the report format: Hab.12.1 |
|
other_relevant_info | Other relevant information Corresponding field in the report format: Hab.12.2 |
|
use_for_statistics | based on the presence information in the habitat_check_list | 0: false; -1: true, |
coverage_etc | Best value, if reported, or average of min/max reported values. | |
natura2000_area_etc | Best value, if reported, or average of min/max reported values. | |
natura2000_coverage_etc | Proportion between coverage_etc and natura2000_area_etc |
Article 17 main results on species from Member States (data_species_regions)
Report format on the 'main results of the surveillance under Article 11' for Annex II, IV and V species, main table
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code Corresponding field in the report format: Spec.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the species occurs Corresponding field in the report format: Spec.4.1 |
Look-up table [ref_bioGeoReg] |
speciescode | Species code Corresponding field in the report format: Spec.1.2 |
|
speciesname | Species scientific name Corresponding field in the report format: Spec.1.3 |
|
alternative_speciesname | Alternative species scientific name Corresponding field in the report format: Spec.1.4 |
|
common_speciesname | Common name Corresponding field in the report format: Spec.1.5 |
|
sensitive_species | Sensitive species Corresponding field in the report format: Spec.2.1 |
0: false; -1: true |
distribution_date | Year or period Corresponding field in the report format: Spec.2.2 |
|
distribution_map | Distribution map Corresponding field in the report format: Spec.2.3 |
0: false; -1: true |
distribution_grid_area | Area from the EU distribution map. | |
distribution_method | Distribution map Method used. The method is assessed at the MS level and is not relevant at the biogeographical level. Corresponding field in the report format: Spec.2.4 |
Look-up table [ref_methodsUsed] |
additional_distribution_map | Additional maps Corresponding field in the report format: Spec.2.5 |
0: false; -1: true |
published | Sources of information Corresponding field in the report format: Spec.4.2 |
|
range_surface_area | Surface area Corresponding field in the report format: Spec.5.1 |
|
range_trend_period | Short-term trend Period Corresponding field in the report format: Spec.5.2 |
|
range_trend | Short-term trend Direction Corresponding field in the report format: Spec.5.3 |
Look-up table [ref_trends] |
range_trend_magnitude_min | Short-term trend Magnitude - Minimum Corresponding field in the report format: Spec.5.4a |
|
range_trend_magnitude_max | Short-term trend Magnitude - Maximum Corresponding field in the report format: Spec.5.4b |
|
range_trend_method | Short-term trend Method used Corresponding field in the report format: Spec.5.5 |
Look-up table [ref_methodsUsed] |
range_trend_long_period | Long-term trend Period Corresponding field in the report format: Spec.5.6 |
|
range_trend_long | Long-term trend Direction Corresponding field in the report format: Spec.5.7 |
Look-up table [ref_trends] |
range_trend_long_magnitude_min | Long-term trend Magnitude - Minimum Corresponding field in the report format: Spec.5.8a |
|
range_trend_long_magnitude_max | Long-term trend Magnitude - Maximum Corresponding field in the report format: Spec.5.8b |
|
range_trend_long_method | Long-term trend Method used Corresponding field in the report format: Spec.5.9 |
Look-up table [ref_methodsUsed] |
complementary_favourable_range | Favourable reference range - In km² Corresponding field in the report format: Spec.5.10a |
|
complementary_favourable_range_q | Favourable reference range - Indicate if operators were used (using symbols ≈, >, >>) or is unknown, indicate by using ‘x’ Corresponding field in the report format: Spec.5.10b,c |
Look-up table [ref_favourableOperator] |
complementary_favourable_range_method | Favourable reference range - Indicate method used to set reference value if other than operators Corresponding field in the report format: Spec.5.10d |
|
range_info | Additional information Corresponding field in the report format: Spec.5.12 |
|
population_date | Year or period Corresponding field in the report format: Spec.6.1 |
|
population_size_unit | Population size - Unit Corresponding field in the report format: Spec.6.2a |
Look-up table [ref_populationUnits] |
population_size_min | Population size - Minimum Corresponding field in the report format: Spec.6.2b |
|
population_size_max | Population size - Maximum Corresponding field in the report format: Spec.6.2c |
|
population_size | Population size - Best single value Corresponding field in the report format: Spec.6.2d |
|
population_estimate_type | Type of estimate Corresponding field in the report format: Spec.6.3 |
Look-up table [ref_typeEstimate] |
population_alt_size_unit | Additional population size - Unit Corresponding field in the report format: Spec.6.4a |
Look-up table [ref_populationUnits] |
population_alt_size_min | Additional population size - Minimum Corresponding field in the report format: Spec.6.4b |
|
population_alt_size_max | Additional population size - Maximum Corresponding field in the report format: Spec.6.4c |
|
population_alt_size | Additional population size - Best single value Corresponding field in the report format: Spec.6.4d |
|
population_alt_estimate_type | Type of estimate Corresponding field in the report format: Spec.6.5 |
Look-up table [ref_typeEstimate] |
population_method | Population size Method used Corresponding field in the report format: Spec.6.6 |
Look-up table [ref_methodsUsed] |
population_trend_period | Short-term trend Period Corresponding field in the report format: Spec.6.7 |
|
population_trend | Short-term trend Direction Corresponding field in the report format: Spec.6.8 |
Look-up table [ref_trends] |
population_trend_magnitude_min | Short-term trend Magnitude - Minimum Corresponding field in the report format: Spec.6.9a |
|
population_trend_magnitude_max | Short-term trend Magnitude - Maximum Corresponding field in the report format: Spec.6.9b |
|
population_trend_magnitude_ci | Short-term trend Magnitude - Confidence interval Corresponding field in the report format: Spec.6.9c |
|
population_trend_method | Short-term trend Method used Corresponding field in the report format: Spec.6.10 |
Look-up table [ref_methodsUsed] |
population_trend_long_period | Long-term trend Period Corresponding field in the report format: Spec.6.11 |
|
population_trend_long | Long-term trend Direction Corresponding field in the report format: Spec.6.12 |
Look-up table [ref_trends] |
population_trend_long_magnitude_min | Long-term trend Magnitude - Minimum Corresponding field in the report format: Spec.6.13a |
|
population_trend_long_magnitude_max | Long-term trend Magnitude - Maximum Corresponding field in the report format: Spec.6.13b |
|
population_trend_long_magnitude_ci | Long-term trend Magnitude - Confidence interval Corresponding field in the report format: Spec.6.13c |
|
population_trend_long_method | Long-term trend Method used Corresponding field in the report format: Spec.6.14 |
Look-up table [ref_methodsUsed] |
complementary_favourable_population_unit | Favourable reference population - Population size unit Corresponding field in the report format: Spec.6.15a2 |
Look-up table [ref_populationUnits] |
complementary_favourable_population | Favourable reference population - Population size Corresponding field in the report format: Spec.6.15a1 |
|
complementary_favourable_population_q | Favourable reference population - Indicate if operators were used or is unknown, indicate by using ‘x’ Corresponding field in the report format: Spec.6.15b,c |
Look-up table [ref_favourableOperator] |
complementary_favourable_population_method | Favourable reference population - Indicate method used to set reference value if other than operators Corresponding field in the report format: Spec.6.15d |
|
population_info | Additional information Corresponding field in the report format: Spec.6.17 |
|
habitat_sufficiency_occupied | Sufficiency of area and quality of occupied habitat - Are area and quality of occupied habitat sufficient (for long-term survival)? Corresponding field in the report format: Spec.7.1a |
Look-up table [ref_yesNoUnknown] |
habitat_sufficiency_unoccupied | Sufficiency of area and quality of occupied habitat - If NO, is there a sufficiently large area of unoccupied habitat of suitable quality (for long-term survival)? Corresponding field in the report format: Spec.7.1b |
Look-up table [ref_yesNoUnknown] |
habitat_sufficiency_method | Sufficiency of area and quality of occupied habitat Method used Corresponding field in the report format: Spec.7.2 |
Look-up table [ref_methodsUsed] |
habitat_trend_period | Short-term trend Period Corresponding field in the report format: Spec.7.3 |
|
habitat_trend | Short-term trend Direction Corresponding field in the report format: Spec.7.4 |
Look-up table [ref_trends] |
habitat_trend_method | Short-term trend Method used Corresponding field in the report format: Spec.7.5 |
Look-up table [ref_methodsUsed] |
habitat_trend_long_period | Long-term trend Period Corresponding field in the report format: Spec.7.6 |
|
habitat_trend_long | Long-term trend Direction Corresponding field in the report format: Spec.7.7 |
Look-up table [ref_trends] |
habitat_trend_long_method | Long-term trend Method used Corresponding field in the report format: Spec.7.8 |
Look-up table [ref_methodsUsed] |
habitat_info | Additional information Corresponding field in the report format: Spec.7.9 |
|
future_range | Future prospects - Range Corresponding field in the report format: Spec.10.1a |
|
future_population | Future prospects - Population Corresponding field in the report format: Spec.10.1b |
|
future_habitat | Future prospects - Habitat of the species Corresponding field in the report format: Spec.10.1c |
|
future_info | Additional information Corresponding field in the report format: Spec.10.2 |
|
conclusion_range | Conclusions - Range Corresponding field in the report format: Spec.11.1 |
Look-up table [ref_assessments] |
conclusion_population | Conclusions - Population Corresponding field in the report format: Spec.11.2 |
Look-up table [ref_assessments] |
conclusion_habitat | Conclusions - Habitat for the species Corresponding field in the report format: Spec.11.3 |
Look-up table [ref_assessments] |
conclusion_future | Conclusions - Future prospects Corresponding field in the report format: Spec.11.4 |
Look-up table [ref_assessments] |
conclusion_assessment | Conclusions - Overall assessment of Conservation Status Corresponding field in the report format: Spec.11.5 |
Look-up table [ref_assessments] |
conclusion_assessment_trend | Conclusions - Overall trend in Conservation Status Corresponding field in the report format: Spec.11.6 |
Look-up table [ref_trendsConclusion] |
main_reason_status_etc | Reasonf for change based on infomration from fields [conclusion_assessment_trend], [conclusion_assessment_trend_prev] and [report_field], [no_change] and [main_reason] in [data_changes] table | Look-up table [ref_reasonChange] and select 'MS only' in field permission |
main_reason_trend_etc | Reasonf for change based on infomration from fields [conclusion_assessment], [conclusion_assessment_prev] and [report_field], [no_change] and [main_reason] in [data_changes] table | Look-up table [ref_reasonChange] and select 'MS only' in field permission |
conclusion_assessment_prev | Assessment of conservation status from the previous reporting cycle 2007-2012. | Look-up table [ref_assessments] |
conclusion_assessment_trend_prev | Trend in conservation status from the previous reporting cycle 2007-2012. | Look-up table [ref_trendsConclusion] |
conclusion_info | Additional information Corresponding field in the report format: Spec.11.8 |
|
natura2000_population_unit | Population size - Unit Corresponding field in the report format: Spec.12.1a |
Look-up table [ref_populationUnits] |
natura2000_population_min | Population size - Minimum Corresponding field in the report format: Spec.12.1b |
|
natura2000_population_max | Population size - Maximum Corresponding field in the report format: Spec.12.1c |
|
natura2000_population | Population size - Best estimate Corresponding field in the report format: Spec.12.1d |
|
natura2000_population_estimate_type | Type of estimate Corresponding field in the report format: Spec.12.2 |
Look-up table [ref_typeEstimate] |
natura2000_population_method | Population size inside the network Method used Corresponding field in the report format: Spec.12.3 |
Look-up table [ref_methodsUsed] |
natura2000_population_trend | Short-term trend of population size within the network - direction Corresponding field in the report format: Spec.12.4 |
Look-up table [ref_trends] |
natura2000_population_trend_method | Short-term trend of population size within the network Method used Corresponding field in the report format: Spec.12.5 |
Look-up table [ref_methodsUsed] |
natura2000_info | Additional information Corresponding field in the report format: Spec.12.6 |
|
justification | Justification of % thresholds for trends Corresponding field in the report format: Spec.13.1 |
|
transboundary_assessment | Trans-boundary assessment Corresponding field in the report format: Spec.13.2 |
|
other_relevant_info | Other relevant information Corresponding field in the report format: Spec.13.3 |
|
use_for_statistics | based on the presence information in the species_check_list | 0: false; -1: true, |
popsize_etc | Best value, if reported, or average of min/max reported values. | |
natura2000_popsize_etc | Best value, if reported, or average of min/max reported values. | |
natura2000_coverage_etc | Proportion between popsize_etc and natura2000_popsize_etc |
Article 17 exploitation of Annex V species (data_species_annexV)
Information related to exploitation of Annex V species (Art. 14)
Field name | Definition | Note |
---|---|---|
country | Member State - two-digit code Corresponding field in the report format: Spec.1.1 |
Look-up table [ref_countries] |
speciescode | Species code Corresponding field in the report format: Spec.1.2 |
|
speciesname | Species scientific name Corresponding field in the report format: Spec.1.3 |
|
group | Taxonomical group from the Habitats Directive. | |
AnnexV | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. | |
wild_takings | Is the species taken in the wild/exploited? Corresponding field in the report format: Spec.3.1 |
0: false; -1: true |
measures_access | Which of the measures in Art. 14 have been taken? - a) regulations regarding access to property Corresponding field in the report format: Spec.3.2a |
0: false; -1: true |
measures_prohibitions | Which of the measures in Art. 14 have been taken? - b) temporary or local prohibition of the taking of specimens in the wild and exploitation Corresponding field in the report format: Spec.3.2b |
0: false; -1: true |
measures_periods | Which of the measures in Art. 14 have been taken? - c) regulation of the periods and/or methods of taking specimens Corresponding field in the report format: Spec.3.2c |
0: false; -1: true |
measures_rules | Which of the measures in Art. 14 have been taken? - d) application of hunting and fishing rules which take account of the conservation of such populations Corresponding field in the report format: Spec.3.2d |
0: false; -1: true |
measures_licences | Which of the measures in Art. 14 have been taken? - e) establishment of a system of licences for taking specimens or of quotas Corresponding field in the report format: Spec.3.2e |
0: false; -1: true |
measures_trading_legislation | Which of the measures in Art. 14 have been taken? - f) regulation of the purchase, sale, offering for sale, keeping for sale or transport for sale of specimens Corresponding field in the report format: Spec.3.2f |
0: false; -1: true |
measures_conservation_propagation | Which of the measures in Art. 14 have been taken? - g) breeding in captivity of animal species as well as artificial propagation of plant species Corresponding field in the report format: Spec.3.2g |
0: false; -1: true |
measures_other | Which of the measures in Art. 14 have been taken? - h) other yes/no Corresponding field in the report format: Spec.3.2h1 |
0: false; -1: true |
measures_other_info | Which of the measures in Art. 14 have been taken? - other yes description Corresponding field in the report format: Spec.3.2h2 |
|
huntingbag_unit | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Unit Corresponding field in the report format: Spec.3.3a |
Look-up table [ref_populationUnits] |
huntingbag_y1_min | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 1 min Corresponding field in the report format: Spec.3.3b1min |
|
huntingbag_y1_max | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 1 max Corresponding field in the report format: Spec.3.3b1max |
|
huntingbag_y1_unknown | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 1 unknown Corresponding field in the report format: Spec.3.3b1x |
0: false; -1: true |
huntingbag_y2_min | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 2 min Corresponding field in the report format: Spec.3.3b2min |
|
huntingbag_y2_max | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 2 max Corresponding field in the report format: Spec.3.3b2max |
|
huntingbag_y2_unknown | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 2 unknown Corresponding field in the report format: Spec.3.3b2x |
0: false; -1: true |
huntingbag_y3_min | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 3 min Corresponding field in the report format: Spec.3.3b3min |
|
huntingbag_y3_max | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 3 max Corresponding field in the report format: Spec.3.3b3max |
|
huntingbag_y3_unknown | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 3 unknown Corresponding field in the report format: Spec.3.3b3x |
0: false; -1: true |
huntingbag_y4_min | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 4 min Corresponding field in the report format: Spec.3.3b4min |
|
huntingbag_y4_max | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 4 max Corresponding field in the report format: Spec.3.3b4max |
|
huntingbag_y4_unknown | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 4 unknown Corresponding field in the report format: Spec.3.3b4x |
0: false; -1: true |
huntingbag_y5_min | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 5 min Corresponding field in the report format: Spec.3.3b5min |
|
huntingbag_y5_max | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 5 max Corresponding field in the report format: Spec.3.3b5max |
|
huntingbag_y5_unknown | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 5 unknown Corresponding field in the report format: Spec.3.3b5x |
0: false; -1: true |
huntingbag_y6_min | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 6 min Corresponding field in the report format: Spec.3.3b6min |
|
huntingbag_y6_max | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 6 max Corresponding field in the report format: Spec.3.3b6max |
|
huntingbag_y6_unknown | Hunting bag or quantity taken in the wild for Mammals and Acipenseridae (Fish) - Statistics/quantity per hunting season or year over the reporting period - Season/year 6 unknown Corresponding field in the report format: Spec.3.3b6x |
0: false; -1: true |
huntingbag_method | Hunting bag or quantity taken in the wild Method used Corresponding field in the report format: Spec.3.4 |
Look-up table [ref_methodsUsed] |
annexV_info | Additional information Corresponding field in the report format: Spec.3.5 |
Article 17 change and reason for change between reporting periods (data_change)
Change and reason for change between reporting periods for overall assessment of conservation status, overall trend in conservation status and values reported for habitats and species parameters
Field name | Definition | Note |
---|---|---|
featuretype | Type of feature : 'habitats' or 'species'. | |
country | Member State - two-digit code Corresponding field in the report format: Hab.1.1/Spec.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat or species occurs Corresponding field in the report format: Hab.3.1/Spec.4.1 |
Look-up table [ref_bioGeoReg] |
featurecode | Habitat or species code Corresponding field in the report format: Hab.1.2/Spec.1.2 |
|
featurename | Habitat description or species scientific name Corresponding field in the report format: Spec.1.3 |
|
report_field | [Habitats] Change and reason for change in surface area of range/in area covered by the habitat type/in conservation status and conservation status trend; [Species] Change and reason for change in surface area of range/in population size/in conservation status and conservation status trend Corresponding field in the report format: Hab.4.11/Hab.5.14/Hab.10.7/Spec.5.11/Spec.6.16/Spec.11.7 |
Values in the field [report_field]: [Habitats] surface area of range: habitatrange/area covered by the habitat type: habitatarea/in conservation status: habitatstatus/in conservation status trend: habitattrend; [Species] surface area of range: speciesrange/in population size: speciespopulation/in conservation status: speciesstatus/in conservation status trend: speciestrend. |
no_change | Is there a change between reporting periods? No, there is no change Corresponding field in the report format: Hab.4.11_/Hab.5.14_/Hab.10.7aa/Hab.10.7ba/Spec.5.11_/Spec.6.16_/Spec.11.7aa/Spec.11.7ba |
0: false; -1: true - True means there is no change between reporting periods. |
genuine | Is there a change between reporting periods? a) yes, due to genuine change Corresponding field in the report format: Hab.4.11a/Hab.5.14a/Hab.10.7ab/Hab.10.7bb/Spec.5.11a/Spec.6.16a/Spec.11.7ab/Spec.11.7bb |
0: false; -1: true |
knowledge | Is there a change between reporting periods? b) yes, due to improved knowledge/more accurate data Corresponding field in the report format: Hab.4.11b/Hab.5.14b/Hab.10.7ac/Hab.10.7bc/Spec.5.11b/Spec.6.16b/Spec.11.7ac/Spec.11.7bc |
0: false; -1: true |
method | Is there a change between reporting periods? c) yes, due to the use of different method Corresponding field in the report format: Hab.4.11c/Hab.5.14c/Hab.10.7ad/Hab.10.7bd/Spec.5.11c/Spec.6.16c/Spec.11.7ad/Spec.11.7bd |
0: false; -1: true |
no_info | Is there a change between reporting periods? d) yes, but there is no information on nature of change Corresponding field in the report format: Hab.4.11d/Hab.5.14d/Hab.10.7ae/Hab.10.7be/Spec.5.11d/Spec.6.16d/Spec.11.7ae/Spec.11.7be |
0: false; -1: true |
main_reason | Is there a change between reporting periods? yes, the change is mainly due to: Corresponding field in the report format: Hab.4.11e/Hab.5.14e/Hab.10.7af/Hab.10.7bf/Spec.5.11e/Spec.6.16e/Spec.11.7af/Spec.11.7bf |
Look-up table [ref_reasonChange] and select 'MS only' in field permission |
use_for_statistics | based on the presence information in the habitats_check_list and species_check_list | 0: false; -1: true |
Article 17 information related to main conservation measures (data_measures_info)
Information related to main conservation measures
Field name | Definition | Note |
---|---|---|
featuretype | Type of feature : 'habitats' or 'species'. | |
country | Member State - two-digit code Corresponding field in the report format: Hab.1.1/Spec.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat or species occurs Corresponding field in the report format: Hab.3.1/Spec.4.1 |
Look-up table [ref_bioGeoReg] |
featurecode | Habitat or species code Corresponding field in the report format: Hab.1.2/Spec.1.2 |
|
featurename | Habitat description or species scientific name Corresponding field in the report format: Spec.1.3 |
|
measures_needed | Status of measures - Are measures needed? Corresponding field in the report format: Hab.8.1a/Spec.9.1a |
0: false; -1: true |
measures_status | Status of measures - If yes, indicate the status of measures: Corresponding field in the report format: Hab.8.1b/Spec.9.1b |
Look-up table [ref_measures_identified] |
measures_purpose | Main purpose of the measures taken Corresponding field in the report format: Hab.8.2/Spec.9.2 |
Look-up table [ref_measures_purpose_habitats] and Look-up table [ref_measures_purpose_species] |
measures_location | Location of the measures Corresponding field in the report format: Hab.8.3/Spec.9.3 |
Look-up table [ref_measures_location] |
measures_response | Response to the measures Corresponding field in the report format: Hab.8.4/Spec.9.4 |
Look-up table [ref_measures_response] |
measures_info | Additional information Corresponding field in the report format: Hab.8.6/Spec.9.6 |
|
use_for_statistics | based on the presence information in the habitats_check_list and species_check_list | 0: false; -1: true |
Article 17 main measures taken (data_measures)
List of conservation measures taken for each habitat or species in Member States’ biogeographical regions
Field name | Definition | Note |
---|---|---|
featuretype | Type of feature : 'habitats' or 'species'. | |
country | Member State - two-digit code Corresponding field in the report format: Hab.1.1/Spec.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat or species occurs Corresponding field in the report format: Hab.3.1/Spec.4.1 |
Look-up table [ref_bioGeoReg] |
featurecode | Habitat or species code Corresponding field in the report format: Hab.1.2/Spec.1.2 |
|
featurename | Habitat description or species scientific name Corresponding field in the report format: Spec.1.3 |
|
measurecode | List of main conservation measures Corresponding field in the report format: Hab.8.5/Spec.9.5 |
Look-up table [ref_measures] |
use_for_statistics | based on the presence information in the habitats_check_list and species_check_list | 0: false; -1: true |
report_obligation | Indicates whether in this table information for a featurecode was mandatory or optional (mandatory for habitats and annex II species, optional for non annex II species). |
Article 17 information related to main pressures and threats (data_pressures_threats_info)
Information related to main pressures and threats
Field name | Definition | Note |
---|---|---|
featuretype | Type of feature : 'habitats' or 'species'. | |
country | Member State - two-digit code Corresponding field in the report format: Hab.1.1/Spec.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat or species occurs Corresponding field in the report format: Hab.3.1/Spec.4.1 |
Look-up table [ref_bioGeoReg] |
featurecode | Habitat or species code Corresponding field in the report format: Hab.1.2/Spec.1.2 |
|
featurename | Habitat description or species scientific name Corresponding field in the report format: Spec.1.3 |
|
pressures_info | Additional information Corresponding field in the report format: Hab.7.3/Spec.8.3 |
|
pressures_source | Sources of information Corresponding field in the report format: Hab.7.2/Spec.8.2 |
|
use_for_statistics | based on the presence information in the habitats_check_list and species_check_list | 0: false; -1: true |
Article 17 main pressures and threats (data_pressures_threats)
List of main pressures and threats for each habitat or species in Member States’ biogeographical regions
Field name | Definition | Note |
---|---|---|
featuretype | Type of feature : 'habitats' or 'species'. | |
country | Member State - two-digit code Corresponding field in the report format: Hab.1.1/Spec.1.1 |
Look-up table [ref_countries] |
region | Biogeographical or marine region where the habitat or species occurs Corresponding field in the report format: Hab.3.1/Spec.4.1 |
Look-up table [ref_bioGeoReg] |
featurecode | Habitat or species code Corresponding field in the report format: Hab.1.2/Spec.1.2 |
|
featurename | Habitat description or species scientific name Corresponding field in the report format: Spec.1.3 |
|
type | Pressure type Corresponding field in the report format: Hab.7.1c/Spec.8.1c |
p=pressures; t=threats |
ranking | Ranking of pressure/threat Corresponding field in the report format: Hab.7.1b/Spec.8.1b |
Look-up table [ref_ranking] |
pressurecode | Pressure / threat Corresponding field in the report format: Hab.7.1a/Spec.8.1a |
Look-up table [ref_threatsPressures] |
use_for_statistics | based on the presence information in the habitats_check_list and species_check_list | 0: false; -1: true |
Article 17 EU assessment of conservation status for habitats (habitatsEUassessment)
Assessments of conservation status at the EU biogeographical level for habitats
Field name | Definition | Note |
---|---|---|
country | Default value EU28. | |
region | Code of the biogeographical or marine region. | Look-up table [ref_bioGeoReg] |
habitatcode | Code of the habitat type Annex I Habitats Directive. | |
habitatname | Description from the Habitats Directive. | |
priority | Flag to indicate whether or not it is a priority habitat type as listed in the annex of the Habitats Directive: 'Y' means yes, 'N' means no. 'EXCP' indicates exception at the Member State level. | |
range_surface_area | Surface area of the range in km². | |
range_trend | Trend of the range. | Look-up table [ref_trends] |
complementary_favourable_range | Favourable reference range in km². | |
complementary_favourable_range_q | Favourable reference range operator. | Look-up table [ref_favourableOperator] |
coverage_surface_area | Area covered by habitat type in km² - Best single value. | |
coverage_surface_area_min | Area covered by habitat type in km² - Minimum. | |
coverage_surface_area_max | Area covered by habitat type in km² - Maximum. | |
coverage_trend | Trend of the habitat area. | Look-up table [ref_trends] |
complementary_favourable_area | Favourable reference area in km². | |
complementary_favourable_area_q | Favourable reference area operator. | Look-up table [ref_favourableOperator] |
method_range | Code of the method used to assess the range at the biogeographical level. | Look-up table [ref_assessments_method] |
conclusion_range | Conclusion - range. | Look-up table [ref_assessments] |
method_area | Code of the method used to assess the area of the habitat type at the biogeographical level. | Look-up table [ref_assessments_method] |
conclusion_area | Conclusion - area of the habitat type. | Look-up table [ref_assessments] |
method_structure | Code of the method used to assess the structures and functions at the biogeographical level. | Look-up table [ref_assessments_method] |
conclusion_structure | Conclusion - structures and functions. | Look-up table [ref_assessments] |
method_future | Code of the method used to assess the future prospects. | Look-up table [ref_assessments_method] |
conclusion_future | Conclusion - future prospects. | Look-up table [ref_assessments] |
method_assessment | Code of the method used to calculate the overall assessment. | Look-up table [ref_assessments_method] |
conclusion_assessment | Overall assessment from EU experts. | Look-up table [ref_assessments] |
conclusion_assessment_trend | Overall trend in conservation status from EU experts. | Look-up table [ref_trendsConclusion] |
conclusion_assessment_prev | Overall assessment from the previous reporting round 2007-2012 from EU experts.. | Look-up table [ref_assessments] |
conclusion_assessment_trend_prev | Overall trend in conservation status from the previous reporting round 2007-2012 from EU experts. | Look-up table [ref_trendsConclusion] |
conclusion_assessment_change | Coded values for the nature of change in the overall assessments between the previous and current reporting. | Look-up table [ref_reasonChange] and select 'EU only' in field permission |
conclusion_assessment_trend_change | Coded values for the nature of change in the overall trend in conservation status between the previous and current reporting. | Look-up table [ref_reasonChange] and select 'EU only' in field permission |
target1 | Contribution to Target 1 of the EU Biodiversity Strategy. | Look-up table [ref_target1] |
future_range | Good-poor-bad value for future prospects of parameter | |
future_area | Good-poor-bad value for future prospects of parameter | |
future_structure | Good-poor-bad value for future prospects of parameter | |
backcasted_2007 | Code for overall assessment of status for 2000-2006 period with backcasting | Look-up table [ref_assessments] |
hab_condition_trend | Trend of the habitat area in good condition. | Look-up table [ref_trends] |
hab_condition_good_best | Habitat area in good condition in km² - Best single value. | |
hab_condition_good_min | Habitat area in good condition in km² - Minimum. | |
hab_condition_good_max | Habitat area in good condition in km² - Maximum. | |
hab_condition_notgood_best | Habitat area not in good condition in km² - Best single value. | |
hab_condition_notgood_min | Habitat area not in good condition in km² - Minimum. | |
hab_condition_notgood_max | Habitat area not in good condition in km² - Maximum. | |
hab_condition_unknown_best | Habitat area where condition is not known in km² - Best single value. | |
hab_condition_unknown_min | Habitat area where condition is not known in km² - Minimum. | |
hab_condition_unknown_max | Habitat area where condition is not known in km² - Maximum. | |
use_for_statistics | based on the presence information in the habitats_check_list. Is 0: false if habitat has no regular occurrence in any of MS within a biogeographical region. | 0: false; -1: true |
Article 17 EU assessment of conservation status for species (speciesEUassessment)
Assessments of conservation status at the EU biogeographical level for species
Field name | Definition | Note |
---|---|---|
country | Default value EU28. | |
region | Code of the biogeographical or marine region. | Look-up table [ref_bioGeoReg] |
assessment_speciescode | Species code corresponding to the assessment_speciesname. | |
assessment_speciesname | Name of the species used for the European assessment. | |
priority | Flag to indicate whether or not this species is listed as a priority species in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. 'EXCP' indicates exception at the Member State level. | |
annexII | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. 'EXCP' indicates exception at the Member State level (meaning a species can be covered by annexes II, IV and V at the EU level) . | |
annexIV | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. 'EXCP' indicates exception at the Member State level (meaning a species can be covered by annexes II, IV and V at the EU level) . | |
annexV | Flag to indicate whether or not this species is listed in the annex of the Habitats Directive. 'N' means the species is not listed in this annex, 'Y' means the species is listed in this annex, 'Y-CTC' and 'Y-HTL' means the species is listed in this annex under a different name (split taxa or taxonomical update) or at a higher level. 'EXCP' indicates exception at the Member State level (meaning a species can be covered by annexes II, IV and V at the EU level) . | |
range_surface_area | Surface area of the range in km². | |
range_trend | Trend of the range. | Look-up table [ref_trends] |
complementary_favourable_range | Favourable reference range in km². | |
complementary_favourable_range_q | Favourable reference range operator. | Look-up table [ref_favourableOperator] |
population_unit | Units used for the population size. | Look-up table [ref_populationUnits] |
population_best_value | Size of the population - Best single value. | |
population_minimum_size | Size of the population - Minimum. | |
population_maximum_size | Size of the population - Maximum. | |
population_trend | Trend of the population. | Look-up table [ref_trends] |
complementary_favourable_population_unit | Favourable reference population unit. | Look-up table [ref_populationUnits] |
complementary_favourable_population | Favourable reference population. | |
complementary_favourable_population_q | Favourable reference population operator. | Look-up table [ref_favourableOperator] |
habitat_trend | Trend of the area of the habitat of species. | Look-up table [ref_trends] |
method_range | Code of the method used to assess the range at the biogeographical level. | Look-up table [ref_assessments_method] |
conclusion_range | Conclusion - range. | Look-up table [ref_assessments] |
method_population | Code of the method used to assess the population of the species at the biogeographical level. | Look-up table [ref_assessments_method] |
conclusion_population | Conclusion - population of the species. | Look-up table [ref_assessments] |
method_habitat | Code of the method used to assess the habitat of the species at the biogeographical level. | Look-up table [ref_assessments_method] |
conclusion_habitat | Conclusion - habitat of the species. | Look-up table [ref_assessments] |
method_future | Code of the method used to assess the future prospects. | Look-up table [ref_assessments_method] |
conclusion_future | Conclusion - future prospects. | Look-up table [ref_assessments] |
method_assessment | Code of the method used to calculate the overall assessment. | Look-up table [ref_assessments_method] |
conclusion_assessment | Overall assessment from EU experts. | Look-up table [ref_assessments] |
conclusion_assessment_trend | Overall trend in conservation status from EU experts. | Look-up table [ref_trendsConclusion] |
conclusion_assessment_prev | Overall assessment from the previous reporting round 2007-2012 from EU experts. | Look-up table [ref_assessments] |
conclusion_assessment_trend_prev | Overall trend in conservation status from the previous reporting round 2007-2012 from EU experts. | Look-up table [ref_trendsConclusion] |
conclusion_assessment_change | Coded values for the nature of change in the overall assessments between the previous and current reporting. | Look-up table [ref_reasonChange] and select 'EU only' in field permission |
conclusion_assessment_trend_change | Coded values for the nature of change in the overall trend in conservation status between the previous and current reporting. | Look-up table [ref_reasonChange] and select 'EU only' in field permission |
target1 | Contribution to Target 1 of the EU Biodiversity Strategy. | Look-up table [ref_target1] |
future_range | Good-poor-bad value for future prospects of parameter | |
future_population | Good-poor-bad value for future prospects of parameter | |
future_habitat | Good-poor-bad value for future prospects of parameter | |
backcasted_2007 | Code for overall assessment of status for 2000-2006 period with backcasting | Look-up table [ref_assessments] |
use_for_statistics | based on the presence information in the species_check_list. Is 0: false if species has no regular occurrence or extinct in any of MS within a biogeographical region. | 0: false; -1: true |
Article 17 general report (data_greport)
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-1/article-17-database-zipped-ms-access-format or scan the QR code.
PDF generated on 02 Dec 2024, 12:10 PM
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