Evaluating the linear regression using Pecan Street data

In [1]:

    

import pandas as pd
import urllib2,urllib
import json
import datetime
import numpy as np
from copy import deepcopy
import pylab
import matplotlib.pyplot as plt
%matplotlib inline
import collections 
import json
import urllib2
import numpy as np
import pandas as pd
import collections 
import matplotlib.pyplot as plt
from scipy import stats
import sys
sys.path.append('../../') # or non-Unix equivalent (add wikienergy/ to path)
from disaggregator import weather
from disaggregator import utils
from disaggregator import PecanStreetDatasetAdapter as psda
from disaggregator import linregress as lng
from disaggregator import appliance as app


    

    




/usr/local/lib/python2.7/dist-packages/pandas/io/excel.py:626: UserWarning: Installed openpyxl is not supported at this time. Use >=1.6.1 and <2.0.0.
  .format(openpyxl_compat.start_ver, openpyxl_compat.stop_ver))

In [2]:

    

#Load Datasets
devices_types={}
devices_types_unsampled={}
db_url='postgresql://USERNAME:PASSWORD@db.wiki-energy.org:5432/postgres'
psda.set_url(db_url)
schema = 'curated'
tables= psda.get_table_names(schema)
print tables


    

    




[u'group1_disaggregated_2013_07', u'group2_disaggregated_2013_05', u'group2_disaggregated_2013_11', u'group2_disaggregated_2013_08', u'group1_disaggregated_2013_01', u'group1_disaggregated_2013_08', u'group3_disaggregated_2013_07', u'group2_disaggregated_2013_03', u'group1_disaggregated_2013_04', u'group3_disaggregated_2013_05', u'west_pv_fall_2013', u'group1_disaggregated_2013_09', u'south_pv_fall_2013', u'pv_summer_2013', u'group1_disaggregated_2013_03', u'southwest_pv_fall_2013', u'group2_disaggregated_2013_10', u'group2_disaggregated_2013_09', u'group3_disaggregated_2013_10', u'group2_disaggregated_2013_07', u'group1_disaggregated_2013_11', u'group1_disaggregated_2012_12', u'group1_disaggregated_2013_02', u'group3_disaggregated_2013_09', u'group2_disaggregated_2013_06', u'group3_disaggregated_2013_06', u'group3_disaggregated_2013_11', u'group2_disaggregated_2013_04', u'group3_disaggregated_2013_08', u'group2_disaggregated_2013_01', u'group1_disaggregated_2013_06', u'group2_disaggregated_2013_02', u'group1_disaggregated_2013_05', u'group1_disaggregated_2013_10', u'ev_fall_2013']

In [3]:

    

table = [u'group2_disaggregated_2013_05',u'group2_disaggregated_2013_06',u'group2_disaggregated_2013_07',u'group2_disaggregated_2013_08',u'group2_disaggregated_2013_09']


    

In [4]:

    

ids_for_devices={}


    

In [5]:

    

#Gets id's associated with a device and generates types for each ids

ids_device_name='furnace2'
ids_for_devices[ids_device_name]=psda.get_dataids_with_real_values(schema,table[4],ids_device_name)


    

In [6]:

    

num_houses=100
device_name='air1'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='use'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='air2'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='air3'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='furnace1'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='furnace2'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='housefan1'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])
device_name='airwindowunit1'
devices_types_unsampled[device_name]=psda.generate_instances_for_appliance_by_dataids(schema,table,device_name,ids_for_devices[ids_device_name][:num_houses])


    

    




select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select air1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select use,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select air2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select air3,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select furnace1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select furnace2,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select housefan1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=93
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=93
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=93
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=93
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=93
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=94
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=94
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=94
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=94
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=94
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=624
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=624
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=624
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=624
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=624
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=739
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=739
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=739
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=739
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=739
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=1953
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=1953
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=1953
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=1953
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=1953
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2818
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2818
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2818
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2818
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2818
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=2864
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=2864
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=2864
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=2864
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=2864
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3367
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3367
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3367
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3367
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3367
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=3723
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=3723
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=3723
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=3723
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=3723
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5814
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5814
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5814
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5814
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5814
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=5972
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=5972
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=5972
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=5972
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=5972
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6101
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6101
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6101
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6101
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6101
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6636
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6636
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6636
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6636
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6636
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=6730
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=6730
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=6730
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=6730
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=6730
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7531
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7531
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7531
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7531
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7531
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7536
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7536
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7536
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7536
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7536
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7769
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7769
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7769
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7769
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7769
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=7800
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=7800
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=7800
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=7800
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=7800
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9019
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9019
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9019
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9019
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9019
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9609
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9609
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9609
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9609
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9609
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9922
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9922
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9922
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9922
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9922
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9926
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9926
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9926
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9926
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9926
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9933
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9933
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9933
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9933
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9933
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_05 where dataid=9982
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_06 where dataid=9982
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_07 where dataid=9982
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_08 where dataid=9982
select airwindowunit1,utc_15min from "PecanStreet_CuratedSets".group2_disaggregated_2013_09 where dataid=9982

