hydro_locations
Data source: api.existenz.ch
211 rows where water_body_type = "river" sorted by lat
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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"} |
75 | 75 | 2143 | Rekingen | Rhein | river | 47.5703 | 8.3298 | 667060 | 269230 | https://www.hydrodaten.admin.ch/de/2143.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2143 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2143 | {"title": "2143", "description": "Rekingen", "alt": "Rekingen", "link": "/existenz-api/hydro_locations?station_id=2143", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2143.png"} |
168 | 168 | 2415 | Rheinsfelden | Glatt | river | 47.5735 | 8.4758 | 678040 | 269720 | https://www.hydrodaten.admin.ch/de/2415.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2415 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2415 | {"title": "2415", "description": "Rheinsfelden", "alt": "Rheinsfelden", "link": "/existenz-api/hydro_locations?station_id=2415", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2415.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"} |
61 | 61 | 2113 | Klingnau | Aare | river | 47.5941 | 8.2251 | 659150 | 271790 | https://www.hydrodaten.admin.ch/de/2113.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2113 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2113 | {"title": "2113", "description": "Klingnau", "alt": "Klingnau", "link": "/existenz-api/hydro_locations?station_id=2113", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2113.png"} |
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"} |
223 | 223 | 2613 | Weil, Palmrainbrücke | Rhein | river | 47.6014 | 7.5947 | 611740 | 272310 | https://www.hydrodaten.admin.ch/de/2613.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2613 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2613 | {"title": "2613", "description": "Weil, Palmrainbr\u00fccke", "alt": "Weil, Palmrainbr\u00fccke", "link": "/existenz-api/hydro_locations?station_id=2613", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2613.png"} |
62 | 62 | 2116 | Koblenz | Rhein | river | 47.609 | 8.2343 | 659830 | 273450 | https://www.hydrodaten.admin.ch/de/2116.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2116 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2116 | {"title": "2116", "description": "Koblenz", "alt": "Koblenz", "link": "/existenz-api/hydro_locations?station_id=2116", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2116.png"} |
161 | 161 | 2392 | Rheinau | Rhein (Oberwasser) | river | 47.6391 | 8.6019 | 687420 | 277140 | https://www.hydrodaten.admin.ch/de/2392.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2392 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2392 | {"title": "2392", "description": "Rheinau", "alt": "Rheinau", "link": "/existenz-api/hydro_locations?station_id=2392", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2392.png"} |
125 | 125 | 2288 | Neuhausen, Flurlingerbrücke | Rhein | river | 47.6815 | 8.6263 | 689180 | 281880 | https://www.hydrodaten.admin.ch/de/2288.html | https://api.existenz.ch/apiv1/hydro/latest?locations=2288 | https://api.existenz.ch/apiv1/hydro/daterange?locations=2288 | {"title": "2288", "description": "Neuhausen, Flurlingerbr\u00fccke", "alt": "Neuhausen, Flurlingerbr\u00fccke", "link": "/existenz-api/hydro_locations?station_id=2288", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P2288.png"} |
240 | 240 | 4601 | Buch | Biber | river | 47.7151 | 8.7924 | 701590 | 285825 | https://www.hydrodaten.admin.ch/de/4601.html | https://api.existenz.ch/apiv1/hydro/latest?locations=4601 | https://api.existenz.ch/apiv1/hydro/daterange?locations=4601 | {"title": "4601", "description": "Buch", "alt": "Buch", "link": "/existenz-api/hydro_locations?station_id=4601", "image": "https://www.hydrodaten.admin.ch/documents/Stationsbilder/P4601.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);