smn_locations

Data source: api.existenz.ch

5 rows where canton = "LU"

✎ 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
50 50 EGO Egolzwil 47.179428 8.004758 522 523 2642913 1225541 Weather station plain MeteoSwiss 01.01.1974 LU Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EGO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06648 https://api.existenz.ch/apiv1/smn/latest?locations=EGO https://api.existenz.ch/apiv1/smn/daterange?locations=EGO {"title": "EGO", "description": "Egolzwil", "alt": "Egolzwil", "link": "/existenz-api/smn_locations?code=EGO"}
57 57 FLU Flühli, LU 46.889436 8.020336 940   2644333 1193311 Weather station western oriented slope MeteoSwiss 01.08.1882 LU Temperature, Humidity, Dew point, Precipitation, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=FLU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06652 https://api.existenz.ch/apiv1/smn/latest?locations=FLU https://api.existenz.ch/apiv1/smn/daterange?locations=FLU {"title": "FLU", "description": "Fl\u00fchli, LU", "alt": "Fl\u00fchli, LU", "link": "/existenz-api/smn_locations?code=FLU"}
90 90 LUZ Luzern 47.036439 8.301022 454 456 2665545 1209850 Weather station plain MeteoSwiss 01.01.1864 LU 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=LUZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06650 https://api.existenz.ch/apiv1/smn/latest?locations=LUZ https://api.existenz.ch/apiv1/smn/daterange?locations=LUZ {"title": "LUZ", "description": "Luzern", "alt": "Luzern", "link": "/existenz-api/smn_locations?code=LUZ"}
97 97 MOA Mosen 47.243847 8.232831 453 454 2660129 1232852 Weather station plain MeteoSwiss 01.01.1901 LU Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=MOA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06644 https://api.existenz.ch/apiv1/smn/latest?locations=MOA https://api.existenz.ch/apiv1/smn/daterange?locations=MOA {"title": "MOA", "description": "Mosen", "alt": "Mosen", "link": "/existenz-api/smn_locations?code=MOA"}
140 140 SPF Schüpfheim 46.947042 8.012442 744 745 2643684 1199711 Weather station plain MeteoSwiss 01.05.1993 LU Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SPF https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06651 https://api.existenz.ch/apiv1/smn/latest?locations=SPF https://api.existenz.ch/apiv1/smn/daterange?locations=SPF {"title": "SPF", "description": "Sch\u00fcpfheim", "alt": "Sch\u00fcpfheim", "link": "/existenz-api/smn_locations?code=SPF"}

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