smn_locations

Data source: api.existenz.ch

14 rows where exposition = "valley"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: canton, 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
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"}
29 29 CEV Cevio TI 46.320486 8.603161 417 422 2689688 1130564 Automatic weather stations valley MeteoSchweiz 01.01.1900 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CEV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06752 https://api.existenz.ch/apiv1/smn/latest?locations=CEV https://api.existenz.ch/apiv1/smn/daterange?locations=CEV {"title": "CEV", "description": "Cevio", "alt": "Cevio", "link": "/existenz-api/smn_locations?code=CEV"}
39 39 COM Acquarossa / Comprovasco TI 46.459517 8.935486 575 576 2714985 1146451 Automatic weather stations valley MeteoSchweiz 01.01.1900 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=COM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06756 https://api.existenz.ch/apiv1/smn/latest?locations=COM https://api.existenz.ch/apiv1/smn/daterange?locations=COM {"title": "COM", "description": "Acquarossa / Comprovasco", "alt": "Acquarossa / Comprovasco", "link": "/existenz-api/smn_locations?code=COM"}
48 48 EBK Ebnat-Kappel SG 47.273389 9.108494 623 624 2726348 1237176 Automatic weather stations valley MeteoSchweiz 01.08.1879 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EBK https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06693 https://api.existenz.ch/apiv1/smn/latest?locations=EBK https://api.existenz.ch/apiv1/smn/daterange?locations=EBK {"title": "EBK", "description": "Ebnat-Kappel", "alt": "Ebnat-Kappel", "link": "/existenz-api/smn_locations?code=EBK"}
66 66 GOS Göschenen UR 46.692678 8.595364 950 951 2688477 1171926 Automatic weather stations valley MeteoSchweiz 01.01.1883 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GOS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06668 https://api.existenz.ch/apiv1/smn/latest?locations=GOS https://api.existenz.ch/apiv1/smn/daterange?locations=GOS {"title": "GOS", "description": "G\u00f6schenen", "alt": "G\u00f6schenen", "link": "/existenz-api/smn_locations?code=GOS"}
71 71 GRO Grono GR 46.255075 9.163758 324 324 2733018 1124089 Automatic weather stations valley MeteoSchweiz 01.01.1901 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06758 https://api.existenz.ch/apiv1/smn/latest?locations=GRO https://api.existenz.ch/apiv1/smn/daterange?locations=GRO {"title": "GRO", "description": "Grono", "alt": "Grono", "link": "/existenz-api/smn_locations?code=GRO"}
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"}
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"}
124 124 ROB Poschiavo / Robbia GR 46.347217 10.063031 1078 1079 2801994 1136249 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=ROB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06794 https://api.existenz.ch/apiv1/smn/latest?locations=ROB https://api.existenz.ch/apiv1/smn/daterange?locations=ROB {"title": "ROB", "description": "Poschiavo / Robbia", "alt": "Poschiavo / Robbia", "link": "/existenz-api/smn_locations?code=ROB"}
130 130 SBE S. Bernardino GR 46.463542 9.1847 1639 1640 2734116 1147294 Automatic weather stations valley MeteoSchweiz, SLF 01.01.1864 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SBE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06783 https://api.existenz.ch/apiv1/smn/latest?locations=SBE https://api.existenz.ch/apiv1/smn/daterange?locations=SBE {"title": "SBE", "description": "S. Bernardino", "alt": "S. Bernardino", "link": "/existenz-api/smn_locations?code=SBE"}
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"}
153 153 VIO Vicosoprano GR 46.353019 9.6278 1089 1090 2768487 1135866 Automatic weather stations valley MeteoSchweiz 01.01.1901 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VIO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06788 https://api.existenz.ch/apiv1/smn/latest?locations=VIO https://api.existenz.ch/apiv1/smn/daterange?locations=VIO {"title": "VIO", "description": "Vicosoprano", "alt": "Vicosoprano", "link": "/existenz-api/smn_locations?code=VIO"}
156 156 VLS Vals GR 46.627758 9.188711 1242   2734017 1165551 Automatic weather stations valley MeteoSchweiz 01.02.1892 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VLS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06663 https://api.existenz.ch/apiv1/smn/latest?locations=VLS https://api.existenz.ch/apiv1/smn/daterange?locations=VLS {"title": "VLS", "description": "Vals", "alt": "Vals", "link": "/existenz-api/smn_locations?code=VLS"}

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