smn_locations

Data source: api.existenz.ch

14 rows where exposition = "height (30-100 m above valley)"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: canton, 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
11 11 BAS Basel / Binningen BL 47.541142 7.583525 316 318 2610909 1265612 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1755 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BAS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06601 https://api.existenz.ch/apiv1/smn/latest?locations=BAS https://api.existenz.ch/apiv1/smn/daterange?locations=BAS {"title": "BAS", "description": "Basel / Binningen", "alt": "Basel / Binningen", "link": "/existenz-api/smn_locations?code=BAS"}
30 30 CGI Nyon / Changins VD 46.401053 6.227722 458 460 2506878 1139574 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1959 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"}
34 34 CHM Chaumont NE 47.049169 6.978825 1136 1137 2565060 1211007 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1864 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"}
36 36 CHZ Cham ZG 47.188278 8.464642 443 443 2677759 1226878 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1961 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CHZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06674 https://api.existenz.ch/apiv1/smn/latest?locations=CHZ https://api.existenz.ch/apiv1/smn/daterange?locations=CHZ {"title": "CHZ", "description": "Cham", "alt": "Cham", "link": "/existenz-api/smn_locations?code=CHZ"}
54 54 EVI Evionnaz VS 46.182953 7.026747 482 483 2568196 1114693 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 30.08.1993 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=EVI https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06715 https://api.existenz.ch/apiv1/smn/latest?locations=EVI https://api.existenz.ch/apiv1/smn/daterange?locations=EVI {"title": "EVI", "description": "Evionnaz", "alt": "Evionnaz", "link": "/existenz-api/smn_locations?code=EVI"}
63 63 GLA Glarus GL 47.034586 9.066961 517 518 2723757 1210567 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1864 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"}
67 67 GRA Fribourg / Grangeneuve FR 46.7714 7.113736 651 651 2575184 1180076 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1900 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06625 https://api.existenz.ch/apiv1/smn/latest?locations=GRA https://api.existenz.ch/apiv1/smn/daterange?locations=GRA {"title": "GRA", "description": "Fribourg / Grangeneuve", "alt": "Fribourg / Grangeneuve", "link": "/existenz-api/smn_locations?code=GRA"}
70 70 GRH Grimsel Hospiz BE 46.571689 8.333256 1980 1962 2668583 1158215 Automatic weather stations height (30-100 m above valley) MeteoSchweiz, SLF 01.01.1868 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GRH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06744 https://api.existenz.ch/apiv1/smn/latest?locations=GRH https://api.existenz.ch/apiv1/smn/daterange?locations=GRH {"title": "GRH", "description": "Grimsel Hospiz", "alt": "Grimsel Hospiz", "link": "/existenz-api/smn_locations?code=GRH"}
74 74 GUT Güttingen TG 47.601733 9.279428 440 441 2738423 1273962 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1959 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=GUT https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06621 https://api.existenz.ch/apiv1/smn/latest?locations=GUT https://api.existenz.ch/apiv1/smn/daterange?locations=GUT {"title": "GUT", "description": "G\u00fcttingen", "alt": "G\u00fcttingen", "link": "/existenz-api/smn_locations?code=GUT"}
108 108 NEU Neuchâtel NE 47.000067 6.953297 485 485 2563087 1205560 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1864 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"}
110 110 ORO Oron VD 46.572269 6.858239 828 829 2555505 1158053 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.02.1993 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 VD 46.811581 6.942469 490 490 2562131 1184612 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.08.1964 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"}
116 116 PLF Plaffeien FR 46.747717 7.266264 1042 1044 2586828 1177407 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.01.1972 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=PLF https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06628 https://api.existenz.ch/apiv1/smn/latest?locations=PLF https://api.existenz.ch/apiv1/smn/daterange?locations=PLF {"title": "PLF", "description": "Plaffeien", "alt": "Plaffeien", "link": "/existenz-api/smn_locations?code=PLF"}
126 126 RUE Rünenberg BL 47.434572 7.879414 611 613 2633253 1253846 Automatic weather stations height (30-100 m above valley) MeteoSchweiz 01.05.1982 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=RUE https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06645 https://api.existenz.ch/apiv1/smn/latest?locations=RUE https://api.existenz.ch/apiv1/smn/daterange?locations=RUE {"title": "RUE", "description": "R\u00fcnenberg", "alt": "R\u00fcnenberg", "link": "/existenz-api/smn_locations?code=RUE"}

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