smn_parameters
Data source: api.existenz.ch
4 rows where unit = "km/h"
This data as json, CSV (advanced)
| Link | rowid ▼ | name | code | unit | description | group | latest_values | last_24h_values |
|---|---|---|---|---|---|---|---|---|
| 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 |
Advanced export
JSON shape: default, array, newline-delimited
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);