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

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
5 5 AND Andeer GR 46.610139 9.431981 987 988 2752692 1164038 Automatic weather stations plain MeteoSchweiz 01.01.1901 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 GR 46.792661 9.679014 1878 1879 2771031 1184830 Automatic weather stations south-eastern oriented slope MeteoSchweiz, SLF 01.01.1890 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 GR 46.409158 10.019567 2260 2261 2798423 1143020 Automatic weather stations pass MeteoSchweiz 01.11.1908 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 GR 46.462494 9.668639 1856   2771283 1148119 Automatic weather stations southern oriented slope MeteoSchweiz, SLF 01.01.1892 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 GR 46.648408 10.2672 1971 1970 2816494 1170255 Automatic weather stations plain MeteoSchweiz 01.01.1917 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 GR 46.870572 9.530761 556 557 2759485 1193176 Automatic weather stations plain MeteoSchweiz 01.01.1887 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 GR 46.842275 9.180042 2468 2484 2732824 1189378 Automatic weather stations crest MeteoSchweiz 13.02.1992 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 GR 46.418039 9.821308 3294 3302 2783156 1143524 Automatic weather stations crest MeteoSchweiz 26.07.1979 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 GR 46.812969 9.843558 1594 1596 2783519 1187459 Automatic weather stations south-eastern oriented slope MeteoSchweiz, SLF 01.01.1864 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 GR 46.706569 8.853478 1197 1198 2708191 1173793 Automatic weather stations south-eastern oriented slope MeteoSchweiz 01.01.1959 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 GR 46.255075 9.163758 324 324 2733018 1124089 Automatic weather stations valley MeteoSchweiz 01.01.1901 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 GR 46.775039 9.215353 698 699 2735686 1181965 Automatic weather stations plain MeteoSchweiz 01.01.1892 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 GR 46.627275 9.753706 1408   2777274 1166618 Automatic weather stations south-western oriented slope MeteoSchweiz 01.01.1973 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 GR 46.817164 10.2614 2380 2381 2815375 1188987 Automatic weather stations south-eastern oriented slope MeteoSchweiz 06.11.1992 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 GR 46.577181 9.529544 2668 2669 2760262 1160570 Automatic weather stations crest MeteoSchweiz 28.10.1993 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 GR 46.347217 10.063031 1078 1079 2801994 1136249 Automatic weather stations valley MeteoSchweiz 01.01.1959 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 GR 46.526247 9.879469 1709 1710 2787251 1155685 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=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 GR 46.463542 9.1847 1639 1640 2734116 1147294 Automatic weather stations valley MeteoSchweiz, SLF 01.01.1864 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 GR 46.793275 10.283267 1304 1305 2817139 1186393 Automatic weather stations south-eastern oriented slope MeteoSchweiz 01.01.1881 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 GR 46.432331 9.762325 1804 1805 2778576 1144976 Automatic weather stations plain MeteoSchweiz 01.12.1863 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 GR 46.602256 10.426314 1386 1387 2828862 1165580 Automatic weather stations north-western oriented slope MeteoSchweiz, SLF 01.10.1900 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 GR 46.975506 9.668075 626   2769618 1205125 Automatic weather stations plain MeteoSchweiz 01.06.1885 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 GR 46.755039 9.554433 1568 1569 2761636 1180385 Automatic weather stations pass MeteoSchweiz 01.07.1993 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 GR 46.353019 9.6278 1089 1090 2768487 1135866 Automatic weather stations valley MeteoSchweiz 01.01.1901 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 GR 46.627758 9.188711 1242   2734017 1165551 Automatic weather stations valley MeteoSchweiz 01.02.1892 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 GR 46.833325 9.806394 2691 2674 2780616 1189634 Automatic weather stations crest MeteoSchweiz, SLF 01.11.1958 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, '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);