SEAS server list private

SEAS Inventory private

EcoMOD House Data Queries

Architecture and SEAS partnered to wire a house:

Here is the auto query site that the kids built: Old PC Server private

Here are some of my queries against this data:

use ecomod;
select count(*) from temp;

select count(*) from power;

select max(ct1), min(ct1), max( datet) from power
  where datet between "2009-7-1" and "2009-7-31"
  group by day(datet),hour(datet), floor(minute(datet)/30) ;

use ecomod;
 select max(t1), min(t1), max( datet) from temp  
where datet between "2009-1-1" and "2009-1-31"  
group by day(datet),hour(datet), floor(minute(datet)/30);



select
    max(datet) as datetime, max(t20) as outside_south, max(t17) as outside_north
from temp
where datet between
   "2010-1-1 21:00"  and "2010-1-2 12:01" 
group by
   day(datet),
   hour(datet),
   case
      when minute(datet) <= 15 then 1
      when (minute(datet) > 15 and minute(datet) <=30) then 2
      when (minute(datet) > 30 and minute(datet) <=45) then 3
      else 4
   end
order by datet;