MeasurementStation
Description
The purpose of the MeasurementStation table is to collect data on air quality measuring stations. It includes their EoI codes, names, as well as air quality networks they belong to and time zone in which the networks operate.
MeasurementStation table has to be reported whenever new information or an update of existing information is available. Attributes which create unique identifier of each record: CountryCode and StationEoICode.
Updates of the MeasurementStation table will be managed using reference/legacy data, where each addition and modification will be stamped with ReportingTime:
addition of new record is understood as addition of new combination of values for the attributes creating unique identifier,
modification of existing record is understood as modification of a value for any other attribute. Validity of the new record will be tested using QC rules to be established, e.g. testing validity of EoI codes.
Valid modifications of existing record in this table are minor corrections, e.g. of NetworkName, StationNationalCode, StationName or Timezone, which are not considered as station re-location into new conditions. Validity of the modifications of existing record will be tested using QC rules to be established. Allowed modifications are not supposed to affect outcomes of compliance analysis and/or assessments.
Data products will present the records with the latest ReportingTime for each unique combination of CountryCode and StationEoICode.
EEA extensions
MeasurementStation table will be extended by EEA by several attributes:
Country (for convenience), based on ISO2 country codes,
City and CityCode, based on intersection of station location with city geometry,
ReportingTime, registering time of the latest reporting or modification for each record.
Data management rules
For traceability purposes it is not allowed to change StationEoICode even in case of significant relocation.
It is recommended not to change NetworkDocumentId in case of documentation update related to the same station/network. Instead, a new attachment should be uploaded in Documentation table re-using the same DocumentId. Previous versions of documentation will be kept in reference data. In case where the same NetworkDocumentId was used for all stations and there is a need to modify documentation only for one specific station, it is recommended to create a new NetworkDocumentId for that record in MeasurementStation table. Then report old network-specific and new station-specific documents as attachments for that new NetworkDocumentId in the Documentation table in a subsequent manner.
Station without active sampling points 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) |
|---|---|---|---|---|---|---|
STA_01 |
CountryCode |
varchar(2) |
string |
PK |
||
STA_02 |
StationEoICode |
varchar(10) |
string |
PK |
||
STA_03 |
NetworkId |
varchar(50) |
string |
|||
STA_04 |
NetworkName |
varchar(150) |
string |
|||
STA_05 |
NetworkOrganisationalLevel |
varchar(20) |
string |
|||
STA_06 |
Timezone |
varchar(20) |
string |
|||
STA_07 |
StationNationalCode |
varchar(50) |
string |
|||
STA_08 |
StationName |
varchar(50) |
string |
|||
STA_09 |
NetworkDocumentId |
varchar(150) |
string |
Attribute details
STA_01 – CountryCode
Content
Country or territory ISO2 code.
STA_02 – StationEoICode
Content
EoI (Exchange of Information) code of the air quality measurement station, as in AirBase, either re-used or given by data provider following strict rules.
Code list / reference
There will be no specific code list in Data Dictionary but the Station table in reference data flow will serve as code list for AirQualityStationEoICode values.
Remarks
StationEoICode must be always provided and cannot be modified.
Station will become inactive if all sampling points in that station are inactive.
The same Station can become active again if there are new active sampling points or existing sampling points become active again.
STA_03 – NetworkId
Content
Identifier of the air quality network, given by data provider.
STA_04 – NetworkName
Content
Name of the air quality measurement network, given by data provider.
STA_05 – NetworkOrganisationalLevel
Content
Level of administration or organization responsible for the air quality network (national, regional, local).
STA_06 – Timezone
Content
Time zone in which air quality measurements and statistics are recorded.
Remarks
TimeZone must be provided and will be used for calculations of AQ statistics.
If TimeZone is modified, all statistics will be recalculated accordingly.
STA_07 – StationNationalCode
Content
National code of the air quality measurement station, given by data provider.
STA_08 – StationName
Content
Name of the air quality measurement station.
STA_09 – NetworkDocumentId
Content
Identifier of the documentation on network and station.
Example
Attribute Code |
Attribute Name |
Example |
SQL DB Data Type |
ReportNet3 Data Type |
PK |
CL |
|---|---|---|---|---|---|---|
STA_01 |
CountryCode |
DU |
varchar(2) |
string |
✓ |
✓ |
STA_02 |
StationEoICode |
DU0001 |
varchar(10) |
string |
✓ |
|
STA_03 |
NetworkId |
NET_DU01 |
varchar(50) |
string |
||
STA_04 |
NetworkName |
Dustovia Capital |
varchar(150) |
string |
||
STA_05 |
NetworkOrganisationalLevel |
regional |
varchar(20) |
string |
✓ |
|
STA_06 |
Timezone |
UTC-1 |
varchar(20) |
string |
✓ |
|
STA_07 |
StationNationalCode |
DU01_01 |
varchar(50) |
string |
||
STA_08 |
StationName |
Rivny-Suburb-A |
varchar(50) |
string |
||
STA_09 |
NetworkDocumentId |
DOC_NET_DU01 |
varchar(150) |
string |
Legend: PK = Primary Key; CL = Code List.
The complete set of examples is available in the Excel workbook, worksheet MeasurementStation.