smn_locations

Data source: api.existenz.ch

20 rows where canton = "GR" and data_owner = "MeteoSwiss"

✎ 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
5 5 AND Andeer 46.610139 9.431981 987 988 2752692 1164038 Weather station plain MeteoSwiss 01.01.1901 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=AND https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06787 https://api.existenz.ch/apiv1/smn/latest?locations=AND https://api.existenz.ch/apiv1/smn/daterange?locations=AND {"title": "AND", "description": "Andeer", "alt": "Andeer", "link": "/existenz-api/smn_locations?code=AND"}
12 12 BEH Passo del Bernina 46.409158 10.019567 2260 2261 2798423 1143020 Weather station pass MeteoSwiss 01.11.1908 GR 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=BEH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06797 https://api.existenz.ch/apiv1/smn/latest?locations=BEH https://api.existenz.ch/apiv1/smn/daterange?locations=BEH {"title": "BEH", "description": "Passo del Bernina", "alt": "Passo del Bernina", "link": "/existenz-api/smn_locations?code=BEH"}
25 25 BUF Buffalora 46.648408 10.2672 1971 1970 2816494 1170255 Weather station plain MeteoSwiss 01.01.1917 GR 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=BUF https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06778 https://api.existenz.ch/apiv1/smn/latest?locations=BUF https://api.existenz.ch/apiv1/smn/daterange?locations=BUF {"title": "BUF", "description": "Buffalora", "alt": "Buffalora", "link": "/existenz-api/smn_locations?code=BUF"}
35 35 CHU Chur 46.870572 9.530761 556 557 2759485 1193176 Weather station plain MeteoSwiss 01.01.1887 GR 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=CHU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06786 https://api.existenz.ch/apiv1/smn/latest?locations=CHU https://api.existenz.ch/apiv1/smn/daterange?locations=CHU {"title": "CHU", "description": "Chur", "alt": "Chur", "link": "/existenz-api/smn_locations?code=CHU"}
38 38 CMA Crap Masegn 46.842275 9.180042 2468 2484 2732824 1189378 Weather station crest MeteoSwiss 01.04.1993 GR Temperature, Humidity, Dew point, Pressure, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CMA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06688 https://api.existenz.ch/apiv1/smn/latest?locations=CMA https://api.existenz.ch/apiv1/smn/daterange?locations=CMA {"title": "CMA", "description": "Crap Masegn", "alt": "Crap Masegn", "link": "/existenz-api/smn_locations?code=CMA"}
40 40 COV Piz Corvatsch 46.418039 9.821308 3294 3302 2783156 1143524 Weather station crest MeteoSwiss 01.08.1979 GR 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=COV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06791 https://api.existenz.ch/apiv1/smn/latest?locations=COV https://api.existenz.ch/apiv1/smn/daterange?locations=COV {"title": "COV", "description": "Piz Corvatsch", "alt": "Piz Corvatsch", "link": "/existenz-api/smn_locations?code=COV"}
46 46 DIS Disentis 46.706569 8.853478 1197 1198 2708191 1173793 Weather station south-eastern oriented slope MeteoSwiss 01.01.1959 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=DIS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06782 https://api.existenz.ch/apiv1/smn/latest?locations=DIS https://api.existenz.ch/apiv1/smn/daterange?locations=DIS {"title": "DIS", "description": "Disentis", "alt": "Disentis", "link": "/existenz-api/smn_locations?code=DIS"}
71 71 GRO Grono 46.255075 9.163758 324 324 2733018 1124089 Weather station valley MeteoSwiss 01.01.1901 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06758 https://api.existenz.ch/apiv1/smn/latest?locations=GRO https://api.existenz.ch/apiv1/smn/daterange?locations=GRO {"title": "GRO", "description": "Grono", "alt": "Grono", "link": "/existenz-api/smn_locations?code=GRO"}
79 79 ILZ Ilanz 46.775039 9.215353 698 699 2735686 1181965 Weather station plain MeteoSwiss 01.01.1892 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Global radiation, Sunshine, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ILZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06789 https://api.existenz.ch/apiv1/smn/latest?locations=ILZ https://api.existenz.ch/apiv1/smn/daterange?locations=ILZ {"title": "ILZ", "description": "Ilanz", "alt": "Ilanz", "link": "/existenz-api/smn_locations?code=ILZ"}
87 87 LAT Bergün / Latsch 46.627275 9.753706 1408   2777274 1166618 Weather station south-western oriented slope MeteoSwiss 01.01.1973 GR Temperature, Humidity, Dew point, Precipitation, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=LAT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06642 https://api.existenz.ch/apiv1/smn/latest?locations=LAT https://api.existenz.ch/apiv1/smn/daterange?locations=LAT {"title": "LAT", "description": "Berg\u00fcn / Latsch", "alt": "Berg\u00fcn / Latsch", "link": "/existenz-api/smn_locations?code=LAT"}
107 107 NAS Naluns / Schlivera 46.817164 10.2614 2380 2381 2815375 1188987 Weather station south-eastern oriented slope MeteoSwiss 01.12.1992 GR Temperature, Humidity, Dew point, Pressure, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=NAS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06799 https://api.existenz.ch/apiv1/smn/latest?locations=NAS https://api.existenz.ch/apiv1/smn/daterange?locations=NAS {"title": "NAS", "description": "Naluns / Schlivera", "alt": "Naluns / Schlivera", "link": "/existenz-api/smn_locations?code=NAS"}
117 117 PMA Piz Martegnas 46.577181 9.529544 2668 2669 2760262 1160570 Weather station crest MeteoSwiss 01.11.1993 GR 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=PMA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06795 https://api.existenz.ch/apiv1/smn/latest?locations=PMA https://api.existenz.ch/apiv1/smn/daterange?locations=PMA {"title": "PMA", "description": "Piz Martegnas", "alt": "Piz Martegnas", "link": "/existenz-api/smn_locations?code=PMA"}
124 124 ROB Poschiavo / Robbia 46.347217 10.063031 1078 1079 2801994 1136249 Weather station valley MeteoSwiss 01.01.1959 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, 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=ROB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06794 https://api.existenz.ch/apiv1/smn/latest?locations=ROB https://api.existenz.ch/apiv1/smn/daterange?locations=ROB {"title": "ROB", "description": "Poschiavo / Robbia", "alt": "Poschiavo / Robbia", "link": "/existenz-api/smn_locations?code=ROB"}
129 129 SAM Samedan 46.526247 9.879469 1709 1710 2787251 1155685 Weather station plain MeteoSwiss 01.01.1980 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature, Longwave radiation, Clouds https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SAM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06792 https://api.existenz.ch/apiv1/smn/latest?locations=SAM https://api.existenz.ch/apiv1/smn/daterange?locations=SAM {"title": "SAM", "description": "Samedan", "alt": "Samedan", "link": "/existenz-api/smn_locations?code=SAM"}
133 133 SCU Scuol 46.793275 10.283267 1304 1305 2817139 1186393 Weather station south-eastern oriented slope MeteoSwiss 01.01.1881 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SCU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06798 https://api.existenz.ch/apiv1/smn/latest?locations=SCU https://api.existenz.ch/apiv1/smn/daterange?locations=SCU {"title": "SCU", "description": "Scuol", "alt": "Scuol", "link": "/existenz-api/smn_locations?code=SCU"}
135 135 SIA Segl-Maria 46.432331 9.762325 1804 1805 2778576 1144976 Weather station plain MeteoSwiss 01.12.1863 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SIA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06779 https://api.existenz.ch/apiv1/smn/latest?locations=SIA https://api.existenz.ch/apiv1/smn/daterange?locations=SIA {"title": "SIA", "description": "Segl-Maria", "alt": "Segl-Maria", "link": "/existenz-api/smn_locations?code=SIA"}
141 141 SRS Schiers 46.975506 9.668075 626   2769618 1205125 Weather station plain MeteoSwiss 01.06.1885 GR 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=SRS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06790 https://api.existenz.ch/apiv1/smn/latest?locations=SRS https://api.existenz.ch/apiv1/smn/daterange?locations=SRS {"title": "SRS", "description": "Schiers", "alt": "Schiers", "link": "/existenz-api/smn_locations?code=SRS"}
150 150 VAB Valbella 46.755039 9.554433 1568 1569 2761636 1180385 Weather station pass MeteoSwiss 01.07.1993 GR 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=VAB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06793 https://api.existenz.ch/apiv1/smn/latest?locations=VAB https://api.existenz.ch/apiv1/smn/daterange?locations=VAB {"title": "VAB", "description": "Valbella", "alt": "Valbella", "link": "/existenz-api/smn_locations?code=VAB"}
153 153 VIO Vicosoprano 46.353019 9.6278 1089 1090 2768487 1135866 Weather station valley MeteoSwiss 01.01.1901 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Foehn index https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VIO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06788 https://api.existenz.ch/apiv1/smn/latest?locations=VIO https://api.existenz.ch/apiv1/smn/daterange?locations=VIO {"title": "VIO", "description": "Vicosoprano", "alt": "Vicosoprano", "link": "/existenz-api/smn_locations?code=VIO"}
156 156 VLS Vals 46.627758 9.188711 1242   2734017 1165551 Weather station valley MeteoSwiss 01.02.1892 GR Temperature, Humidity, Dew point, Precipitation, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VLS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06663 https://api.existenz.ch/apiv1/smn/latest?locations=VLS https://api.existenz.ch/apiv1/smn/daterange?locations=VLS {"title": "VLS", "description": "Vals", "alt": "Vals", "link": "/existenz-api/smn_locations?code=VLS"}

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