MOEResultGrid
Attributes
Attribute Code |
Attribute Name |
SQL DB Data Type |
ReportNet3 Data Type |
Properties |
Code list |
Related table(s) |
In Reporting |
|---|---|---|---|---|---|---|---|
MRG_01 |
CountryCode |
varchar(2) |
string |
PK |
N |
||
MRG_02 |
AssessmentMethodId |
varchar(100) |
string |
PK |
N |
||
MRG_03 |
Start |
datetime |
datetime |
PK |
N |
||
MRG_04 |
DataAggregationProcessId |
varchar(50) |
string |
PK |
N |
||
MRG_05 |
X |
int |
numeric |
PK |
N |
||
MRG_06 |
Y |
int |
numeric |
PK |
N |
||
MRG_07 |
PollutantId |
int |
numeric |
N |
|||
MRG_08 |
End |
datetime |
datetime |
N |
|||
MRG_09 |
Value |
decimal(10,3) |
numeric |
N |
|||
MRG_10 |
Unit |
varchar(20) |
string |
N |
|||
MRG_11 |
Validity |
int |
numeric |
N |
|||
MRG_12 |
ResultTime |
datetime |
datetime |
N |
|||
MRG_13 |
Country |
varchar(50) |
string |
N |
|||
MRG_14 |
Pollutant |
varchar(100) |
string |
N |
|||
MRG_15 |
DataAggregationProcess |
varchar(100) |
string |
N |
|||
MRG_16 |
Verification |
int |
numeric |
N |
|||
MRG_17 |
Area |
decimal(10,3) |
N |
||||
MRG_18 |
GridNum10m |
bigint |
numeric |
N |
|||
MRG_19 |
GridNum100m |
bigint |
numeric |
N |
|||
MRG_20 |
GridNum1km |
bigint |
numeric |
N |
|||
MRG_21 |
GridNum10km |
bigint |
numeric |
N |
|||
MRG_22 |
SourceDataFlow |
varchar(10) |
??? |
N |
|||
MRG_23 |
Deletion |
bit |
boolean |
N |
Note
There is no corresponding table in the reporting data model. Therefore, all attributes are marked N.
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
MRG_01 - CountryCode
Content
Country or territory ISO2 code.
In Reporting
N - No corresponding reporting table.
MRG_02 - AssessmentMethodId
Content
Identifier of the assessment method (model), given by provider.
In Reporting
N - No corresponding reporting table.
MRG_03 - Start
Content
Start date and time of the model simulation period.
In Reporting
N - No corresponding reporting table.
MRG_04 - DataAggregationProcessId
Content
Identifier for the process of aggregating model data into statistical values.
In Reporting
N - No corresponding reporting table.
MRG_05 - X
Content
X-coordinate of the modeled data point in a projected coordinate reference system.
In Reporting
N - No corresponding reporting table.
MRG_06 - Y
Content
Y-coordinate of the modeled data point in a projected coordinate reference system.
In Reporting
N - No corresponding reporting table.
MRG_07 - PollutantId
Content
Code of the air pollutant being modeled, as per Data Dictionary standards.
In Reporting
N - No corresponding reporting table.
MRG_08 - End
Content
End date and time of the model simulation period.
In Reporting
N - No corresponding reporting table.
MRG_09 - Value
Content
Modeled concentration or level of the air pollutant.
In Reporting
N - No corresponding reporting table.
MRG_10 - Unit
Content
Unit of measurement for the air pollution level (e.g., µg/m³).
In Reporting
N - No corresponding reporting table.
MRG_11 - Validity
Content
Indicator of whether the model data is valid or flagged.
In Reporting
N - No corresponding reporting table.
MRG_12 - ResultTime
Content
Time at which the model results were generated or recorded.
In Reporting
N - No corresponding reporting table.
MRG_13 - Country
Content
Name of the country.
In Reporting
N - No corresponding reporting table.
MRG_14 - Pollutant
Content
Name of the air pollutant being modeled, as per Data Dictionary standards.
In Reporting
N - No corresponding reporting table.
MRG_15 - DataAggregationProcess
Content
Label of the process of data aggregation into statistical values.
In Reporting
N - No corresponding reporting table.
MRG_16 - Verification
Content
Information based on verification flags found in reported time series.
In Reporting
N - No corresponding reporting table.
MRG_17 - Area
In Reporting
N - No corresponding reporting table.
MRG_18 - GridNum10m
Content
Grid cell identifier in the EEA grid according to spatial resolution
In Reporting
N - No corresponding reporting table.
MRG_19 - GridNum100m
Content
Grid cell identifier in the EEA grid according to spatial resolution
In Reporting
N - No corresponding reporting table.
MRG_20 - GridNum1km
Content
Grid cell identifier in the EEA grid according to spatial resolution
In Reporting
N - No corresponding reporting table.
MRG_21 - GridNum10km
Content
Grid cell identifier in the EEA grid according to spatial resolution
In Reporting
N - No corresponding reporting table.
MRG_22 - SourceDataFlow
Content
Indicate whether the data were transmitted in E1b (Reportnet2) or within the new system Reportnet3.
In Reporting
N - No corresponding reporting table.
MRG_23 - Deletion
Content
Flag to indicate that this element must be deleted.
In Reporting
N - No corresponding reporting table.