smn_locations

Data source: api.existenz.ch

13 rows where data_since = "01.01.1901"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: canton, exposition, data_owner

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"}
5 5 AND Andeer GR 46.610139 9.431981 987 988 2752692 1164038 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=AND https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06787 https://api.existenz.ch/apiv1/smn/latest?locations=AND https://api.existenz.ch/apiv1/smn/daterange?locations=AND {"title": "AND", "description": "Andeer", "alt": "Andeer", "link": "/existenz-api/smn_locations?code=AND"}
23 23 BRL La Brévine NE 46.983844 6.610297 1050 1051 2536981 1203975 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=BRL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06617 https://api.existenz.ch/apiv1/smn/latest?locations=BRL https://api.existenz.ch/apiv1/smn/daterange?locations=BRL {"title": "BRL", "description": "La Br\u00e9vine", "alt": "La Br\u00e9vine", "link": "/existenz-api/smn_locations?code=BRL"}
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"}
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"}
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"}
76 76 HAI Salen-Reutenen TG 47.651242 9.023911 719 720 2719100 1279047 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=HAI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06623 https://api.existenz.ch/apiv1/smn/latest?locations=HAI https://api.existenz.ch/apiv1/smn/daterange?locations=HAI {"title": "HAI", "description": "Salen-Reutenen", "alt": "Salen-Reutenen", "link": "/existenz-api/smn_locations?code=HAI"}
94 94 MAS Marsens FR 46.656486 7.069669 715   2571758 1167317 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=MAS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06640 https://api.existenz.ch/apiv1/smn/latest?locations=MAS https://api.existenz.ch/apiv1/smn/daterange?locations=MAS {"title": "MAS", "description": "Marsens", "alt": "Marsens", "link": "/existenz-api/smn_locations?code=MAS"}
97 97 MOA Mosen LU 47.243847 8.232831 453 454 2660129 1232852 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=MOA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06644 https://api.existenz.ch/apiv1/smn/latest?locations=MOA https://api.existenz.ch/apiv1/smn/daterange?locations=MOA {"title": "MOA", "description": "Mosen", "alt": "Mosen", "link": "/existenz-api/smn_locations?code=MOA"}
113 113 PFA Pfäffikon, ZH ZH 47.376817 8.754864 537 538 2699401 1248165 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=PFA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-756-0-PFA https://api.existenz.ch/apiv1/smn/latest?locations=PFA https://api.existenz.ch/apiv1/smn/daterange?locations=PFA {"title": "PFA", "description": "Pf\u00e4ffikon, ZH", "alt": "Pf\u00e4ffikon, ZH", "link": "/existenz-api/smn_locations?code=PFA"}
120 120 PUY Pully VD 46.512283 6.667517 456 457 2540819 1151511 Automatic weather stations southern oriented slope MeteoSchweiz 01.01.1901 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=PUY https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06711 https://api.existenz.ch/apiv1/smn/latest?locations=PUY https://api.existenz.ch/apiv1/smn/daterange?locations=PUY {"title": "PUY", "description": "Pully", "alt": "Pully", "link": "/existenz-api/smn_locations?code=PUY"}
128 128 SAG Sattel, SZ SZ 47.081064 8.636967 790 791 2691000 1215145 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=SAG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06662 https://api.existenz.ch/apiv1/smn/latest?locations=SAG https://api.existenz.ch/apiv1/smn/daterange?locations=SAG {"title": "SAG", "description": "Sattel, SZ", "alt": "Sattel, SZ", "link": "/existenz-api/smn_locations?code=SAG"}
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"}

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