# Measure

```{image} ../_static/table-icons/Measure.png
:alt: Measure
:align: right
:width: 200px
```

```{contents}
:local:
:depth: 2
```

## Attributes

| Attribute Code | Attribute Name | SQL DB Data Type | ReportNet3 Data Type | Properties | Code list | Related table(s) | In Reporting |
| -------------- | -------------- | ---------------- | -------------------- | ---------- | --------- | ---------------- | :----------: |
| MEA_01 | CountryCode | varchar(2) | string | PK | [countries](https://dd.eionet.europa.eu/vocabulary/common/countries) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-01-countrycode) |
| MEA_02 | MeasureGroupId | varchar(50) | string | PK |  | ScenarioMeasure | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-02-measuregroupid) |
| MEA_03 | MeasureId | varchar(50) | string | PK |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-03-measureid) |
| MEA_20 | ReportingTime | datetime | datetime | PK |  |  | N |
| MEA_04 | MeasureNationalCode | varchar(50) | string |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-04-measurenationalcode) |
| MEA_05 | MeasureName | varchar(150) | string |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-05-measurename) |
| MEA_06 | MeasureClassification | varchar(50) | string |  | [measureclassification](https://dd.eionet.europa.eu/vocabulary/aq/measureclassification/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-06-measureclassification) |
| MEA_07 | MeasureType | varchar(50) | string |  | [measuretype](https://dd.eionet.europa.eu/vocabulary/aq/measuretype/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-07-measuretype) |
| MEA_08 | SourceSector | varchar(50) | string |  | [sourcesectors](https://dd.eionet.europa.eu/vocabulary/aq/sourcesectors/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-08-sourcesector) |
| MEA_09 | SpatialScale | varchar(50) | string |  | [spatialscale](https://dd.eionet.europa.eu/vocabulary/aq/spatialscale/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-09-spatialscale) |
| MEA_10 | ImplementationBegin | date | datetime |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-10-implementationbegin) |
| MEA_11 | ImplementationEnd | date | datetime |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-11-implementationend) |
| MEA_12 | MeasureCost | decimal(18,2) | numeric |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-12-measurecost) |
| MEA_13 | FullEffectDate | date | datetime |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-13-fulleffectdate) |
| MEA_14 | MeasureStatus | varchar(50) | string |  | [measureimplementationstatus](https://dd.eionet.europa.eu/vocabulary/aq/measureimplementationstatus/view) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-14-measurestatus) |
| MEA_15 | ReasonIfMeasureNotUsed | varchar(50) | string |  | [reasonifmeasurenotused](https://dd.eionet.europa.eu/vocabulary/aq/reasonifmeasurenotused) |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-15-reasonifmeasurenotused) |
| MEA_16 | Deletion | bit | boolean |  |  |  | [Y](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-16-deletion) |
| MEA_21 | Country | varchar(20) | string |  |  |  | N |

```{note}
`ReportingTime` and `Country` are Reference attributes without a corresponding attribute in the reporting data model.
```

## Attribute details

### MEA_01 - CountryCode

**Content**

Country or territory ISO2 code.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-01-countrycode)

### MEA_02 - MeasureGroupId

**Content**

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

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-02-measuregroupid)

### MEA_03 - MeasureId

**Content**

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

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-03-measureid)

### MEA_20 - ReportingTime

**Content**

Date and time when the information is submitted.

**In Reporting**

N - No corresponding reporting attribute.

### MEA_04 - MeasureNationalCode

**Content**

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

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-04-measurenationalcode)

### MEA_05 - MeasureName

**Content**

Name or title of the pollution reduction measure.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-05-measurename)

### MEA_06 - MeasureClassification

**Content**

Classification of the measure based on regulatory categories.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-06-measureclassification)

### MEA_07 - MeasureType

**Content**

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

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-07-measuretype)

### 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 Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-08-sourcesector)

### 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 Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-09-spatialscale)

### MEA_10 - ImplementationBegin

**Content**

Start date for implementing the measure.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-10-implementationbegin)

### MEA_11 - ImplementationEnd

**Content**

End date for implementing the measure.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-11-implementationend)

### MEA_12 - MeasureCost

**Content**

Estimated costs for implementing the measure over its lifetime.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-12-measurecost)

### MEA_13 - FullEffectDate

**Content**

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

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-13-fulleffectdate)

### MEA_14 - MeasureStatus

**Content**

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

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-14-measurestatus)

### MEA_15 - ReasonIfMeasureNotUsed

**Content**

Explanation or justification if the measure was not implemented.

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-15-reasonifmeasurenotused)

### MEA_16 - Deletion

**Content**

Flag to indicate that this element must be deleted.

**Remarks**

Y/N

**In Reporting**

[Y – View reporting attribute](https://eeadata.github.io/AQ.Documentation.ReportingGuide/tables/Measure.html#mea-16-deletion)

### MEA_21 - Country

**Content**

Name of the country.

**In Reporting**

N - No corresponding reporting attribute.