Bear Paw Sugar Bush Monitoring Dashboard - Last 72 Hours 

Selected time range: Last 24 hours

Timestamp (24 hours ago): 1773886664 (2026-03-18 21:17:44)

Current timestamp: 1773973064 (2026-03-19 21:17:44)

Queries being executed:

=== Actual Tank Query Executed ===
SELECT distinct tc.name longname, ti.timestamp, ti.fromid, ti.curr_ch1, ti.curr_ch2, ti.curr_ch3
                       FROM TankInfo ti
                       JOIN TankConfig tc ON ti.fromid = tc.fromid
                       WHERE ti.timestamp > 1773886664 and tc.active = 1
                       ORDER BY ti.fromid, ti.timestamp ASC

=== Actual Temperature Query Executed ===
SELECT DISTINCT DATE_ADD(d.timestamp, INTERVAL 2 HOUR) as timestamp, (d.temp * 9/5) + 32 as temp, tc.fromid, tc.name
                       FROM data d
                       JOIN EnvConfig tc ON d.location = tc.fromid
                       WHERE d.timestamp > FROM_UNIXTIME(1773886664) and tc.active = 1
                       ORDER BY d.timestamp ASC,tc.fromid

=== Actual Pressure Query Executed ===
SELECT DISTINCT DATE_ADD(d.timestamp, INTERVAL 2 HOUR) as timestamp, d.pressure, tc.fromid, tc.name
                       FROM data d
                       JOIN EnvConfig tc ON d.location = tc.fromid
                       WHERE d.timestamp > FROM_UNIXTIME(1773886664) and tc.active = 1
                       ORDER BY d.timestamp ASC, tc.fromid

=== Actual Humidity Query Executed ===
SELECT DISTINCT DATE_ADD(d.timestamp, INTERVAL 2 HOUR) as timestamp, d.humidity, tc.fromid, tc.name
                       FROM data d
                       JOIN EnvConfig tc ON d.location = tc.fromid
                       WHERE d.timestamp > FROM_UNIXTIME(1773886664) and tc.active = 1
                       ORDER BY d.timestamp ASC, tc.fromid

                

Tank: Returned 77 rows
Temperature: Returned 47 rows
Pressure: Returned 47 rows
Humidity: Returned 47 rows