smn_parameters

Data source: api.existenz.ch

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit

Link rowid ▼ name code unit description latest_values last_24h_values
1 1 dd dkl010z0 ° wind direction; ten minutes mean https://api.existenz.ch/apiv1/smn/latest?parameters=dd https://api.existenz.ch/apiv1/smn/daterange?parameters=dd
2 2 dd_tow dv1towz0 ° wind direction vectorial, average of 10 min; instrument 1 https://api.existenz.ch/apiv1/smn/latest?parameters=dd_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=dd_tow
3 3 ff fu3010z0 km/h Wind speed; ten minutes mean https://api.existenz.ch/apiv1/smn/latest?parameters=ff https://api.existenz.ch/apiv1/smn/daterange?parameters=ff
4 4 ff_tow fu3towz0 km/h Wind speed tower; ten minutes mean https://api.existenz.ch/apiv1/smn/latest?parameters=ff_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=ff_tow
5 5 fx fu3010z1 km/h Gust peak (one second); maximum https://api.existenz.ch/apiv1/smn/latest?parameters=fx https://api.existenz.ch/apiv1/smn/daterange?parameters=fx
6 6 fx_tow fu3towz1 km/h Gust peak (one second) tower; maximum https://api.existenz.ch/apiv1/smn/latest?parameters=fx_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=fx_tow
7 7 gp700 ppz700s0 gpm geopotential height of the 700 hPa-surface; current value https://api.existenz.ch/apiv1/smn/latest?parameters=gp700 https://api.existenz.ch/apiv1/smn/daterange?parameters=gp700
8 8 gp850 ppz850s0 gpm geopotential height of the 850 hPa-surface; current value https://api.existenz.ch/apiv1/smn/latest?parameters=gp850 https://api.existenz.ch/apiv1/smn/daterange?parameters=gp850
9 9 qfe prestas0 hPa Pressure at station level (QFE); current value https://api.existenz.ch/apiv1/smn/latest?parameters=qfe https://api.existenz.ch/apiv1/smn/daterange?parameters=qfe
10 10 qff pp0qffs0 hPa Pressure reduced to sea level (QFF); current value https://api.existenz.ch/apiv1/smn/latest?parameters=qff https://api.existenz.ch/apiv1/smn/daterange?parameters=qff
11 11 qnh pp0qnhs0 hPa Pressure reduced to sea level according to standard atmosphere (QNH); current value https://api.existenz.ch/apiv1/smn/latest?parameters=qnh https://api.existenz.ch/apiv1/smn/daterange?parameters=qnh
12 12 rad gre000z0 W/m² Global radiation; ten minutes mean https://api.existenz.ch/apiv1/smn/latest?parameters=rad https://api.existenz.ch/apiv1/smn/daterange?parameters=rad
13 13 rh ure200s0 % Relative air humidity 2 m above ground; current value https://api.existenz.ch/apiv1/smn/latest?parameters=rh https://api.existenz.ch/apiv1/smn/daterange?parameters=rh
14 14 rh_tow uretows0 % Relative air humidity tower; current value https://api.existenz.ch/apiv1/smn/latest?parameters=rh_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=rh_tow
15 15 rr rre150z0 mm Precipitation; ten minutes total https://api.existenz.ch/apiv1/smn/latest?parameters=rr https://api.existenz.ch/apiv1/smn/daterange?parameters=rr
16 16 ss sre000z0 min Sunshine duration; ten minutes total https://api.existenz.ch/apiv1/smn/latest?parameters=ss https://api.existenz.ch/apiv1/smn/daterange?parameters=ss
17 17 td tde200s0 °C Dew point 2 m above ground; current value https://api.existenz.ch/apiv1/smn/latest?parameters=td https://api.existenz.ch/apiv1/smn/daterange?parameters=td
18 18 td_tow tdetows0 °C Dew point tower https://api.existenz.ch/apiv1/smn/latest?parameters=td_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=td_tow
19 19 tt tre200s0 °C Air temperature 2 m above ground; current value https://api.existenz.ch/apiv1/smn/latest?parameters=tt https://api.existenz.ch/apiv1/smn/daterange?parameters=tt
20 20 tt_tow ta1tows0 °C Air temperature tool 1 https://api.existenz.ch/apiv1/smn/latest?parameters=tt_tow https://api.existenz.ch/apiv1/smn/daterange?parameters=tt_tow

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE smn_parameters (name string, code string, unit real, description real, latest_values string, last_24h_values string);
CREATE UNIQUE INDEX smn_parameters_name_index ON smn_parameters(name);