Measured Performance Of A Varied Airflow Small-Diameter Duct System
Department of Energy
@usgov.doe_gov_measured_performance_of_a_varied_airflow_small_8fd795ba
Department of Energy
@usgov.doe_gov_measured_performance_of_a_varied_airflow_small_8fd795ba
CREATE TABLE to4_2_1_2_monitoringdata (
"time" TIMESTAMP,
"flux_wpm2_pv_hor_avg" VARCHAR,
"rh_tstat_xx_43in_avg" VARCHAR,
"rh_out_xx_humitter_avg" VARCHAR,
"rh_bsmt_xx_fininished_43in_avg" VARCHAR,
"rh_sup_xx_plenum_avg" VARCHAR,
"rh_ret_xx_plenum_avg" DOUBLE,
"rh_sup_erv_avg" VARCHAR,
"rh_bed2_xx_43in_avg" DOUBLE,
"rh_bed3_xx_43in_avg" DOUBLE,
"rh_bed4_xx_43in_avg" DOUBLE,
"rh_hall_xx_43in_avg" VARCHAR,
"t_c_ret_xx_plenum_avg" VARCHAR,
"t_c_sup_xx_plenum_avg" VARCHAR,
"t_c_hall_reg_avg" VARCHAR,
"t_c_reg_xx_dining_avg" VARCHAR,
"t_c_reg_xx_breakfast_avg" VARCHAR,
"t_c_lvg_reg_avg" VARCHAR,
"t_c_xx_xx_laundry_43in_avg" VARCHAR,
"t_c_xx_xx_dining_43in_avg" VARCHAR,
"t_c_kit_xx_43in_avg" DOUBLE,
"t_c_xx_xx_breakfast_43in_avg" DOUBLE,
"t_c_lvg_xx_43in_avg" VARCHAR,
"t_c_tstat_xx_avg" VARCHAR,
"t_c_bsmt_xx_finished_43in_avg" DOUBLE,
"t_c_bsmt_xx_unfinished_43in_avg" DOUBLE,
"t_c_out_xx_humitter_avg" DOUBLE,
"t_c_out_xx_thermocouple_avg" VARCHAR,
"t_c_sup_erv_avg" VARCHAR,
"t_c_bsmt_reg_unfinished_avg" DOUBLE,
"t_c_bsmt_reg_finished_avg" DOUBLE,
"t_c_master_xx_43in_avg" VARCHAR,
"t_c_bed2_xx_43in_avg" VARCHAR,
"t_c_bed3_xx_43in_avg" VARCHAR,
"t_c_bed4_xx_43in_avg" VARCHAR,
"t_c_bath_master_43in_avg" VARCHAR,
"t_c_hall_xx_upper_43in_avg" VARCHAR,
"t_c_master_reg_avg" VARCHAR,
"t_c_bed2_reg_avg" VARCHAR,
"t_c_bed3_reg_avg" VARCHAR,
"t_c_bed4_reg_avg" VARCHAR,
"t_c_master_xx_transfer_avg" VARCHAR,
"t_c_bed2_xx_transfer_avg" VARCHAR,
"t_c_bed3_xx_transfer_avg" VARCHAR,
"t_c_bed4_xx_transfer_avg" VARCHAR,
"ee_kwh_tot_xx_totalsystem" DOUBLE,
"ee_kwh_ahu_tot" DOUBLE,
"ep_kw_tot_xx_totalsystem_avg" DOUBLE,
"ep_kw_ahu_xx_avg" DOUBLE,
"state_dl_tot_xx_onoff_totalsystem_avg" DOUBLE,
"state_dl_ahu_xx_onoff_avg" DOUBLE,
"flow_mps_lvg_reg_avg" DOUBLE,
"flow_mps_bsmt_reg_finished_avg" DOUBLE,
"flow_mps_master_reg_avg" DOUBLE,
"flow_mps_bed4_xx_avg" DOUBLE,
"flow_mps_bed3_xx_avg" DOUBLE,
"flow_mps_bed2_xx_avg" DOUBLE,
"p_pa_sup_xx_plenum_avg" VARCHAR,
"p_pa_ret_xx_plenum_avg" VARCHAR,
"p_pa_master_reg_avg" VARCHAR,
"p_pa_bed4_reg_avg" DOUBLE,
"p_pa_bed3_reg_avg" DOUBLE,
"p_pa_bed2_reg_avg" DOUBLE,
"voltage_volt_logger_xx_avg" DOUBLE,
"t_c_panel_xx_avg" DOUBLE
);
Anyone who has the link will be able to view this.