MOEResultExternal
Description
The purpose of the MOEResultExternal table is to collect information on results from air quality modelling applications. It is similar to the table MREResultInline except that here the results are submitted in attached GEOTIFF file, following the common grid approach (see Introduction).
MOEResultExternal table has to be reported every year (if models/OBE are declared for compliance) because new information is expected at each reporting cycle. Attributes which create unique identifier of each record: CountryCode, AssessmentMethodId, Start and DataAggregationProcessId.
Updates of the MOEResultExternal table will not be time stamped - i.e. each update generates the only version of the (gridded) AQ values that is stored at the EEA, as well - the only version of the corresponding table in reference/legacy data:
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 existing records in ModelObjectiveEstimation table.
Valid modifications of existing record in this table are based on re-submission of a GEOTIFF file for the existing set of attributes creating unique identifier:
either to overwrite/correct the values of other attributes,
or to modify Validity flag to -1 for deletion purpose. Validity of the modifications 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 already been completed, will require additional tests against reference/legacy data before official release of such data is granted.
Data products for the public will present records validated at the latest deadline. Data products for reporters will present records as most recently reported, highlighting differences between validated reports and recent reports in case of re-submissions.
EEA extensions
Reference data flow will have two tables representing reporting of model/OBE results:
MOEResultInventory;
MOEResultGrid. MOEResultInventory will collect information about count of values reported for each model/OBE and year with certain settings (validity, verification, spatial resolution, etc.) and will contain a reference to raw data file. MOEResultGrid table will differ from the reporting data flow however it will contain gridded AQ values in 3 layers:
2 Very High Resolution layers (10 and 100m - depending on original resolutions) for populated areas, traffic links and areas with values above thresholds,
1 High Resolution layer (1000m) for all areas.
MOEResultGrid table will be extended by several attributes:
Pollutant (for convenience), based on code list,
DataAggregationProcess, based on DataAggregationProcessId,
SourceDataFlow (R2 e-Reporting, R3 e-Reporting),
Verification,
Grid number identifiers, based on X,Y (SRID 3035).
Data management rules
Results from modelling reported through external files should point to a record in the ModelObjectiveEstimation table with:
ResultEncoding = 'external'
Attributes
Attribute Code |
Attribute Name |
SQL DB Data Type |
ReportNet3 Data Type |
Properties |
Code list |
Related table(s) |
|---|---|---|---|---|---|---|
MRE_01 |
CountryCode |
varchar(2) |
string |
PK |
||
MRE_02 |
AssessmentMethodId |
varchar(50) |
string |
PK |
||
MRE_03 |
Start |
datetime |
datetime |
PK |
||
MRE_04 |
DataAggregationProcessId |
varchar(50) |
string |
PK |
https://dd.eionet.europa.eu/vocabulary/aq/aggregationprocess/view |
|
MRE_05 |
PollutantId |
int |
numeric |
|||
MRE_06 |
End |
datetime |
datetime |
|||
MRE_07 |
Unit |
varchar(10) |
string |
|||
MRE_08 |
Validity |
int |
numeric |
https://dd.eionet.europa.eu/vocabulary/aq/observationvalidity/view |
||
MRE_09 |
SpatialResolution |
int |
numeric |
|||
MRE_10 |
ResultTime |
datetime |
datetime |
|||
MRE_11 |
GeoTiffAttachment |
varchar(100) |
attachment (R3 data type) |
Attribute details
MRE_01 – CountryCode
Content
Country or territory ISO2 code.
MRE_02 – AssessmentMethodId
Content
Identifier of the assessment method (model), given by provider.
Remarks
It will be cross-checked against the Model table.
MRE_03 – Start
Content
Start date and time of the model simulation period.
Remarks
Start must be provided with time zone. This information will be used for recalculation of all datetimes into UTC+1 for storage and analytical purposes.
MRE_04 – DataAggregationProcessId
Content
Identifier for the process of aggregating model data into statistical values.
MRE_05 – PollutantId
Content
Code of the air pollutant being modeled, as per Data Dictionary standards.
MRE_06 – End
Content
End date and time of the model simulation period.
Remarks
End must be provided with time zone. This information will be used for recalculation of all datetimes into UTC+1 for storage and analytical purposes.
MRE_07 – Unit
Content
Unit of measurement for the air pollution level (e.g., µg/m³).
Remarks
Units must follow those recommended unit for AQD pollutants.
MRE_08 – Validity
Content
Indicator of whether the model data is valid or flagged.
MRE_09 – SpatialResolution
Content
Description of the spatial resolution of the model output, indicating the level of detail - new code list.
Remarks
SpatialResolution will be tested against the code list for allowed values.
MRE_10 – ResultTime
Content
Time at which the model results were generated or recorded.
MRE_11 – GeoTiffAttachment
Content
Attached GEOTIFF.
Example
Attribute Code |
Attribute Name |
Example |
SQL DB Data Type |
ReportNet3 Data Type |
PK |
CL |
|---|---|---|---|---|---|---|
MRE_01 |
CountryCode |
DU |
varchar(2) |
string |
✓ |
✓ |
MRE_02 |
AssessmentMethodId |
MOD_DU_PM10_NAT_SR |
varchar(50) |
string |
✓ |
|
MRE_03 |
Start |
2021-01-01 00:00:00 |
datetime |
datetime |
✓ |
|
MRE_04 |
DataAggregationProcessId |
P1Y |
varchar(50) |
string |
✓ |
✓ |
MRE_05 |
PollutantId |
5 |
int |
numeric |
✓ |
|
MRE_06 |
End |
2022-01-01 00:00:00 |
datetime |
datetime |
||
MRE_07 |
Unit |
ug/m3 |
varchar(10) |
string |
✓ |
|
MRE_08 |
Validity |
1 |
int |
numeric |
✓ |
|
MRE_09 |
SpatialResolution |
1000 |
int |
numeric |
✓ |
|
MRE_10 |
ResultTime |
2023-04-14 10:19:44 |
datetime |
datetime |
||
MRE_11 |
GeoTiffAttachment |
varchar(100) |
attachment (R3 data type) |
Legend: PK = Primary Key; FK = Foreign Key; CL = Code List.
The complete set of examples is available in the Excel workbook, worksheet MOEResultExternal.