TTN TWIST2018 Dataset
Files | Size | Format | Created | Updated | License | Source |
---|---|---|---|---|---|---|
4 | 8.67 MB | geojson, csv, zip |
Data from The Things Network (TTN) gateways in Zürich, collected as part of ongoing research and originally provided by Benedikt Hitz-Gamper (Institute of Information Systems, University of Bern) fo...
Data Views
Data Files
File | Description | Size | Last modified | Download |
---|---|---|---|---|
ttn_gateways_geojson | 40.1 kB | ttn_gateways_geojson | ||
ttn_gateways | 12.1 kB | ttn_gateways | ||
ttn_measurements_preview | 6.25 kB | ttn_measurements_preview | ||
ttn_measurements | 8.61 MB | ttn_measurements |
Data Previews
Gateways map
Gateways data
Schema
name | type | format |
---|---|---|
device_id | integer | default |
eui_id | string | default |
platform | string | default |
category | string | default |
lat | number | default |
lng | number | default |
altitude | number | default |
ETH_dist | number | default |
Sample data (preview)
Schema
name | type | format |
---|---|---|
id | integer | default |
device_id | integer | default |
last_online | string | default |
rx_ok | number | default |
tx_in | number | default |
measured_at | string | default |
Sample data (compressed)
Data from The Things Network (TTN) gateways in Zürich, collected as part of ongoing research and originally provided by Benedikt Hitz-Gamper (Institute of Information Systems, University of Bern) for the TWIST 2018 hackathon. Uploaded by @gnz and reformatted by @loleg as Geospatial Data Package for publication at DataHub.io
Data files
File ttn_gateways.csv
(134 rows)
device_id
: unique key for device_id in tablettn_measurements
(this is an internal key, not connected with TTN IDs)eui_id
: id used by TTN to uniquely identify gatewaysplatform
: make/model of gateway if providedcategory
: clustered value forplatform
lat
/lng
: location of gateway if providedaltitude
: altitute of gateway if providedETH_dist
: distance from gateway to ETH main building (selection criteria for gateways is < 20km)
File ttn_measurements.csv
(750926 rows)
(Distributed as ZIP-compressed file, with .preview
file available)
id
: unique iddevice_id
: key fordevice_id
in tablettn_gateways
last_online
: last handshake of gateway with TTN backendrx_ok
: number of packets received by this gateway (counter is never reset)tx_in
: number of packets sent by this gateway (counter is never reset)measured_at
: time of measurement
To decide whether a gateway is online, verify the difference of measured_at - last_online
. If difference is smaller than 30 to 90 seconds, the gateway was online at this time.
Note:
Somethimes last_online
is greater than measured_at
, this has to do with the fact that the values get actually stored in the database after measured_at
and sometimes even a newer last_online
is available.
Related datasets
- TTN Mapper data dumps (crowd-sourced network coverage measurements): https://ttnmapper.org/dumps/
- Live data of the NOC API: http://noc.thethingsnetwork.org:8085/api/v2/gateways/eui-[x] (replace
[x]
with gateway EUI) - Ownership data on https://github.com/ttn-zh/gateway-remote-config/
Credit
Data part of ongoing research, provided by Benedikt Hitz-Gamper, Institute of Information Systems, University of Bern, [email protected]
License
The content in this repository is licensed under the CC-BY-SA 4.0 License (see the LICENSE file for details) unless stated otherwise.