hydro_locations
Data source: api.existenz.ch
211 rows where water_body_type = "river" sorted by water_body_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
216 | 216 | 2605 | Lavertezzo, Campiöi | Verzasca | river | 46.249 | 8.8446 | 708420 | 122920 | https://www.hydrodaten.admin.ch/de/2605.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2605 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2605 | {"title": "2605", "description": "Lavertezzo, Campi\u00f6i", "alt": "Lavertezzo, Campi\u00f6i", "link": "/existenz-api/hydro_locations?station_id=2605", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2605.png"} |
201 | 201 | 2486 | Vevey, Coppet | Veveyse | river | 46.4689 | 6.8485 | 554675 | 146565 | https://www.hydrodaten.admin.ch/de/2486.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2486 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2486 | {"title": "2486", "description": "Vevey, Coppet", "alt": "Vevey, Coppet", "link": "/existenz-api/hydro_locations?station_id=2486", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2486.png"} |
144 | 144 | 2351 | Visp | Vispa | river | 46.2742 | 7.8817 | 634150 | 124850 | https://www.hydrodaten.admin.ch/de/2351.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2351 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2351 | {"title": "2351", "description": "Visp", "alt": "Visp", "link": "/existenz-api/hydro_locations?station_id=2351", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2351.png"} |
23 | 23 | 2033 | Ilanz | Vorderrhein | river | 46.7758 | 9.2064 | 735000 | 182030 | https://www.hydrodaten.admin.ch/de/2033.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2033 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2033 | {"title": "2033", "description": "Ilanz", "alt": "Ilanz", "link": "/existenz-api/hydro_locations?station_id=2033", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2033.png"} |
96 | 96 | 2200 | Zweilütschinen | Weisse Lütschine | river | 46.6313 | 7.8997 | 635310 | 164550 | https://www.hydrodaten.admin.ch/de/2200.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2200 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2200 | {"title": "2200", "description": "Zweil\u00fctschinen", "alt": "Zweil\u00fctschinen", "link": "/existenz-api/hydro_locations?station_id=2200", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2200.png"} |
94 | 94 | 2187 | Salez | Werdenberger Binnenkanal | river | 47.2383 | 9.5096 | 756795 | 234005 | https://www.hydrodaten.admin.ch/de/2187.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2187 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2187 | {"title": "2187", "description": "Salez", "alt": "Salez", "link": "/existenz-api/hydro_locations?station_id=2187", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2187.png"} |
81 | 81 | 2156 | Gerlafingen | Werkkanal | river | 47.1638 | 7.5543 | 608770 | 223650 | https://www.hydrodaten.admin.ch/de/2156.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2156 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2156 | {"title": "2156", "description": "Gerlafingen", "alt": "Gerlafingen", "link": "/existenz-api/hydro_locations?station_id=2156", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2156.png"} |
95 | 95 | 2199 | Basel | Wiese | river | 47.5779 | 7.5955 | 611800 | 269700 | https://www.hydrodaten.admin.ch/de/2199.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2199 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2199 | {"title": "2199", "description": "Basel", "alt": "Basel", "link": "/existenz-api/hydro_locations?station_id=2199", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2199.png"} |
183 | 183 | 2450 | Zofingen | Wigger | river | 47.2835 | 7.9354 | 637580 | 237080 | https://www.hydrodaten.admin.ch/de/2450.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2450 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2450 | {"title": "2450", "description": "Zofingen", "alt": "Zofingen", "link": "/existenz-api/hydro_locations?station_id=2450", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2450.png"} |
212 | 212 | 2500 | Ittigen | Worble | river | 46.9732 | 7.4781 | 603005 | 202455 | https://www.hydrodaten.admin.ch/de/2500.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2500 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2500 | {"title": "2500", "description": "Ittigen", "alt": "Ittigen", "link": "/existenz-api/hydro_locations?station_id=2500", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2500.png"} |
181 | 181 | 2446 | Gampelen, Zihlbrücke | Zihlkanal | river | 47.0211 | 7.0342 | 569250 | 207860 | https://www.hydrodaten.admin.ch/de/2446.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2446 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2446 | {"title": "2446", "description": "Gampelen, Zihlbr\u00fccke", "alt": "Gampelen, Zihlbr\u00fccke", "link": "/existenz-api/hydro_locations?station_id=2446", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2446.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);