smn_locations

Data source: api.existenz.ch

3 rows where canton = "OW" and data_owner = "MeteoSwiss"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition

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
62 62 GIH Giswil 46.849447 8.190225 471 472 2657323 1188976 Weather station plain MeteoSwiss 01.08.1976 OW Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GIH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06657 https://api.existenz.ch/apiv1/smn/latest?locations=GIH https://api.existenz.ch/apiv1/smn/daterange?locations=GIH {"title": "GIH", "description": "Giswil", "alt": "Giswil", "link": "/existenz-api/smn_locations?code=GIH"}
114 114 PIL Pilatus 46.978869 8.252256 2105 2109 2661905 1203410 Weather station crest MeteoSwiss 01.01.1981 OW 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=PIL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06659 https://api.existenz.ch/apiv1/smn/latest?locations=PIL https://api.existenz.ch/apiv1/smn/daterange?locations=PIL {"title": "PIL", "description": "Pilatus", "alt": "Pilatus", "link": "/existenz-api/smn_locations?code=PIL"}
147 147 TIT Titlis 46.770608 8.425981 3045 3096 2675413 1180411 Weather station crest MeteoSwiss 01.06.1993 OW Temperature, Humidity, Dew point, Pressure, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=TIT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06740 https://api.existenz.ch/apiv1/smn/latest?locations=TIT https://api.existenz.ch/apiv1/smn/daterange?locations=TIT {"title": "TIT", "description": "Titlis", "alt": "Titlis", "link": "/existenz-api/smn_locations?code=TIT"}

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