smn_locations

Data source: api.existenz.ch

7 rows where canton = "GR" and exposition = "plain"

✎ View and edit SQL

This data as json, CSV (advanced)

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
5 5 AND Andeer GR 46.610139 9.431981 987 988 2752692 1164038 Automatic weather stations plain MeteoSchweiz 01.01.1901 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=AND https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06787 https://api.existenz.ch/apiv1/smn/latest?locations=AND https://api.existenz.ch/apiv1/smn/daterange?locations=AND {"title": "AND", "description": "Andeer", "alt": "Andeer", "link": "/existenz-api/smn_locations?code=AND"}
25 25 BUF Buffalora GR 46.648408 10.2672 1971 1970 2816494 1170255 Automatic weather stations plain MeteoSchweiz 01.01.1917 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BUF https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06778 https://api.existenz.ch/apiv1/smn/latest?locations=BUF https://api.existenz.ch/apiv1/smn/daterange?locations=BUF {"title": "BUF", "description": "Buffalora", "alt": "Buffalora", "link": "/existenz-api/smn_locations?code=BUF"}
35 35 CHU Chur GR 46.870572 9.530761 556 557 2759485 1193176 Automatic weather stations plain MeteoSchweiz 01.01.1887 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CHU https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06786 https://api.existenz.ch/apiv1/smn/latest?locations=CHU https://api.existenz.ch/apiv1/smn/daterange?locations=CHU {"title": "CHU", "description": "Chur", "alt": "Chur", "link": "/existenz-api/smn_locations?code=CHU"}
79 79 ILZ Ilanz GR 46.775039 9.215353 698 699 2735686 1181965 Automatic weather stations plain MeteoSchweiz 01.01.1892 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=ILZ https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06789 https://api.existenz.ch/apiv1/smn/latest?locations=ILZ https://api.existenz.ch/apiv1/smn/daterange?locations=ILZ {"title": "ILZ", "description": "Ilanz", "alt": "Ilanz", "link": "/existenz-api/smn_locations?code=ILZ"}
129 129 SAM Samedan GR 46.526247 9.879469 1709 1710 2787251 1155685 Automatic weather stations plain MeteoSchweiz 01.01.1864 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SAM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06792 https://api.existenz.ch/apiv1/smn/latest?locations=SAM https://api.existenz.ch/apiv1/smn/daterange?locations=SAM {"title": "SAM", "description": "Samedan", "alt": "Samedan", "link": "/existenz-api/smn_locations?code=SAM"}
135 135 SIA Segl-Maria GR 46.432331 9.762325 1804 1805 2778576 1144976 Automatic weather stations plain MeteoSchweiz 01.12.1863 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SIA https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06779 https://api.existenz.ch/apiv1/smn/latest?locations=SIA https://api.existenz.ch/apiv1/smn/daterange?locations=SIA {"title": "SIA", "description": "Segl-Maria", "alt": "Segl-Maria", "link": "/existenz-api/smn_locations?code=SIA"}
141 141 SRS Schiers GR 46.975506 9.668075 626   2769618 1205125 Automatic weather stations plain MeteoSchweiz 01.06.1885 https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=SRS https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06790 https://api.existenz.ch/apiv1/smn/latest?locations=SRS https://api.existenz.ch/apiv1/smn/daterange?locations=SRS {"title": "SRS", "description": "Schiers", "alt": "Schiers", "link": "/existenz-api/smn_locations?code=SRS"}

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