smn_parameters
Data source: api.existenz.ch
3 rows where unit = "hPa"
This data as json, CSV (advanced)
| Link | rowid ▼ | name | code | unit | description | group | latest_values | last_24h_values |
|---|---|---|---|---|---|---|---|---|
| 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 |
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);