smn_locations

Data source: api.existenz.ch

12 rows where canton = "TI" 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
15 15 BIA Biasca 46.336053 8.978197 278 279 2718535 1132792 Weather station plain MeteoSwiss 01.01.1900 TI 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=BIA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-756-0-BIA https://api.existenz.ch/apiv1/smn/latest?locations=BIA https://api.existenz.ch/apiv1/smn/daterange?locations=BIA {"title": "BIA", "description": "Biasca", "alt": "Biasca", "link": "/existenz-api/smn_locations?code=BIA"}
29 29 CEV Cevio 46.320486 8.603161 417 422 2689688 1130564 Weather station valley MeteoSwiss 01.10.1900 TI 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=CEV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06752 https://api.existenz.ch/apiv1/smn/latest?locations=CEV https://api.existenz.ch/apiv1/smn/daterange?locations=CEV {"title": "CEV", "description": "Cevio", "alt": "Cevio", "link": "/existenz-api/smn_locations?code=CEV"}
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"}
39 39 COM Acquarossa / Comprovasco 46.459517 8.935486 575 576 2714985 1146451 Weather station valley MeteoSwiss 01.10.1900 TI 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=COM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06756 https://api.existenz.ch/apiv1/smn/latest?locations=COM https://api.existenz.ch/apiv1/smn/daterange?locations=COM {"title": "COM", "description": "Acquarossa / Comprovasco", "alt": "Acquarossa / Comprovasco", "link": "/existenz-api/smn_locations?code=COM"}
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"}
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"}
91 91 MAG Magadino / Cadenazzo 46.160025 8.933672 203 205 2715480 1113161 Weather station plain MeteoSwiss 01.06.1953 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=MAG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06762 https://api.existenz.ch/apiv1/smn/latest?locations=MAG https://api.existenz.ch/apiv1/smn/daterange?locations=MAG {"title": "MAG", "description": "Magadino / Cadenazzo", "alt": "Magadino / Cadenazzo", "link": "/existenz-api/smn_locations?code=MAG"}
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"}
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"}
115 115 PIO Piotta 46.514811 8.688039 990 991 2695881 1152264 Weather station plain MeteoSwiss 01.02.1979 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=PIO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06753 https://api.existenz.ch/apiv1/smn/latest?locations=PIO https://api.existenz.ch/apiv1/smn/daterange?locations=PIO {"title": "PIO", "description": "Piotta", "alt": "Piotta", "link": "/existenz-api/smn_locations?code=PIO"}
125 125 ROE Robièi 46.443067 8.513389 1898 1896 2682588 1144091 Weather station basin MeteoSwiss 01.02.1991 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=ROE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06751 https://api.existenz.ch/apiv1/smn/latest?locations=ROE https://api.existenz.ch/apiv1/smn/daterange?locations=ROE {"title": "ROE", "description": "Robi\u00e8i", "alt": "Robi\u00e8i", "link": "/existenz-api/smn_locations?code=ROE"}
131 131 SBO Stabio 45.843444 8.932364 351 353 2716049 1077972 Weather station plain MeteoSwiss 01.08.1981 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=SBO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06771 https://api.existenz.ch/apiv1/smn/latest?locations=SBO https://api.existenz.ch/apiv1/smn/daterange?locations=SBO {"title": "SBO", "description": "Stabio", "alt": "Stabio", "link": "/existenz-api/smn_locations?code=SBO"}

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