smn_locations

Data source: api.existenz.ch

16 rows where canton = "VD"

✎ 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
3 3 AIG Aigle 46.326647 6.924472 381 382 2560404 1130713 Weather station plain MeteoSwiss 01.01.1981 VD 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=AIG https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06712 https://api.existenz.ch/apiv1/smn/latest?locations=AIG https://api.existenz.ch/apiv1/smn/daterange?locations=AIG {"title": "AIG", "description": "Aigle", "alt": "Aigle", "link": "/existenz-api/smn_locations?code=AIG"}
16 16 BIE Bière 46.524908 6.342386 684 684 2515887 1153211 Weather station plain MeteoSwiss 01.05.1974 VD 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=BIE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06704 https://api.existenz.ch/apiv1/smn/latest?locations=BIE https://api.existenz.ch/apiv1/smn/daterange?locations=BIE {"title": "BIE", "description": "Bi\u00e8re", "alt": "Bi\u00e8re", "link": "/existenz-api/smn_locations?code=BIE"}
28 28 CDM Col des Mosses 46.391525 7.098239 1412   2573817 1137853 Weather station pass MeteoSwiss 01.01.1972 VD Temperature, Humidity, Dew point, Precipitation, Wind, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CDM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06713 https://api.existenz.ch/apiv1/smn/latest?locations=CDM https://api.existenz.ch/apiv1/smn/daterange?locations=CDM {"title": "CDM", "description": "Col des Mosses", "alt": "Col des Mosses", "link": "/existenz-api/smn_locations?code=CDM"}
30 30 CGI Nyon / Changins 46.401053 6.227722 458 460 2506878 1139574 Weather station height (30-100 m above valley) MeteoSwiss 01.01.1965 VD Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CGI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06705 https://api.existenz.ch/apiv1/smn/latest?locations=CGI https://api.existenz.ch/apiv1/smn/daterange?locations=CGI {"title": "CGI", "description": "Nyon / Changins", "alt": "Nyon / Changins", "link": "/existenz-api/smn_locations?code=CGI"}
32 32 CHB Les Charbonnières 46.67015 6.312428 1045 1046 2513821 1169388 Weather station southern oriented slope MeteoSwiss 01.07.1982 VD Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CHB https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06703 https://api.existenz.ch/apiv1/smn/latest?locations=CHB https://api.existenz.ch/apiv1/smn/daterange?locations=CHB {"title": "CHB", "description": "Les Charbonni\u00e8res", "alt": "Les Charbonni\u00e8res", "link": "/existenz-api/smn_locations?code=CHB"}
33 33 CHD Château-d'Oex 46.479819 7.139656 1028 1029 2577040 1147655 Weather station southern oriented slope MeteoSwiss 01.01.1879 VD 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=CHD https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06627 https://api.existenz.ch/apiv1/smn/latest?locations=CHD https://api.existenz.ch/apiv1/smn/daterange?locations=CHD {"title": "CHD", "description": "Ch\u00e2teau-d'Oex", "alt": "Ch\u00e2teau-d'Oex", "link": "/existenz-api/smn_locations?code=CHD"}
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"}
58 58 FRE Bullet / La Frétaz 46.840622 6.576369 1205 1207 2534225 1188082 Weather station south-eastern oriented slope MeteoSwiss 01.01.1978 VD 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=FRE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06619 https://api.existenz.ch/apiv1/smn/latest?locations=FRE https://api.existenz.ch/apiv1/smn/daterange?locations=FRE {"title": "FRE", "description": "Bullet / La Fr\u00e9taz", "alt": "Bullet / La Fr\u00e9taz", "link": "/existenz-api/smn_locations?code=FRE"}
92 92 MAH Mathod 46.736978 6.567983 435 436 2533458 1176568 Weather station plain MeteoSwiss 01.09.1992 VD 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=MAH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06618 https://api.existenz.ch/apiv1/smn/latest?locations=MAH https://api.existenz.ch/apiv1/smn/daterange?locations=MAH {"title": "MAH", "description": "Mathod", "alt": "Mathod", "link": "/existenz-api/smn_locations?code=MAH"}
110 110 ORO Oron 46.572269 6.858239 828 829 2555505 1158053 Weather station height (30-100 m above valley) MeteoSwiss 01.02.1993 VD 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=ORO https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06708 https://api.existenz.ch/apiv1/smn/latest?locations=ORO https://api.existenz.ch/apiv1/smn/daterange?locations=ORO {"title": "ORO", "description": "Oron", "alt": "Oron", "link": "/existenz-api/smn_locations?code=ORO"}
112 112 PAY Payerne 46.811581 6.942469 490 490 2562131 1184612 Weather station height (30-100 m above valley) MeteoSwiss 01.08.1964 VD 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=PAY https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06610 https://api.existenz.ch/apiv1/smn/latest?locations=PAY https://api.existenz.ch/apiv1/smn/daterange?locations=PAY {"title": "PAY", "description": "Payerne", "alt": "Payerne", "link": "/existenz-api/smn_locations?code=PAY"}
118 118 PRE St-Prex 46.483683 6.443 425   2523549 1148526 Weather station plain MeteoSwiss 01.05.1993 VD Wind https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=PRE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06706 https://api.existenz.ch/apiv1/smn/latest?locations=PRE https://api.existenz.ch/apiv1/smn/daterange?locations=PRE {"title": "PRE", "description": "St-Prex", "alt": "St-Prex", "link": "/existenz-api/smn_locations?code=PRE"}
120 120 PUY Pully 46.512283 6.667517 456 457 2540819 1151511 Weather station southern oriented slope MeteoSwiss 01.01.1961 VD 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=PUY https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06711 https://api.existenz.ch/apiv1/smn/latest?locations=PUY https://api.existenz.ch/apiv1/smn/daterange?locations=PUY {"title": "PUY", "description": "Pully", "alt": "Pully", "link": "/existenz-api/smn_locations?code=PUY"}
152 152 VEV Vevey / Corseaux 46.471239 6.815056 405   2552106 1146847 Weather station southern oriented slope MeteoSwiss 01.01.1961 VD Temperature, Humidity, Dew point, Precipitation, Wind, Global radiation, Sunshine, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VEV https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06603 https://api.existenz.ch/apiv1/smn/latest?locations=VEV https://api.existenz.ch/apiv1/smn/daterange?locations=VEV {"title": "VEV", "description": "Vevey / Corseaux", "alt": "Vevey / Corseaux", "link": "/existenz-api/smn_locations?code=VEV"}
155 155 VIT Villars-Tiercelin 46.621778 6.710069 859   2544198 1163651 Weather station western oriented slope MeteoSwiss 01.10.1984 VD Temperature, Humidity, Dew point, Precipitation, Wind, Snow https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=VIT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06707 https://api.existenz.ch/apiv1/smn/latest?locations=VIT https://api.existenz.ch/apiv1/smn/daterange?locations=VIT {"title": "VIT", "description": "Villars-Tiercelin", "alt": "Villars-Tiercelin", "link": "/existenz-api/smn_locations?code=VIT"}

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