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 | |