smn_locations

Data source: api.existenz.ch

2 rows where canton = "SO"

✎ 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
64 64 GOE Gösgen 47.363147 7.973733 380 382 2640422 1245949 Weather station plain MeteoSwiss 01.12.1981 SO 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=GOE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06626 https://api.existenz.ch/apiv1/smn/latest?locations=GOE https://api.existenz.ch/apiv1/smn/daterange?locations=GOE {"title": "GOE", "description": "G\u00f6sgen", "alt": "G\u00f6sgen", "link": "/existenz-api/smn_locations?code=GOE"}
69 69 GRE Grenchen 47.179097 7.415144 428 429 2598219 1225350 Weather station plain MeteoSwiss 01.06.1992 SO Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Clouds https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06632 https://api.existenz.ch/apiv1/smn/latest?locations=GRE https://api.existenz.ch/apiv1/smn/daterange?locations=GRE {"title": "GRE", "description": "Grenchen", "alt": "Grenchen", "link": "/existenz-api/smn_locations?code=GRE"}

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