smn_locations

Data source: api.existenz.ch

5 rows where canton = "AG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: measurements

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
14 14 BEZ Beznau 47.557256 8.233325 326 327 2659813 1267696 Weather station plain MeteoSwiss 01.01.1981 AG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BEZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06646 https://api.existenz.ch/apiv1/smn/latest?locations=BEZ https://api.existenz.ch/apiv1/smn/daterange?locations=BEZ {"title": "BEZ", "description": "Beznau", "alt": "Beznau", "link": "/existenz-api/smn_locations?code=BEZ"}
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"}
88 88 LEI Leibstadt 47.597361 8.1882 341 343 2656375 1272122 Weather station plain MeteoSwiss 01.03.1984 AG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=LEI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06666 https://api.existenz.ch/apiv1/smn/latest?locations=LEI https://api.existenz.ch/apiv1/smn/daterange?locations=LEI {"title": "LEI", "description": "Leibstadt", "alt": "Leibstadt", "link": "/existenz-api/smn_locations?code=LEI"}
99 99 MOE Möhlin 47.572197 7.877911 343 344 2633054 1269147 Weather station plain MeteoSwiss 01.10.1900 AG 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=MOE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06641 https://api.existenz.ch/apiv1/smn/latest?locations=MOE https://api.existenz.ch/apiv1/smn/daterange?locations=MOE {"title": "MOE", "description": "M\u00f6hlin", "alt": "M\u00f6hlin", "link": "/existenz-api/smn_locations?code=MOE"}
119 119 PSI Würenlingen / PSI 47.536475 8.226944 334 336 2659356 1265381 Weather station plain MeteoSwiss 01.02.1992 AG 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=PSI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06647 https://api.existenz.ch/apiv1/smn/latest?locations=PSI https://api.existenz.ch/apiv1/smn/daterange?locations=PSI {"title": "PSI", "description": "W\u00fcrenlingen / PSI", "alt": "W\u00fcrenlingen / PSI", "link": "/existenz-api/smn_locations?code=PSI"}

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