hydro_locations

Data source: api.existenz.ch

3 rows where water_body_name = "Murg"

✎ 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
68 68 2126 Wängi Murg river 47.4963 8.953 714105 261720 https://www.hydrodaten.admin.ch/de/2126.html https://api.existenz.ch/apiv1/hydro/latest?locations=2126 https://api.existenz.ch/apiv1/hydro/daterange?locations=2126 {"title": "2126", "description": "W\u00e4ngi", "alt": "W\u00e4ngi", "link": "/existenz-api/hydro_locations?station_id=2126", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2126.png"}
159 159 2386 Frauenfeld Murg river 47.5685 8.8944 709540 269660 https://www.hydrodaten.admin.ch/de/2386.html https://api.existenz.ch/apiv1/hydro/latest?locations=2386 https://api.existenz.ch/apiv1/hydro/daterange?locations=2386 {"title": "2386", "description": "Frauenfeld", "alt": "Frauenfeld", "link": "/existenz-api/hydro_locations?station_id=2386", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2386.png"}
191 191 2471 Murgenthal, Walliswil Murg river 47.2523 7.8262 629340 233555 https://www.hydrodaten.admin.ch/de/2471.html https://api.existenz.ch/apiv1/hydro/latest?locations=2471 https://api.existenz.ch/apiv1/hydro/daterange?locations=2471 {"title": "2471", "description": "Murgenthal, Walliswil", "alt": "Murgenthal, Walliswil", "link": "/existenz-api/hydro_locations?station_id=2471", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2471.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);