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). SRSAssessmentMethodId 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(50)	string	PK		ComplianceAssessmentMethod
SRS_03	SRSApplicationId	varchar(50)	string	PK		SRSInline SRSExternal
SRS_04	SRSApplication	varchar(50)	string		SRapplication
SRS_05	ResultEncoding	varchar(10)	string		resultencoding
SRS_06	RepresentativenessAssessmentMethodId	varchar(50)	string			ModelObjectiveEstimation

Attribute details

SRS_01 – CountryCode

Content

Country or territory ISO2 code.

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.

SRS_03 – SRSApplicationId

Content

Identifier pointing to the specific spatial representativeness given by data provider.

Remarks

The same SRSId can have several SRSApplication_Id (e.g. one for the SPO representativeness area and one for the exceedance extent).

SRS_04 – SRSApplication

Content

Application of spatial representativeness (SPO representativeness or the exceedance extent).

Remarks

New code list (SPO representativeness area, exceedance extent area).

SRS_05 – ResultEncoding

Content

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

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 Model table) which was used for the assessments of the SPO representativeness area or the exceedance extent.

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(50)	string	✓
SRS_03	SRSApplicationId	SRS_SPO_DU0001_0005_100	varchar(50)	string	✓
SRS_04	SRSApplication	spo_sr	varchar(50)	string		✓
SRS_05	ResultEncoding	inline	varchar(10)	string		✓
SRS_06	RepresentativenessAssessmentMethodId	MOD_DU_PM10_NAT_SR	varchar(50)	string

Legend: PK = Primary Key; CL = Code List.

The complete set of examples is available in the Excel workbook, worksheet SpatialRepresentativeness.

Download complete examples workbook