SpatialRepresentativeness
Description
The purpose of the SpatialRepresentativeness table is to ensure the link between the coverage of the spatial representativeness area of a sampling point or exceedance extent, and the ComplianceAssessmentMethod table. It can also point to the method (model/OBE) used for the assessment of the SPO representativeness or the exceedance extent.
SpatialRepresentativeness table has to be reported whenever a new information or an update of existing information is available (at least every 5 years for the SPO representativeness and for each sampling point declared for compliance assessments). Attributes which create unique identifier of each record: CountryCode, SRSId and SRSApplicationId.
Updates of the SpatialRepresentativeness table will not be time stamped, i.e. each update generates the only version of the SpatialRepresentativeness that is stored at the EEA. Validity of a new record or modification will be tested using QC (rules to be established) - e.g. cross checking against existing records in ComplianceAssessmentMethod table, SRSInline and/or SRSExternal tables.
Data products for public will present the records validated at the latest deadline. Data products for reporters will present the records as reported the most recently.
EEA extensions
SpatialRepresentativeness table will be extended by EEA by:
Country (for convenience), based on ISO2 country codes.
Data management rules
It is allowed to reuse SRSId within the same AQ zone and across the years. However, it is strongly recommended to set a new SRSId in ComplianceAssessmentMethod table and new record in SpatialRepresentativeness table with SRSApplication = exc_sr, whenever a new exceedance is reported (also by model/OBE).
This practice enables reporting of exceedance extents after relevant plans are in place, without re-submitting records for ComplianceAssessmentMethod table (but simply by using the SRSId which is already there). RepresentativenessAssessmentMethodId can be used for pointing to AssessmentMethodId in the ModelObjectiveEstimation table for definition of the modelling/OBE method which generated the SR areas (either for sampling point or as exceedance extents).
It is expected that in case of exceedance extents, the value in RepresentativenessAssessmentMethodId will be the same as value in ScenarioAssessmentMethodId in PlanScenario record referring to the same AttainmentId (because it is the same model/OBE).
Records in SpatialRepresentativeness 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) |
|---|---|---|---|---|---|---|
SRS_01 |
CountryCode |
varchar(2) |
string |
PK |
||
SRS_02 |
SRSId |
varchar(100) |
string |
PK |
||
SRS_03 |
SRSApplicationId |
varchar(100) |
string |
PK |
||
SRS_04 |
SRSApplication |
varchar(10) |
string |
|||
SRS_05 |
ResultEncoding |
varchar(10) |
string |
|||
SRS_06 |
RepresentativenessAssessmentMethodId |
varchar(100) |
string |
Attribute details
SRS_01 – CountryCode
Content
Country or territory ISO2 code.
In Reference
SRS_02 – SRSId
Content
Identifier of the area representing the sampling point’s measurement spatial coverage or the extent of the exceedance, given by data provider.
In Reference
SRS_03 – SRSApplicationId
Content
Identifier pointing to the specific spatial representativeness given by data provider.
Remarks
The same SRSId can have several SRSApplicationId (e.g. one for the SPO representativeness area and one for the exceedance extent).
In Reference
SRS_04 – SRSApplication
Content
Application of spatial representativeness (SPO representativeness or the exceedance extent).
Remarks
New code list (SPO representativeness area, exceedance extent area).
In Reference
SRS_05 – ResultEncoding
Content
Encoding method used for model results (internal or external).
In Reference
SRS_06 – RepresentativenessAssessmentMethodId
Content
Identifier of the assessment method (model) used for defining the area (either representativeness or extent), given by data provider.
Remarks
AssessmentMethodId is a model or OBE identifier that points to the method (model/OBE in the ModelObjectiveEstimation table) which was used for the assessments of the SPO representativeness area or the exceedance extent.
In Reference
Example
Attribute Code |
Attribute Name |
Example |
SQL DB Data Type |
ReportNet3 Data Type |
PK |
CL |
|---|---|---|---|---|---|---|
SRS_01 |
CountryCode |
DU |
varchar(2) |
string |
✓ |
✓ |
SRS_02 |
SRSId |
SRS_ZON_DU000A_00005_1 |
varchar(100) |
string |
✓ |
|
SRS_03 |
SRSApplicationId |
SRS_SPO_DU0001_0005_100 |
varchar(100) |
string |
✓ |
|
SRS_04 |
SRSApplication |
spo_sr |
varchar(10) |
string |
✓ |
|
SRS_05 |
ResultEncoding |
inline |
varchar(10) |
string |
✓ |
|
SRS_06 |
RepresentativenessAssessmentMethodId |
MOD_DU_PM10_NAT_SR |
varchar(100) |
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.