smn_parameters

Data source: api.existenz.ch

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, group

Link rowid ▼ name code unit description group latest_values last_24h_values
1 1 dd dkl010z0 ° Wind direction; ten minutes mean wind 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 tower; ten minutes mean wind 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 in km/h wind 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 scalar tower; ten minutes mean in km/h wind 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 in km/h wind 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 in km/h wind 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 level; current value pressure 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 level; current value pressure https://api.existenz.ch/apiv1/smn/latest?parameters=gp850 https://api.existenz.ch/apiv1/smn/daterange?parameters=gp850
9 9 qfe prestas0 hPa Atmospheric pressure at barometric altitude (QFE); current value pressure 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 pressure 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 pressure 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 radiation 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 humidity 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 humidity 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 precipitation 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 sunshine 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 humidity 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; current value humidity 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 temperature 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 tower; current value temperature 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, 'group' string, 'latest_values' string, 'last_24h_values' string);
CREATE UNIQUE INDEX smn_parameters_name_index ON smn_parameters(name);