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

Link rowid ▼ code name canton lat lon alt alt_barometric chx chy station_type exposition data_owner data_since link wigos_id latest_values last_24h_values popup
7 7 ARH Altenrhein SG 47.483631 9.56685 398 399 2760387 1261382 Automatic weather stations plain MeteoSchweiz 15.01.1993 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 SG 47.273389 9.108494 623 624 2726348 1237176 Automatic weather stations valley MeteoSchweiz 01.08.1879 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 SG 47.376608 9.612706 409 410 2764171 1249582 Automatic weather stations plain MeteoSchweiz 27.08.2014 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 SG 47.128739 9.21605 419 421 2734849 1221278 Automatic weather stations southern oriented slope MeteoSchweiz 23.07.1992 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 SG 47.016631 9.502594 497 497 2756911 1209351 Automatic weather stations plain MeteoSchweiz 01.01.1864 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 SG 47.224933 8.9403 408 409 2713726 1231533 Automatic weather stations plain MeteoSchweiz 28.01.1993 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 SG 47.425475 9.398528 776 777 2747866 1254588 Automatic weather stations north-western oriented slope MeteoSchweiz 01.01.1864 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, 'canton' 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, 'link' string, 'wigos_id' string, 'latest_values' string, 'last_24h_values' string, popup);
CREATE UNIQUE INDEX smn_locations_code_index ON smn_locations(code);