Weather Data Store
The database schema for weather readings with filename format : <weather-readings.sqlite> in the top level EWB data directory.
| Table Name | Description |
|---|---|
processed_files | |
version | |
weather_readings | |
weather_stations |
processed_files
| Attribute | Type | Description |
|---|---|---|
filename | Text |
version
| Attribute | Type | Description |
|---|---|---|
version | Text |
weather_readings
| Attribute | Type | Description |
|---|---|---|
weather_station_id | Text | |
timestamp_utc | Text | |
temperature_dry_bulb | Number | |
temperature_dew_point | Number | |
temperature_feels_like | Number | |
relative_humidity | Number | |
wind_direction | Number | |
wind_speed_mean | Number | |
wind_speed_gust | Number | |
pressure | Number | |
rainfall_last_10min | Number | |
rainfall_since_9am | Number |
weather_stations
| Attribute | Type | Description |
|---|---|---|
id | Text | |
name | Text | |
time_zone | Text |