hydro_parameters

Data source: api.existenz.ch

7 rows

✎ View and edit SQL

This data as json, CSV (advanced)

unit 6 ✖

Link rowid ▼ name unit description latest_values last_24h_values
1 1 flow m3/s Abfluss m3/s https://api.existenz.ch/apiv1/hydro/latest?parameters=flow https://api.existenz.ch/apiv1/hydro/daterange?parameters=flow
2 2 flow_ls l/s Abfluss l/s https://api.existenz.ch/apiv1/hydro/latest?parameters=flow_ls https://api.existenz.ch/apiv1/hydro/daterange?parameters=flow_ls
3 3 height m Pegel m ü. M. https://api.existenz.ch/apiv1/hydro/latest?parameters=height https://api.existenz.ch/apiv1/hydro/daterange?parameters=height
4 4 height_abs m Pegel m https://api.existenz.ch/apiv1/hydro/latest?parameters=height_abs https://api.existenz.ch/apiv1/hydro/daterange?parameters=height_abs
5 5 oxygen mg/l Sauerstoff https://api.existenz.ch/apiv1/hydro/latest?parameters=oxygen https://api.existenz.ch/apiv1/hydro/daterange?parameters=oxygen
6 6 temperature °C Wassertemperatur https://api.existenz.ch/apiv1/hydro/latest?parameters=temperature https://api.existenz.ch/apiv1/hydro/daterange?parameters=temperature
7 7 turbidity NTU Trübung https://api.existenz.ch/apiv1/hydro/latest?parameters=turbidity https://api.existenz.ch/apiv1/hydro/daterange?parameters=turbidity

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE hydro_parameters (name string, unit real, description text, latest_values string, last_24h_values string);
CREATE UNIQUE INDEX hydro_parameters_name_index ON hydro_parameters(name);