smn_locations

Data source: api.existenz.ch

23 rows where exposition = "crest"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: data_owner, data_since, canton, 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
9 9 ATT Les Attelas 46.0991 7.26865 2734 2735 2586854 1105302 Weather station crest MeteoSwiss 01.09.1993 VS 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=ATT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06723 https://api.existenz.ch/apiv1/smn/latest?locations=ATT https://api.existenz.ch/apiv1/smn/daterange?locations=ATT {"title": "ATT", "description": "Les Attelas", "alt": "Les Attelas", "link": "/existenz-api/smn_locations?code=ATT"}
10 10 BAN Bantiger 46.977806 7.528667 942   2606850 1202975 Weather station crest MeteoSwiss 01.01.1993 BE Temperature, Humidity, Dew point, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BAN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06634 https://api.existenz.ch/apiv1/smn/latest?locations=BAN https://api.existenz.ch/apiv1/smn/daterange?locations=BAN {"title": "BAN", "description": "Bantiger", "alt": "Bantiger", "link": "/existenz-api/smn_locations?code=BAN"}
31 31 CHA Chasseral 47.131761 7.054367 1594 1596 2570845 1220158 Weather station crest MeteoSwiss 01.01.1981 BE 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=CHA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06605 https://api.existenz.ch/apiv1/smn/latest?locations=CHA https://api.existenz.ch/apiv1/smn/daterange?locations=CHA {"title": "CHA", "description": "Chasseral", "alt": "Chasseral", "link": "/existenz-api/smn_locations?code=CHA"}
37 37 CIM Cimetta 46.200467 8.79165 1661 1662 2704434 1117457 Weather station crest MeteoSwiss 01.01.1982 TI Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Longwave radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CIM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06759 https://api.existenz.ch/apiv1/smn/latest?locations=CIM https://api.existenz.ch/apiv1/smn/daterange?locations=CIM {"title": "CIM", "description": "Cimetta", "alt": "Cimetta", "link": "/existenz-api/smn_locations?code=CIM"}
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"}
45 45 DIA Les Diablerets 46.32675 7.203781 2964 2965 2581913 1130622 Weather station crest MeteoSwiss 01.11.1992 VD Temperature, Humidity, Dew point, Pressure, Wind, Global radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=DIA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06714 https://api.existenz.ch/apiv1/smn/latest?locations=DIA https://api.existenz.ch/apiv1/smn/daterange?locations=DIA {"title": "DIA", "description": "Les Diablerets", "alt": "Les Diablerets", "link": "/existenz-api/smn_locations?code=DIA"}
47 47 DOL La Dôle 46.424794 6.099453 1670 1671 2497059 1142373 Weather station crest MeteoSwiss 01.01.1973 VD 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=DOL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06702 https://api.existenz.ch/apiv1/smn/latest?locations=DOL https://api.existenz.ch/apiv1/smn/daterange?locations=DOL {"title": "DOL", "description": "La D\u00f4le", "alt": "La D\u00f4le", "link": "/existenz-api/smn_locations?code=DOL"}
49 49 EGH Eggishorn 46.426528 8.092728 2892 2893 2650279 1141897 Weather station crest MeteoSwiss 01.11.1993 VS 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=EGH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06739 https://api.existenz.ch/apiv1/smn/latest?locations=EGH https://api.existenz.ch/apiv1/smn/daterange?locations=EGH {"title": "EGH", "description": "Eggishorn", "alt": "Eggishorn", "link": "/existenz-api/smn_locations?code=EGH"}
60 60 GEN Monte Generoso 45.927592 9.017875 1600 1601 2722503 1087455 Weather station crest MeteoSwiss 01.08.1992 TI 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=GEN https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06777 https://api.existenz.ch/apiv1/smn/latest?locations=GEN https://api.existenz.ch/apiv1/smn/daterange?locations=GEN {"title": "GEN", "description": "Monte Generoso", "alt": "Monte Generoso", "link": "/existenz-api/smn_locations?code=GEN"}
65 65 GOR Gornergrat 45.983633 7.785742 3129 3131 2626899 1092512 Weather station crest MeteoSwiss 01.08.1993 VS 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=GOR https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06749 https://api.existenz.ch/apiv1/smn/latest?locations=GOR https://api.existenz.ch/apiv1/smn/daterange?locations=GOR {"title": "GOR", "description": "Gornergrat", "alt": "Gornergrat", "link": "/existenz-api/smn_locations?code=GOR"}
78 78 HOE Hörnli 47.370864 8.941644 1133 1134 2713517 1247756 Weather station crest MeteoSwiss 01.08.1974 ZH 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=HOE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06689 https://api.existenz.ch/apiv1/smn/latest?locations=HOE https://api.existenz.ch/apiv1/smn/daterange?locations=HOE {"title": "HOE", "description": "H\u00f6rnli", "alt": "H\u00f6rnli", "link": "/existenz-api/smn_locations?code=HOE"}
85 85 LAE Lägern 47.481933 8.397222 845 845 2672251 1259460 Weather station crest MeteoSwiss 01.12.1989 ZH 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=LAE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06669 https://api.existenz.ch/apiv1/smn/latest?locations=LAE https://api.existenz.ch/apiv1/smn/daterange?locations=LAE {"title": "LAE", "description": "L\u00e4gern", "alt": "L\u00e4gern", "link": "/existenz-api/smn_locations?code=LAE"}
96 96 MLS Le Moléson 46.546197 7.017753 1974 1976 2567718 1155077 Weather station crest MeteoSwiss 01.10.1982 FR 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=MLS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06609 https://api.existenz.ch/apiv1/smn/latest?locations=MLS https://api.existenz.ch/apiv1/smn/daterange?locations=MLS {"title": "MLS", "description": "Le Mol\u00e9son", "alt": "Le Mol\u00e9son", "link": "/existenz-api/smn_locations?code=MLS"}
103 103 MTR Matro 46.410103 8.924742 2171 2190 2714264 1140943 Weather station crest MeteoSwiss 01.01.1993 TI 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=MTR https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06754 https://api.existenz.ch/apiv1/smn/latest?locations=MTR https://api.existenz.ch/apiv1/smn/daterange?locations=MTR {"title": "MTR", "description": "Matro", "alt": "Matro", "link": "/existenz-api/smn_locations?code=MTR"}
106 106 NAP Napf 47.004667 7.940117 1404 1405 2638137 1206079 Weather station crest MeteoSwiss 01.01.1978 BE 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=NAP https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06639 https://api.existenz.ch/apiv1/smn/latest?locations=NAP https://api.existenz.ch/apiv1/smn/daterange?locations=NAP {"title": "NAP", "description": "Napf", "alt": "Napf", "link": "/existenz-api/smn_locations?code=NAP"}
114 114 PIL Pilatus 46.978869 8.252256 2105 2109 2661905 1203410 Weather station crest MeteoSwiss 01.01.1981 OW 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=PIL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06659 https://api.existenz.ch/apiv1/smn/latest?locations=PIL https://api.existenz.ch/apiv1/smn/daterange?locations=PIL {"title": "PIL", "description": "Pilatus", "alt": "Pilatus", "link": "/existenz-api/smn_locations?code=PIL"}
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"}
127 127 SAE Säntis 47.249447 9.343469 2501 2494 2744188 1234920 Weather station crest MeteoSwiss 01.01.1864 AI 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=SAE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06680 https://api.existenz.ch/apiv1/smn/latest?locations=SAE https://api.existenz.ch/apiv1/smn/daterange?locations=SAE {"title": "SAE", "description": "S\u00e4ntis", "alt": "S\u00e4ntis", "link": "/existenz-api/smn_locations?code=SAE"}
142 142 STC St. Chrischona 47.571767 7.687094 493   2618696 1269037 Weather station crest MeteoSwiss 01.01.1992 BS Temperature, Humidity, Dew point, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=STC https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06600 https://api.existenz.ch/apiv1/smn/latest?locations=STC https://api.existenz.ch/apiv1/smn/daterange?locations=STC {"title": "STC", "description": "St. Chrischona", "alt": "St. Chrischona", "link": "/existenz-api/smn_locations?code=STC"}
147 147 TIT Titlis 46.770608 8.425981 3045 3096 2675413 1180411 Weather station crest MeteoSwiss 01.06.1993 OW 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=TIT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06740 https://api.existenz.ch/apiv1/smn/latest?locations=TIT https://api.existenz.ch/apiv1/smn/daterange?locations=TIT {"title": "TIT", "description": "Titlis", "alt": "Titlis", "link": "/existenz-api/smn_locations?code=TIT"}
148 148 UEB Uetliberg 47.351364 8.490225 854   2679455 1245034 Weather station crest MeteoSwiss 01.12.1991 ZH Temperature, Humidity, Dew point, Wind, Global radiation, Sunshine https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=UEB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06677 https://api.existenz.ch/apiv1/smn/latest?locations=UEB https://api.existenz.ch/apiv1/smn/daterange?locations=UEB {"title": "UEB", "description": "Uetliberg", "alt": "Uetliberg", "link": "/existenz-api/smn_locations?code=UEB"}
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);