Cumulusmx.db: Difference between revisions

From Cumulus Wiki
Jump to navigationJump to search

Cumulusmx.db (view source)

Revision as of 09:29, 1 October 2022

622 bytes removed ,  09:29, 1 October 2022
m
→‎The Recent Data Table
Line 19: Line 19:
'''Note''': The CumulusMX [[Weather Diary]] also uses a SQLite database stored in [[diary.db|data/diary.db]].
'''Note''': The CumulusMX [[Weather Diary]] also uses a SQLite database stored in [[diary.db|data/diary.db]].


= The Recent Data Table =
= The Recent History Data Table =


This table has the following columns:
This table has the following columns:
Line 29: Line 29:
! style="width:280px" | Properties  
! style="width:280px" | Properties  
! style="width:450px" | Description  
! style="width:450px" | Description  
! style="width:120px" | Example column value
|-
|-
| 0
| 0
Line 36: Line 35:
| Primary Key, can never be NULL, No Default Value,
| Primary Key, can never be NULL, No Default Value,
| Dates and times for the last 7 days, at whatever interval available (at logging interval for historic archive data, at one minute intervals while MX is running)
| Dates and times for the last 7 days, at whatever interval available (at logging interval for historic archive data, at one minute intervals while MX is running)
| 2021-07-31 19:44:00
|-
|-
| 1
| 1
Line 43: Line 41:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The average wind speed (see [[Wind_measurement#Weather_Stations_and_Cumulus]] for links) calculated at the stated time, if necessary converted to units requested
| The average wind speed (see [[Wind_measurement#Weather_Stations_and_Cumulus]] for links) calculated at the stated time, if necessary converted to units requested
| 2.2593056529
|-
|-
| 2
| 2
Line 50: Line 47:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The spot gust speed recorded at the stated time, if necessary converted to units requested
| The spot gust speed recorded at the stated time, if necessary converted to units requested
| 6.99691241605804
|-
|-
| 3
| 3
Line 57: Line 53:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The spot latest wind speed recorded at the stated time, if necessary converted to units requested
| The spot latest wind speed recorded at the stated time, if necessary converted to units requested
| 3.15989597323001
|-
|-
| 4
| 4
Line 64: Line 59:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The wind bearing (0 =calm), (1 to 360 = number of degrees)
| The wind bearing (0 =calm), (1 to 360 = number of degrees)
| 315
|-
|-
| 5
| 5
Line 71: Line 65:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The average wind bearing over the defined period
| The average wind bearing over the defined period
| 270
|-
|-
| 6
| 6
Line 78: Line 71:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The measured [[Temperature_(and_humidity)_measurement|outside air temperature]], if necessary converted to units requested
| The measured [[Temperature_(and_humidity)_measurement|outside air temperature]], if necessary converted to units requested
| 17.0
|-
|-
| 7
| 7
Line 85: Line 77:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The [[wind chill]], either calculated by MX, or supplied by weather station. (Note: strictly only valid for low temperatures and significant wind speeds)
| The [[wind chill]], either calculated by MX, or supplied by weather station. (Note: strictly only valid for low temperatures and significant wind speeds)
| (In the example used here, temperature in previous column was too high for wind chill, so the value was set to agree with 'OutsideTemp' column instead)
|-
|-
| 8
| 8
Line 92: Line 83:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The [[Temperature_(and_humidity)_measurement#Cumulus_Calculated_Parameters|dew point]], either calculated by MX, or supplied by weather station, for the stated time.
| The [[Temperature_(and_humidity)_measurement#Cumulus_Calculated_Parameters|dew point]], either calculated by MX, or supplied by weather station, for the stated time.
| 11.9134549845367
|-
|-
| 9
| 9
Line 99: Line 89:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The USA [[Heat index]] as calculated by Cumulus for the stated time (if the temperature is high enough)
| The USA [[Heat index]] as calculated by Cumulus for the stated time (if the temperature is high enough)
|  (In the example used here, temperature in 'OutsideTemp' column was too low for heat index, so the value was set to agree with 'OutsideTemp' column instead)
|-
|-
| 10
| 10
Line 106: Line 95:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The [[Temperature_(and_humidity)_measurement|Relative Humidity]] reported by the station at the stated time
| The [[Temperature_(and_humidity)_measurement|Relative Humidity]] reported by the station at the stated time
| 72.0
|-
|-
| 11
| 11
Line 113: Line 101:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The sea level pressure at the stated time, either as reported by the station or calculated by Cumulus from the absolute pressure reported by the station, if necessary converted to units requested
| The sea level pressure at the stated time, either as reported by the station or calculated by Cumulus from the absolute pressure reported by the station, if necessary converted to units requested
| 996.400024414062
|-
|-
| 12
| 12
Line 120: Line 107:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The rainfall for today so far, calculated by Cumulus from the rain counter (column 15) now minus the rain counter at start of day, if necessary converted to units requested
| The rainfall for today so far, calculated by Cumulus from the rain counter (column 15) now minus the rain counter at start of day, if necessary converted to units requested
| 4.5
|-
|-
| 13
| 13
Line 127: Line 113:
| Not NULL, No Default Value
| Not NULL, No Default Value
| Solar radiation value reported by station at stated time
| Solar radiation value reported by station at stated time
| 200
|-
|-
| 14
| 14
Line 134: Line 119:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The Ultra Violet Index reported by station at stated time
| The Ultra Violet Index reported by station at stated time
| 3.0
|-
|-
| 15
| 15
Line 141: Line 125:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The rain counter is used by Cumulus for all rainfall outputs, this is its value at stated time
| The rain counter is used by Cumulus for all rainfall outputs, this is its value at stated time
| 550.4
|-
|-
| 16
| 16
Line 148: Line 131:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The [[Feels Like]] temperature calculated by MX at stated time
| The [[Feels Like]] temperature calculated by MX at stated time
| 17.0782773978147
|-
|-
| 17
| 17
Line 155: Line 137:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The Canadian [[Humidex|Humidity Index]], calculated by Cumulus at the stated time
| The Canadian [[Humidex|Humidity Index]], calculated by Cumulus at the stated time
| 19.1775362738161
|-
|-
| 18
| 18
Line 162: Line 143:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The [[Apparent temperature]], calculated by MX at the stated time
| The [[Apparent temperature]], calculated by MX at the stated time
| 16.8864476063546
|-
|-
| 19
| 19
Line 169: Line 149:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The indoor temperature directly as reported by station at stated time
| The indoor temperature directly as reported by station at stated time
| 120.89999961853
|-
|-
| 20
| 20
Line 176: Line 155:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The indoor relative humidity directly as reported by station at stated time
| The indoor relative humidity directly as reported by station at stated time
| 61
|-
|-
| 21
| 21
Line 183: Line 161:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The calculated maximum value for solar radiation at stated time
| The calculated maximum value for solar radiation at stated time
| 1026
|-
|-
| 22
| 22
Line 190: Line 167:
| Not NULL, No Default Value
| Not NULL, No Default Value
| Air Quality expressed in terms of particulate matter of 2.5 μm, or less,  (?? Rolling 24 hours average ??)
| Air Quality expressed in terms of particulate matter of 2.5 μm, or less,  (?? Rolling 24 hours average ??)
| 1.5
|-
|-
| 23
| 23
Line 197: Line 173:
| Not NULL, No Default Value
| Not NULL, No Default Value
| Air Quality expressed in terms of particulate matter of 10 μm, or less, (?? Rolling 24 hours average ??)
| Air Quality expressed in terms of particulate matter of 10 μm, or less, (?? Rolling 24 hours average ??)
| 1.7
|-
|-
| 24
| 24
Line 204: Line 179:
| Not NULL, No Default Value
| Not NULL, No Default Value
| The [[FAQ#How_is_my_rain_rate_calculated.3F|rainfall rate]] calculated for the stated time
| The [[FAQ#How_is_my_rain_rate_calculated.3F|rainfall rate]] calculated for the stated time
| 303.2
|}
|}


Retrieved from "https://www.cumuluswiki.org/a/Special:MobileDiff/10798"

Navigation menu