smn_locations
Data source: api.existenz.ch
16 rows where data_since = "01.01.1864" sorted by name
This data as json, CSV (advanced)
Suggested facets: exposition, canton, measurements
data_owner 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | ALT | Altdorf | 46.887069 | 8.621894 | 438 | 440 | 2690181 | 1193564 | Weather station | plain | MeteoSwiss | 01.01.1864 | UR | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ALT | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06672 | https://api.existenz.ch/apiv1/smn/latest?locations=ALT | https://api.existenz.ch/apiv1/smn/daterange?locations=ALT | {"title": "ALT", "description": "Altdorf", "alt": "Altdorf", "link": "/existenz-api/smn_locations?code=ALT"} |
6 | 6 | ANT | Andermatt | 46.630914 | 8.580553 | 1435 | 1436 | 2687445 | 1165044 | Weather station | basin | MeteoSwiss, SLF | 01.01.1864 | UR | 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=ANT | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06695 | https://api.existenz.ch/apiv1/smn/latest?locations=ANT | https://api.existenz.ch/apiv1/smn/daterange?locations=ANT | {"title": "ANT", "description": "Andermatt", "alt": "Andermatt", "link": "/existenz-api/smn_locations?code=ANT"} |
13 | 13 | BER | Bern / Zollikofen | 46.990744 | 7.464061 | 553 | 554 | 2601934 | 1204410 | Weather station | plain | MeteoSwiss | 01.01.1864 | BE | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, 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=BER | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06631 | https://api.existenz.ch/apiv1/smn/latest?locations=BER | https://api.existenz.ch/apiv1/smn/daterange?locations=BER | {"title": "BER", "description": "Bern / Zollikofen", "alt": "Bern / Zollikofen", "link": "/existenz-api/smn_locations?code=BER"} |
34 | 34 | CHM | Chaumont | 47.049169 | 6.978825 | 1136 | 1137 | 2565060 | 1211007 | Weather station | height (30-100 m above valley) | MeteoSwiss | 01.01.1864 | NE | 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=CHM | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06608 | https://api.existenz.ch/apiv1/smn/latest?locations=CHM | https://api.existenz.ch/apiv1/smn/daterange?locations=CHM | {"title": "CHM", "description": "Chaumont", "alt": "Chaumont", "link": "/existenz-api/smn_locations?code=CHM"} |
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"} |
51 | 51 | EIN | Einsiedeln | 47.133042 | 8.756556 | 911 | 912 | 2699984 | 1221068 | Weather station | plain | MeteoSwiss | 01.01.1864 | SZ | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EIN | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06675 | https://api.existenz.ch/apiv1/smn/latest?locations=EIN | https://api.existenz.ch/apiv1/smn/daterange?locations=EIN | {"title": "EIN", "description": "Einsiedeln", "alt": "Einsiedeln", "link": "/existenz-api/smn_locations?code=EIN"} |
53 | 53 | ENG | Engelberg | 46.821639 | 8.410514 | 1036 | 1037 | 2674162 | 1186069 | Weather station | south-western oriented slope | MeteoSwiss, SLF | 01.01.1864 | OW | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ENG | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06655 | https://api.existenz.ch/apiv1/smn/latest?locations=ENG | https://api.existenz.ch/apiv1/smn/daterange?locations=ENG | {"title": "ENG", "description": "Engelberg", "alt": "Engelberg", "link": "/existenz-api/smn_locations?code=ENG"} |
63 | 63 | GLA | Glarus | 47.034586 | 9.066961 | 517 | 518 | 2723757 | 1210567 | Weather station | height (30-100 m above valley) | MeteoSwiss | 01.01.1864 | GL | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GLA | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06685 | https://api.existenz.ch/apiv1/smn/latest?locations=GLA | https://api.existenz.ch/apiv1/smn/daterange?locations=GLA | {"title": "GLA", "description": "Glarus", "alt": "Glarus", "link": "/existenz-api/smn_locations?code=GLA"} |
68 | 68 | GRC | Grächen | 46.195314 | 7.836822 | 1605 | 1606 | 2630738 | 1116062 | Weather station | western oriented slope | MeteoSwiss | 01.01.1864 | VS | Temperature, Humidity, Dew point, Precipitation, Pressure, 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=GRC | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06728 | https://api.existenz.ch/apiv1/smn/latest?locations=GRC | https://api.existenz.ch/apiv1/smn/daterange?locations=GRC | {"title": "GRC", "description": "Gr\u00e4chen", "alt": "Gr\u00e4chen", "link": "/existenz-api/smn_locations?code=GRC"} |
111 | 111 | OTL | Locarno / Monti | 46.172256 | 8.787494 | 367 | 374 | 2704167 | 1114316 | Weather station | southern oriented slope | MeteoSwiss | 01.01.1864 | TI | 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=OTL | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06760 | https://api.existenz.ch/apiv1/smn/latest?locations=OTL | https://api.existenz.ch/apiv1/smn/daterange?locations=OTL | {"title": "OTL", "description": "Locarno / Monti", "alt": "Locarno / Monti", "link": "/existenz-api/smn_locations?code=OTL"} |
89 | 89 | LUG | Lugano | 46.004217 | 8.960322 | 273 | 301 | 2717874 | 1095883 | Weather station | plain | MeteoSwiss | 01.01.1864 | TI | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=LUG | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06770 | https://api.existenz.ch/apiv1/smn/latest?locations=LUG | https://api.existenz.ch/apiv1/smn/daterange?locations=LUG | {"title": "LUG", "description": "Lugano", "alt": "Lugano", "link": "/existenz-api/smn_locations?code=LUG"} |
90 | 90 | LUZ | Luzern | 47.036439 | 8.301022 | 454 | 456 | 2665545 | 1209850 | Weather station | plain | MeteoSwiss | 01.01.1864 | LU | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=LUZ | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06650 | https://api.existenz.ch/apiv1/smn/latest?locations=LUZ | https://api.existenz.ch/apiv1/smn/daterange?locations=LUZ | {"title": "LUZ", "description": "Luzern", "alt": "Luzern", "link": "/existenz-api/smn_locations?code=LUZ"} |
108 | 108 | NEU | Neuchâtel | 47.000067 | 6.953297 | 485 | 485 | 2563087 | 1205560 | Weather station | height (30-100 m above valley) | MeteoSwiss | 01.01.1864 | NE | 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=NEU | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06604 | https://api.existenz.ch/apiv1/smn/latest?locations=NEU | https://api.existenz.ch/apiv1/smn/daterange?locations=NEU | {"title": "NEU", "description": "Neuch\u00e2tel", "alt": "Neuch\u00e2tel", "link": "/existenz-api/smn_locations?code=NEU"} |
143 | 143 | STG | St. Gallen | 47.425475 | 9.398528 | 776 | 777 | 2747866 | 1254588 | Weather station | north-western oriented slope | MeteoSwiss | 01.01.1864 | SG | 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=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"} |
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"} |
138 | 138 | SMA | Zürich / Fluntern | 47.377925 | 8.565742 | 556 | 557 | 2685118 | 1248066 | Weather station | southern oriented slope | MeteoSwiss | 01.01.1864 | ZH | Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Foehn index, Temperature 5cm, Longwave radiation | https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SMA | https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06660 | https://api.existenz.ch/apiv1/smn/latest?locations=SMA | https://api.existenz.ch/apiv1/smn/daterange?locations=SMA | {"title": "SMA", "description": "Z\u00fcrich / Fluntern", "alt": "Z\u00fcrich / Fluntern", "link": "/existenz-api/smn_locations?code=SMA"} |
Advanced export
JSON shape: default, array, newline-delimited
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);