smn_locations

Data source: api.existenz.ch

5 rows where canton = "NE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: exposition, data_since

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
23 23 BRL La Brévine 46.983844 6.610297 1050 1051 2536981 1203975 Weather station plain MeteoSwiss 01.01.1901 NE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Temperature 5cm https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=BRL https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06617 https://api.existenz.ch/apiv1/smn/latest?locations=BRL https://api.existenz.ch/apiv1/smn/daterange?locations=BRL {"title": "BRL", "description": "La Br\u00e9vine", "alt": "La Br\u00e9vine", "link": "/existenz-api/smn_locations?code=BRL"}
27 27 CDF La Chaux-de-Fonds 47.082947 6.792314 1017 1018 2550919 1214862 Weather station basin MeteoSwiss 01.01.1900 NE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation, Sunshine, Snow, Temperature 5cm, Soil temperature, Clouds https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CDF https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06612 https://api.existenz.ch/apiv1/smn/latest?locations=CDF https://api.existenz.ch/apiv1/smn/daterange?locations=CDF {"title": "CDF", "description": "La Chaux-de-Fonds", "alt": "La Chaux-de-Fonds", "link": "/existenz-api/smn_locations?code=CDF"}
34 34 CHM Chaumont 47.049169 6.978825 1136 1137 2565060 1211007 Weather station height (30-100 m above valley) MeteoSwiss 01.01.1864 NE 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=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"}
42 42 CRM Cressier 47.047581 7.059147 430 431 2571163 1210798 Weather station plain MeteoSwiss 01.11.1991 NE Temperature, Humidity, Dew point, Precipitation, Pressure, Wind, Global radiation https://www.meteoswiss.admin.ch/services-and-publications/applications/measurement-values-and-measuring-networks.html#param=messnetz-automatisch&station=CRM https://oscar.wmo.int/surface/#/search/station/stationReportDetails/0-20000-0-06606 https://api.existenz.ch/apiv1/smn/latest?locations=CRM https://api.existenz.ch/apiv1/smn/daterange?locations=CRM {"title": "CRM", "description": "Cressier", "alt": "Cressier", "link": "/existenz-api/smn_locations?code=CRM"}
108 108 NEU Neuchâtel 47.000067 6.953297 485 485 2563087 1205560 Weather station height (30-100 m above valley) MeteoSwiss 01.01.1864 NE 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=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"}

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