smn_locations

Data source: api.existenz.ch

2 rows where canton = "GL"

✎ 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
52 52 ELM Elm 46.923742 9.175347 958 958 2732266 1198424 Weather station plain MeteoSwiss 01.02.1878 GL 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=ELM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06682 https://api.existenz.ch/apiv1/smn/latest?locations=ELM https://api.existenz.ch/apiv1/smn/daterange?locations=ELM {"title": "ELM", "description": "Elm", "alt": "Elm", "link": "/existenz-api/smn_locations?code=ELM"}
63 63 GLA Glarus 47.034586 9.066961 517 518 2723757 1210567 Weather station height (30-100 m above valley) MeteoSwiss 01.01.1864 GL 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=GLA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06685 https://api.existenz.ch/apiv1/smn/latest?locations=GLA https://api.existenz.ch/apiv1/smn/daterange?locations=GLA {"title": "GLA", "description": "Glarus", "alt": "Glarus", "link": "/existenz-api/smn_locations?code=GLA"}

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