SRSExternal
Description
The purpose of the SRSExternal table is to collect the representativeness area (either SPO representativeness or exceedance extent) as external GIS files, for each sampling point declared for compliance assessments.
Attributes which create unique identifier of each record: CountryCode and SRSApplicationId.
Updates of the SRSExternal table will not be time stamped - i.e. each update generates the only version of the table in reference/legacy data. Validity of the modifications of existing record and/or new record will be tested using QC (rules to be established).
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
Reference data flow will have two tables representing reporting of SR areas:
SRSInventory;
SRSGrid. SRSInventory will collect information about count of values reported for each SR area and will contain a reference to raw data file. SRSGrid 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 and traffic links;
1 High Resolution layer (1000m) for all areas.
SRSGrid table will be extended by several attributes:
Country (for convenience), based on ISO2 country codes;
Grid number identifiers, based on X,Y (SRID 3035).
Data management rules
It is expected that SR areas for sampling points declared for compliance assessments will be reported together with attainment reports (when ComplianceAssessmentMethod table is reported).
Exceedance extents are expected to be reported as soon as relevant air quality plans are in place.
Records in SRSExternal table which do not have any correspondence to records in SpatialRepresentativeness 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) |
|---|---|---|---|---|---|---|
SRE_01 |
CountryCode |
varchar(2) |
string |
PK |
||
SRE_02 |
SRSApplicationId |
varchar(50) |
string |
PK |
||
SRE_03 |
SpatialResolution |
int |
numeric |
|||
SRE_04 |
GeoTiffAttachment |
varchar(100) |
attachment (R3 data type) |
Attribute details
SRE_01 – CountryCode
Content
Country or territory ISO2 code.
SRE_02 – SRSApplicationId
Content
Identifier of the specific spatial representativeness given by data provider.
SRE_03 – SpatialResolution
Content
Description of the spatial resolution of the data, indicating the level of detail.
Remarks
SpatialResolution will be tested against the code list for allowed values.
SRE_04 – GISAttachment
Content
Attached GIS file containing the spatial representativeness area.
Remarks
The attachment contains either:
sampling point representativeness area; or
exceedance extent area.
Example
Attribute Code |
Attribute Name |
Example |
SQL DB Data Type |
ReportNet3 Data Type |
PK |
CL |
|---|---|---|---|---|---|---|
SRE_01 |
CountryCode |
DU |
varchar(2) |
string |
✓ |
✓ |
SRE_02 |
SRSApplicationId |
SRS_SPO_DU0001_0008_100 |
varchar(50) |
string |
✓ |
|
SRE_03 |
SpatialResolution |
100 |
int |
numeric |
✓ |
|
SRE_04 |
GeoTiffAttachment |
varchar(100) |
attachment (R3 data type) |
Legend: PK = Primary Key; CL = Code List.
The complete set of examples is available in the Excel workbook, worksheet SRSExternal.