AssessmentRegimeZone

AssessmentRegimeZone

Description

The purpose of the AssessmentRegimeZone table is to collect information about air quality zones and related assessment regimes. It specifies zone details such as (geographical) name, area, code, category, type, population as well as zone level parameters of assessment regimes such as objective, target, pollutant, reporting metric, assessment threshold and characteristics of exemptions (postponement, SPO reduction).

AssessmentRegimeZone table has to be reported at least every 5 years or whenever a new information or an update of existing information is available. Attributes which create unique identifier of each record: CountryCode and AssessmentRegimeId.

Updates of the AssessmentRegimeZone table will not be time stamped, i.e. each update generates the only version of the assessment regimes that is stored at the EEA:

  • either as addition of new record, understood as addition of new combination of values for the attributes creating unique identifier,

  • or modification of existing record, understood as modification of a value for any other attribute. Validity of the new record will be tested using QC (rules to be established) - e.g. cross checking against aggregation code list, existing records in Zone table, etc.

Valid modifications of existing record in this table are:

  • correction of PostponementYear or FixedMeasurementReduction or AssessmentThresholdExceedance,

  • minor corrections e.g. of ZoneName or ZoneNationalCode, ZoneResidentPopulation and ZoneResidentPopulationYear.

Validity of the modifications of existing record will be tested using QC (rules to be established). Allowed modifications may affect outcomes of compliance analysis and/or assessments, therefore re-submissions for past years, for which compliance reporting has been already done, will require additional tests vs reference/legacy data before official release of such data is granted.

Data products for public will present the records validated at the latest deadline. Data products for reporters will present the records as reported recently, highlighting the differences between validated reports and recent reports in case of re-submissions.

EEA extensions

AssessmentRegimeZone table will be extended by EEA by several attributes in the reference data flow:

  • Country (for convenience), based on ISO2 country codes,

  • Pollutant (for convenience), based on code list,

  • DataAggregationProcess, based on DataAggregationProcessId,

  • ReportingYear, based on the corresponding records in ComplianceAssessmentMethod,

  • Required number of sampling points, based on the recasted Air Quality Directive 2024/2881,

  • Reported number of sampling points and modelling applications, based on data reported in ComplianceAssessmentMethod table,

  • SR areas coverage,

  • Modelling results coverage,

  • Assessment regime zone exceedance status,

  • Exceedance extent coverage,

  • Reported number of measures.

Data management rules

It is recommended to report the AssessmentRegimeZone table only when a new classification is available (at least every 5 years).

If a NUTS region is used - the ZoneCategory should be reported as nuts and NUTS region id should be provided as ZoneId, geometry does not need to be reported. If a combination of NUTS regions is used, the area should be reported in the same way as a zone, i.e. ZoneCategory should be reported as aqzone, ZoneId should be assigned (following the rule for ZoneIds) and the zone geometry must be provided.

In case of reporting territorial units for AEI, the NUTS regions or combination of NUTS region may be used.

The new environmental objectives should be reported from the beginning of the new reporting in ReportNet3, to cover the needs for roadmaps.

Records in AssessmentRegimeZone table which do not have any correspondence to records in ComplianceAssessmentMethods table will be flagged for deletion in the reference data flow.

Attributes

Attribute Code

Attribute Name

SQL DB Data Type

ReportNet3 Data Type

Properties

Code list

Related table(s)

ARZ_01

CountryCode

varchar(2)

string

PK

countries

ARZ_02

AssessmentRegimeId

varchar(100)

string

PK

ComplianceAssessmentMethod

ARZ_03

ZoneId

varchar(50)

string

ZoneGeometry

ARZ_04

ZoneNationalCode

varchar(50)

string

ARZ_05

ZoneArea

decimal(10,2)

numeric

ARZ_06

ZoneCategory

varchar(20)

string

zonecategory

ARZ_07

ZoneType

varchar(20)

string

zonetype

ARZ_08

ZoneName

varchar(150)

string

ARZ_09

PollutantId

int

numeric

pollutant

ARZ_10

ProtectionTarget

varchar(50)

string

protectiontarget

ARZ_11

ObjectiveType

varchar(50)

string

objectivetype

ARZ_12

ReportingMetric

varchar(50)

string

reportingmetric

ARZ_13

AssessmentThresholdExceedance

varchar(20)

string

assessmentthresholdexceedance

ARZ_14

PostponementYear

int

numeric

ARZ_15

FixedMeasurementReduction

char(1)

string

fixedmeasurementreduction

ARZ_16

ZoneResidentPopulationYear

int

numeric

ARZ_17

ZoneResidentPopulation

int

numeric

ARZ_18

ClassificationYear

int

numeric

ARZ_19

ClassificationDocumentId

varchar(150)

string

Documentation

Attribute details

ARZ_01 – CountryCode

Content

Country or territory ISO2 code.

