hydro_locations
Data source: api.existenz.ch
211 rows where water_body_type = "river" sorted by lon
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
150 | 150 | 2366 | La Rösa | Poschiavino | river | 46.399 | 10.0672 | 802120 | 142010 | https://www.hydrodaten.admin.ch/de/2366.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2366 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2366 | {"title": "2366", "description": "La R\u00f6sa", "alt": "La R\u00f6sa", "link": "/existenz-api/hydro_locations?station_id=2366", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2366.png"} |
41 | 41 | 2079 | Le Prese | Canale industriale | river | 46.2947 | 10.0795 | 803460 | 130460 | https://www.hydrodaten.admin.ch/de/2079.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2079 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2079 | {"title": "2079", "description": "Le Prese", "alt": "Le Prese", "link": "/existenz-api/hydro_locations?station_id=2079", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2079.png"} |
40 | 40 | 2078 | Le Prese | Poschiavino | river | 46.2954 | 10.08 | 803490 | 130530 | https://www.hydrodaten.admin.ch/de/2078.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2078 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2078 | {"title": "2078", "description": "Le Prese", "alt": "Le Prese", "link": "/existenz-api/hydro_locations?station_id=2078", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2078.png"} |
135 | 135 | 2319 | Zernez | Ova da Cluozza | river | 46.6932 | 10.1183 | 804930 | 174830 | https://www.hydrodaten.admin.ch/de/2319.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2319 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2319 | {"title": "2319", "description": "Zernez", "alt": "Zernez", "link": "/existenz-api/hydro_locations?station_id=2319", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2319.png"} |
130 | 130 | 2304 | Zernez, Punt la Drossa | Ova dal Fuorn | river | 46.6551 | 10.19 | 810560 | 170790 | https://www.hydrodaten.admin.ch/de/2304.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2304 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2304 | {"title": "2304", "description": "Zernez, Punt la Drossa", "alt": "Zernez, Punt la Drossa", "link": "/existenz-api/hydro_locations?station_id=2304", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2304.png"} |
109 | 109 | 2239 | Punt dal Gall | Spöl | river | 46.6292 | 10.1947 | 811020 | 167920 | https://www.hydrodaten.admin.ch/de/2239.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2239 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2239 | {"title": "2239", "description": "Punt dal Gall", "alt": "Punt dal Gall", "link": "/existenz-api/hydro_locations?station_id=2239", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2239.png"} |
138 | 138 | 2329 | San Giacomo di Fraéle | Derivazione Spöl | river | 46.5489 | 10.2503 | 815600 | 159150 | https://www.hydrodaten.admin.ch/de/2329.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2329 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2329 | {"title": "2329", "description": "San Giacomo di Fra\u00e9le", "alt": "San Giacomo di Fra\u00e9le", "link": "/existenz-api/hydro_locations?station_id=2329", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2329.png"} |
118 | 118 | 2265 | Tarasp | Inn | river | 46.789 | 10.2786 | 816800 | 185910 | https://www.hydrodaten.admin.ch/de/2265.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2265 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2265 | {"title": "2265", "description": "Tarasp", "alt": "Tarasp", "link": "/existenz-api/hydro_locations?station_id=2265", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2265.png"} |
235 | 235 | 2639 | Martina, Sclamischot | Inn | river | 46.8704 | 10.4461 | 829232 | 195429 | https://www.hydrodaten.admin.ch/de/2639.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2639 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2639 | {"title": "2639", "description": "Martina, Sclamischot", "alt": "Martina, Sclamischot", "link": "/existenz-api/hydro_locations?station_id=2639", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2639.png"} |
225 | 225 | 2617 | Müstair | Rom | river | 46.6296 | 10.4532 | 830800 | 168700 | https://www.hydrodaten.admin.ch/de/2617.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2617 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2617 | {"title": "2617", "description": "M\u00fcstair", "alt": "M\u00fcstair", "link": "/existenz-api/hydro_locations?station_id=2617", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2617.png"} |
33 | 33 | 2067 | Martina | Inn | river | 46.8858 | 10.4654 | 830640 | 197190 | https://www.hydrodaten.admin.ch/de/2067.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2067 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2067 | {"title": "2067", "description": "Martina", "alt": "Martina", "link": "/existenz-api/hydro_locations?station_id=2067", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2067.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);