View source for Cumulusmx.db (preserving history)

[[Category:Cumulus Files]]

As the name suggests, this file '''/CumulusMX/data/cumulusmx.db''' (note case for Linux environments) is only applicable for MX.  

=Database type=

This file holds a SQLite3 database.


=Releases 3.0.0 to 3.11.4 inclusive=

The database only contains one table '''StandardData'''.

Here is the relevant create table instruction, so this tells you the 17 fields in the file:
CREATE TABLE "StandardData"(
"Timestamp" datetime primary key not null ,
"Interval" integer ,
"OutTemp" float ,
"LoOutTemp" float ,
"HiOutTemp" float ,
"DewPoint" float ,
"LoDewPoint" float ,
"HiDewPoint" float ,
"WindChill" float ,
"LoWindChill" float ,
"HiWindChill" float ,
"InTemp" float ,
"LoInTemp" float ,
"HiInTemp" float ,
"Pressure" float ,
"LoPressure" float ,
"HiPressure" float )

Whenever I have viewed this table (with phpLiteAdmin), there has been zero rows within the table.  This is because although MX creates the table, currently it does not actually use it.

In [https://cumulus.hosiene.co.uk/viewtopic.php?p=123594#p123594 this forum post] Steve Loft describes this table as being for a possible future enhancement.  He gives no clue as to why he selected the above columns or what he was thinking about using them for.  The table name suggests he was planning to replace the [[Standard log files|Standard log text files]] with a database equivalent.  I suspect he was actually thinking about implementing [[Monthly_log_files#Enhancement never implemented]].

This table still exists in release 3.12.0 that introduces the second table described below.  I wonder whether MX in the future will actually implement use of this first table.

=Release 3.12.0 onwards=

Release 3.12.0 introduces a second table '''RecentData''' into the same database.  This is documented in the update.txt for CumulusMX at release 3.12.0 (beta build 3134) as "Change: Cumulus MX now uses a persistent database to store the recent 1 minute data
	- This means that charts, recent webtags, and internal calculations for trends and periodic values will be more accurate after a restart
	- If Cumulus MX is offline for a prolonged period, data for that offline period will obviously still be at the station logging interval resolution".

This second table has the following columns:
{| border="1" class="wikitable"
|-
! style="width:10px" | Column number # 
! style="width:80px" | Column name
! style="width:80px" | Column type
! style="width:280px" | Properties 
! style="width:450px" | Description 
! style="width:120px" | Example column value
|-
| 0
| Timestamp
| datetime
| 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)
| 2021-07-31 19:44:00
|-
| 1
| WindSpeed
| float
| 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
| 2.2593056529
|-
| 2
| WindGust
| float
| Not NULL, No Default Value
| The spot gust speed recorded at the stated time, if necessary converted to units requested
| 6.99691241605804
|-
| 3
| WindLatest
| float
| Not NULL, No Default Value
| The spot latest wind speed recorded at the stated time, if necessary converted to units requested
| 3.15989597323001
|-
| 4
| WindDir
| integer
| Not NULL, No Default Value
| The wind bearing (0 =calm), (1 to 360 = number of degrees)
| 315
|-
| 5
| WindAvgDir
| integer
| Not NULL, No Default Value
| The average wind bearing over the defined period
| 270
|-
| 6
| OutsideTemp
| float
| Not NULL, No Default Value
| The measured [[Temperature_(and_humidity)_measurement|outside air temperature]], if necessary converted to units requested
| 17.0
|-
| 7
| WindChill
| float
| 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)
| (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
| DewPoint
| float
| 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.
| 11.9134549845367
|-
| 9
| HeatIndex
| float
| Not NULL, No Default Value
| 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
| Humidity
| float (1 decimal place)
| Not NULL, No Default Value
| The [[Temperature_(and_humidity)_measurement|Relative Humidity]] reported by the station at the stated time
| 72.0
|-
| 11
| Pressure
| float
| 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
| 996.400024414062
|-
| 12
| RainToday
| float
| 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
| 4.5
|-
| 13
| SolarRad
| integer
| Not NULL, No Default Value
| Solar radiation value reported by station at stated time
| 200
|-
| 14
| UV
| float
| Not NULL, No Default Value
| The Ultra Violet Index reported by station at stated time
| 3.0
|-
| 15
| raincounter
| float
| Not NULL, No Default Value
| The rain counter is used by Cumulus for all rainfall outputs, this is its value at stated time
| 550.4
|-
| 16
| FeelsLike
| float
| Not NULL, No Default Value
| The [[Feels Like]] temperature calculated by MX at stated time
| 17.0782773978147
|-
| 17
| Humidex
| float
| Not NULL, No Default Value
| The Canadian [[Humidex|Humidity Index]], calculated by Cumulus at the stated time
| 19.1775362738161
|-
| 18
| AppTemp
| float
| Not NULL, No Default Value
| The [[Apparent temperature]], calculated by MX at the stated time
| 16.8864476063546
|-
| 19
| IndoorTemp
| float
| Not NULL, No Default Value
| The indoor temperature directly as reported by station at stated time
| 120.89999961853
|-
| 20
| IndoorHumidity
| integer (0 decimal places, contrast with column 10)
| Not NULL, No Default Value
| The indoor relative humidity directly as reported by station at stated time
| 61
|-
| 21
| SolarMax
| integer
| Not NULL, No Default Value
| The calculated maximum value for solar radiation at stated time
| 1026
|-
| 22
| Pm2p5
| float
| Not NULL, No Default Value
| Air Quality expressed in terms of particulate matter of 2.5 μm, or less,   (?? Rolling 24 hours average ??)
| 1.5
|-
| 23
| Pm10
| float
| Not NULL, No Default Value
| Air Quality expressed in terms of particulate matter of 10 μm, or less, (?? Rolling 24 hours average ??)
| 1.7
|-
| 24
| RainRate
| float
| Not NULL, No Default Value
| The [[FAQ#How_is_my_rain_rate_calculated.3F|rainfall rate]] calculated for the stated time
| 303.2
|}