smn_locations

Data source: api.existenz.ch

4 rows where exposition = "western oriented slope"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: data_owner, canton

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
57 57 FLU Flühli, LU 46.889436 8.020336 940   2644333 1193311 Weather station western oriented slope MeteoSwiss 01.08.1882 LU Temperature, Humidity, Dew point, Precipitation, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=FLU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06652 https://api.existenz.ch/apiv1/smn/latest?locations=FLU https://api.existenz.ch/apiv1/smn/daterange?locations=FLU {"title": "FLU", "description": "Fl\u00fchli, LU", "alt": "Fl\u00fchli, LU", "link": "/existenz-api/smn_locations?code=FLU"}
68 68 GRC Grächen 46.195314 7.836822 1605 1606 2630738 1116062 Weather station western oriented slope MeteoSwiss 01.01.1864 VS Temperature, Humidity, Dew point, Precipitation, Pressure, Global radiation, Sunshine, Snow, Temperature 5cm, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRC https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06728 https://api.existenz.ch/apiv1/smn/latest?locations=GRC https://api.existenz.ch/apiv1/smn/daterange?locations=GRC {"title": "GRC", "description": "Gr\u00e4chen", "alt": "Gr\u00e4chen", "link": "/existenz-api/smn_locations?code=GRC"}
155 155 VIT Villars-Tiercelin 46.621778 6.710069 859   2544198 1163651 Weather station western oriented slope MeteoSwiss 01.10.1984 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=VIT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06707 https://api.existenz.ch/apiv1/smn/latest?locations=VIT https://api.existenz.ch/apiv1/smn/daterange?locations=VIT {"title": "VIT", "description": "Villars-Tiercelin", "alt": "Villars-Tiercelin", "link": "/existenz-api/smn_locations?code=VIT"}
160 160 ZER Zermatt 46.029272 7.752433 1638 1640 2624298 1097574 Weather station western oriented slope MeteoSwiss, SLF 01.04.1892 VS 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=ZER https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06748 https://api.existenz.ch/apiv1/smn/latest?locations=ZER https://api.existenz.ch/apiv1/smn/daterange?locations=ZER {"title": "ZER", "description": "Zermatt", "alt": "Zermatt", "link": "/existenz-api/smn_locations?code=ZER"}

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