SRSInline
Description
The purpose of the SRSInline table is to collect the representativeness area (either SPO representativeness or exceedance extent) as set of grid cells following the common grid approach (see Introduction), for each sampling point declared for compliance assessments.
Attributes which create unique identifier of each record: CountryCode, SRSApplicationId, X and Y.
Updates of the SRSInline 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 SRSInline 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) |
|---|---|---|---|---|---|---|
SRI_01 |
CountryCode |
varchar(2) |
string |
PK |
||
SRI_02 |
SRSApplicationId |
varchar(50) |
string |
PK |
||
SRI_03 |
X |
bigint |
numeric |
PK |
||
SRI_04 |
Y |
bigint |
numeric |
PK |
||
SRI_05 |
SpatialResolution |
int |
numeric |
Attribute details
SRI_01 – CountryCode
Content
Country or territory ISO2 code.
SRI_02 – SRSApplicationId
Content
Identifier of the specific spatial representativeness given by data provider.
SRI_03 – X
Content
X-coordinate of grid cell belonging to SRA in a projected coordinate reference system.
Remarks
It must be using SRID 3035.
SRI_04 – Y
Content
Y-coordinate of grid cell belonging to SRA in a projected coordinate reference system.
Remarks
It must be using SRID 3035.
SRI_05 – 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.
Example
Attribute Code |
Attribute Name |
Example |
SQL DB Data Type |
ReportNet3 Data Type |
PK |
CL |
|---|---|---|---|---|---|---|
SRI_01 |
CountryCode |
DU |
varchar(2) |
string |
✓ |
✓ |
SRI_02 |
SRSApplicationId |
SRS_SPO_DU0001_0005_100 |
varchar(50) |
string |
✓ |
|
SRI_03 |
X |
3825000 |
bigint |
numeric |
✓ |
|
SRI_04 |
Y |
2274000 |
bigint |
numeric |
✓ |
|
SRI_05 |
SpatialResolution |
1000 |
int |
numeric |
✓ |
Legend: PK = Primary Key; CL = Code List.
The complete set of examples is available in the Excel workbook, worksheet SRSInline.