home / existenz-api

smn_locations

Data source: api.existenz.ch

18 rows where canton = "BE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
1 1 ABO Adelboden BE 46.491703 7.560703 1321 1326 2609372 1148939 Automatic weather stations south-eastern oriented slope MeteoSchweiz, SLF 01.01.1901 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 BE 46.977806 7.528667 942   2606850 1202975 Automatic tower stations crest MeteoSchweiz 16.12.1992 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 BE 46.990744 7.464061 553 554 2601934 1204410 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=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 BE 46.623519 7.384206 820 821 2595831 1163587 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=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 BE 46.740719 8.060864 567 568 2647553 1176803 Automatic weather stations plain MeteoSchweiz 01.01.1901 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 BE 47.131761 7.054367 1594 1596 2570845 1220158 Automatic weather stations crest MeteoSchweiz 31.12.1980 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 BE 47.180811 7.090656 695   2573623 1225598 Automatic weather stations plain MeteoSchweiz 01.01.1913 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 BE 46.599003 7.657542 756   2616773 1160884 Automatic weather stations plain MeteoSchweiz 01.01.1901 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 BE 46.571689 8.333256 1980 1962 2668583 1158215 Automatic weather stations height (30-100 m above valley) MeteoSchweiz, SLF 01.01.1868 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 BE 46.672033 7.87045 578 580 2633043 1169070 Automatic weather stations plain MeteoSchweiz 01.01.1894 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 BE 47.11885 7.605503 485 486 2612663 1218665 Automatic weather stations plain MeteoSchweiz 01.11.1960 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. BE 46.939633 7.806425 744 745 2628004 1198793 Automatic weather stations plain MeteoSchweiz 01.01.1900 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 BE 46.732222 8.169247 589 589 2655844 1175930 Automatic weather stations plain MeteoSchweiz 01.07.1889 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 BE 46.952103 7.282972 706   2588150 1200125 Weather station   MeteoSwiss 01.02.1987 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 BE 46.973278 7.278217 480 481 2587793 1202480 Automatic weather stations plain MeteoSchweiz 01.01.1981 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 BE 47.004667 7.940117 1404 1405 2638137 1206079 Automatic weather stations crest MeteoSchweiz 01.01.1978 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 BE 46.749853 7.585222 570 571 2611201 1177640 Automatic weather stations plain MeteoSchweiz 31.05.1875 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 BE 47.255025 7.787475 422 424 2626405 1233849 Automatic weather stations basin MeteoSchweiz 01.01.1978 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, '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);
Powered by Datasette · Queries took 64.062ms · Data source: api.existenz.ch