Article 17 dataset

Data Table

23 min read

This is an old version, kept for reference only.

Go to latest version

The dataset contains tabular data as reported by Member States for periods 2007-2012 and 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 2015

data_greport
data_gmeasures
data_greintroduction_of_species
data_habitats_check_list
data_habitats_regions_EU_level
data_habitats_regions_MS_level
data_species_check_list
data_species_regions_EU_level
data_species_regions_MS_level
data_htypical_species
data_pressures_threats
data_pressures_threats_pol
data_measures
habitats_maes
species_maes

Article 17 2020

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 2015

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)