SpatialRepresentativeness

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

countries

SRS_02

SRSId

varchar(100)

string

PK

ComplianceAssessmentMethod

SRS_03

SRSApplicationId

varchar(100)

string

PK

SRSInline
SRSExternal

SRS_04

SRSApplication

varchar(10)

string

SRapplication

SRS_05

ResultEncoding

varchar(10)

string

resultencoding

SRS_06

RepresentativenessAssessmentMethodId

varchar(100)

string

ModelObjectiveEstimation

Attribute details

SRS_01 – CountryCode

Content

Country or territory ISO2 code.

In Reference

View reference attribute

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

View reference attribute

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

View reference attribute

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

View reference attribute

SRS_05 – ResultEncoding

Content

Encoding method used for model results (internal or external).

In Reference

View reference attribute

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

View reference attribute

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.