In [7]:

    

#pecan_temps=weather.get_weather_data_as_df('1d83c5de274645d4','78739','TX', '20130501', '20130930')

import pickle
with open('temp_austin_may_sept_2013.pkl','rb') as f:
    pecan_temps=pickle.load(f)


    

In [19]:

    

num_hours=24
pecan_temps_resampled=pecan_temps.resample(str(num_hours)+'H', fill_method='ffill')
pecan_temps_resampled['temps']=pecan_temps_resampled['temp']
pecan_temps_resampled=remove_outliers(pecan_temps_resampled,-200,24)
temps_series=pecan_temps_resampled['temp']
devices_types_actual_types=turn_instance_list_dict_into_type(devices_types_unsampled)
devices_types=resample_and_split(devices_types_actual_types,str(num_hours)+'H','D',True,True)
house_energy_dict=turn_type_dict_into_df_dict(devices_types)


    

    




Returned 3 outliers.
Made type for use
Made type for housefan1
Made type for furnace1
Made type for furnace2
Made type for air1
Made type for air2
Made type for air3
Made type for airwindowunit1
Resampled use
Resampled housefan1
Resampled furnace1
Resampled furnace2
Resampled air1
Resampled air2
Resampled air3
Resampled airwindowunit1

In [65]:

    

r2_list=[]
avg_errors_list=[]
all_errors_list=[]
total_list=[]
all_totals_list=[]
all_real_airs_list=[]

for house_num in house_energy_dict:
    trace_series=house_energy_dict[house_num]['kwh']
    real_air_series=house_energy_dict[house_num]['air_kwh']
    results_dict=lng.run_regressions(trace_series,temps_series)
    [total_series,air_series,diff_series]=lng.predict_from_regressions(trace_series,temps_series,results_dict)
    a=0
    error_list = []
    for i,val in enumerate(air_series):
        error = (float(real_air_series[i])-float(val))
        error_list.append(error)
        all_errors_list.append(abs(error))
        all_totals_list.append(total_series[i])
        all_real_airs_list.append(real_air_series[i])
        r2=results_dict['best_r2_adj_cdd']
        r2_list.append(r2)
    avg_error = np.mean(error_list)
    total=np.sum(total_series)
    avg_errors_list.append(abs(avg_error))
    total_list.append(total)


    

In [111]:

    

df = pd.DataFrame(all_errors_list,all_totals_list).sort()
r2_thresh=0
thresh=10
a=0
for val in df[df.index > r2_thresh][0]:
    if(val<thresh):
        a=a+1
print a/float(len(df[df.index > r2_thresh]))


    

    




0.649204607789

In [139]:

    

high_lim=50
bins=10
plt.hist(avg_errors_list,bins,range=[0,high_lim])
plt.xlim([0 ,high_lim])
plt.figure()
high_lim=50
bins=1000
plt.hist(all_errors_list,bins,range=[0,high_lim])
plt.xlim([0 ,high_lim])
plt.figure()
high_lim=100
bins=1000
plt.hist(all_totals_list,bins,range=[0,high_lim],alpha=0.8,edgecolor = "none")
plt.xlim([0 ,high_lim])
plt.hist(all_real_airs_list,bins,range=[.1,high_lim],alpha=0.8, edgecolor = "none")
plt.xlim([0 ,high_lim])


    

    
Out[139]:





(0, 100)






    













    













    

In [147]:

    

plt.hist(all_errors_list,bins,range=[0,high_lim],alpha=1,edgecolor = "none")
plt.xlim([0 ,high_lim])
plt.xlabel('kWh')
plt.ylabel('# of Days')
plt.title("Error of Linear Regression")
plt.savefig("error.png")


    

In [121]:

    

a=0
thresh=6
for i,val in enumerate(avg_errors_list):
    if val<thresh:
        a=a+1
