smn_locations

Data source: api.existenz.ch

5 rows where canton = "TG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition, 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
19 19 BIZ Bischofszell / Sitterdorf 47.508828 9.266797 507 508 2737714 1263613 Weather station plain MeteoSwiss 01.10.1900 TG 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=BIZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06678 https://api.existenz.ch/apiv1/smn/latest?locations=BIZ https://api.existenz.ch/apiv1/smn/daterange?locations=BIZ {"title": "BIZ", "description": "Bischofszell / Sitterdorf", "alt": "Bischofszell / Sitterdorf", "link": "/existenz-api/smn_locations?code=BIZ"}
74 74 GUT Güttingen 47.601733 9.279428 440 441 2738423 1273962 Weather station height (30-100 m above valley) MeteoSwiss 01.06.1976 TG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index, Temperature 5cm, Soil temperature, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GUT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06621 https://api.existenz.ch/apiv1/smn/latest?locations=GUT https://api.existenz.ch/apiv1/smn/daterange?locations=GUT {"title": "GUT", "description": "G\u00fcttingen", "alt": "G\u00fcttingen", "link": "/existenz-api/smn_locations?code=GUT"}
76 76 HAI Salen-Reutenen 47.651242 9.023911 719 720 2719100 1279047 Weather station plain MeteoSwiss 01.01.1901 TG 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=HAI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06623 https://api.existenz.ch/apiv1/smn/latest?locations=HAI https://api.existenz.ch/apiv1/smn/daterange?locations=HAI {"title": "HAI", "description": "Salen-Reutenen", "alt": "Salen-Reutenen", "link": "/existenz-api/smn_locations?code=HAI"}
144 144 STK Steckborn 47.668628 8.981433 397 398 2715872 1280916 Weather station plain MeteoSwiss 01.02.1993 TG Pressure, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=STK https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06671 https://api.existenz.ch/apiv1/smn/latest?locations=STK https://api.existenz.ch/apiv1/smn/daterange?locations=STK {"title": "STK", "description": "Steckborn", "alt": "Steckborn", "link": "/existenz-api/smn_locations?code=STK"}
145 145 TAE Aadorf / Tänikon 47.479892 8.904928 539 539 2710518 1259824 Weather station plain MeteoSwiss 01.01.1970 TG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=TAE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06679 https://api.existenz.ch/apiv1/smn/latest?locations=TAE https://api.existenz.ch/apiv1/smn/daterange?locations=TAE {"title": "TAE", "description": "Aadorf / T\u00e4nikon", "alt": "Aadorf / T\u00e4nikon", "link": "/existenz-api/smn_locations?code=TAE"}

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