smn_locations

Data source: api.existenz.ch

4 rows where canton = "UR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: data_owner, data_since

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
4 4 ALT Altdorf 46.887069 8.621894 438 440 2690181 1193564 Weather station plain MeteoSwiss 01.01.1864 UR 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=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"}
6 6 ANT Andermatt 46.630914 8.580553 1435 1436 2687445 1165044 Weather station basin MeteoSwiss, SLF 01.01.1864 UR 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=ANT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06695 https://api.existenz.ch/apiv1/smn/latest?locations=ANT https://api.existenz.ch/apiv1/smn/daterange?locations=ANT {"title": "ANT", "description": "Andermatt", "alt": "Andermatt", "link": "/existenz-api/smn_locations?code=ANT"}
66 66 GOS Göschenen 46.692678 8.595364 950 951 2688477 1171926 Weather station valley MeteoSwiss 01.01.1883 UR 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=GOS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06668 https://api.existenz.ch/apiv1/smn/latest?locations=GOS https://api.existenz.ch/apiv1/smn/daterange?locations=GOS {"title": "GOS", "description": "G\u00f6schenen", "alt": "G\u00f6schenen", "link": "/existenz-api/smn_locations?code=GOS"}
73 73 GUE Gütsch, Andermatt 46.652475 8.615531 2286 2288 2690087 1167480 Weather station southern oriented slope MeteoSwiss 01.01.1954 UR 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=GUE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06750 https://api.existenz.ch/apiv1/smn/latest?locations=GUE https://api.existenz.ch/apiv1/smn/daterange?locations=GUE {"title": "GUE", "description": "G\u00fctsch, Andermatt", "alt": "G\u00fctsch, Andermatt", "link": "/existenz-api/smn_locations?code=GUE"}

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