Data source: api.existenz.ch

5 rows

View and edit SQL

Link rowid ▼ name unit type description latest_values last_24h_values
1 flow m3/s 10.0 Abfluss m3/s https://api.existenz.ch/apiv1/hydro/latest?parameters=flow https://api.existenz.ch/apiv1/hydro/daterange?parameters=flow
2 flow_ls l/s 22.0 Abfluss l/s https://api.existenz.ch/apiv1/hydro/latest?parameters=flow_ls https://api.existenz.ch/apiv1/hydro/daterange?parameters=flow_ls
3 height m ü. M. 2.0 Pegel m ü. M. https://api.existenz.ch/apiv1/hydro/latest?parameters=height https://api.existenz.ch/apiv1/hydro/daterange?parameters=height
4 height_abs m 1.0 Pegel m https://api.existenz.ch/apiv1/hydro/latest?parameters=height_abs https://api.existenz.ch/apiv1/hydro/daterange?parameters=height_abs
5 temperature °C 3.0 Temperatur https://api.existenz.ch/apiv1/hydro/latest?parameters=temperature https://api.existenz.ch/apiv1/hydro/daterange?parameters=temperature

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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