smn_locations

Data source: api.existenz.ch

4 rows where exposition = "basin" sorted by wigos_id

✎ View and edit SQL

This data as json, CSV (advanced)

data_owner 2 ✖

exposition 1 ✖

  • basin · 4 ✖
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
27 27 CDF La Chaux-de-Fonds 47.082947 6.792314 1017 1018 2550919 1214862 Weather station basin MeteoSwiss 01.01.1900 NE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature, Clouds https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CDF https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06612 https://api.existenz.ch/apiv1/smn/latest?locations=CDF https://api.existenz.ch/apiv1/smn/daterange?locations=CDF {"title": "CDF", "description": "La Chaux-de-Fonds", "alt": "La Chaux-de-Fonds", "link": "/existenz-api/smn_locations?code=CDF"}
159 159 WYN Wynau 47.255025 7.787475 422 424 2626405 1233849 Weather station basin MeteoSwiss 01.01.1978 BE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=WYN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06643 https://api.existenz.ch/apiv1/smn/latest?locations=WYN https://api.existenz.ch/apiv1/smn/daterange?locations=WYN {"title": "WYN", "description": "Wynau", "alt": "Wynau", "link": "/existenz-api/smn_locations?code=WYN"}
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"}
125 125 ROE Robièi 46.443067 8.513389 1898 1896 2682588 1144091 Weather station basin MeteoSwiss 01.02.1991 TI Temperature, Humidity, Dew point, Precipitation, 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=ROE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06751 https://api.existenz.ch/apiv1/smn/latest?locations=ROE https://api.existenz.ch/apiv1/smn/daterange?locations=ROE {"title": "ROE", "description": "Robi\u00e8i", "alt": "Robi\u00e8i", "link": "/existenz-api/smn_locations?code=ROE"}

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