smn_locations

Data source: api.existenz.ch

8 rows where data_owner = "MeteoSchweiz", data_since = "01.01.1864" and exposition = "plain"

✎ View and edit SQL

This data as json, CSV (advanced)

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
4 4 ALT Altdorf UR 46.887069 8.621894 438 440 2690181 1193564 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=ALT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06672 https://api.existenz.ch/apiv1/smn/latest?locations=ALT https://api.existenz.ch/apiv1/smn/daterange?locations=ALT {"title": "ALT", "description": "Altdorf", "alt": "Altdorf", "link": "/existenz-api/smn_locations?code=ALT"}
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"}
51 51 EIN Einsiedeln SZ 47.133042 8.756556 911 912 2699984 1221068 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=EIN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06675 https://api.existenz.ch/apiv1/smn/latest?locations=EIN https://api.existenz.ch/apiv1/smn/daterange?locations=EIN {"title": "EIN", "description": "Einsiedeln", "alt": "Einsiedeln", "link": "/existenz-api/smn_locations?code=EIN"}
89 89 LUG Lugano TI 46.004217 8.960322 273 301 2717874 1095883 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=LUG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06770 https://api.existenz.ch/apiv1/smn/latest?locations=LUG https://api.existenz.ch/apiv1/smn/daterange?locations=LUG {"title": "LUG", "description": "Lugano", "alt": "Lugano", "link": "/existenz-api/smn_locations?code=LUG"}
90 90 LUZ Luzern LU 47.036439 8.301022 454 456 2665545 1209850 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=LUZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06650 https://api.existenz.ch/apiv1/smn/latest?locations=LUZ https://api.existenz.ch/apiv1/smn/daterange?locations=LUZ {"title": "LUZ", "description": "Luzern", "alt": "Luzern", "link": "/existenz-api/smn_locations?code=LUZ"}
122 122 RAG Bad Ragaz SG 47.016631 9.502594 497 497 2756911 1209351 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=RAG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06686 https://api.existenz.ch/apiv1/smn/latest?locations=RAG https://api.existenz.ch/apiv1/smn/daterange?locations=RAG {"title": "RAG", "description": "Bad Ragaz", "alt": "Bad Ragaz", "link": "/existenz-api/smn_locations?code=RAG"}
129 129 SAM Samedan GR 46.526247 9.879469 1709 1710 2787251 1155685 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=SAM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06792 https://api.existenz.ch/apiv1/smn/latest?locations=SAM https://api.existenz.ch/apiv1/smn/daterange?locations=SAM {"title": "SAM", "description": "Samedan", "alt": "Samedan", "link": "/existenz-api/smn_locations?code=SAM"}
137 137 SIO Sion VS 46.21865 7.330203 482 483 2591633 1118584 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=SIO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06720 https://api.existenz.ch/apiv1/smn/latest?locations=SIO https://api.existenz.ch/apiv1/smn/daterange?locations=SIO {"title": "SIO", "description": "Sion", "alt": "Sion", "link": "/existenz-api/smn_locations?code=SIO"}

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