hydro_locations

Data source: api.existenz.ch

3 rows where water_body_name = "Linth"

✎ 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
55 55 2104 Weesen, Biäsche Linth river 47.1316 9.0884 725160 221380 https://www.hydrodaten.admin.ch/de/2104.html https://api.existenz.ch/apiv1/hydro/latest?locations=2104 https://api.existenz.ch/apiv1/hydro/daterange?locations=2104 {"title": "2104", "description": "Weesen, Bi\u00e4sche", "alt": "Weesen, Bi\u00e4sche", "link": "/existenz-api/hydro_locations?station_id=2104", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2104.png"}
145 145 2352 Linthal, Ausgleichsbecken KLL Linth river 46.9164 8.9915 718285 197310 https://www.hydrodaten.admin.ch/de/2352.html https://api.existenz.ch/apiv1/hydro/latest?locations=2352 https://api.existenz.ch/apiv1/hydro/daterange?locations=2352 {"title": "2352", "description": "Linthal, Ausgleichsbecken KLL", "alt": "Linthal, Ausgleichsbecken KLL", "link": "/existenz-api/hydro_locations?station_id=2352", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2352.png"}
155 155 2372 Mollis, Linthbrücke Linth river 47.1011 9.072 723985 217965 https://www.hydrodaten.admin.ch/de/2372.html https://api.existenz.ch/apiv1/hydro/latest?locations=2372 https://api.existenz.ch/apiv1/hydro/daterange?locations=2372 {"title": "2372", "description": "Mollis, Linthbr\u00fccke", "alt": "Mollis, Linthbr\u00fccke", "link": "/existenz-api/hydro_locations?station_id=2372", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2372.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);