print a/float(i+1)
print 'We get within ' + str(thresh) + ' kWh of the average value for '+ str(a*100/float(i+1)) +'% of the houses'
a=0
for i,val in enumerate(all_errors_list):
    if val<thresh:
        a=a+1
print a/float(i+1)
print 'We get within ' + str(thresh) + ' kWh '+ str(a*100/float(i+1)) +'% of the time'


    

    




0.541666666667
We get within 6 kWh of the average value for 54.1666666667% of the houses
0.354776895702
We get within 6 kWh 35.4776895702% of the time

In [126]:

    

len(devices_types['air1'].instances)


    

    
Out[126]:





24

In [119]:

    

np.mean(all_errors_list)


    

    
Out[119]:





9.6881132828816554

In [135]:

    

metrics_list=np.sort(all_errors_list)
print len(metrics_list)
a=0
for i,val in enumerate(metrics_list[:1300]):
    if val<6:
        a=a+1
print a/float(i+1)


    

    




3653
0.996923076923

In [58]:

    

print house_energy_dict.keys()


    

    




[2818, 9609, 3723, 7536, 1953, 3367, 2864, 5814, 9019, 9922, 9926, 6730, 9933, 5972, 6101, 7769, 93, 94, 739, 7531, 6636, 624, 7800, 9982]

In [121]:

    

house_num=7800
trace_series=house_energy_dict[house_num]['kwh']
real_air_series=house_energy_dict[house_num]['air_kwh']
results_dict=lng.run_regressions(trace_series,temps_series)
[total_series,air_series,diff_series]=lng.predict_from_regressions(trace_series,temps_series,results_dict)
plt.plot(air_series,'b')
plt.plot(real_air_series,'k')
plt.plot(total_series,'r')
plt.figure()
plt.plot(temps_series,real_air_series,'.')
plt.plot(temps_series,total_series,'.')
x=np.arange(results_dict['best_cdd_temp'],90,(40)/float(len(temps_series)))
y_lng=(x)*results_dict['slope_cdd']+results_dict['intercept_cdd']
plt.plot(x,y_lng,'k')
intercept_new=results_dict['best_cdd_temp']*results_dict['slope_cdd']
y2_lng=(x)*results_dict['slope_cdd']-intercept_new
plt.plot(x,y2_lng,'c')
print results_dict['best_r2_adj_cdd']


    

    




0.4981366388






    













    

In [12]:

    

#Resamples the data
def resample_and_split(devices_types_unsampled_test,sample_rate,length,sample,split):
    devices_types_test={}
    devices_types_unsplit_test={}
    for key in devices_types_unsampled_test:
        if(sample):
            devices_types_unsplit_test[key]=devices_types_unsampled_test[key].resample(sample_rate)
        else:
            devices_types_unsplit_test[key]=devices_types_unsampled_test[key]
        if(split):
            devices_types_test[key]=devices_types_unsplit_test[key].split_by(length)
        else:
            devices_types_test[key]=devices_types_unsplit_test[key]
        print "Resampled " + str(key)
    return devices_types_test


    

In [13]:

    

#Turns instances into type
def turn_instance_list_dict_into_type(devices_types_unsampled):
    devices_types_actual_types={}
    for key in devices_types_unsampled:
        metadata=devices_types_unsampled[key][0].metadata
        devices_types_actual_types[key]=app.ApplianceType(devices_types_unsampled[key],metadata)
        print "Made type for " + str(key)
    return devices_types_actual_types


    

In [14]:

    

def turn_type_dict_into_df_dict(devices_types):
    house_energy_dict={}
    for i,instance in enumerate(devices_types['use'].instances):
        daily_energy_total={}
        daily_energy_air={}
        for j,trace in enumerate(instance.traces):
            for k,val in enumerate(trace.series):
                daily_energy_total[trace.series.index[k]]=trace.series[k]*24
            total_hvac_dict={}
            for device in devices_types:
                if device is not 'use':
                    total_hvac_dict[device]=(devices_types[device].instances[i].traces[j])
            
            for k,val in enumerate(devices_types['air1'].instances[i].traces[j].series):
                total_hvac=0
                for device in total_hvac_dict:
                    total_hvac=total_hvac+total_hvac_dict[device].series[k]
                daily_energy_air[total_hvac_dict['air1'].series.index[k]]=(total_hvac)*24
                
        df=pd.DataFrame.from_dict(daily_energy_total,orient='index')
        df_air=pd.DataFrame.from_dict(daily_energy_air,orient='index')
        df=df.sort_index()
        df_air=df_air.sort_index()
        df['kwh']=df[0]
        df['air_kwh']=df_air[0]
        df.drop(0, axis=1, inplace=True)
        house_energy_dict[instance.metadata['dataid']]=df
    return house_energy_dict


    

