Article 17 - 2020 dataset

Data Table

42 min read

The dataset contains tabular data as reported by Member States for the period 2013-2018; this includes habitat areas, population sizes, trends, pressures and threats, and conservation status at the national biogeographical level. In addition, it includes conservation status and trends in conservation status at the EU biogeographical level as assessed by the EEA and its ETC on Biological Diversity.

Data and maps

Menu

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