Simulated Load Profiles For DOE Commercial Reference Buildings (17 Years Using NSRDB Data)
Department of Energy
@usgov.doe_gov_simulated_load_profiles_for_doe_commercial_ref_817beb4f
Department of Energy
@usgov.doe_gov_simulated_load_profiles_for_doe_commercial_ref_817beb4f
CREATE TABLE albuquerque_nm_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE atlanta_ga_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE baltimore_md_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE boulder_co_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE chicago_il_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE duluth_mn_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE helena_mt_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE houston_tx_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE las_vegas_nv_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE los_angeles_ca_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE miami_fl_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE minneapolis_mn_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE phoenix_az_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE san_francisco_ca_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
CREATE TABLE seattle_wa_commercial_simulated_load_profiles_1998_2014 (
"unnamed_0" BIGINT,
"supermarketnew2004" DOUBLE,
"supermarketpre1980" DOUBLE,
"quickservicerestaurantnew2004" DOUBLE,
"quickservicerestaurantpre1980" DOUBLE,
"primaryschoolnew2004" DOUBLE,
"primaryschoolpre1980" DOUBLE,
"stripmallnew2004" DOUBLE,
"stripmallpre1980" DOUBLE,
"warehousenew2004" DOUBLE,
"warehousepre1980" DOUBLE,
"stand_aloneretailnew2004" DOUBLE,
"stand_aloneretailpre1980" DOUBLE,
"secondaryschoolnew2004" DOUBLE,
"secondaryschoolpre1980" DOUBLE,
"fullservicerestaurantnew2004" DOUBLE,
"fullservicerestaurantpre1980" DOUBLE,
"smallofficenew2004" DOUBLE,
"smallofficepre1980" DOUBLE,
"mediumofficenew2004" DOUBLE,
"mediumofficepre1980" DOUBLE,
"largeofficenew2004" DOUBLE,
"largeofficepre1980" DOUBLE,
"hospitalnew2004" DOUBLE,
"hospitalpre1980" DOUBLE,
"midriseapartmentnew2004" DOUBLE,
"midriseapartmentpre1980" DOUBLE,
"smallhotelnew2004" DOUBLE,
"smallhotelpre1980" DOUBLE,
"largehotelnew2004" DOUBLE,
"largehotelpre1980" DOUBLE
);
Anyone who has the link will be able to view this.