hydro_locations
Data source: api.existenz.ch
3 rows where water_body_name = "Lac Léman" and water_body_type = "lake" sorted by name
This data as json, CSV (advanced)
Link | rowid | station_id | name ▼ | water_body_name | water_body_type | lat | lon | chx | chy | link | latest_values | last_24h_values | popup |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16 | 16 | 2026 | Chillon | Lac Léman | lake | 46.4146 | 6.9277 | 560720 | 140490 | https://www.hydrodaten.admin.ch/de/2026.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2026 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2026 | {"title": "2026", "description": "Chillon", "alt": "Chillon", "link": "/existenz-api/hydro_locations?station_id=2026", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2026.png"} |
18 | 18 | 2028 | Genève, Sécheron | Lac Léman | lake | 46.2186 | 6.1524 | 500750 | 119390 | https://www.hydrodaten.admin.ch/de/2028.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2028 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2028 | {"title": "2028", "description": "Gen\u00e8ve, S\u00e9cheron", "alt": "Gen\u00e8ve, S\u00e9cheron", "link": "/existenz-api/hydro_locations?station_id=2028", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2028.png"} |
17 | 17 | 2027 | St-Prex | Lac Léman | lake | 46.4828 | 6.4611 | 524940 | 148410 | https://www.hydrodaten.admin.ch/de/2027.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2027 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2027 | {"title": "2027", "description": "St-Prex", "alt": "St-Prex", "link": "/existenz-api/hydro_locations?station_id=2027", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2027.png"} |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE hydro_locations (station_id string, name string, water_body_name string, water_body_type string, lat real, lon real, chx integer, chy integer, link string, latest_values string, last_24h_values string, popup); CREATE UNIQUE INDEX hydro_locations_station_id_index ON hydro_locations(station_id);