smn_locations
Data source: api.existenz.ch
4 rows where measurements = "Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature" sorted by alt
This data as json, CSV (advanced)
Suggested facets: exposition
measurements 1 ✖
- Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature · 4 ✖
data_owner 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26 | 26 | BUS | Buchs / Aarau | 47.384381 | 8.07955 | 387 | 388 | 2648396 | 1248370 | Weather station | plain | MeteoSwiss | 01.04.1984 | AG | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BUS | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06633 | https://api.existenz.ch/apiv1/smn/latest?locations=BUS | https://api.existenz.ch/apiv1/smn/daterange?locations=BUS | {"title": "BUS", "description": "Buchs / Aarau", "alt": "Buchs / Aarau", "link": "/existenz-api/smn_locations?code=BUS"} |
123 | 123 | REH | Zürich / Affoltern | 47.427694 | 8.517953 | 444 | 445 | 2681433 | 1253548 | Weather station | plain | MeteoSwiss | 01.01.1961 | ZH | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=REH | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06664 | https://api.existenz.ch/apiv1/smn/latest?locations=REH | https://api.existenz.ch/apiv1/smn/daterange?locations=REH | {"title": "REH", "description": "Z\u00fcrich / Affoltern", "alt": "Z\u00fcrich / Affoltern", "link": "/existenz-api/smn_locations?code=REH"} |
30 | 30 | CGI | Nyon / Changins | 46.401053 | 6.227722 | 458 | 460 | 2506878 | 1139574 | Weather station | height (30-100 m above valley) | MeteoSwiss | 01.01.1965 | VD | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CGI | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06705 | https://api.existenz.ch/apiv1/smn/latest?locations=CGI | https://api.existenz.ch/apiv1/smn/daterange?locations=CGI | {"title": "CGI", "description": "Nyon / Changins", "alt": "Nyon / Changins", "link": "/existenz-api/smn_locations?code=CGI"} |
67 | 67 | GRA | Fribourg / Grangeneuve | 46.7714 | 7.113736 | 651 | 651 | 2575184 | 1180076 | Weather station | height (30-100 m above valley) | MeteoSwiss | 01.10.1900 | FR | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRA | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06625 | https://api.existenz.ch/apiv1/smn/latest?locations=GRA | https://api.existenz.ch/apiv1/smn/daterange?locations=GRA | {"title": "GRA", "description": "Fribourg / Grangeneuve", "alt": "Fribourg / Grangeneuve", "link": "/existenz-api/smn_locations?code=GRA"} |
Advanced export
JSON shape: default, array, newline-delimited
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);