API Access
Access dataset files directly from scripts, code, or AI agents.
Browse dataset files
API Access
Access dataset files directly from scripts, code, or AI agents.
Each file has a stable URL (r-link) that you can use directly in scripts, apps, or AI agents. These URLs are permanent and safe to hardcode.
Start with these files — they give you everything you need to understand and access the dataset.
- 1. Download data resources listed in the metadata file
- 2. Read README.md for full context
Data Views
Data Files
Explore with AIGateways map
Download
Download GEOJSONAbout
- Format
- GEOJSON
- File size
- 40.1 kB
Gateways data
| Field | 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 |
Download
Download CSVAbout
- Total rows
- ...
- Format
- CSV
- File size
- 12.1 kB
Sample data (preview)
| Field | 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 |
Download
Download CSVAbout
- Total rows
- ...
- Format
- CSV
- File size
- 6.25 kB
Sample data (compressed)
Download
Download ZIPAbout
- Format
- ZIP
- File size
- 8.61 MB
About this dataset
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 forplatformlat/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_idin tablettn_gatewayslast_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, benedikt.hitz@iwi.unibe.ch
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.
