Measure

Measure

Description

The purpose of the Measure table is to provide information on the different measures contained in the groups of measures. It describes the spatial scale of the measures, their type and classification as well as sector of impact. The table includes also operational characteristics of measures such as: responsible entity, implementation timing, costs, status and expected time of full effect or reason if measure has not been used.

Measure (record) table has to be reported whenever a new information or an update of existing information is available. Attributes which create unique identifier of each record: CountryCode, MeasureGroupId and MeasureId.

Updates of the Measure table will be managed using reference/legacy data, where each addition and modification will be stamped with ReportingTime:

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

  • modification of existing record is 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 relevant code lists and tested for coherence.

Valid modifications of existing record in this table are:

  • modifying ResponsibleEntity, ImplementationBegin and/or End, MeasureCost, FullEffectDate, MeasureStatus or ReasonIfMeasureNotUsed,

  • minor corrections e.g. of name, code or type.

Validity of the modifications of existing record will be tested using QC (rules to be established). Allowed modifications may affect outcomes of scenario analysis and/or assessments of measures, therefore re-submissions for past years, for which plans 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 - i.e. with the latest ReportingTime for each unique combination of CountryCode, MeasureGroupId and MeasureId, highlighting the differences between validated reports and recent reports in case of re-submissions.

Deletion of an existing record will be possible by flagging the Deletion attribute. After QCs (rules to be established), all associated records in other tables will be flagged as deleted.

EEA extensions

Measure table will be extended by several attributes:

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

  • ReportingTime, registering time of the latest reporting or modification for each record.

Data management rules

Since the unique identifier of each record consists of CountryCode, MeasureGroupId and MeasureId, the MeasureIds can be handled as static set of measures (with code, name, type, source sector) and can be re-used in different MeasureGroupIds - which can be then used for giving spatial and temporal context to the measures (spatial scale, responsible entity, implementation timing, costs, etc.).

Deletion of an existing record will be possible via the Deletion attribute (by reporting value = 1).

Attributes

Attribute Code

Attribute Name

SQL DB Data Type

ReportNet3 Data Type

Properties

Code list

Related table(s)

MEA_01

CountryCode

varchar(2)

string

PK

countries

MEA_02

MeasureGroupId

varchar(100)

string

PK

ScenarioMeasure

MEA_03

MeasureId

varchar(200)

string

PK

MEA_04

MeasureNationalCode

varchar(100)

string

MEA_05

MeasureName

varchar(150)

string

MEA_06

MeasureClassification

varchar(50)

string

measureclassification - recast

MEA_07

MeasureType

varchar(50)

string

measuretype

MEA_08

SourceSector

varchar(50)

string

sourcesectors

MEA_09

SpatialScale

varchar(50)

string

spatialscale

MEA_10

ImplementationBegin

date

date

MEA_11

ImplementationEnd

date

date

MEA_12

MeasureCost

bigint

numeric

MEA_13

FullEffectDate

date

date

MEA_14

MeasureStatus

varchar(50)

string

measureimplementationstatus

MEA_15

ReasonIfMeasureNotUsed

varchar(50)

string

reasonifmeasurenotused

MEA_16

Deletion

char(1)

string

Deletion

Note

Attributes with ReportNet3 data type date or datetime shall use the ISO 8601 format. Date-time values may include a local UTC offset.

Attribute details

MEA_01 – CountryCode

Content

Country or territory ISO2 code.

In Reference

View reference attribute

MEA_02 – MeasureGroupId

Content

Identifier of the pollution reduction for measure group, given by data provider.

In Reference

View reference attribute

MEA_03 – MeasureId

Content

Identifier of the pollution reduction measure, given by data provider.

In Reference

View reference attribute

MEA_04 – MeasureNationalCode

Content

Unique local code assigned to the measure by the data provider.

In Reference

View reference attribute

MEA_05 – MeasureName

Content

Name or title of the pollution reduction measure.

In Reference

View reference attribute

MEA_06 – MeasureClassification

Content

Classification of the measure based on regulatory categories.

In Reference

View reference attribute

MEA_07 – MeasureType

Content

Description of the high-level implementation mechanism or scope of the measure.

In Reference

View reference attribute

MEA_08 – SourceSector

Content

Economic or activity sector targeted by the measure (e.g., transport, energy, industry).

Remarks

It can be tested against the SourceSector of SourceApportionment which was used as base for corresponding ScenarioId.

In Reference

View reference attribute

MEA_09 – SpatialScale

Content

Geographical coverage of the measure (e.g., local, national, EU-wide).

Remarks

It can be tested against the SpatialScale of SourceApportionment which was used as base for corresponding ScenarioId.

In Reference

View reference attribute

MEA_10 – ImplementationBegin

Content

Start date for implementing the measure.

In Reference

View reference attribute

MEA_11 – ImplementationEnd

Content

End date for implementing the measure.

In Reference

View reference attribute

MEA_12 – MeasureCost

Content

Estimated costs for implementing the measure over its lifetime.

In Reference

View reference attribute

MEA_13 – FullEffectDate

Content

Date when the measure is expected to reach its full impact.

In Reference

View reference attribute

MEA_14 – MeasureStatus

Content

Current status of the measure (e.g., planned, in progress, completed).

In Reference

View reference attribute

MEA_15 – ReasonIfMeasureNotUsed

Content

Explanation or justification if the measure was not implemented.

In Reference

View reference attribute

MEA_16 – Deletion

Content

Flag to indicate that this element must be deleted

Remarks

Y/N

In Reference

View reference attribute

Example

Attribute Code

Attribute Name

Example

SQL DB Data Type

ReportNet3 Data Type

PK

CL

MEA_01

CountryCode

DU

varchar(2)

string

✓

✓

MEA_02

MeasureGroupId

MG1_SCE_ZON_DU000B_00005_LV_H_daysAbove

varchar(100)

string

✓

MEA_03

MeasureId

Measure_1256

varchar(200)

string

✓

MEA_04

MeasureNationalCode

Measure_1256

varchar(100)

string

MEA_05

MeasureName

Industrial Emission Control

varchar(150)

string

MEA_06

MeasureClassification

emissioncontrol

varchar(50)

string

✓

MEA_07

MeasureType

outside

varchar(50)

string

✓

MEA_08

SourceSector

industry

varchar(50)

string

✓

MEA_09

SpatialScale

local

varchar(50)

string

✓

MEA_10

ImplementationBegin

2025-02-01

date

date

MEA_11

ImplementationEnd

2027-12-31

date

date

MEA_12

MeasureCost

null

bigint

numeric

MEA_13

FullEffectDate

null

date

date

MEA_14

MeasureStatus

implementation

varchar(50)

string

✓

MEA_15

ReasonIfMeasureNotUsed

null

varchar(50)

string

✓

MEA_16

Deletion

N

char(1)

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.