Last Update: 12 September 2023
Since we will compare data from more than 15 co-location places, we would appreciate if you could provide the reference data in the following format.
File format
Please provide the data as tab delimited csv file
Column Definitions
| date_utc | date_local | pm1_ugm3 | pm25_ugm3 | pm10_ugm3 | temp_degc | rh_per | co2_ppm | location | sensor_id | type |
|---|---|---|---|---|---|---|---|---|---|---|
| UTC Date in format “2023-05-01T10:00:00.000Z” | UTC Date in local time zone “2023-05-01T15:00:00.000” | PM1 in μg/m³ | PM2.5 in μg/m³ | PM10 in μg/m³ | Temperature in Degrees Celcius | Relative Humidity | CO2 in ppm | Short name of co-location station. Contact us if you do not have | Always “123” for reference stations | Always “reference” for reference stations |
Example
Please see below as example data submitted to us.
| date_utc | date_local | pm1_ugm3 | pm25_ugm3 | pm10_ugm3 | temp_degc | rh_per | co2_ppm | location | sensor_id | type |
|---|---|---|---|---|---|---|---|---|---|---|
| 2023-05-01T10:00:00.000Z | 2023-05-01T10:00:00.000 | 7 | 3 | 6 | 14.6 | 41 | 431 | ucam | 123 | reference |
| 2023-05-01T10:05:00.000Z | 2023-05-01T10:00:00.000 | 6 | 4 | 5 | 14.3 | 40 | 435 | ucam | 123 | reference |
| 2023-05-01T10:10:00.000Z | 2023-05-01T10:00:00.000 | 4 | 3 | 5 | 14.1 | 40 | 438 | ucam | 123 | reference |
Aggregations
In case your reference stations does less than 5 minute averages, kindly provide the average for all data points within 5 minutes. The timestamp should be the beginning of the averaged period, i.e. a time stamp of 20:15:00 would encompass all averaged data points between 20:15:00 and 20:19:59.
In case you have only hourly averages, please explain exactly how the average is done and if the time stamp is at the beginning, middle or end of the averaged period.
Time Stamps
Ideally you can provide us with two time stamps:
- Local Date and Time and
- UTC0