hydro_locations

Data source: api.existenz.ch

3 rows where water_body_name = "Thur" and water_body_type = "river"

✖
✖
✖

✎ View and edit SQL

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
27 27 2044 Andelfingen Thur river 47.5965 8.682 693510 272500 https://www.hydrodaten.admin.ch/de/2044.html https://api.existenz.ch/apiv1/hydro/latest?locations=2044 https://api.existenz.ch/apiv1/hydro/daterange?locations=2044 {"title": "2044", "description": "Andelfingen", "alt": "Andelfingen", "link": "/existenz-api/hydro_locations?station_id=2044", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2044.png"}
92 92 2181 Halden Thur river 47.5058 9.2115 733560 263180 https://www.hydrodaten.admin.ch/de/2181.html https://api.existenz.ch/apiv1/hydro/latest?locations=2181 https://api.existenz.ch/apiv1/hydro/daterange?locations=2181 {"title": "2181", "description": "Halden", "alt": "Halden", "link": "/existenz-api/hydro_locations?station_id=2181", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2181.png"}
129 129 2303 Jonschwil, Mühlau Thur river 47.4137 9.0775 723675 252720 https://www.hydrodaten.admin.ch/de/2303.html https://api.existenz.ch/apiv1/hydro/latest?locations=2303 https://api.existenz.ch/apiv1/hydro/daterange?locations=2303 {"title": "2303", "description": "Jonschwil, M\u00fchlau", "alt": "Jonschwil, M\u00fchlau", "link": "/existenz-api/hydro_locations?station_id=2303", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2303.png"}

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);