Data source: api.existenz.ch

1 row

View and edit SQL

Link rowid ▼ name lat lon device_id brand model latest_values last_24h_values popup
1 balkon 46.9 7.4 eui-a84041a56182d2c8 Dragino LHT65 https://api.existenz.ch/apiv1/sensors/latest?locations=balkon https://api.existenz.ch/apiv1/sensors/daterange?locations=balkon {"title": "balkon", "description": "balkon", "alt": "balkon", "link": "/existenz-api/sensors_locations?name=balkon"}

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE sensors_locations (name string, lat real, lon real, device_id string, brand string, model string, latest_values string, last_24h_values string, popup);
CREATE UNIQUE INDEX sensors_locations_name_index ON sensors_locations(name);