smn_locations

Data source: api.existenz.ch

21 rows where canton = "VS"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: alt, alt_barometric, station_type, exposition, data_owner, data_since

Link rowid ▼ code name canton lat lon alt alt_barometric chx chy station_type exposition data_owner data_since link wigos_id latest_values last_24h_values popup
9 9 ATT Les Attelas VS 46.0991 7.26865 2734 2735 2586854 1105302 Automatic weather stations crest MeteoSchweiz 10.08.1993 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ATT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06723 https://api.existenz.ch/apiv1/smn/latest?locations=ATT https://api.existenz.ch/apiv1/smn/daterange?locations=ATT {"title": "ATT", "description": "Les Attelas", "alt": "Les Attelas", "link": "/existenz-api/smn_locations?code=ATT"}
17 17 BIN Binn VS 46.367661 8.192306 1479   2657996 1135421 Automatic weather stations valley MeteoSchweiz 01.08.1899 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BIN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06721 https://api.existenz.ch/apiv1/smn/latest?locations=BIN https://api.existenz.ch/apiv1/smn/daterange?locations=BIN {"title": "BIN", "description": "Binn", "alt": "Binn", "link": "/existenz-api/smn_locations?code=BIN"}
20 20 BLA Blatten, Lötschental VS 46.420453 7.823194 1538 1539 2629564 1141084 Automatic weather stations valley MeteoSchweiz 01.01.1959 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BLA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06725 https://api.existenz.ch/apiv1/smn/latest?locations=BLA https://api.existenz.ch/apiv1/smn/daterange?locations=BLA {"title": "BLA", "description": "Blatten, L\u00f6tschental", "alt": "Blatten, L\u00f6tschental", "link": "/existenz-api/smn_locations?code=BLA"}
22 22 BOU Bouveret VS 46.393447 6.857006 374 375 2555263 1138175 Automatic weather stations plain MeteoSchweiz 14.09.1993 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BOU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06709 https://api.existenz.ch/apiv1/smn/latest?locations=BOU https://api.existenz.ch/apiv1/smn/daterange?locations=BOU {"title": "BOU", "description": "Bouveret", "alt": "Bouveret", "link": "/existenz-api/smn_locations?code=BOU"}
49 49 EGH Eggishorn VS 46.426528 8.092728 2892 2893 2650279 1141897 Automatic weather stations crest MeteoSchweiz 20.10.1993 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EGH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06739 https://api.existenz.ch/apiv1/smn/latest?locations=EGH https://api.existenz.ch/apiv1/smn/daterange?locations=EGH {"title": "EGH", "description": "Eggishorn", "alt": "Eggishorn", "link": "/existenz-api/smn_locations?code=EGH"}
54 54 EVI Evionnaz VS 46.182953 7.026747 482 483 2568196 1114693 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 30.08.1993 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EVI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06715 https://api.existenz.ch/apiv1/smn/latest?locations=EVI https://api.existenz.ch/apiv1/smn/daterange?locations=EVI {"title": "EVI", "description": "Evionnaz", "alt": "Evionnaz", "link": "/existenz-api/smn_locations?code=EVI"}
55 55 EVO Evolène / Villa VS 46.112211 7.508631 1825 1829 2605412 1106748 Automatic weather stations south-western oriented slope MeteoSchweiz 23.09.1986 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EVO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06722 https://api.existenz.ch/apiv1/smn/latest?locations=EVO https://api.existenz.ch/apiv1/smn/daterange?locations=EVO {"title": "EVO", "description": "Evol\u00e8ne / Villa", "alt": "Evol\u00e8ne / Villa", "link": "/existenz-api/smn_locations?code=EVO"}
65 65 GOR Gornergrat VS 45.983644 7.785944 3129 3131 2626915 1092513 Automatic weather stations crest MeteoSchweiz 28.07.1993 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GOR https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06749 https://api.existenz.ch/apiv1/smn/latest?locations=GOR https://api.existenz.ch/apiv1/smn/daterange?locations=GOR {"title": "GOR", "description": "Gornergrat", "alt": "Gornergrat", "link": "/existenz-api/smn_locations?code=GOR"}
68 68 GRC Grächen VS 46.195314 7.836822 1605 1606 2630738 1116062 Automatic weather stations western oriented slope MeteoSchweiz 01.12.1863 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRC https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06728 https://api.existenz.ch/apiv1/smn/latest?locations=GRC https://api.existenz.ch/apiv1/smn/daterange?locations=GRC {"title": "GRC", "description": "Gr\u00e4chen", "alt": "Gr\u00e4chen", "link": "/existenz-api/smn_locations?code=GRC"}
72 72 GSB Col du Grand St-Bernard VS 45.869092 7.170683 2472 2488 2579191 1079754 Automatic weather stations pass MeteoSchweiz 01.01.1818 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GSB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06717 https://api.existenz.ch/apiv1/smn/latest?locations=GSB https://api.existenz.ch/apiv1/smn/daterange?locations=GSB {"title": "GSB", "description": "Col du Grand St-Bernard", "alt": "Col du Grand St-Bernard", "link": "/existenz-api/smn_locations?code=GSB"}
81 81 JUN Jungfraujoch VS 46.547556 7.985444 3571 3576 2641939 1155287 Automatic weather stations pass MeteoSchweiz 01.01.1931 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=JUN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06730 https://api.existenz.ch/apiv1/smn/latest?locations=JUN https://api.existenz.ch/apiv1/smn/daterange?locations=JUN {"title": "JUN", "description": "Jungfraujoch", "alt": "Jungfraujoch", "link": "/existenz-api/smn_locations?code=JUN"}
93 93 MAR Les Marécottes VS 46.118903 7.016597 990   2567374 1107577 Automatic weather stations south-eastern oriented slope MeteoSchweiz 01.01.1961 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=MAR https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06614 https://api.existenz.ch/apiv1/smn/latest?locations=MAR https://api.existenz.ch/apiv1/smn/daterange?locations=MAR {"title": "MAR", "description": "Les Mar\u00e9cottes", "alt": "Les Mar\u00e9cottes", "link": "/existenz-api/smn_locations?code=MAR"}
98 98 MOB Montagnier, Bagnes VS 46.071019 7.225272 839 840 2583491 1102189 Automatic weather stations valley MeteoSchweiz 01.03.1906 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=MOB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06615 https://api.existenz.ch/apiv1/smn/latest?locations=MOB https://api.existenz.ch/apiv1/smn/daterange?locations=MOB {"title": "MOB", "description": "Montagnier, Bagnes", "alt": "Montagnier, Bagnes", "link": "/existenz-api/smn_locations?code=MOB"}
100 100 MRP Monte Rosa-Plattje VS 45.956628 7.814575 2885 2887 2629148 1089520 Weather station north-western oriented slope MeteoSwiss 01.01.2010 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=MRP https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06747 https://api.existenz.ch/apiv1/smn/latest?locations=MRP https://api.existenz.ch/apiv1/smn/daterange?locations=MRP {"title": "MRP", "description": "Monte Rosa-Plattje", "alt": "Monte Rosa-Plattje", "link": "/existenz-api/smn_locations?code=MRP"}
102 102 MTE Mottec VS 46.147897 7.624033 1580 1581 2614324 1110730 Automatic weather stations valley MeteoSchweiz 01.01.1973 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=MTE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06716 https://api.existenz.ch/apiv1/smn/latest?locations=MTE https://api.existenz.ch/apiv1/smn/daterange?locations=MTE {"title": "MTE", "description": "Mottec", "alt": "Mottec", "link": "/existenz-api/smn_locations?code=MTE"}
105 105 MVE Montana VS 46.298806 7.460814 1423 1424 2601709 1127489 Automatic weather stations south-western oriented slope MeteoSchweiz, SLF 01.01.1926 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=MVE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06724 https://api.existenz.ch/apiv1/smn/latest?locations=MVE https://api.existenz.ch/apiv1/smn/daterange?locations=MVE {"title": "MVE", "description": "Montana", "alt": "Montana", "link": "/existenz-api/smn_locations?code=MVE"}
136 136 SIM Simplon-Dorf VS 46.196825 8.056336 1465 1473 2647683 1116340 Automatic weather stations valley MeteoSchweiz 01.01.1961 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SIM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06654 https://api.existenz.ch/apiv1/smn/latest?locations=SIM https://api.existenz.ch/apiv1/smn/daterange?locations=SIM {"title": "SIM", "description": "Simplon-Dorf", "alt": "Simplon-Dorf", "link": "/existenz-api/smn_locations?code=SIM"}
137 137 SIO Sion VS 46.21865 7.330203 482 483 2591633 1118584 Automatic weather stations plain MeteoSchweiz 01.01.1864 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SIO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06720 https://api.existenz.ch/apiv1/smn/latest?locations=SIO https://api.existenz.ch/apiv1/smn/daterange?locations=SIO {"title": "SIO", "description": "Sion", "alt": "Sion", "link": "/existenz-api/smn_locations?code=SIO"}
149 149 ULR Ulrichen VS 46.504881 8.308236 1346 1347 2666748 1150767 Automatic weather stations plain MeteoSchweiz 01.01.1959 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ULR https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06745 https://api.existenz.ch/apiv1/smn/latest?locations=ULR https://api.existenz.ch/apiv1/smn/daterange?locations=ULR {"title": "ULR", "description": "Ulrichen", "alt": "Ulrichen", "link": "/existenz-api/smn_locations?code=ULR"}
154 154 VIS Visp VS 46.3029 7.842958 639 641 2631151 1128024 Automatic weather stations plain MeteoSchweiz 01.01.1959 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VIS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06727 https://api.existenz.ch/apiv1/smn/latest?locations=VIS https://api.existenz.ch/apiv1/smn/daterange?locations=VIS {"title": "VIS", "description": "Visp", "alt": "Visp", "link": "/existenz-api/smn_locations?code=VIS"}
160 160 ZER Zermatt VS 46.029272 7.752433 1638 1640 2624298 1097574 Automatic weather stations western oriented slope MeteoSchweiz, SLF 01.04.1892 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ZER https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06748 https://api.existenz.ch/apiv1/smn/latest?locations=ZER https://api.existenz.ch/apiv1/smn/daterange?locations=ZER {"title": "ZER", "description": "Zermatt", "alt": "Zermatt", "link": "/existenz-api/smn_locations?code=ZER"}

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE smn_locations ('code' string, 'name' string, 'canton' string, 'lat' real, 'lon' real, 'alt' integer, 'alt_barometric' integer, 'chx' integer, 'chy' integer, 'station_type' string, 'exposition' string, 'data_owner' string, 'data_since' string, 'link' string, 'wigos_id' string, 'latest_values' string, 'last_24h_values' string, popup);
CREATE UNIQUE INDEX smn_locations_code_index ON smn_locations(code);