The measurement file is a comma delimited text file know as csv format. The fields are separated by commas, and each row is seperated by a newline.
We have two file formats, a basic format for simple sensor and reference data, and an advanced format that includes temperature and humidity as well. The upload system will accept either format.
Basic File Format
The basic file format has three columns, timestamp, sensor measurement and reference measurement:
- timestamp is the date and time the measurement started. It should not have any daylight savings adjustments. It can have various formats that are selectable when you upload the data. The preferred format is dd/mm/yyyy hh:mm:ss.xxx where dd is the day, mm is the month, yyyy is the year, hh is the hour, mm is the minute, ss is the second, and xxx is the milliseconds. Data wil be accepted without seconds or milliseconds e.g. dd/mm/yyyy hh:mm is also fine.
- Sensor measurement is the sensor measurement in ug/m3
- Reference measurement is the reference sensor measurement in ug/m3
The first line of the file has the headers. These can have any names, but we would recommend:
timestamp,measurement,refmeasurement
The remaining lines are the rows of data.
You can use the following basic template.
Here is an example file:
timestamp,measurement,refmeasurement
14/04/2019 22:00,41.83,36.51
14/04/2019 23:00,31.51,31.51
15/04/2019 00:00,29.50,20.94
15/04/2019 01:00,23.93,26.71
15/04/2019 02:00,26.13,26.52
15/04/2019 03:00,27.15,29.21
Advanced File Format
The advanced file format has the same three columns as the basic format above, but also has two additional columns for temperature and humidity:
- Temperature is in degrees Celsius
- Humidity is relative humidity, which is a percentage e.g. between 0 and 100
The first line of the file has the headers. These can have any names, but we would recommend:
timestamp,measurement,refmeasurement,temperature,humidity
The remaining lines are the rows of data.
You can use the following advanced template.
Here is an example file:
timestamp,measurement,refmeasurement,temperature,humidity
14/04/2019 22:00,41.83,36.51,1.5,90.2
14/04/2019 23:00,31.51,31.51,3.2,89.5
15/04/2019 00:00,29.50,20.94,4.5,81.2
15/04/2019 01:00,23.93,26.71,-15.3, 20
15/04/2019 02:00,26.13,26.52,45.2,21.5
15/04/2019 03:00,27.15,29.21,20.1,65.2