smn_locations

Data source: api.existenz.ch

2 rows where canton = "SH"

✎ 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
77 77 HLL Hallau 47.697278 8.470464 419 420 2677457 1283472 Weather station plain MeteoSwiss 01.07.1886 SH 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=HLL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06624 https://api.existenz.ch/apiv1/smn/latest?locations=HLL https://api.existenz.ch/apiv1/smn/daterange?locations=HLL {"title": "HLL", "description": "Hallau", "alt": "Hallau", "link": "/existenz-api/smn_locations?code=HLL"}
134 134 SHA Schaffhausen 47.689842 8.620142 438 440 2688704 1282803 Weather station eastern oriented slope MeteoSwiss 01.10.1863 SH Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Temperature 5cm, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SHA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06620 https://api.existenz.ch/apiv1/smn/latest?locations=SHA https://api.existenz.ch/apiv1/smn/daterange?locations=SHA {"title": "SHA", "description": "Schaffhausen", "alt": "Schaffhausen", "link": "/existenz-api/smn_locations?code=SHA"}

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