In Reference

View reference attribute

ARZ_02 – AssessmentRegimeId

Content

Identifier of the air quality assessment regime, given by data provider.

Remarks

This attribute must follow a defined structure (see Identifiers section).

In Reference

View reference attribute

ARZ_03 – ZoneId

Content

Identifier of the air quality zone, given by data provider.

Remarks

It will be cross-checked against the ZoneGeometry table.

In Reference

View reference attribute

ARZ_04 – ZoneNationalCode

Content

Unique identifier of the air quality zone, given by data provider.

In Reference

View reference attribute

ARZ_05 – ZoneArea

Content

Total area of the air quality zone.

In Reference

View reference attribute

ARZ_06 – ZoneCategory

Content

Category of the air quality zone (aq zone or nuts) - new code list.

In Reference

View reference attribute

ARZ_07 – ZoneType

Content

Type of air quality zone (e.g., agglomeration and non-agglomeration).

In Reference

View reference attribute

ARZ_08 – ZoneName

Content

Geographical name of the air quality zone.

In Reference

View reference attribute

ARZ_09 – PollutantId

Content

Code of the air pollutant for which the assessment is being conducted.

In Reference

View reference attribute

ARZ_10 – ProtectionTarget

Content

Protection target for air quality (e.g., human health, vegetation).

In Reference

View reference attribute

ARZ_11 – ObjectiveType

Content

Type of environmental objective related to air quality assessment.

In Reference

View reference attribute

ARZ_12 – ReportingMetric

Content

Metric corresponding to the standard (objective type).

In Reference

View reference attribute

ARZ_13 – AssessmentThresholdExceedance

Content

Status indicating whether an assessment threshold has been exceeded.

In Reference

View reference attribute

ARZ_14 – PostponementYear

Content

Year of postponement applied to the air quality zone, pollutant, target, objective and metric/aggregation.

Remarks

PostponementYear relates to the postponement of attainment deadline and exemption from the obligation to apply certain limit values foreseen in the recasted Air Quality Directive 2024/2881 art. 18. Leaving this attribute blank will mean that no postponement does apply.

In Reference

View reference attribute

ARZ_15 – FixedMeasurementReduction

Content

Use of indicative measurements and/or modelling to reduce fixed measurement network.

Remarks

Y/N/X

FixedMeasurementReduction relates to the reduction of the number of sampling points for fixed measurements, which may be reduced by up to 50% under certain conditions as foreseen in the recasted Air Quality Directive 2024/2881 art. 9 §3.

In Reference

View reference attribute

ARZ_16 – ZoneResidentPopulationYear

Content

Reference year for the resident population data in the zone.

In Reference

View reference attribute

ARZ_17 – ZoneResidentPopulation

Content

Number of people residing within the air quality zone.

In Reference

View reference attribute

ARZ_18 – ClassificationYear

Content

The year of the last classification of the pollution level in the zone.

In Reference

View reference attribute

ARZ_19 – ClassificationDocumentId

Content

Identifier of the report detailing the classification procedure given by data provider.

In Reference

View reference attribute

Example

Attribute Code

Attribute Name

Example

SQL DB Data Type

ReportNet3 Data Type

PK

CL

ARZ_01

CountryCode

DU

varchar(2)

string

✓

✓

ARZ_02

AssessmentRegimeId

ARE_ZON_DU000A_0005_LV_H_aMean_2021_1

varchar(100)

string

✓

ARZ_03

ZoneId

ZON_DU000A

varchar(50)

string

ARZ_04

ZoneNationalCode

DU000A

varchar(50)

string

ARZ_05

ZoneArea

442.31

decimal(10,2)

numeric

ARZ_06

ZoneCategory

zone

varchar(20)

string

✓

ARZ_07

ZoneType

agg

varchar(20)

string

✓

ARZ_08

ZoneName

EcoDome Heights

varchar(150)

string

ARZ_09

PollutantId

5

int

numeric

✓

ARZ_10

ProtectionTarget

H

varchar(50)

string

✓

ARZ_11

ObjectiveType

LV

varchar(50)

string

✓

ARZ_12

ReportingMetric

aMean

varchar(50)

string

✓

ARZ_13

AssessmentThresholdExceedance

aboveUAT

varchar(20)

string

✓

ARZ_14

PostponementYear

null

int

numeric

ARZ_15

FixedMeasurementReduction

N

char(1)

string

✓

ARZ_16

ZoneResidentPopulationYear

2020

int

numeric

ARZ_17

ZoneResidentPopulation

599159

int

numeric

ARZ_18

ClassificationYear

2021

int

numeric

ARZ_19

ClassificationDocumentId

DOC_ARE_ZON_DU_2021

varchar(150)

string

Legend: PK = Primary Key; CL = Code List.

Note: The example file is temporarily unavailable while it is being updated. The updated version will be made available once the revision is complete.