smn_locations

Data source: api.existenz.ch

18 rows where canton = "BE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition, data_owner, data_since, 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
1 1 ABO Adelboden 46.491703 7.560703 1321 1326 2609372 1148939 Weather station south-eastern oriented slope MeteoSwiss, SLF 01.01.1901 BE 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=ABO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06735 https://api.existenz.ch/apiv1/smn/latest?locations=ABO https://api.existenz.ch/apiv1/smn/daterange?locations=ABO {"title": "ABO", "description": "Adelboden", "alt": "Adelboden", "link": "/existenz-api/smn_locations?code=ABO"}
10 10 BAN Bantiger 46.977806 7.528667 942   2606850 1202975 Weather station crest MeteoSwiss 01.01.1993 BE Temperature, Humidity, Dew point, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BAN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06634 https://api.existenz.ch/apiv1/smn/latest?locations=BAN https://api.existenz.ch/apiv1/smn/daterange?locations=BAN {"title": "BAN", "description": "Bantiger", "alt": "Bantiger", "link": "/existenz-api/smn_locations?code=BAN"}
13 13 BER Bern / Zollikofen 46.990744 7.464061 553 554 2601934 1204410 Weather station plain MeteoSwiss 01.01.1864 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, 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=BER https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06631 https://api.existenz.ch/apiv1/smn/latest?locations=BER https://api.existenz.ch/apiv1/smn/daterange?locations=BER {"title": "BER", "description": "Bern / Zollikofen", "alt": "Bern / Zollikofen", "link": "/existenz-api/smn_locations?code=BER"}
21 21 BOL Boltigen 46.623519 7.384206 820 821 2595831 1163587 Weather station plain MeteoSwiss 01.08.1993 BE 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=BOL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06733 https://api.existenz.ch/apiv1/smn/latest?locations=BOL https://api.existenz.ch/apiv1/smn/daterange?locations=BOL {"title": "BOL", "description": "Boltigen", "alt": "Boltigen", "link": "/existenz-api/smn_locations?code=BOL"}
24 24 BRZ Brienz 46.740719 8.060864 567 568 2647553 1176803 Weather station plain MeteoSwiss 01.01.1901 BE Precipitation, Pressure, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BRZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06656 https://api.existenz.ch/apiv1/smn/latest?locations=BRZ https://api.existenz.ch/apiv1/smn/daterange?locations=BRZ {"title": "BRZ", "description": "Brienz", "alt": "Brienz", "link": "/existenz-api/smn_locations?code=BRZ"}
31 31 CHA Chasseral 47.131761 7.054367 1594 1596 2570845 1220158 Weather station crest MeteoSwiss 01.01.1981 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CHA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06605 https://api.existenz.ch/apiv1/smn/latest?locations=CHA https://api.existenz.ch/apiv1/smn/daterange?locations=CHA {"title": "CHA", "description": "Chasseral", "alt": "Chasseral", "link": "/existenz-api/smn_locations?code=CHA"}
41 41 COY Courtelary 47.180811 7.090656 695   2573623 1225598 Weather station plain MeteoSwiss 01.01.1913 BE 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=COY https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06710 https://api.existenz.ch/apiv1/smn/latest?locations=COY https://api.existenz.ch/apiv1/smn/daterange?locations=COY {"title": "COY", "description": "Courtelary", "alt": "Courtelary", "link": "/existenz-api/smn_locations?code=COY"}
59 59 FRU Frutigen 46.599003 7.657542 756   2616773 1160884 Weather station plain MeteoSwiss 01.01.1901 BE Temperature, Humidity, Dew point, Precipitation, Wind, Global radiation, Sunshine, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=FRU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06613 https://api.existenz.ch/apiv1/smn/latest?locations=FRU https://api.existenz.ch/apiv1/smn/daterange?locations=FRU {"title": "FRU", "description": "Frutigen", "alt": "Frutigen", "link": "/existenz-api/smn_locations?code=FRU"}
70 70 GRH Grimsel Hospiz 46.571689 8.333256 1980 1962 2668583 1158215 Weather station height (30-100 m above valley) MeteoSwiss, SLF 01.01.1868 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06744 https://api.existenz.ch/apiv1/smn/latest?locations=GRH https://api.existenz.ch/apiv1/smn/daterange?locations=GRH {"title": "GRH", "description": "Grimsel Hospiz", "alt": "Grimsel Hospiz", "link": "/existenz-api/smn_locations?code=GRH"}
80 80 INT Interlaken 46.672033 7.87045 578 580 2633043 1169070 Weather station plain MeteoSwiss 01.01.1894 BE 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=INT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06734 https://api.existenz.ch/apiv1/smn/latest?locations=INT https://api.existenz.ch/apiv1/smn/daterange?locations=INT {"title": "INT", "description": "Interlaken", "alt": "Interlaken", "link": "/existenz-api/smn_locations?code=INT"}
83 83 KOP Koppigen 47.11885 7.605503 485 486 2612663 1218665 Weather station plain MeteoSwiss 01.11.1960 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, 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=KOP https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06635 https://api.existenz.ch/apiv1/smn/latest?locations=KOP https://api.existenz.ch/apiv1/smn/daterange?locations=KOP {"title": "KOP", "description": "Koppigen", "alt": "Koppigen", "link": "/existenz-api/smn_locations?code=KOP"}
86 86 LAG Langnau i.E. 46.939633 7.806425 744 745 2628004 1198793 Weather station plain MeteoSwiss 01.10.1900 BE 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=LAG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06638 https://api.existenz.ch/apiv1/smn/latest?locations=LAG https://api.existenz.ch/apiv1/smn/daterange?locations=LAG {"title": "LAG", "description": "Langnau i.E.", "alt": "Langnau i.E.", "link": "/existenz-api/smn_locations?code=LAG"}
95 95 MER Meiringen 46.732222 8.169247 589 589 2655844 1175930 Weather station plain MeteoSwiss 01.07.1889 BE 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=MER https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06637 https://api.existenz.ch/apiv1/smn/latest?locations=MER https://api.existenz.ch/apiv1/smn/daterange?locations=MER {"title": "MER", "description": "Meiringen", "alt": "Meiringen", "link": "/existenz-api/smn_locations?code=MER"}
101 101 MSK Mühleberg / Stockeren 46.952103 7.282972 706   2588150 1200125 Weather station   MeteoSwiss 01.02.1987 BE Temperature, Humidity, Dew point, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/home/measurement-values.html?param=messnetz-automatisch&station=MSK https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06629 https://api.existenz.ch/apiv1/smn/latest?locations=MSK https://api.existenz.ch/apiv1/smn/daterange?locations=MSK {"title": "MSK", "description": "M\u00fchleberg / Stockeren", "alt": "M\u00fchleberg / Stockeren", "link": "/existenz-api/smn_locations?code=MSK"}
104 104 MUB Mühleberg 46.973278 7.278217 480 481 2587793 1202480 Weather station plain MeteoSwiss 01.01.1981 BE 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=MUB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06636 https://api.existenz.ch/apiv1/smn/latest?locations=MUB https://api.existenz.ch/apiv1/smn/daterange?locations=MUB {"title": "MUB", "description": "M\u00fchleberg", "alt": "M\u00fchleberg", "link": "/existenz-api/smn_locations?code=MUB"}
106 106 NAP Napf 47.004667 7.940117 1404 1405 2638137 1206079 Weather station crest MeteoSwiss 01.01.1978 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=NAP https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06639 https://api.existenz.ch/apiv1/smn/latest?locations=NAP https://api.existenz.ch/apiv1/smn/daterange?locations=NAP {"title": "NAP", "description": "Napf", "alt": "Napf", "link": "/existenz-api/smn_locations?code=NAP"}
146 146 THU Thun 46.749853 7.585222 570 571 2611201 1177640 Weather station plain MeteoSwiss 01.06.1875 BE 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=THU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06731 https://api.existenz.ch/apiv1/smn/latest?locations=THU https://api.existenz.ch/apiv1/smn/daterange?locations=THU {"title": "THU", "description": "Thun", "alt": "Thun", "link": "/existenz-api/smn_locations?code=THU"}
159 159 WYN Wynau 47.255025 7.787475 422 424 2626405 1233849 Weather station basin MeteoSwiss 01.01.1978 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=WYN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06643 https://api.existenz.ch/apiv1/smn/latest?locations=WYN https://api.existenz.ch/apiv1/smn/daterange?locations=WYN {"title": "WYN", "description": "Wynau", "alt": "Wynau", "link": "/existenz-api/smn_locations?code=WYN"}

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