# SRSInline

```{contents}
:local:
:depth: 2
```

## 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 | [countries](https://dd.eionet.europa.eu/vocabulary/common/countries) |  |
| SRI_02 | SRSApplicationId | varchar(50) | string | PK |  | [SpatialRepresentativeness](SpatialRepresentativeness.md) |
| SRI_03 | X | bigint | numeric | PK |  |  |
| SRI_04 | Y | bigint | numeric | PK |  |  |
| SRI_05 | SpatialResolution | int | numeric |  | [spatialresolution](https://dd.eionet.europa.eu/vocabulary/aq/spatialresolution) |  |

## 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`.

[Download complete examples workbook](../_static/R3_v501_AQ_Reporting_guide_example.xlsx)