smn_locations

Data source: api.existenz.ch

5 rows where exposition = "pass"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: canton, measurements

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
12 12 BEH Passo del Bernina 46.409158 10.019567 2260 2261 2798423 1143020 Weather station pass MeteoSwiss 01.11.1908 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BEH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06797 https://api.existenz.ch/apiv1/smn/latest?locations=BEH https://api.existenz.ch/apiv1/smn/daterange?locations=BEH {"title": "BEH", "description": "Passo del Bernina", "alt": "Passo del Bernina", "link": "/existenz-api/smn_locations?code=BEH"}
28 28 CDM Col des Mosses 46.391525 7.098239 1412   2573817 1137853 Weather station pass MeteoSwiss 01.01.1972 VD Temperature, Humidity, Dew point, Precipitation, Wind, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CDM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06713 https://api.existenz.ch/apiv1/smn/latest?locations=CDM https://api.existenz.ch/apiv1/smn/daterange?locations=CDM {"title": "CDM", "description": "Col des Mosses", "alt": "Col des Mosses", "link": "/existenz-api/smn_locations?code=CDM"}
72 72 GSB Col du Grand St-Bernard 45.869092 7.170683 2472 2488 2579191 1079754 Weather station pass MeteoSwiss 01.01.1818 VS Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GSB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06717 https://api.existenz.ch/apiv1/smn/latest?locations=GSB https://api.existenz.ch/apiv1/smn/daterange?locations=GSB {"title": "GSB", "description": "Col du Grand St-Bernard", "alt": "Col du Grand St-Bernard", "link": "/existenz-api/smn_locations?code=GSB"}
81 81 JUN Jungfraujoch 46.547556 7.985444 3571 3576 2641939 1155287 Weather station pass MeteoSwiss 01.01.1931 VS Temperature, Humidity, Dew point, Pressure, Wind, Global radiation, Sunshine, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=JUN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06730 https://api.existenz.ch/apiv1/smn/latest?locations=JUN https://api.existenz.ch/apiv1/smn/daterange?locations=JUN {"title": "JUN", "description": "Jungfraujoch", "alt": "Jungfraujoch", "link": "/existenz-api/smn_locations?code=JUN"}
150 150 VAB Valbella 46.755039 9.554433 1568 1569 2761636 1180385 Weather station pass MeteoSwiss 01.07.1993 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VAB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06793 https://api.existenz.ch/apiv1/smn/latest?locations=VAB https://api.existenz.ch/apiv1/smn/daterange?locations=VAB {"title": "VAB", "description": "Valbella", "alt": "Valbella", "link": "/existenz-api/smn_locations?code=VAB"}

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