services:indoor-climate-dataset

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
services:indoor-climate-dataset [2022/03/29 11:31] – [Issue: missing .csv headers] aleksipirttimaaservices:indoor-climate-dataset [2022/10/25 12:39] (current) aleksipirttimaa
Line 3: Line 3:
 Indoor air-quality, presence and light measurements from the University of Oulu Linnanmaa-campus and botanical garden are published at [[https://etsin.fairdata.fi/dataset/98ff83ec-96fb-45d2-af82-c041200a3fb2|fairdata.fi]]. Indoor air-quality, presence and light measurements from the University of Oulu Linnanmaa-campus and botanical garden are published at [[https://etsin.fairdata.fi/dataset/98ff83ec-96fb-45d2-af82-c041200a3fb2|fairdata.fi]].
  
-The dataset begins on 1.7.2020. Read more about our open data releases. +The dataset begins on 1.7.2020. Read more about our [[services:open-data|open data timeline]].
  
  
Line 12: Line 11:
  
 A month of this .csv formatted data consumes around 100 MiB's of memory, however the files are distributed in a compressed archive. A month of this .csv formatted data consumes around 100 MiB's of memory, however the files are distributed in a compressed archive.
- 
  
  
Line 18: Line 16:
  
 The network consists of 429 deployed sensors. Each of which transmit once every 15 minutes. The network consists of 429 deployed sensors. Each of which transmit once every 15 minutes.
 +
 +=== application.csv ===
  
 The following quantities are included in the 'application'-table. The following quantities are included in the 'application'-table.
Line 40: Line 40:
  
 This format is similar to the [[lorawan:prelude|Prelude data format]]. This format is similar to the [[lorawan:prelude|Prelude data format]].
 +
 +=== lora.csv ===
 +
 +The gateway publishes LoRaWAN link related messages over MQTT. These messages are JSON, but in the data release these messages are represented as .csv. The field keys are documented by our vendor (under //Fields in up messages//):
 +
 +  * https://www.multitech.net/developer/software/lora/lora-network-server/mqtt-messages/
  
  
 ===== Sensor metadata ===== ===== Sensor metadata =====
  
-devices.jsonl uses the jsonlines-format. It contains metadata about individual sensor devices, including the geolocation (Web Mercator EPSG:3785) and spoken description of installation location.+devices.json uses the jsonlines-format. It contains metadata about individual sensor devices, including the geolocation (Web Mercator EPSG:3785) and spoken description of installation location.
  
 +
 +===== Base station =====
 +
 +If you're looking to compare the location of the base station's antenna to the locations of the sensors as provided in the devices.json, you may assume that the location is:
 +
 +//GeoJSON//
 +<code>
 +{
 + "type": "Point",
 + "coordinates": [65.05809420045529, 25.468898266029942]
 +}
 +</code>
  
  
Line 77: Line 95:
  
 On 22.3.2022 it was brought to our attention that the initial release is missing .csv headers. A fix was implemented by releasing this data again, now including the expected headers. On 22.3.2022 it was brought to our attention that the initial release is missing .csv headers. A fix was implemented by releasing this data again, now including the expected headers.
 +
 +
 +===== Read more =====
 +
 +  * [[services:open-source|Related open source software]]
  • services/indoor-climate-dataset.1648553473.txt.gz
  • Last modified: 2022/03/29 11:31
  • by aleksipirttimaa