In [15]:

    

def plot_lin_regress(perc_act,perc_pred,date_start,date_end):
    perc_act_subset=perc_act[date_start:date_end]
    plt.plot(perc_act_subset.index,perc_act_subset)

    perc_pred_subset=perc_pred[date_start:date_end]
    plt.plot(perc_pred_subset.index,perc_pred_subset,'r')

    
    print "Average Error: " + str(sum(perc_act_subset-perc_pred_subset)/len(perc_pred_subset))
    print "Estimated Total %: " + str(sum(perc_pred_subset)/len(perc_pred_subset[perc_pred_subset!=0]))
    print "Actual Total %: " + str(sum(perc_act_subset)/len(perc_act_subset[perc_act_subset!=0]))


    

In [16]:

    

def combine_daily_and_hourly_lin_regress(hourly_perc_act,hourly_perc_pred,df_daily_pred,date_start,date_end):
    hourly_perc_act_subset=hourly_perc_act[date_start:date_end]
    hourly_perc_pred_subset=hourly_perc_pred[date_start:date_end]
    pred_air_daily_temp=[]
    time_temp=[]
    mean_pred_air_daily_new=[]
    mean_pred_air_daily_temp=hourly_perc_pred_subset.resample('D',how='mean')
    for i,val in enumerate(hourly_perc_pred_subset):
        pred_air_daily_temp.append(df_daily_pred[str(hourly_perc_pred_subset.index[i].date())][0][0])
        time_temp.append(hourly_perc_pred_subset.index[i])
        mean_pred_air_daily_new.append(mean_pred_air_daily_temp[str(hourly_perc_pred_subset.index[i].date())])
    hourly_series=pd.Series(pred_air_daily_temp,index=time_temp)
    hourly_mean_series=pd.Series(mean_pred_air_daily_new,index=time_temp)
    d = {'daily_avg_regress' : hourly_series,'hourly_avg': hourly_perc_pred_subset,'daily_mean':hourly_mean_series}
    df=pd.DataFrame(d)
    df['hourly_normalized']=df['hourly_avg']/df['daily_mean']*df['daily_avg_regress']
    df.loc[df['hourly_normalized']>100,'hourly_normalized'] = 100
    return df


    

In [17]:

    

#Outlier Removal
def remove_outliers(cal_temps,threshold,num_hours):
    outliers=cal_temps['temp'][(cal_temps['temp'] < threshold)].index
    a=-1
    for a,i in enumerate(outliers):
        try: cal_temps['temp'][i]= cal_temps['temp'][i-pd.DateOffset(hours=num_hours)]
        except KeyError: cal_temps['temp'][i]= cal_temps['temp'][i+pd.DateOffset(hours=num_hours)]
    print 'Returned ' + str(a+1)+ ' outliers.'
    return cal_temps


    

In [18]:

    

temps_series=cal_temps['temps']
trace_good=cal_elec['kwh']
a=get_best_lin_regress2(trace_good,temps_series)


    

    




---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
<ipython-input-18-9cc04215f190> in <module>()
----> 1 temps_series=cal_temps['temps']
      2 trace_good=cal_elec['kwh']
      3 a=get_best_lin_regress2(trace_good,temps_series)

NameError: name 'cal_temps' is not defined

In [ ]:

    

num_hours=24
pecan_temps_resampled=pecan_temps.resample(str(num_hours)+'H', how='mean')
pecan_temps_resampled=remove_outliers(pecan_temps_resampled,-400,24)
temps_series=pecan_temps_resampled['temp']
devices_types_actual_types=turn_instance_list_dict_into_type(devices_types_unsampled)
devices_types=resample_and_split(devices_types_actual_types,str(num_hours)+'H','D',True,True)
house_energy_dict=turn_type_dict_into_df_dict(devices_types)

house_num=3723
trace_series=house_energy_dict[house_num]['kwh']
real_air_series=house_energy_dict[house_num]['air_kwh']

results_dict=lng.run_regressions(trace_series,temps_series)


    

In [ ]: