smn_locations

Data source: api.existenz.ch

7 rows where canton = "SG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition, data_since, 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
7 7 ARH Altenrhein 47.483631 9.56685 398 399 2760387 1261382 Weather station plain MeteoSwiss 01.02.1993 SG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Clouds https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ARH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06690 https://api.existenz.ch/apiv1/smn/latest?locations=ARH https://api.existenz.ch/apiv1/smn/daterange?locations=ARH {"title": "ARH", "description": "Altenrhein", "alt": "Altenrhein", "link": "/existenz-api/smn_locations?code=ARH"}
48 48 EBK Ebnat-Kappel 47.273389 9.108494 623 624 2726348 1237176 Weather station valley MeteoSwiss 01.08.1879 SG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EBK https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06693 https://api.existenz.ch/apiv1/smn/latest?locations=EBK https://api.existenz.ch/apiv1/smn/daterange?locations=EBK {"title": "EBK", "description": "Ebnat-Kappel", "alt": "Ebnat-Kappel", "link": "/existenz-api/smn_locations?code=EBK"}
109 109 OBR Oberriet / Kriessern 47.376608 9.612706 409 410 2764171 1249582 Weather station plain MeteoSwiss 01.06.2015 SG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Foehn index, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=OBR https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06649 https://api.existenz.ch/apiv1/smn/latest?locations=OBR https://api.existenz.ch/apiv1/smn/daterange?locations=OBR {"title": "OBR", "description": "Oberriet / Kriessern", "alt": "Oberriet / Kriessern", "link": "/existenz-api/smn_locations?code=OBR"}
121 121 QUI Quinten 47.128739 9.21605 419 421 2734849 1221278 Weather station southern oriented slope MeteoSwiss 01.08.1992 SG Pressure, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=QUI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06687 https://api.existenz.ch/apiv1/smn/latest?locations=QUI https://api.existenz.ch/apiv1/smn/daterange?locations=QUI {"title": "QUI", "description": "Quinten", "alt": "Quinten", "link": "/existenz-api/smn_locations?code=QUI"}
122 122 RAG Bad Ragaz 47.016631 9.502594 497 497 2756911 1209351 Weather station plain MeteoSwiss 01.06.1870 SG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, 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=RAG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06686 https://api.existenz.ch/apiv1/smn/latest?locations=RAG https://api.existenz.ch/apiv1/smn/daterange?locations=RAG {"title": "RAG", "description": "Bad Ragaz", "alt": "Bad Ragaz", "link": "/existenz-api/smn_locations?code=RAG"}
132 132 SCM Schmerikon 47.224933 8.9403 408 409 2713726 1231533 Weather station plain MeteoSwiss 01.02.1993 SG Pressure, Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SCM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06683 https://api.existenz.ch/apiv1/smn/latest?locations=SCM https://api.existenz.ch/apiv1/smn/daterange?locations=SCM {"title": "SCM", "description": "Schmerikon", "alt": "Schmerikon", "link": "/existenz-api/smn_locations?code=SCM"}
143 143 STG St. Gallen 47.425475 9.398528 776 777 2747866 1254588 Weather station north-western oriented slope MeteoSwiss 01.01.1864 SG Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Soil temperature https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=STG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06681 https://api.existenz.ch/apiv1/smn/latest?locations=STG https://api.existenz.ch/apiv1/smn/daterange?locations=STG {"title": "STG", "description": "St. Gallen", "alt": "St. Gallen", "link": "/existenz-api/smn_locations?code=STG"}

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