smn_locations

Data source: api.existenz.ch

4 rows where canton = "SZ"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition

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
51 51 EIN Einsiedeln 47.133042 8.756556 911 912 2699984 1221068 Weather station plain MeteoSwiss 01.01.1864 SZ Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation 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"}
61 61 GES Gersau 46.996069 8.523442 521 521 2682510 1205572 Weather station southern oriented slope MeteoSwiss 01.02.1867 SZ Temperature, Humidity, Dew point, Precipitation, Pressure, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GES https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06653 https://api.existenz.ch/apiv1/smn/latest?locations=GES https://api.existenz.ch/apiv1/smn/daterange?locations=GES {"title": "GES", "description": "Gersau", "alt": "Gersau", "link": "/existenz-api/smn_locations?code=GES"}
84 84 LAC Lachen / Galgenen 47.179197 8.858686 468   2707638 1226334 Weather station plain MeteoSwiss 01.10.1882 SZ Temperature, Humidity, Dew point, Precipitation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=LAC https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06665 https://api.existenz.ch/apiv1/smn/latest?locations=LAC https://api.existenz.ch/apiv1/smn/daterange?locations=LAC {"title": "LAC", "description": "Lachen / Galgenen", "alt": "Lachen / Galgenen", "link": "/existenz-api/smn_locations?code=LAC"}
128 128 SAG Sattel, SZ 47.081064 8.636967 790 791 2691000 1215145 Weather station plain MeteoSwiss 01.01.1901 SZ 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=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"}

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