smn_locations

Data source: api.existenz.ch

26 rows where canton = "GR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition, data_owner, 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"}
8 8 ARO Arosa 46.792661 9.679014 1878 1879 2771031 1184830 Weather station south-eastern oriented slope MeteoSwiss, SLF 01.01.1890 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=ARO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06785 https://api.existenz.ch/apiv1/smn/latest?locations=ARO https://api.existenz.ch/apiv1/smn/daterange?locations=ARO {"title": "ARO", "description": "Arosa", "alt": "Arosa", "link": "/existenz-api/smn_locations?code=ARO"}
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"}
18 18 BIV Bivio 46.462494 9.668639 1856   2771283 1148119 Weather station southern oriented slope MeteoSwiss, SLF 01.01.1892 GR Temperature, Humidity, Dew point, Precipitation, Wind, Snow, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BIV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06774 https://api.existenz.ch/apiv1/smn/latest?locations=BIV https://api.existenz.ch/apiv1/smn/daterange?locations=BIV {"title": "BIV", "description": "Bivio", "alt": "Bivio", "link": "/existenz-api/smn_locations?code=BIV"}
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"}
43 43 DAV Davos 46.812969 9.843558 1594 1596 2783519 1187459 Weather station south-eastern oriented slope MeteoSwiss, SLF 01.01.1864 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=DAV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06784 https://api.existenz.ch/apiv1/smn/latest?locations=DAV https://api.existenz.ch/apiv1/smn/daterange?locations=DAV {"title": "DAV", "description": "Davos", "alt": "Davos", "link": "/existenz-api/smn_locations?code=DAV"}
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"}
130 130 SBE S. Bernardino 46.463542 9.1847 1639 1640 2734116 1147294 Weather station valley MeteoSwiss, SLF 01.01.1968 GR 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=SBE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06783 https://api.existenz.ch/apiv1/smn/latest?locations=SBE https://api.existenz.ch/apiv1/smn/daterange?locations=SBE {"title": "SBE", "description": "S. Bernardino", "alt": "S. Bernardino", "link": "/existenz-api/smn_locations?code=SBE"}
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"}
139 139 SMM Sta. Maria, Val Müstair 46.602256 10.426314 1386 1387 2828862 1165580 Weather station north-western oriented slope MeteoSwiss, SLF 01.10.1900 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=SMM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06796 https://api.existenz.ch/apiv1/smn/latest?locations=SMM https://api.existenz.ch/apiv1/smn/daterange?locations=SMM {"title": "SMM", "description": "Sta. Maria, Val M\u00fcstair", "alt": "Sta. Maria, Val M\u00fcstair", "link": "/existenz-api/smn_locations?code=SMM"}
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"}
158 158 WFJ Weissfluhjoch 46.833325 9.806394 2691 2674 2780616 1189634 Weather station crest MeteoSwiss, SLF 01.11.1958 GR Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=WFJ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06780 https://api.existenz.ch/apiv1/smn/latest?locations=WFJ https://api.existenz.ch/apiv1/smn/daterange?locations=WFJ {"title": "WFJ", "description": "Weissfluhjoch", "alt": "Weissfluhjoch", "link": "/existenz-api/smn_locations?code=WFJ"}

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