home / existenz-api

sensors_locations

Data source: api.existenz.ch

3 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: lat, lon, source

Link rowid ▼ name lat lon device_id brand model source latest_values last_24h_values popup
1 1 balkon 47.0 7.5 eui-a84041a56182d2c8 Dragino LHT65 Existenz.ch Custom Sensors Network 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"}
2 2 c1 47.0 7.5   ELV WS980 Existenz.ch Custom Sensors Network https://api.existenz.ch/apiv1/sensors/latest?locations=c1 https://api.existenz.ch/apiv1/sensors/daterange?locations=c1 {"title": "c1", "description": "c1", "alt": "c1", "link": "/existenz-api/sensors_locations?name=c1"}
3 3 temperaare_olten 47.35 7.9       TemperAare by Tobias Oetiker https://api.existenz.ch/apiv1/sensors/latest?locations=temperaare_olten https://api.existenz.ch/apiv1/sensors/daterange?locations=temperaare_olten {"title": "temperaare_olten", "description": "temperaare_olten", "alt": "temperaare_olten", "link": "/existenz-api/sensors_locations?name=temperaare_olten"}

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, source string, latest_values string, last_24h_values string, popup);
CREATE UNIQUE INDEX sensors_locations_name_index ON sensors_locations(name);
Powered by Datasette · Queries took 19.288ms · Data source: api.existenz.ch