smn_locations

Data source: api.existenz.ch

10 rows where exposition = "southern oriented slope"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: data_owner, data_since, 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
18 18 BIV Bivio 46.462494 9.668639 1856   2771283 1148119 Weather station southern oriented slope MeteoSwiss, SLF 01.01.1892 GR Temperature, Humidity, Dew point, Precipitation, Wind, Snow, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BIV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06774 https://api.existenz.ch/apiv1/smn/latest?locations=BIV https://api.existenz.ch/apiv1/smn/daterange?locations=BIV {"title": "BIV", "description": "Bivio", "alt": "Bivio", "link": "/existenz-api/smn_locations?code=BIV"}
32 32 CHB Les Charbonnières 46.67015 6.312428 1045 1046 2513821 1169388 Weather station southern oriented slope MeteoSwiss 01.07.1982 VD 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=CHB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06703 https://api.existenz.ch/apiv1/smn/latest?locations=CHB https://api.existenz.ch/apiv1/smn/daterange?locations=CHB {"title": "CHB", "description": "Les Charbonni\u00e8res", "alt": "Les Charbonni\u00e8res", "link": "/existenz-api/smn_locations?code=CHB"}
33 33 CHD Château-d'Oex 46.479819 7.139656 1028 1029 2577040 1147655 Weather station southern oriented slope MeteoSwiss 01.01.1879 VD Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, 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=CHD https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06627 https://api.existenz.ch/apiv1/smn/latest?locations=CHD https://api.existenz.ch/apiv1/smn/daterange?locations=CHD {"title": "CHD", "description": "Ch\u00e2teau-d'Oex", "alt": "Ch\u00e2teau-d'Oex", "link": "/existenz-api/smn_locations?code=CHD"}
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"}
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"}
111 111 OTL Locarno / Monti 46.172256 8.787494 367 374 2704167 1114316 Weather station southern oriented slope MeteoSwiss 01.01.1864 TI Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Soil temperature, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=OTL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06760 https://api.existenz.ch/apiv1/smn/latest?locations=OTL https://api.existenz.ch/apiv1/smn/daterange?locations=OTL {"title": "OTL", "description": "Locarno / Monti", "alt": "Locarno / Monti", "link": "/existenz-api/smn_locations?code=OTL"}
120 120 PUY Pully 46.512283 6.667517 456 457 2540819 1151511 Weather station southern oriented slope MeteoSwiss 01.01.1961 VD 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=PUY https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06711 https://api.existenz.ch/apiv1/smn/latest?locations=PUY https://api.existenz.ch/apiv1/smn/daterange?locations=PUY {"title": "PUY", "description": "Pully", "alt": "Pully", "link": "/existenz-api/smn_locations?code=PUY"}
121 121 QUI Quinten 47.128739 9.21605 419 421 2734849 1221278 Weather station southern oriented slope MeteoSwiss 01.08.1992 SG Pressure, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=QUI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06687 https://api.existenz.ch/apiv1/smn/latest?locations=QUI https://api.existenz.ch/apiv1/smn/daterange?locations=QUI {"title": "QUI", "description": "Quinten", "alt": "Quinten", "link": "/existenz-api/smn_locations?code=QUI"}
138 138 SMA Zürich / Fluntern 47.377925 8.565742 556 557 2685118 1248066 Weather station southern oriented slope MeteoSwiss 01.01.1864 ZH 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=SMA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06660 https://api.existenz.ch/apiv1/smn/latest?locations=SMA https://api.existenz.ch/apiv1/smn/daterange?locations=SMA {"title": "SMA", "description": "Z\u00fcrich / Fluntern", "alt": "Z\u00fcrich / Fluntern", "link": "/existenz-api/smn_locations?code=SMA"}
152 152 VEV Vevey / Corseaux 46.471239 6.815056 405   2552106 1146847 Weather station southern oriented slope MeteoSwiss 01.01.1961 VD Temperature, Humidity, Dew point, Precipitation, Wind, Global radiation, Sunshine, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VEV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06603 https://api.existenz.ch/apiv1/smn/latest?locations=VEV https://api.existenz.ch/apiv1/smn/daterange?locations=VEV {"title": "VEV", "description": "Vevey / Corseaux", "alt": "Vevey / Corseaux", "link": "/existenz-api/smn_locations?code=VEV"}

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