Data source: api.existenz.ch

243 rows sorted by rowid descending

View and edit SQL

Suggested facets: water_body_type

Link rowid ▲ station_id name water_body_name water_body_type lat lon chx chy link latest_values last_24h_values popup
243 C384 Simplonpass Bisse kalte Wasser river 46.2459 8.0361 646080 121780 https://api.existenz.ch/apiv1/hydro/latest?locations=C384 https://api.existenz.ch/apiv1/hydro/daterange?locations=C384 {"title": "C384", "description": "Simplonpass", "alt": "Simplonpass", "link": "/existenz-api/hydro_locations?station_id=C384", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/PC384.jpg"}
242 A270 Combe des Sarrasins Doubs river 47.1955 6.8782 557530 227320 https://api.existenz.ch/apiv1/hydro/latest?locations=A270 https://api.existenz.ch/apiv1/hydro/daterange?locations=A270 {"title": "A270", "description": "Combe des Sarrasins", "alt": "Combe des Sarrasins", "link": "/existenz-api/hydro_locations?station_id=A270", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/PA270.jpg"}
241 9632 Chur Untertorer Mühlbach river 46.8473 9.5356 759926 190599 https://api.existenz.ch/apiv1/hydro/latest?locations=9632 https://api.existenz.ch/apiv1/hydro/daterange?locations=9632 {"title": "9632", "description": "Chur", "alt": "Chur", "link": "/existenz-api/hydro_locations?station_id=9632", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P9632.jpg"}
240 9020 Bellinzona Ticino river 46.1938 9.0093 721245 117025 https://api.existenz.ch/apiv1/hydro/latest?locations=9020 https://api.existenz.ch/apiv1/hydro/daterange?locations=9020 {"title": "9020", "description": "Bellinzona", "alt": "Bellinzona", "link": "/existenz-api/hydro_locations?station_id=9020", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P9020.jpg"}
239 520 Rämismühle Töss river 47.443 8.8148 703795 255605 https://api.existenz.ch/apiv1/hydro/latest?locations=520 https://api.existenz.ch/apiv1/hydro/daterange?locations=520 {"title": "520", "description": "R\u00e4mism\u00fchle", "alt": "R\u00e4mism\u00fchle", "link": "/existenz-api/hydro_locations?station_id=520", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P520.jpg"}
238 4601 Buch Biber river 47.7151 8.7924 701590 285825 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/lhg/sdi/station_pics/P4601.jpg"}
237 2643 Montlingen Rhein river 47.3337 9.5947 762945 244778 https://api.existenz.ch/apiv1/hydro/latest?locations=2643 https://api.existenz.ch/apiv1/hydro/daterange?locations=2643 {"title": "2643", "description": "Montlingen", "alt": "Montlingen", "link": "/existenz-api/hydro_locations?station_id=2643", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2643.jpg"}
236 2642 Neuchâtel, Nid-du-Crô Lac de Neuchâtel lake 46.9965 6.951 562913 205165 https://api.existenz.ch/apiv1/hydro/latest?locations=2642 https://api.existenz.ch/apiv1/hydro/daterange?locations=2642 {"title": "2642", "description": "Neuch\u00e2tel, Nid-du-Cr\u00f4", "alt": "Neuch\u00e2tel, Nid-du-Cr\u00f4", "link": "/existenz-api/hydro_locations?station_id=2642", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2642.jpg"}
235 2640 Delémont Sorne river 47.3643 7.351 593380 245940 https://api.existenz.ch/apiv1/hydro/latest?locations=2640 https://api.existenz.ch/apiv1/hydro/daterange?locations=2640 {"title": "2640", "description": "Del\u00e9mont", "alt": "Del\u00e9mont", "link": "/existenz-api/hydro_locations?station_id=2640", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2640.jpg"}
234 2636 Muotathal, Hölloch Hölloch river 46.9764 8.7884 702700 203700 https://api.existenz.ch/apiv1/hydro/latest?locations=2636 https://api.existenz.ch/apiv1/hydro/daterange?locations=2636 {"title": "2636", "description": "Muotathal, H\u00f6lloch", "alt": "Muotathal, H\u00f6lloch", "link": "/existenz-api/hydro_locations?station_id=2636", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2636.jpg"}
233 2635 Einsiedeln, Gross Grossbach river 47.1065 8.7655 700710 218125 https://api.existenz.ch/apiv1/hydro/latest?locations=2635 https://api.existenz.ch/apiv1/hydro/daterange?locations=2635 {"title": "2635", "description": "Einsiedeln, Gross", "alt": "Einsiedeln, Gross", "link": "/existenz-api/hydro_locations?station_id=2635", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2635.jpg"}
232 2634 Emmen Kleine Emme river 47.072 8.2753 663550 213785 https://api.existenz.ch/apiv1/hydro/latest?locations=2634 https://api.existenz.ch/apiv1/hydro/daterange?locations=2634 {"title": "2634", "description": "Emmen", "alt": "Emmen", "link": "/existenz-api/hydro_locations?station_id=2634", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2634.jpg"}
231 2632 Mühlbach. Trennbauwerk Sand Mühlbach river 46.8453 9.5373 760059 190378 https://api.existenz.ch/apiv1/hydro/latest?locations=2632 https://api.existenz.ch/apiv1/hydro/daterange?locations=2632 {"title": "2632", "description": "M\u00fchlbach. Trennbauwerk Sand", "alt": "M\u00fchlbach. Trennbauwerk Sand", "link": "/existenz-api/hydro_locations?station_id=2632", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2632.jpg"}
230 2631 Hinterrhein, Schiessplatz Hinterrhein river 46.5234 9.1813 733706 153945 https://api.existenz.ch/apiv1/hydro/latest?locations=2631 https://api.existenz.ch/apiv1/hydro/daterange?locations=2631 {"title": "2631", "description": "Hinterrhein, Schiessplatz", "alt": "Hinterrhein, Schiessplatz", "link": "/existenz-api/hydro_locations?station_id=2631", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2631.jpg"}
229 2630 Sion Sionne river 46.2305 7.366 594400 119900 https://api.existenz.ch/apiv1/hydro/latest?locations=2630 https://api.existenz.ch/apiv1/hydro/daterange?locations=2630 {"title": "2630", "description": "Sion", "alt": "Sion", "link": "/existenz-api/hydro_locations?station_id=2630", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2630.jpg"}
228 2629 Agno Vedeggio river 46.003 8.9117 714110 95680 https://api.existenz.ch/apiv1/hydro/latest?locations=2629 https://api.existenz.ch/apiv1/hydro/daterange?locations=2629 {"title": "2629", "description": "Agno", "alt": "Agno", "link": "/existenz-api/hydro_locations?station_id=2629", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2629.jpg"}
227 2623 Oberwald Rhône river 46.5344 8.3494 669870 154080 https://api.existenz.ch/apiv1/hydro/latest?locations=2623 https://api.existenz.ch/apiv1/hydro/daterange?locations=2623 {"title": "2623", "description": "Oberwald", "alt": "Oberwald", "link": "/existenz-api/hydro_locations?station_id=2623", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2623.jpg"}
226 2620 Soglio Mera river 46.3332 9.5268 760770 133450 https://api.existenz.ch/apiv1/hydro/latest?locations=2620 https://api.existenz.ch/apiv1/hydro/daterange?locations=2620 {"title": "2620", "description": "Soglio", "alt": "Soglio", "link": "/existenz-api/hydro_locations?station_id=2620", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2620.jpg"}
225 2617 Müstair Rom river 46.6296 10.4532 830800 168700 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/lhg/sdi/station_pics/P2617.jpg"}
224 2615 Basel LHG Rhein river 47.5617 7.5867 611140 267900 https://api.existenz.ch/apiv1/hydro/latest?locations=2615 https://api.existenz.ch/apiv1/hydro/daterange?locations=2615 {"title": "2615", "description": "Basel LHG", "alt": "Basel LHG", "link": "/existenz-api/hydro_locations?station_id=2615", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2615.jpg"}
223 2613 Weil, Palmrainbrücke Rhein river 47.6014 7.5947 611740 272310 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/lhg/sdi/station_pics/P2613.jpg"}
222 2612 Lavertezzo Riale di Pincascia river 46.2583 8.8401 708060 123950 https://api.existenz.ch/apiv1/hydro/latest?locations=2612 https://api.existenz.ch/apiv1/hydro/daterange?locations=2612 {"title": "2612", "description": "Lavertezzo", "alt": "Lavertezzo", "link": "/existenz-api/hydro_locations?station_id=2612", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2612.jpg"}
221 2610 Vicques Scheulte river 47.3482 7.4318 599485 244150 https://api.existenz.ch/apiv1/hydro/latest?locations=2610 https://api.existenz.ch/apiv1/hydro/daterange?locations=2610 {"title": "2610", "description": "Vicques", "alt": "Vicques", "link": "/existenz-api/hydro_locations?station_id=2610", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2610.jpg"}
220 2609 Einsiedeln Alp river 47.1508 8.7393 698640 223020 https://api.existenz.ch/apiv1/hydro/latest?locations=2609 https://api.existenz.ch/apiv1/hydro/daterange?locations=2609 {"title": "2609", "description": "Einsiedeln", "alt": "Einsiedeln", "link": "/existenz-api/hydro_locations?station_id=2609", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2609.jpg"}
219 2608 Neuenkirch Sellenbodenbach river 47.113 8.2098 658530 218290 https://api.existenz.ch/apiv1/hydro/latest?locations=2608 https://api.existenz.ch/apiv1/hydro/daterange?locations=2608 {"title": "2608", "description": "Neuenkirch", "alt": "Neuenkirch", "link": "/existenz-api/hydro_locations?station_id=2608", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2608.jpg"}
218 2607 Oberwald Goneri river 46.532 8.3578 670520 153830 https://api.existenz.ch/apiv1/hydro/latest?locations=2607 https://api.existenz.ch/apiv1/hydro/daterange?locations=2607 {"title": "2607", "description": "Oberwald", "alt": "Oberwald", "link": "/existenz-api/hydro_locations?station_id=2607", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2607.jpg"}
217 2606 Genève, Halle de l'Île Rhône river 46.2047 6.1415 499890 117850 https://api.existenz.ch/apiv1/hydro/latest?locations=2606 https://api.existenz.ch/apiv1/hydro/daterange?locations=2606 {"title": "2606", "description": "Gen\u00e8ve, Halle de l'\u00cele", "alt": "Gen\u00e8ve, Halle de l'\u00cele", "link": "/existenz-api/hydro_locations?station_id=2606", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2606.jpg"}
216 2605 Lavertezzo, Campiöi Verzasca river 46.249 8.8446 708420 122920 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/lhg/sdi/station_pics/P2605.jpg"}
215 2604 Biberbrugg Biber river 47.1533 8.7209 697240 223280 https://api.existenz.ch/apiv1/hydro/latest?locations=2604 https://api.existenz.ch/apiv1/hydro/daterange?locations=2604 {"title": "2604", "description": "Biberbrugg", "alt": "Biberbrugg", "link": "/existenz-api/hydro_locations?station_id=2604", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2604.jpg"}
214 2603 Langnau Ilfis river 46.9379 7.7974 627320 198600 https://api.existenz.ch/apiv1/hydro/latest?locations=2603 https://api.existenz.ch/apiv1/hydro/daterange?locations=2603 {"title": "2603", "description": "Langnau", "alt": "Langnau", "link": "/existenz-api/hydro_locations?station_id=2603", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2603.jpg"}
213 2602 Domat/Ems Rhein river 46.8377 9.4561 753890 189370 https://api.existenz.ch/apiv1/hydro/latest?locations=2602 https://api.existenz.ch/apiv1/hydro/daterange?locations=2602 {"title": "2602", "description": "Domat/Ems", "alt": "Domat/Ems", "link": "/existenz-api/hydro_locations?station_id=2602", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2602.jpg"}
212 2500 Ittigen Worble river 46.9732 7.4781 603005 202455 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/lhg/sdi/station_pics/P2500.jpg"}
211 2499 Muotathal Schlichenden Brünnen river 46.9731 8.7843 702392 203328 https://api.existenz.ch/apiv1/hydro/latest?locations=2499 https://api.existenz.ch/apiv1/hydro/daterange?locations=2499 {"title": "2499", "description": "Muotathal", "alt": "Muotathal", "link": "/existenz-api/hydro_locations?station_id=2499", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2499.jpg"}
210 2498 Castrisch Glenner river 46.7735 9.2106 735330 181790 https://api.existenz.ch/apiv1/hydro/latest?locations=2498 https://api.existenz.ch/apiv1/hydro/daterange?locations=2498 {"title": "2498", "description": "Castrisch", "alt": "Castrisch", "link": "/existenz-api/hydro_locations?station_id=2498", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2498.jpg"}
209 2497 Nebikon Luthern river 47.1904 7.9738 640560 226740 https://api.existenz.ch/apiv1/hydro/latest?locations=2497 https://api.existenz.ch/apiv1/hydro/daterange?locations=2497 {"title": "2497", "description": "Nebikon", "alt": "Nebikon", "link": "/existenz-api/hydro_locations?station_id=2497", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2497.jpg"}
208 2494 Pollegio, Campagna Ticino river 46.3593 8.9475 716120 135330 https://api.existenz.ch/apiv1/hydro/latest?locations=2494 https://api.existenz.ch/apiv1/hydro/daterange?locations=2494 {"title": "2494", "description": "Pollegio, Campagna", "alt": "Pollegio, Campagna", "link": "/existenz-api/hydro_locations?station_id=2494", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2494.jpg"}
207 2493 Gland, Route Suisse Promenthouse river 46.406 6.2693 510080 140080 https://api.existenz.ch/apiv1/hydro/latest?locations=2493 https://api.existenz.ch/apiv1/hydro/daterange?locations=2493 {"title": "2493", "description": "Gland, Route Suisse", "alt": "Gland, Route Suisse", "link": "/existenz-api/hydro_locations?station_id=2493", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2493.jpg"}
206 2492 Buerglen, EW Altdorf Dorfbachableitung river 46.8758 8.6592 693040 192350 https://api.existenz.ch/apiv1/hydro/latest?locations=2492 https://api.existenz.ch/apiv1/hydro/daterange?locations=2492 {"title": "2492", "description": "Buerglen, EW Altdorf", "alt": "Buerglen, EW Altdorf", "link": "/existenz-api/hydro_locations?station_id=2492", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2492.jpg"}
205 2491 Bürglen, Galgenwäldli Schächen river 46.8709 8.6517 692480 191800 https://api.existenz.ch/apiv1/hydro/latest?locations=2491 https://api.existenz.ch/apiv1/hydro/daterange?locations=2491 {"title": "2491", "description": "B\u00fcrglen, Galgenw\u00e4ldli", "alt": "B\u00fcrglen, Galgenw\u00e4ldli", "link": "/existenz-api/hydro_locations?station_id=2491", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2491.jpg"}
204 2490 Dardagny, Les Granges Allondon river 46.2174 5.9985 488880 119460 https://api.existenz.ch/apiv1/hydro/latest?locations=2490 https://api.existenz.ch/apiv1/hydro/daterange?locations=2490 {"title": "2490", "description": "Dardagny, Les Granges", "alt": "Dardagny, Les Granges", "link": "/existenz-api/hydro_locations?station_id=2490", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2490.jpg"}
203 2488 Latterbach Simme river 46.6617 7.5782 610680 167840 https://api.existenz.ch/apiv1/hydro/latest?locations=2488 https://api.existenz.ch/apiv1/hydro/daterange?locations=2488 {"title": "2488", "description": "Latterbach", "alt": "Latterbach", "link": "/existenz-api/hydro_locations?station_id=2488", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2488.jpg"}
202 2487 Werthenstein, Chappelboden Kleine Emme river 47.0349 8.0684 647870 209510 https://api.existenz.ch/apiv1/hydro/latest?locations=2487 https://api.existenz.ch/apiv1/hydro/daterange?locations=2487 {"title": "2487", "description": "Werthenstein, Chappelboden", "alt": "Werthenstein, Chappelboden", "link": "/existenz-api/hydro_locations?station_id=2487", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2487.jpg"}
201 2486 Vevey, Coppet Veveyse river 46.4689 6.8485 554675 146565 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/lhg/sdi/station_pics/P2486.jpg"}
200 2485 Boncourt, Frontière Allaine river 47.5008 7.0117 567830 261200 https://api.existenz.ch/apiv1/hydro/latest?locations=2485 https://api.existenz.ch/apiv1/hydro/daterange?locations=2485 {"title": "2485", "description": "Boncourt, Fronti\u00e8re", "alt": "Boncourt, Fronti\u00e8re", "link": "/existenz-api/hydro_locations?station_id=2485", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2485.jpg"}
199 2484 Lauerz, Chlostermatt Lauerzersee lake 47.031 8.5966 688020 209530 https://api.existenz.ch/apiv1/hydro/latest?locations=2484 https://api.existenz.ch/apiv1/hydro/daterange?locations=2484 {"title": "2484", "description": "Lauerz, Chlostermatt", "alt": "Lauerz, Chlostermatt", "link": "/existenz-api/hydro_locations?station_id=2484", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2484.jpg"}
198 2481 Buochs, Flugplatz Engelberger Aa river 46.9728 8.4053 673555 202870 https://api.existenz.ch/apiv1/hydro/latest?locations=2481 https://api.existenz.ch/apiv1/hydro/daterange?locations=2481 {"title": "2481", "description": "Buochs, Flugplatz", "alt": "Buochs, Flugplatz", "link": "/existenz-api/hydro_locations?station_id=2481", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2481.jpg"}
197 2480 Boudry Areuse river 46.949 6.839 554350 199940 https://api.existenz.ch/apiv1/hydro/latest?locations=2480 https://api.existenz.ch/apiv1/hydro/daterange?locations=2480 {"title": "2480", "description": "Boudry", "alt": "Boudry", "link": "/existenz-api/hydro_locations?station_id=2480", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2480.jpg"}
196 2478 Soyhières, Bois du Treuil Birse river 47.3924 7.396 596780 249070 https://api.existenz.ch/apiv1/hydro/latest?locations=2478 https://api.existenz.ch/apiv1/hydro/daterange?locations=2478 {"title": "2478", "description": "Soyhi\u00e8res, Bois du Treuil", "alt": "Soyhi\u00e8res, Bois du Treuil", "link": "/existenz-api/hydro_locations?station_id=2478", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2478.jpg"}
195 2477 Zug, Letzi Lorze river 47.1807 8.502 680600 226070 https://api.existenz.ch/apiv1/hydro/latest?locations=2477 https://api.existenz.ch/apiv1/hydro/daterange?locations=2477 {"title": "2477", "description": "Zug, Letzi", "alt": "Zug, Letzi", "link": "/existenz-api/hydro_locations?station_id=2477", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2477.jpg"}
194 2475 Bignasco, Ponte nuovo Maggia river 46.3383 8.6081 690040 132550 https://api.existenz.ch/apiv1/hydro/latest?locations=2475 https://api.existenz.ch/apiv1/hydro/daterange?locations=2475 {"title": "2475", "description": "Bignasco, Ponte nuovo", "alt": "Bignasco, Ponte nuovo", "link": "/existenz-api/hydro_locations?station_id=2475", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2475.jpg"}
193 2474 Buseno Calancasca river 46.2836 9.1182 729440 127180 https://api.existenz.ch/apiv1/hydro/latest?locations=2474 https://api.existenz.ch/apiv1/hydro/daterange?locations=2474 {"title": "2474", "description": "Buseno", "alt": "Buseno", "link": "/existenz-api/hydro_locations?station_id=2474", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2474.jpg"}
192 2473 Diepoldsau, Rietbrücke Rhein river 47.3831 9.6409 766280 250360 https://api.existenz.ch/apiv1/hydro/latest?locations=2473 https://api.existenz.ch/apiv1/hydro/daterange?locations=2473 {"title": "2473", "description": "Diepoldsau, Rietbr\u00fccke", "alt": "Diepoldsau, Rietbr\u00fccke", "link": "/existenz-api/hydro_locations?station_id=2473", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2473.jpg"}
191 2471 Murgenthal, Walliswil Murg river 47.2523 7.8262 629340 233555 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/lhg/sdi/station_pics/P2471.jpg"}
190 2469 Hondrich Kander river 46.6666 7.6711 617790 168400 https://api.existenz.ch/apiv1/hydro/latest?locations=2469 https://api.existenz.ch/apiv1/hydro/daterange?locations=2469 {"title": "2469", "description": "Hondrich", "alt": "Hondrich", "link": "/existenz-api/hydro_locations?station_id=2469", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2469.jpg"}
189 2468 St. Gallen, Bruggen/Au Sitter river 47.4144 9.3275 742540 253230 https://api.existenz.ch/apiv1/hydro/latest?locations=2468 https://api.existenz.ch/apiv1/hydro/daterange?locations=2468 {"title": "2468", "description": "St. Gallen, Bruggen/Au", "alt": "St. Gallen, Bruggen/Au", "link": "/existenz-api/hydro_locations?station_id=2468", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2468.jpg"}
188 2467 Gümmenen Saane river 46.9441 7.2429 585100 199240 https://api.existenz.ch/apiv1/hydro/latest?locations=2467 https://api.existenz.ch/apiv1/hydro/daterange?locations=2467 {"title": "2467", "description": "G\u00fcmmenen", "alt": "G\u00fcmmenen", "link": "/existenz-api/hydro_locations?station_id=2467", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2467.jpg"}
187 2462 S-Chanf Inn river 46.6157 9.9952 795800 165910 https://api.existenz.ch/apiv1/hydro/latest?locations=2462 https://api.existenz.ch/apiv1/hydro/daterange?locations=2462 {"title": "2462", "description": "S-Chanf", "alt": "S-Chanf", "link": "/existenz-api/hydro_locations?station_id=2462", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2462.jpg"}
186 2461 Magliaso, Ponte Magliasina river 45.982 8.879 711620 93290 https://api.existenz.ch/apiv1/hydro/latest?locations=2461 https://api.existenz.ch/apiv1/hydro/daterange?locations=2461 {"title": "2461", "description": "Magliaso, Ponte", "alt": "Magliaso, Ponte", "link": "/existenz-api/hydro_locations?station_id=2461", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2461.jpg"}
185 2458 Valangin Seyon river 47.0111 6.9043 559370 206810 https://api.existenz.ch/apiv1/hydro/latest?locations=2458 https://api.existenz.ch/apiv1/hydro/daterange?locations=2458 {"title": "2458", "description": "Valangin", "alt": "Valangin", "link": "/existenz-api/hydro_locations?station_id=2458", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2458.jpg"}
184 2457 Ringgenberg, Goldswil Aare river 46.694 7.8796 633730 171510 https://api.existenz.ch/apiv1/hydro/latest?locations=2457 https://api.existenz.ch/apiv1/hydro/daterange?locations=2457 {"title": "2457", "description": "Ringgenberg, Goldswil", "alt": "Ringgenberg, Goldswil", "link": "/existenz-api/hydro_locations?station_id=2457", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2457.jpg"}
183 2450 Zofingen Wigger river 47.2835 7.9354 637580 237080 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/lhg/sdi/station_pics/P2450.jpg"}
182 2447 Sugiez Canal de la Broye river 46.9637 7.1146 575340 201450 https://api.existenz.ch/apiv1/hydro/latest?locations=2447 https://api.existenz.ch/apiv1/hydro/daterange?locations=2447 {"title": "2447", "description": "Sugiez", "alt": "Sugiez", "link": "/existenz-api/hydro_locations?station_id=2447", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2447.jpg"}
181 2446 Gampelen, Zihlbrücke Zihlkanal river 47.0211 7.0342 569250 207860 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/lhg/sdi/station_pics/P2446.jpg"}
180 2437 Ecublens, Eschiens Parimbot river 46.6044 6.8129 552060 161650 https://api.existenz.ch/apiv1/hydro/latest?locations=2437 https://api.existenz.ch/apiv1/hydro/daterange?locations=2437 {"title": "2437", "description": "Ecublens, Eschiens", "alt": "Ecublens, Eschiens", "link": "/existenz-api/hydro_locations?station_id=2437", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2437.jpg"}
179 2436 Alpnach, Chilch Erli Chli Schliere river 46.9441 8.2766 663800 199570 https://api.existenz.ch/apiv1/hydro/latest?locations=2436 https://api.existenz.ch/apiv1/hydro/daterange?locations=2436 {"title": "2436", "description": "Alpnach, Chilch Erli", "alt": "Alpnach, Chilch Erli", "link": "/existenz-api/hydro_locations?station_id=2436", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2436.jpg"}
178 2434 Olten, Hammermühle Dünnern river 47.3503 7.893 634330 244480 https://api.existenz.ch/apiv1/hydro/latest?locations=2434 https://api.existenz.ch/apiv1/hydro/daterange?locations=2434 {"title": "2434", "description": "Olten, Hammerm\u00fchle", "alt": "Olten, Hammerm\u00fchle", "link": "/existenz-api/hydro_locations?station_id=2434", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2434.jpg"}
177 2433 Allaman, Le Coulet Aubonne river 46.4733 6.4064 520720 147410 https://api.existenz.ch/apiv1/hydro/latest?locations=2433 https://api.existenz.ch/apiv1/hydro/daterange?locations=2433 {"title": "2433", "description": "Allaman, Le Coulet", "alt": "Allaman, Le Coulet", "link": "/existenz-api/hydro_locations?station_id=2433", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2433.jpg"}
176 2432 Ecublens, Les Bois Venoge river 46.5353 6.5527 532040 154160 https://api.existenz.ch/apiv1/hydro/latest?locations=2432 https://api.existenz.ch/apiv1/hydro/daterange?locations=2432 {"title": "2432", "description": "Ecublens, Les Bois", "alt": "Ecublens, Les Bois", "link": "/existenz-api/hydro_locations?station_id=2432", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2432.jpg"}
175 2430 Sumvitg, Encardens Rein da Sumvitg river 46.6499 8.9907 718810 167690 https://api.existenz.ch/apiv1/hydro/latest?locations=2430 https://api.existenz.ch/apiv1/hydro/daterange?locations=2430 {"title": "2430", "description": "Sumvitg, Encardens", "alt": "Sumvitg, Encardens", "link": "/existenz-api/hydro_locations?station_id=2430", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2430.jpg"}
174 2426 Mels Seez river 47.0465 9.4182 750410 212510 https://api.existenz.ch/apiv1/hydro/latest?locations=2426 https://api.existenz.ch/apiv1/hydro/daterange?locations=2426 {"title": "2426", "description": "Mels", "alt": "Mels", "link": "/existenz-api/hydro_locations?station_id=2426", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2426.jpg"}
173 2420 Lumino, Sassello Moesa river 46.2231 9.0558 724765 120360 https://api.existenz.ch/apiv1/hydro/latest?locations=2420 https://api.existenz.ch/apiv1/hydro/daterange?locations=2420 {"title": "2420", "description": "Lumino, Sassello", "alt": "Lumino, Sassello", "link": "/existenz-api/hydro_locations?station_id=2420", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2420.jpg"}
172 2419 Reckingen Rhône river 46.4695 8.2447 661910 146780 https://api.existenz.ch/apiv1/hydro/latest?locations=2419 https://api.existenz.ch/apiv1/hydro/daterange?locations=2419 {"title": "2419", "description": "Reckingen", "alt": "Reckingen", "link": "/existenz-api/hydro_locations?station_id=2419", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2419.jpg"}
171 2418 Tiefencastel Julia river 46.6604 9.576 763570 169910 https://api.existenz.ch/apiv1/hydro/latest?locations=2418 https://api.existenz.ch/apiv1/hydro/daterange?locations=2418 {"title": "2418", "description": "Tiefencastel", "alt": "Tiefencastel", "link": "/existenz-api/hydro_locations?station_id=2418", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2418.jpg"}
170 2417 Oberkirch Suhre river 47.1572 8.1154 651320 223140 https://api.existenz.ch/apiv1/hydro/latest?locations=2417 https://api.existenz.ch/apiv1/hydro/daterange?locations=2417 {"title": "2417", "description": "Oberkirch", "alt": "Oberkirch", "link": "/existenz-api/hydro_locations?station_id=2417", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2417.jpg"}
169 2416 Hitzkirch, Richensee Aabach river 47.2201 8.2491 661390 230220 https://api.existenz.ch/apiv1/hydro/latest?locations=2416 https://api.existenz.ch/apiv1/hydro/daterange?locations=2416 {"title": "2416", "description": "Hitzkirch, Richensee", "alt": "Hitzkirch, Richensee", "link": "/existenz-api/hydro_locations?station_id=2416", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2416.jpg"}
168 2415 Rheinsfelden Glatt river 47.5735 8.4758 678040 269720 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/lhg/sdi/station_pics/P2415.jpg"}
167 2414 Mosnang, Rietholz Rietholzbach river 47.3761 9.0123 718840 248440 https://api.existenz.ch/apiv1/hydro/latest?locations=2414 https://api.existenz.ch/apiv1/hydro/daterange?locations=2414 {"title": "2414", "description": "Mosnang, Rietholz", "alt": "Mosnang, Rietholz", "link": "/existenz-api/hydro_locations?station_id=2414", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2414.jpg"}
166 2412 Vuippens, Château Sionge river 46.6585 7.0783 572420 167540 https://api.existenz.ch/apiv1/hydro/latest?locations=2412 https://api.existenz.ch/apiv1/hydro/daterange?locations=2412 {"title": "2412", "description": "Vuippens, Ch\u00e2teau", "alt": "Vuippens, Ch\u00e2teau", "link": "/existenz-api/hydro_locations?station_id=2412", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2412.jpg"}
165 2410 Ruggell Liechtensteiner Binnenkanal river 47.2434 9.5225 757751 234590 https://api.existenz.ch/apiv1/hydro/latest?locations=2410 https://api.existenz.ch/apiv1/hydro/daterange?locations=2410 {"title": "2410", "description": "Ruggell", "alt": "Ruggell", "link": "/existenz-api/hydro_locations?station_id=2410", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2410.jpg"}
164 2409 Eggiwil, Heidbüel Emme river 46.8712 7.8047 627910 191180 https://api.existenz.ch/apiv1/hydro/latest?locations=2409 https://api.existenz.ch/apiv1/hydro/daterange?locations=2409 {"title": "2409", "description": "Eggiwil, Heidb\u00fcel", "alt": "Eggiwil, Heidb\u00fcel", "link": "/existenz-api/hydro_locations?station_id=2409", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2409.jpg"}
163 2404 Cinuos-chel, Val Torta Innabl. EKW river 46.6431 10.0312 798460 169040 https://api.existenz.ch/apiv1/hydro/latest?locations=2404 https://api.existenz.ch/apiv1/hydro/daterange?locations=2404 {"title": "2404", "description": "Cinuos-chel, Val Torta", "alt": "Cinuos-chel, Val Torta", "link": "/existenz-api/hydro_locations?station_id=2404", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2404.jpg"}
162 2403 Cinuos - Chel Inn river 46.6355 10.0209 797700 168170 https://api.existenz.ch/apiv1/hydro/latest?locations=2403 https://api.existenz.ch/apiv1/hydro/daterange?locations=2403 {"title": "2403", "description": "Cinuos - Chel", "alt": "Cinuos - Chel", "link": "/existenz-api/hydro_locations?station_id=2403", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2403.jpg"}
161 2392 Rheinau Rhein (Oberwasser) river 47.6391 8.6019 687420 277140 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/lhg/sdi/station_pics/P2392.jpg"}
160 2387 Fürstenau Hinterrhein river 46.7151 9.4473 753570 175730 https://api.existenz.ch/apiv1/hydro/latest?locations=2387 https://api.existenz.ch/apiv1/hydro/daterange?locations=2387 {"title": "2387", "description": "F\u00fcrstenau", "alt": "F\u00fcrstenau", "link": "/existenz-api/hydro_locations?station_id=2387", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2387.jpg"}
159 2386 Frauenfeld Murg river 47.5685 8.8944 709540 269660 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/lhg/sdi/station_pics/P2386.jpg"}
158 2384 Simplonpass Bisse kalte Wasser river 46.2459 8.0361 646080 121780 https://api.existenz.ch/apiv1/hydro/latest?locations=2384 https://api.existenz.ch/apiv1/hydro/daterange?locations=2384 {"title": "2384", "description": "Simplonpass", "alt": "Simplonpass", "link": "/existenz-api/hydro_locations?station_id=2384", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2384.jpg"}
157 2378 Orbe, Le Chalet Orbe river 46.7276 6.5239 530080 175560 https://api.existenz.ch/apiv1/hydro/latest?locations=2378 https://api.existenz.ch/apiv1/hydro/daterange?locations=2378 {"title": "2378", "description": "Orbe, Le Chalet", "alt": "Orbe, Le Chalet", "link": "/existenz-api/hydro_locations?station_id=2378", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2378.jpg"}
156 2374 Mogelsberg, Aachsäge Necker river 47.3642 9.1214 727110 247290 https://api.existenz.ch/apiv1/hydro/latest?locations=2374 https://api.existenz.ch/apiv1/hydro/daterange?locations=2374 {"title": "2374", "description": "Mogelsberg, Aachs\u00e4ge", "alt": "Mogelsberg, Aachs\u00e4ge", "link": "/existenz-api/hydro_locations?station_id=2374", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2374.jpg"}
155 2372 Mollis, Linthbrücke Linth river 47.1011 9.072 723985 217965 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/lhg/sdi/station_pics/P2372.jpg"}
154 2371 Le Chenit, Frontière Orbe river 46.5508 6.1535 501445 156305 https://api.existenz.ch/apiv1/hydro/latest?locations=2371 https://api.existenz.ch/apiv1/hydro/daterange?locations=2371 {"title": "2371", "description": "Le Chenit, Fronti\u00e8re", "alt": "Le Chenit, Fronti\u00e8re", "link": "/existenz-api/hydro_locations?station_id=2371", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2371.jpg"}
153 2370 Le Noirmont, La Goule Doubs river 47.2292 6.9293 561430 231050 https://api.existenz.ch/apiv1/hydro/latest?locations=2370 https://api.existenz.ch/apiv1/hydro/daterange?locations=2370 {"title": "2370", "description": "Le Noirmont, La Goule", "alt": "Le Noirmont, La Goule", "link": "/existenz-api/hydro_locations?station_id=2370", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2370.jpg"}
152 2369 Yvonand Mentue river 46.7768 6.7242 545440 180875 https://api.existenz.ch/apiv1/hydro/latest?locations=2369 https://api.existenz.ch/apiv1/hydro/daterange?locations=2369 {"title": "2369", "description": "Yvonand", "alt": "Yvonand", "link": "/existenz-api/hydro_locations?station_id=2369", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2369.jpg"}
151 2368 Locarno, Solduno Maggia river 46.1683 8.7736 703100 113860 https://api.existenz.ch/apiv1/hydro/latest?locations=2368 https://api.existenz.ch/apiv1/hydro/daterange?locations=2368 {"title": "2368", "description": "Locarno, Solduno", "alt": "Locarno, Solduno", "link": "/existenz-api/hydro_locations?station_id=2368", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2368.jpg"}
150 2366 La Rösa Poschiavino river 46.399 10.0672 802120 142010 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/lhg/sdi/station_pics/P2366.jpg"}
149 2364 Piotta Ticino river 46.5167 8.6715 694610 152450 https://api.existenz.ch/apiv1/hydro/latest?locations=2364 https://api.existenz.ch/apiv1/hydro/daterange?locations=2364 {"title": "2364", "description": "Piotta", "alt": "Piotta", "link": "/existenz-api/hydro_locations?station_id=2364", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2364.jpg"}
148 2356 Cavergno, Pontit Riale di Calneggia river 46.3696 8.5429 684970 135960 https://api.existenz.ch/apiv1/hydro/latest?locations=2356 https://api.existenz.ch/apiv1/hydro/daterange?locations=2356 {"title": "2356", "description": "Cavergno, Pontit ", "alt": "Cavergno, Pontit ", "link": "/existenz-api/hydro_locations?station_id=2356", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2356.jpg"}
147 2355 Davos, Frauenkirch Landwasser river 46.7578 9.7903 779640 181200 https://api.existenz.ch/apiv1/hydro/latest?locations=2355 https://api.existenz.ch/apiv1/hydro/daterange?locations=2355 {"title": "2355", "description": "Davos, Frauenkirch", "alt": "Davos, Frauenkirch", "link": "/existenz-api/hydro_locations?station_id=2355", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2355.jpg"}
146 2353 Linthal, Wasserrückgabe KLL Betriebswasser KLL river 46.9172 8.9925 718360 197409 https://api.existenz.ch/apiv1/hydro/latest?locations=2353 https://api.existenz.ch/apiv1/hydro/daterange?locations=2353 {"title": "2353", "description": "Linthal, Wasserr\u00fcckgabe KLL", "alt": "Linthal, Wasserr\u00fcckgabe KLL", "link": "/existenz-api/hydro_locations?station_id=2353", "image": "https://www.hydrodaten.admin.ch/lhg/sdi/station_pics/P2353.jpg"}
145 2352 Linthal, Ausgleichsbecken KLL Linth river 46.9164 8.9915 718285 197310 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/lhg/sdi/station_pics/P2352.jpg"}
144 2351 Visp Vispa river 46.2742 7.8817 634150 124850 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/lhg/sdi/station_pics/P2351.jpg"}

Next page

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);