smn_locations

Data source: api.existenz.ch

2 rows where canton = "JU"

✎ View and edit SQL

This data as json, CSV (advanced)

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
44 44 DEM Delémont 47.351706 7.349567 439 440 2593270 1244543 Weather station plain MeteoSwiss 01.08.1892 JU 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=DEM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06602 https://api.existenz.ch/apiv1/smn/latest?locations=DEM https://api.existenz.ch/apiv1/smn/daterange?locations=DEM {"title": "DEM", "description": "Del\u00e9mont", "alt": "Del\u00e9mont", "link": "/existenz-api/smn_locations?code=DEM"}
56 56 FAH Fahy 47.423814 6.941194 596 598 2562465 1252676 Weather station plain MeteoSwiss 01.01.1957 JU 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=FAH https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06616 https://api.existenz.ch/apiv1/smn/latest?locations=FAH https://api.existenz.ch/apiv1/smn/daterange?locations=FAH {"title": "FAH", "description": "Fahy", "alt": "Fahy", "link": "/existenz-api/smn_locations?code=FAH"}

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