smn_locations

Data source: api.existenz.ch

2 rows where alt_barometric = 1640 and data_owner = "MeteoSwiss, SLF"

✎ View and edit SQL

This data as json, CSV (advanced)

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
130 130 SBE S. Bernardino 46.463542 9.1847 1639 1640 2734116 1147294 Weather station valley MeteoSwiss, SLF 01.01.1968 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SBE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06783 https://api.existenz.ch/apiv1/smn/latest?locations=SBE https://api.existenz.ch/apiv1/smn/daterange?locations=SBE {"title": "SBE", "description": "S. Bernardino", "alt": "S. Bernardino", "link": "/existenz-api/smn_locations?code=SBE"}
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);