sensors_parameters

Data source: api.existenz.ch

5 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

Link rowid ▼ name unit dragino_name temperaare_name latest_values last_24h_values
1 1 bat V BatV volt https://api.existenz.ch/apiv1/sensors/latest?parameters=bat https://api.existenz.ch/apiv1/sensors/daterange?parameters=bat
2 2 bat_status # Bat_status   https://api.existenz.ch/apiv1/sensors/latest?parameters=bat_status https://api.existenz.ch/apiv1/sensors/daterange?parameters=bat_status
3 3 rh % Hum_SHT   https://api.existenz.ch/apiv1/sensors/latest?parameters=rh https://api.existenz.ch/apiv1/sensors/daterange?parameters=rh
4 4 tt °C TempC_SHT celsius2 https://api.existenz.ch/apiv1/sensors/latest?parameters=tt https://api.existenz.ch/apiv1/sensors/daterange?parameters=tt
5 5 tt_water °C TempC_DS celsius1 https://api.existenz.ch/apiv1/sensors/latest?parameters=tt_water https://api.existenz.ch/apiv1/sensors/daterange?parameters=tt_water

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE sensors_parameters ('name' string, 'unit' real, 'dragino_name' string, 'temperaare_name' string, 'latest_values' string, 'last_24h_values' string);
CREATE UNIQUE INDEX sensors_parameters_name_index ON sensors_parameters(name);