hydro_locations
Data source: api.existenz.ch
2 rows where water_body_name = "Lago di Lugano" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
53 | 53 | 2101 | Melide, Ferrera | Lago di Lugano | lake | 45.9663 | 8.9489 | 717070 | 91650 | https://www.hydrodaten.admin.ch/de/2101.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2101 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2101 | {"title": "2101", "description": "Melide, Ferrera", "alt": "Melide, Ferrera", "link": "/existenz-api/hydro_locations?station_id=2101", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2101.png"} |
11 | 11 | 2021 | Ponte Tresa | Lago di Lugano | lake | 45.9688 | 8.8603 | 710200 | 91800 | https://www.hydrodaten.admin.ch/de/2021.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2021 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2021 | {"title": "2021", "description": "Ponte Tresa", "alt": "Ponte Tresa", "link": "/existenz-api/hydro_locations?station_id=2021", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2021.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);