smn_locations

Data source: api.existenz.ch

14 rows where exposition = "valley"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: data_owner, data_since, canton, measurements

Link rowid ▼ code name lat lon alt alt_barometric chx chy station_type exposition data_owner data_since canton measurements link wigos_id latest_values last_24h_values popup
17 17 BIN Binn 46.367661 8.192306 1479   2657996 1135421 Weather station valley MeteoSwiss 01.08.1899 VS Temperature, Humidity, Dew point, Precipitation, Wind 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 46.420453 7.823194 1538 1539 2629564 1141084 Weather station valley MeteoSwiss 01.03.2001 VS Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm 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 46.320486 8.603161 417 422 2689688 1130564 Weather station valley MeteoSwiss 01.10.1900 TI Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index 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 46.459517 8.935486 575 576 2714985 1146451 Weather station valley MeteoSwiss 01.10.1900 TI Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index, Temperature 5cm 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 47.273389 9.108494 623 624 2726348 1237176 Weather station valley MeteoSwiss 01.08.1879 SG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm 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 46.692678 8.595364 950 951 2688477 1171926 Weather station valley MeteoSwiss 01.01.1883 UR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Snow 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 46.255075 9.163758 324 324 2733018 1124089 Weather station valley MeteoSwiss 01.01.1901 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index, Temperature 5cm 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 46.071019 7.225272 839 840 2583491 1102189 Weather station valley MeteoSwiss 01.03.1906 VS Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Snow 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 46.147897 7.624033 1580 1581 2614324 1110730 Weather station valley MeteoSwiss 01.01.1973 VS Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine 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 46.347217 10.063031 1078 1079 2801994 1136249 Weather station valley MeteoSwiss 01.01.1959 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Soil temperature, Longwave radiation 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 46.463542 9.1847 1639 1640 2734116 1147294 Weather station valley MeteoSwiss, SLF 01.01.1968 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm 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 46.196825 8.056336 1465 1473 2647683 1116340 Weather station valley MeteoSwiss 01.01.1961 VS Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow 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 46.353019 9.6278 1089 1090 2768487 1135866 Weather station valley MeteoSwiss 01.01.1901 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index 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 46.627758 9.188711 1242   2734017 1165551 Weather station valley MeteoSwiss 01.02.1892 GR Temperature, Humidity, Dew point, Precipitation, Wind, Global radiation, Sunshine 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, lat real, lon real, alt integer, alt_barometric integer, chx integer, chy integer, station_type string, exposition string, data_owner string, data_since string, canton string, measurements 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);