OpenStudio:utilities
Loading...
Searching...
No Matches
openstudio::SqlFile Class Reference

#include <SqlFile.hpp>

Public Member Functions

Constructors
 SqlFile ()
 default constructor
 
 SqlFile (const openstudio::path &path, const bool createIndexes=true)
 constructor from path Creates indexes by default, pass in false for no new indexes and quicker opening
 
 SqlFile (const openstudio::path &t_path, const openstudio::EpwFile &t_epwFile, const openstudio::DateTime &t_simulationTime, const openstudio::Calendar &t_calendar, const bool createIndexes=true)
 initializes a new sql file for output Creates indexes by default, pass in false for no indexes and quicker creation
 
virtual ~SqlFile ()=default
 
void removeIndexes ()
 
void createIndexes ()
 
File Queries and Operations
bool connectionOpen () const
 returns whether or not connection is open
 
openstudio::path path () const
 get the path
 
bool supportedVersion () const
 
bool hasYear () const
 
bool hasIlluminanceMapYear () const
 
boost::optional< double > getExteriorFenestrationValue (const std::string &subSurfaceName, const std::string &columnName) const
 
boost::optional< double > assemblyUFactor (const std::string &subSurfaceName) const
 
boost::optional< double > assemblySHGC (const std::string &subSurfaceName) const
 
boost::optional< double > assemblyVisibleTransmittance (const std::string &subSurfaceName) const
 
bool close ()
 close the file
 
bool reopen ()
 re-open the file
 
std::string energyPlusSqliteFile () const
 Energy Plus eplusout.sql file name.
 
Standard Queries
boost::optional< double > hoursSimulated () const
 hours simulated
 
boost::optional< double > netSiteEnergy () const
 net site energy in GJ
 
boost::optional< double > netSourceEnergy () const
 net source energy in GJ
 
boost::optional< double > totalSiteEnergy () const
 total site energy in GJ
 
boost::optional< double > totalSourceEnergy () const
 total source energy in GJ
 
boost::optional< double > annualTotalCost (const FuelType &fuel) const
 Returns the annual total cost associated with the given fuel type in dollars.
 
boost::optional< double > annualTotalCostPerBldgArea (const FuelType &fuel) const
 Returns the annual total cost per total building area associated with the given fuel type in dollars per square meter.
 
boost::optional< double > annualTotalCostPerNetConditionedBldgArea (const FuelType &fuel) const
 Returns the annual total cost per net conditioned building area associated with the given fuel type in dollars per square meter.
 
boost::optional< double > annualTotalUtilityCost () const
 Returns the annual total cost for all fuel types in dollars. Requires EnergyPlus simulation output to calculate.
 
boost::optional< double > economicsEnergyCost () const
 Returns the total energy cost over the analysis period in dollars according to the discounting convention.
 
OptionalDouble getElecOrGasUse (bool t_getGas=true) const
 
OptionalDouble getElecOrGasCost (bool t_getGas=true) const
 
boost::optional< EndUsesendUses () const
 Returns an EndUses object containing all end uses for the simulation.
 
boost::optional< double > energyConsumptionByMonth (const openstudio::EndUseFuelType &t_fuelType, const openstudio::EndUseCategoryType &t_categoryType, const openstudio::MonthOfYear &t_monthOfYear) const
 Returns the energy consumption for the given fuel type, category and month.
 
boost::optional< double > peakEnergyDemandByMonth (const openstudio::EndUseFuelType &t_fuelType, const openstudio::EndUseCategoryType &t_categoryType, const openstudio::MonthOfYear &t_monthOfYear) const
 Returns the energy demand for the given fuel type, category and month.
 
boost::optional< double > electricityHeating () const
 Returns the electric energy used for heating in gigajoules.
 
boost::optional< double > electricityCooling () const
 Returns the electric energy used for cooling in gigajoules.
 
boost::optional< double > electricityInteriorLighting () const
 Returns the electric energy used for interior lighting in gigajoules.
 
boost::optional< double > electricityExteriorLighting () const
 Returns the electric energy used for exterior lighting in gigajoules.
 
boost::optional< double > electricityInteriorEquipment () const
 Returns the electric energy used for interior equipment in gigajoules.
 
boost::optional< double > electricityExteriorEquipment () const
 Returns the electric energy used for exterior equipment in gigajoules.
 
boost::optional< double > electricityFans () const
 Returns the electric energy used for fans in gigajoules.
 
boost::optional< double > electricityPumps () const
 Returns the electric energy used for pumps in gigajoules.
 
boost::optional< double > electricityHeatRejection () const
 Returns the electric energy used for heat rejection in gigajoules.
 
boost::optional< double > electricityHumidification () const
 Returns the electric energy used for humidification in gigajoules.
 
boost::optional< double > electricityHeatRecovery () const
 Returns the electric energy used for heat recovery in gigajoules.
 
boost::optional< double > electricityWaterSystems () const
 Returns the electric energy used for water systems in gigajoules.
 
boost::optional< double > electricityRefrigeration () const
 Returns the electric energy used for refrigeration in gigajoules.
 
boost::optional< double > electricityGenerators () const
 Returns the electric energy used for generators in gigajoules.
 
boost::optional< double > electricityTotalEndUses () const
 Returns the electric energy used for all uses in gigajoules.
 
boost::optional< double > naturalGasHeating () const
 Returns the natural gas energy used for heating in gigajoules.
 
boost::optional< double > naturalGasCooling () const
 Returns the natural gas energy used for cooling in gigajoules.
 
boost::optional< double > naturalGasInteriorLighting () const
 Returns the natural gas energy used for interior lighting in gigajoules.
 
boost::optional< double > naturalGasExteriorLighting () const
 Returns the natural gas energy used for exterior lighting in gigajoules.
 
boost::optional< double > naturalGasInteriorEquipment () const
 Returns the natural gas energy used for interior equipment in gigajoules.
 
boost::optional< double > naturalGasExteriorEquipment () const
 Returns the natural gas energy used for exterior equipment in gigajoules.
 
boost::optional< double > naturalGasFans () const
 Returns the natural gas energy used for fans in gigajoules.
 
boost::optional< double > naturalGasPumps () const
 Returns the natural gas energy used for pumps in gigajoules.
 
boost::optional< double > naturalGasHeatRejection () const
 Returns the natural gas energy used for heat rejection in gigajoules.
 
boost::optional< double > naturalGasHumidification () const
 Returns the natural gas energy used for humidification in gigajoules.
 
boost::optional< double > naturalGasHeatRecovery () const
 Returns the natural gas energy used for heat recovery in gigajoules.
 
boost::optional< double > naturalGasWaterSystems () const
 Returns the natural gas energy used for water systems in gigajoules.
 
boost::optional< double > naturalGasRefrigeration () const
 Returns the natural gas energy used for refrigeration in gigajoules.
 
boost::optional< double > naturalGasGenerators () const
 Returns the natural gas energy used for generators in gigajoules.
 
boost::optional< double > naturalGasTotalEndUses () const
 Returns the natural gas energy used for all end uses in gigajoules.
 
boost::optional< double > gasolineHeating () const
 Gasoline Returns the energy used for heating from gasoline in gigajoules.
 
boost::optional< double > gasolineCooling () const
 Returns the energy used for cooling from gasoline in gigajoules.
 
boost::optional< double > gasolineInteriorLighting () const
 Returns the energy used for interior lighting from gasoline in gigajoules.
 
boost::optional< double > gasolineExteriorLighting () const
 Returns the energy used for exterior lighting from gasoline in gigajoules.
 
boost::optional< double > gasolineInteriorEquipment () const
 Returns the energy used for interior equipment from gasoline in gigajoules.
 
boost::optional< double > gasolineExteriorEquipment () const
 Returns the energy used for exterior equipment from gasoline in gigajoules.
 
boost::optional< double > gasolineFans () const
 Returns the energy used for fans from gasoline in gigajoules.
 
boost::optional< double > gasolinePumps () const
 Returns the energy used for pumps from gasoline in gigajoules.
 
boost::optional< double > gasolineHeatRejection () const
 Returns the energy used for heat rejection from gasoline in gigajoules.
 
boost::optional< double > gasolineHumidification () const
 Returns the energy used for humidification from gasoline in gigajoules.
 
boost::optional< double > gasolineHeatRecovery () const
 Returns the energy used for heat recovery from gasoline in gigajoules.
 
boost::optional< double > gasolineWaterSystems () const
 Returns the energy used for water systems from gasoline in gigajoules.
 
boost::optional< double > gasolineRefrigeration () const
 Returns the energy used for refrigeration from gasoline in gigajoules.
 
boost::optional< double > gasolineGenerators () const
 Returns the energy used for generators from gasoline in gigajoules.
 
boost::optional< double > gasolineTotalEndUses () const
 Returns the energy used for all end uses from gasoline in gigajoules.
 
boost::optional< double > dieselHeating () const
 Diesel Returns the energy used for heating from diesel in gigajoules.
 
boost::optional< double > dieselCooling () const
 Returns the energy used for cooling from diesel in gigajoules.
 
boost::optional< double > dieselInteriorLighting () const
 Returns the energy used for interior lighting from diesel in gigajoules.
 
boost::optional< double > dieselExteriorLighting () const
 Returns the energy used for exterior lighting from diesel in gigajoules.
 
boost::optional< double > dieselInteriorEquipment () const
 Returns the energy used for interior equipment from diesel in gigajoules.
 
boost::optional< double > dieselExteriorEquipment () const
 Returns the energy used for exterior equipment from diesel in gigajoules.
 
boost::optional< double > dieselFans () const
 Returns the energy used for fans from diesel in gigajoules.
 
boost::optional< double > dieselPumps () const
 Returns the energy used for pumps from diesel in gigajoules.
 
boost::optional< double > dieselHeatRejection () const
 Returns the energy used for heat rejection from diesel in gigajoules.
 
boost::optional< double > dieselHumidification () const
 Returns the energy used for humidification from diesel in gigajoules.
 
boost::optional< double > dieselHeatRecovery () const
 Returns the energy used for heat recovery from diesel in gigajoules.
 
boost::optional< double > dieselWaterSystems () const
 Returns the energy used for water systems from diesel in gigajoules.
 
boost::optional< double > dieselRefrigeration () const
 Returns the energy used for refrigeration from diesel in gigajoules.
 
boost::optional< double > dieselGenerators () const
 Returns the energy used for generators from diesel in gigajoules.
 
boost::optional< double > dieselTotalEndUses () const
 Returns the energy used for all end uses from diesel in gigajoules.
 
boost::optional< double > coalHeating () const
 Coal Returns the energy used for heating from coal in gigajoules.
 
boost::optional< double > coalCooling () const
 Returns the energy used for cooling from coal in gigajoules.
 
boost::optional< double > coalInteriorLighting () const
 Returns the energy used for interior lighting from coal in gigajoules.
 
boost::optional< double > coalExteriorLighting () const
 Returns the energy used for exterior lighting from coal in gigajoules.
 
boost::optional< double > coalInteriorEquipment () const
 Returns the energy used for interior equipment from coal in gigajoules.
 
boost::optional< double > coalExteriorEquipment () const
 Returns the energy used for exterior equipment from coal in gigajoules.
 
boost::optional< double > coalFans () const
 Returns the energy used for fans from coal in gigajoules.
 
boost::optional< double > coalPumps () const
 Returns the energy used for pumps from coal in gigajoules.
 
boost::optional< double > coalHeatRejection () const
 Returns the energy used for heat rejection from coal in gigajoules.
 
boost::optional< double > coalHumidification () const
 Returns the energy used for humidification from coal in gigajoules.
 
boost::optional< double > coalHeatRecovery () const
 Returns the energy used for heat recovery from coal in gigajoules.
 
boost::optional< double > coalWaterSystems () const
 Returns the energy used for water systems from coal in gigajoules.
 
boost::optional< double > coalRefrigeration () const
 Returns the energy used for refrigeration from coal in gigajoules.
 
boost::optional< double > coalGenerators () const
 Returns the energy used for generators from coal in gigajoules.
 
boost::optional< double > coalTotalEndUses () const
 Returns the energy used for all end uses from coal in gigajoules.
 
boost::optional< double > fuelOilNo1Heating () const
 Fuel Oil No 1 Returns the energy used for heating from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1Cooling () const
 Returns the energy used for cooling from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1InteriorLighting () const
 Returns the energy used for interior lighting from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1ExteriorLighting () const
 Returns the energy used for exterior lighting from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1InteriorEquipment () const
 Returns the energy used for interior equipment from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1ExteriorEquipment () const
 Returns the energy used for exterior equipment from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1Fans () const
 Returns the energy used for fans from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1Pumps () const
 Returns the energy used for pumps from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1HeatRejection () const
 Returns the energy used for heat rejection from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1Humidification () const
 Returns the energy used for humidification from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1HeatRecovery () const
 Returns the energy used for heat recovery from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1WaterSystems () const
 Returns the energy used for water systems from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1Refrigeration () const
 Returns the energy used for refrigeration from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1Generators () const
 Returns the energy used for generators from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo1TotalEndUses () const
 Returns the energy used for all end uses from fuelOilNo1 in gigajoules.
 
boost::optional< double > fuelOilNo2Heating () const
 Fuel Oil No 2 Returns the energy used for heating from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2Cooling () const
 Returns the energy used for cooling from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2InteriorLighting () const
 Returns the energy used for interior lighting from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2ExteriorLighting () const
 Returns the energy used for exterior lighting from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2InteriorEquipment () const
 Returns the energy used for interior equipment from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2ExteriorEquipment () const
 Returns the energy used for exterior equipment from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2Fans () const
 Returns the energy used for fans from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2Pumps () const
 Returns the energy used for pumps from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2HeatRejection () const
 Returns the energy used for heat rejection from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2Humidification () const
 Returns the energy used for humidification from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2HeatRecovery () const
 Returns the energy used for heat recovery from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2WaterSystems () const
 Returns the energy used for water systems from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2Refrigeration () const
 Returns the energy used for refrigeration from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2Generators () const
 Returns the energy used for generators from fuelOilNo2 in gigajoules.
 
boost::optional< double > fuelOilNo2TotalEndUses () const
 Returns the energy used for all end uses from fuelOilNo2 in gigajoules.
 
boost::optional< double > propaneHeating () const
 Propane Returns the energy used for heating from propane in gigajoules.
 
boost::optional< double > propaneCooling () const
 Returns the energy used for cooling from propane in gigajoules.
 
boost::optional< double > propaneInteriorLighting () const
 Returns the energy used for interior lighting from propane in gigajoules.
 
boost::optional< double > propaneExteriorLighting () const
 Returns the energy used for exterior lighting from propane in gigajoules.
 
boost::optional< double > propaneInteriorEquipment () const
 Returns the energy used for interior equipment from propane in gigajoules.
 
boost::optional< double > propaneExteriorEquipment () const
 Returns the energy used for exterior equipment from propane in gigajoules.
 
boost::optional< double > propaneFans () const
 Returns the energy used for fans from propane in gigajoules.
 
boost::optional< double > propanePumps () const
 Returns the energy used for pumps from propane in gigajoules.
 
boost::optional< double > propaneHeatRejection () const
 Returns the energy used for heat rejection from propane in gigajoules.
 
boost::optional< double > propaneHumidification () const
 Returns the energy used for humidification from propane in gigajoules.
 
boost::optional< double > propaneHeatRecovery () const
 Returns the energy used for heat recovery from propane in gigajoules.
 
boost::optional< double > propaneWaterSystems () const
 Returns the energy used for water systems from propane in gigajoules.
 
boost::optional< double > propaneRefrigeration () const
 Returns the energy used for refrigeration from propane in gigajoules.
 
boost::optional< double > propaneGenerators () const
 Returns the energy used for generators from propane in gigajoules.
 
boost::optional< double > propaneTotalEndUses () const
 Returns the energy used for all end uses from propane in gigajoules.
 
boost::optional< double > otherFuel1Heating () const
 Other Fuel 1 Returns the energy used for heating from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1Cooling () const
 Returns the energy used for cooling from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1InteriorLighting () const
 Returns the energy used for interior lighting from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1ExteriorLighting () const
 Returns the energy used for exterior lighting from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1InteriorEquipment () const
 Returns the energy used for interior equipment from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1ExteriorEquipment () const
 Returns the energy used for exterior equipment from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1Fans () const
 Returns the energy used for fans from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1Pumps () const
 Returns the energy used for pumps from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1HeatRejection () const
 Returns the energy used for heat rejection from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1Humidification () const
 Returns the energy used for humidification from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1HeatRecovery () const
 Returns the energy used for heat recovery from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1WaterSystems () const
 Returns the energy used for water systems from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1Refrigeration () const
 Returns the energy used for refrigeration from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1Generators () const
 Returns the energy used for generators from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel1TotalEndUses () const
 Returns the energy used for all end uses from otherFuel1 in gigajoules.
 
boost::optional< double > otherFuel2Heating () const
 Other Fuel 2 Returns the energy used for heating from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2Cooling () const
 Returns the energy used for cooling from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2InteriorLighting () const
 Returns the energy used for interior lighting from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2ExteriorLighting () const
 Returns the energy used for exterior lighting from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2InteriorEquipment () const
 Returns the energy used for interior equipment from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2ExteriorEquipment () const
 Returns the energy used for exterior equipment from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2Fans () const
 Returns the energy used for fans from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2Pumps () const
 Returns the energy used for pumps from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2HeatRejection () const
 Returns the energy used for heat rejection from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2Humidification () const
 Returns the energy used for humidification from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2HeatRecovery () const
 Returns the energy used for heat recovery from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2WaterSystems () const
 Returns the energy used for water systems from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2Refrigeration () const
 Returns the energy used for refrigeration from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2Generators () const
 Returns the energy used for generators from otherFuel2 in gigajoules.
 
boost::optional< double > otherFuel2TotalEndUses () const
 Returns the energy used for all end uses from otherFuel2 in gigajoules.
 
boost::optional< double > districtCoolingHeating () const
 Returns the district cooling energy used for heating in gigajoules.
 
boost::optional< double > districtCoolingCooling () const
 Returns the district cooling energy used for cooling in gigajoules.
 
boost::optional< double > districtCoolingInteriorLighting () const
 Returns the district cooling energy used for interior lighting in gigajoules.
 
boost::optional< double > districtCoolingExteriorLighting () const
 Returns the district cooling energy used for exterior lighting in gigajoules.
 
boost::optional< double > districtCoolingInteriorEquipment () const
 Returns the district cooling energy used for interior equipment in gigajoules.
 
boost::optional< double > districtCoolingExteriorEquipment () const
 Returns the district cooling energy used for exterior equipment in gigajoules.
 
boost::optional< double > districtCoolingFans () const
 Returns the district cooling energy used for fans in gigajoules.
 
boost::optional< double > districtCoolingPumps () const
 Returns the district cooling energy used for pumps in gigajoules.
 
boost::optional< double > districtCoolingHeatRejection () const
 Returns the district cooling energy used for heat rejection in gigajoules.
 
boost::optional< double > districtCoolingHumidification () const
 Returns the district cooling energy used for humidification in gigajoules.
 
boost::optional< double > districtCoolingHeatRecovery () const
 Returns the district cooling energy used for heat recovery in gigajoules.
 
boost::optional< double > districtCoolingWaterSystems () const
 Returns the district cooling energy used for water systems in gigajoules.
 
boost::optional< double > districtCoolingRefrigeration () const
 Returns the district cooling energy used for refrigeration in gigajoules.
 
boost::optional< double > districtCoolingGenerators () const
 Returns the district cooling energy used for generators in gigajoules.
 
boost::optional< double > districtCoolingTotalEndUses () const
 Returns the district cooling energy used for all end uses in gigajoules.
 
boost::optional< double > districtHeatingHeating () const
 Returns the district heating energy used for heating in gigajoules.
 
boost::optional< double > districtHeatingCooling () const
 Returns the district heating energy used for cooling in gigajoules.
 
boost::optional< double > districtHeatingInteriorLighting () const
 Returns the district heating energy used for interior lighting in gigajoules.
 
boost::optional< double > districtHeatingExteriorLighting () const
 Returns the district heating energy used for exterior lighting in gigajoules.
 
boost::optional< double > districtHeatingInteriorEquipment () const
 Returns the district heating energy used for interior equipment in gigajoules.
 
boost::optional< double > districtHeatingExteriorEquipment () const
 Returns the district heating energy used for exterior equipment in gigajoules.
 
boost::optional< double > districtHeatingFans () const
 Returns the district heating energy used for fans in gigajoules.
 
boost::optional< double > districtHeatingPumps () const
 Returns the district heating energy used for pumps in gigajoules.
 
boost::optional< double > districtHeatingHeatRejection () const
 Returns the district heating energy used for heat rejection in gigajoules.
 
boost::optional< double > districtHeatingHumidification () const
 Returns the district heating energy used for humidification in gigajoules.
 
boost::optional< double > districtHeatingHeatRecovery () const
 Returns the district heating energy used for heat recovery in gigajoules.
 
boost::optional< double > districtHeatingWaterSystems () const
 Returns the district heating energy used for water systems in gigajoules.
 
boost::optional< double > districtHeatingRefrigeration () const
 Returns the district heating energy used for refrigeration in gigajoules.
 
boost::optional< double > districtHeatingGenerators () const
 Returns the district heating energy used for generators in gigajoules.
 
boost::optional< double > districtHeatingTotalEndUses () const
 Returns the district heating energy used for all end uses in gigajoules.
 
boost::optional< double > districtHeatingWaterHeating () const
 Returns the district heating water energy used for heating in gigajoules.
 
boost::optional< double > districtHeatingWaterCooling () const
 Returns the district heating water energy used for cooling in gigajoules.
 
boost::optional< double > districtHeatingWaterInteriorLighting () const
 Returns the district heating water energy used for interior lighting in gigajoules.
 
boost::optional< double > districtHeatingWaterExteriorLighting () const
 Returns the district heating water energy used for exterior lighting in gigajoules.
 
boost::optional< double > districtHeatingWaterInteriorEquipment () const
 Returns the district heating water energy used for interior equipment in gigajoules.
 
boost::optional< double > districtHeatingWaterExteriorEquipment () const
 Returns the district heating water energy used for exterior equipment in gigajoules.
 
boost::optional< double > districtHeatingWaterFans () const
 Returns the district heating water energy used for fans in gigajoules.
 
boost::optional< double > districtHeatingWaterPumps () const
 Returns the district heating water energy used for pumps in gigajoules.
 
boost::optional< double > districtHeatingWaterHeatRejection () const
 Returns the district heating water energy used for heat rejection in gigajoules.
 
boost::optional< double > districtHeatingWaterHumidification () const
 Returns the district heating water energy used for humidification in gigajoules.
 
boost::optional< double > districtHeatingWaterHeatRecovery () const
 Returns the district heating water energy used for heat recovery in gigajoules.
 
boost::optional< double > districtHeatingWaterWaterSystems () const
 Returns the district heating water energy used for water systems in gigajoules.
 
boost::optional< double > districtHeatingWaterRefrigeration () const
 Returns the district heating water energy used for refrigeration in gigajoules.
 
boost::optional< double > districtHeatingWaterGenerators () const
 Returns the district heating water energy used for generators in gigajoules.
 
boost::optional< double > districtHeatingWaterTotalEndUses () const
 Returns the district heating water energy used for all end uses in gigajoules.
 
boost::optional< double > districtHeatingSteamHeating () const
 Returns the district heating steam energy used for heating in gigajoules.
 
boost::optional< double > districtHeatingSteamCooling () const
 Returns the district heating steam energy used for cooling in gigajoules.
 
boost::optional< double > districtHeatingSteamInteriorLighting () const
 Returns the district heating steam energy used for interior lighting in gigajoules.
 
boost::optional< double > districtHeatingSteamExteriorLighting () const
 Returns the district heating steam energy used for exterior lighting in gigajoules.
 
boost::optional< double > districtHeatingSteamInteriorEquipment () const
 Returns the district heating steam energy used for interior equipment in gigajoules.
 
boost::optional< double > districtHeatingSteamExteriorEquipment () const
 Returns the district heating steam energy used for exterior equipment in gigajoules.
 
boost::optional< double > districtHeatingSteamFans () const
 Returns the district heating steam energy used for fans in gigajoules.
 
boost::optional< double > districtHeatingSteamPumps () const
 Returns the district heating steam energy used for pumps in gigajoules.
 
boost::optional< double > districtHeatingSteamHeatRejection () const
 Returns the district heating steam energy used for heat rejection in gigajoules.
 
boost::optional< double > districtHeatingSteamHumidification () const
 Returns the district heating steam energy used for humidification in gigajoules.
 
boost::optional< double > districtHeatingSteamHeatRecovery () const
 Returns the district heating steam energy used for heat recovery in gigajoules.
 
boost::optional< double > districtHeatingSteamWaterSystems () const
 Returns the district heating steam energy used for water systems in gigajoules.
 
boost::optional< double > districtHeatingSteamRefrigeration () const
 Returns the district heating steam energy used for refrigeration in gigajoules.
 
boost::optional< double > districtHeatingSteamGenerators () const
 Returns the district heating steam energy used for generators in gigajoules.
 
boost::optional< double > districtHeatingSteamTotalEndUses () const
 Returns the district heating steam energy used for all end uses in gigajoules.
 
boost::optional< double > waterHeating () const
 Returns the water used for heating in cubic meters.
 
boost::optional< double > waterCooling () const
 Returns the water used for cooling in cubic meters.
 
boost::optional< double > waterInteriorLighting () const
 Returns the water used for interior lighting in cubic meters.
 
boost::optional< double > waterExteriorLighting () const
 Returns the water used for exterior lighting in cubic meters.
 
boost::optional< double > waterInteriorEquipment () const
 Returns the water used for interior equipment in cubic meters.
 
boost::optional< double > waterExteriorEquipment () const
 Returns the water used for exterior equipment in cubic meters.
 
boost::optional< double > waterFans () const
 Returns the water used for fans in cubic meters.
 
boost::optional< double > waterPumps () const
 Returns the water used for pumps in cubic meters.
 
boost::optional< double > waterHeatRejection () const
 Returns the water used for heat rejection in cubic meters.
 
boost::optional< double > waterHumidification () const
 Returns the water used for humidification in cubic meters.
 
boost::optional< double > waterHeatRecovery () const
 Returns the water used for heat recovery in cubic meters.
 
boost::optional< double > waterWaterSystems () const
 Returns the water used for water systems in cubic meters.
 
boost::optional< double > waterRefrigeration () const
 Returns the water used for refrigeration in cubic meters.
 
boost::optional< double > waterGenerators () const
 Returns the water used for generators in cubic meters.
 
boost::optional< double > waterTotalEndUses () const
 Returns the water used for all uses in cubic meters.
 
boost::optional< double > hoursHeatingSetpointNotMet () const
 Returns the total number of hours the heating setpoint is not met.
 
boost::optional< double > hoursCoolingSetpointNotMet () const
 Returns the total number of hours the cooling setpoint is not met.
 
boost::optional< std::pair< DateTime, DateTime > > daylightSavingsPeriod () const
 
std::string energyPlusVersion () const
 Energy plus version number.
 
Generic TimeSeries Interface
std::vector< std::string > availableTimeSeries ()
 
boost::optional< openstudio::EnvironmentTypeenvironmentType (const std::string &envPeriod) const
 
std::vector< std::string > availableEnvPeriods () const
 
std::vector< std::string > availableReportingFrequencies (const std::string &envPeriod)
 
boost::optional< openstudio::ReportingFrequencyreportingFrequencyFromDB (const std::string &dbReportingFrequency)
 
std::vector< std::string > availableVariableNames (const std::string &envPeriod, const std::string &reportingFrequency) const
 
std::vector< TimeSeriestimeSeries (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName)
 
std::vector< std::string > availableKeyValues (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName)
 
boost::optional< double > runPeriodValue (const std::string &envPeriod, const std::string &timeSeriesName, const std::string &keyValue)
 
boost::optional< TimeSeriestimeSeries (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName, const std::string &keyValue)
 
std::vector< SqlFileTimeSeriesQueryexpandQuery (const SqlFileTimeSeriesQuery &query)
 Expands query to create a vector of all matching queries.
 
std::vector< TimeSeriestimeSeries (const SqlFileTimeSeriesQuery &query)
 Executes query.
 
Illuminance Map Interface
std::vector< std::string > illuminanceMapNames () const
 get names of all available illuminance maps
 
std::vector< std::string > illuminanceMapNames (const std::string &envPeriod) const
 
std::vector< std::string > illuminanceMapZoneNames (const std::string &name) const
 get zone names of for specified illuminance map
 
std::vector< std::string > illuminanceMapZoneNames (int mapIndex) const
 
boost::optional< std::string > illuminanceMapRefPt (const std::string &name, int ptNum) const
 reference point for map - form RefPtn=(x:y:illuminance)
 
boost::optional< std::string > illuminanceMapRefPt (int mapIndex, int ptNum) const
 
boost::optional< double > illuminanceMapMinValue (const std::string &name) const
 minimum value of map
 
boost::optional< double > illuminanceMapMinValue (int mapIndex) const
 
boost::optional< double > illuminanceMapMaxValue (const std::string &name) const
 maximum value of map
 
boost::optional< double > illuminanceMapMaxValue (int mapIndex) const
 
void illuminanceMapMaxValue (const std::string &name, double &minValue, double &maxValue) const
 minimum and maximum of map
 
void illuminanceMapMaxValue (int mapIndex, double &minValue, double &maxValue) const
 
boost::optional< intilluminanceMapIndex (const std::string &name) const
 
Vector illuminanceMapX (const std::string &name, const DateTime &dateTime) const
 x position (m) of the illuminance map
 
Vector illuminanceMapY (const std::string &name, const DateTime &dateTime) const
 y position (m) of the illuminance map
 
Vector illuminanceMapX (int hourlyReportIndex) const
 x position (m) of the illuminance map
 
Vector illuminanceMapY (int hourlyReportIndex) const
 y position (m) of the illuminance map
 
boost::optional< intilluminanceMapHourlyReportIndex (int mapIndex, const DateTime &dateTime) const
 hourly report index for mapIndex at date and time
 
boost::optional< DateTimeilluminanceMapDate (int hourlyReportIndex) const
 date time at hourly report index
 
std::vector< intilluminanceMapHourlyReportIndices (const std::string &name) const
 hourly report indices of the illuminance map
 
std::vector< std::pair< int, DateTime > > illuminanceMapHourlyReportIndicesDates (int mapIndex) const
 hourly report indices of the illuminance map
 
std::vector< std::pair< int, DateTime > > illuminanceMapHourlyReportIndicesDates (const std::string &name) const
 hourly report indices of the illuminance map
 
std::vector< intilluminanceMapHourlyReportIndices (int mapIndex) const
 hourly report indices of the illuminance map
 
Matrix illuminanceMap (const std::string &name, const DateTime &dateTime) const
 value (lux) of the illuminance map at date and time value(i,j) is the illuminance at x(i), y(j)
 
Matrix illuminanceMap (int hourlyReportIndex) const
 value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j)
 
void illuminanceMap (int hourlyReportIndex, std::vector< double > &x, std::vector< double > &y, std::vector< double > &illuminance) const
 value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j) fills in x,y, illuminance
 
std::vector< SummaryDatagetSummaryData () const
 Returns the summary data for each installlocation and fuel type found in report variables.
 
int insertZone (const std::string &t_name, double t_relNorth, double t_originX, double t_originY, double t_originZ, double t_centroidX, double t_centroidY, double t_centroidZ, int t_ofType, double t_multiplier, double t_listMultiplier, double t_minimumX, double t_maximumX, double t_minimumY, double t_maximumY, double t_minimumZ, double t_maximumZ, double t_ceilingHeight, double t_volume, int t_insideConvectionAlgo, int t_outsideConvectionAlgo, double t_floorArea, double t_extGrossWallArea, double t_extNetWallArea, double t_extWindowArea, bool t_isPartOfTotalArea)
 
void insertIlluminanceMap (const std::string &t_zoneName, const std::string &t_name, const std::string &t_environmentName, const std::vector< DateTime > &t_times, const std::vector< double > &t_xs, const std::vector< double > &t_ys, double t_z, const std::vector< Matrix > &t_maps)
 
Generic Query Interface
template<typename... Args>
boost::optional< double > execAndReturnFirstDouble (const std::string &statement, Args &&... args) const
 execute a statement and return the first (if any) value as a double
 
boost::optional< double > execAndReturnFirstDouble (const std::string &statement) const
 
template<typename... Args>
boost::optional< intexecAndReturnFirstInt (const std::string &statement, Args &&... args) const
 execute a statement and return the first (if any) value as a int
 
boost::optional< intexecAndReturnFirstInt (const std::string &statement) const
 
template<typename... Args>
boost::optional< std::string > execAndReturnFirstString (const std::string &statement, Args &&... args) const
 execute a statement and return the first (if any) value as a string
 
boost::optional< std::string > execAndReturnFirstString (const std::string &statement) const
 
template<typename... Args>
boost::optional< std::vector< double > > execAndReturnVectorOfDouble (const std::string &statement, Args &&... args) const
 execute a statement and return the results (if any) in a vector of double
 
boost::optional< std::vector< double > > execAndReturnVectorOfDouble (const std::string &statement) const
 
template<typename... Args>
boost::optional< std::vector< int > > execAndReturnVectorOfInt (const std::string &statement, Args &&... args) const
 execute a statement and return the results (if any) in a vector of int
 
boost::optional< std::vector< int > > execAndReturnVectorOfInt (const std::string &statement) const
 
template<typename... Args>
boost::optional< std::vector< std::string > > execAndReturnVectorOfString (const std::string &statement, Args &&... args) const
 execute a statement and return the results (if any) in a vector of string
 
boost::optional< std::vector< std::string > > execAndReturnVectorOfString (const std::string &statement) const
 
template<typename... Args>
int execute (const std::string &statement, Args &&... args)
 execute a statement and return the error code, used for create/drop tables
 
int execute (const std::string &statement)
 
void insertTimeSeriesData (const std::string &t_variableType, const std::string &t_indexGroup, const std::string &t_timestepType, const std::string &t_keyValue, const std::string &t_variableName, const openstudio::ReportingFrequency &t_reportingFrequency, const boost::optional< std::string > &t_scheduleName, const std::string &t_variableUnits, const openstudio::TimeSeries &t_timeSeries)
 

Operators

bool operator== (const SqlFile &other) const
 
bool operator< (const SqlFile &other) const
 

Detailed Description

SqlFile class is a transaction script around the sql output of EnergyPlus.

Constructor & Destructor Documentation

◆ SqlFile() [1/3]

openstudio::SqlFile::SqlFile ( )

default constructor

◆ SqlFile() [2/3]

openstudio::SqlFile::SqlFile ( const openstudio::path & path,
const bool createIndexes = true )
explicit

constructor from path Creates indexes by default, pass in false for no new indexes and quicker opening

◆ SqlFile() [3/3]

openstudio::SqlFile::SqlFile ( const openstudio::path & t_path,
const openstudio::EpwFile & t_epwFile,
const openstudio::DateTime & t_simulationTime,
const openstudio::Calendar & t_calendar,
const bool createIndexes = true )

initializes a new sql file for output Creates indexes by default, pass in false for no indexes and quicker creation

◆ ~SqlFile()

virtual openstudio::SqlFile::~SqlFile ( )
virtualdefault

Member Function Documentation

◆ annualTotalCost()

boost::optional< double > openstudio::SqlFile::annualTotalCost ( const FuelType & fuel) const

Returns the annual total cost associated with the given fuel type in dollars.

Requires EnergyPlus simulation output to calculate.

◆ annualTotalCostPerBldgArea()

boost::optional< double > openstudio::SqlFile::annualTotalCostPerBldgArea ( const FuelType & fuel) const

Returns the annual total cost per total building area associated with the given fuel type in dollars per square meter.

Requires EnergyPlus simulation output to calculate.

◆ annualTotalCostPerNetConditionedBldgArea()

boost::optional< double > openstudio::SqlFile::annualTotalCostPerNetConditionedBldgArea ( const FuelType & fuel) const

Returns the annual total cost per net conditioned building area associated with the given fuel type in dollars per square meter.

Requires EnergyPlus simulation output to calculate.

◆ annualTotalUtilityCost()

boost::optional< double > openstudio::SqlFile::annualTotalUtilityCost ( ) const

Returns the annual total cost for all fuel types in dollars. Requires EnergyPlus simulation output to calculate.

◆ assemblySHGC()

boost::optional< double > openstudio::SqlFile::assemblySHGC ( const std::string & subSurfaceName) const

◆ assemblyUFactor()

boost::optional< double > openstudio::SqlFile::assemblyUFactor ( const std::string & subSurfaceName) const

◆ assemblyVisibleTransmittance()

boost::optional< double > openstudio::SqlFile::assemblyVisibleTransmittance ( const std::string & subSurfaceName) const

◆ availableEnvPeriods()

std::vector< std::string > openstudio::SqlFile::availableEnvPeriods ( ) const

◆ availableKeyValues()

std::vector< std::string > openstudio::SqlFile::availableKeyValues ( const std::string & envPeriod,
const std::string & reportingFrequency,
const std::string & timeSeriesName )

◆ availableReportingFrequencies()

std::vector< std::string > openstudio::SqlFile::availableReportingFrequencies ( const std::string & envPeriod)

◆ availableTimeSeries()

std::vector< std::string > openstudio::SqlFile::availableTimeSeries ( )

◆ availableVariableNames()

std::vector< std::string > openstudio::SqlFile::availableVariableNames ( const std::string & envPeriod,
const std::string & reportingFrequency ) const

◆ close()

bool openstudio::SqlFile::close ( )

close the file

◆ coalCooling()

boost::optional< double > openstudio::SqlFile::coalCooling ( ) const

Returns the energy used for cooling from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalExteriorEquipment()

boost::optional< double > openstudio::SqlFile::coalExteriorEquipment ( ) const

Returns the energy used for exterior equipment from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalExteriorLighting()

boost::optional< double > openstudio::SqlFile::coalExteriorLighting ( ) const

Returns the energy used for exterior lighting from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalFans()

boost::optional< double > openstudio::SqlFile::coalFans ( ) const

Returns the energy used for fans from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalGenerators()

boost::optional< double > openstudio::SqlFile::coalGenerators ( ) const

Returns the energy used for generators from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalHeating()

boost::optional< double > openstudio::SqlFile::coalHeating ( ) const

Coal Returns the energy used for heating from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalHeatRecovery()

boost::optional< double > openstudio::SqlFile::coalHeatRecovery ( ) const

Returns the energy used for heat recovery from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalHeatRejection()

boost::optional< double > openstudio::SqlFile::coalHeatRejection ( ) const

Returns the energy used for heat rejection from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalHumidification()

boost::optional< double > openstudio::SqlFile::coalHumidification ( ) const

Returns the energy used for humidification from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalInteriorEquipment()

boost::optional< double > openstudio::SqlFile::coalInteriorEquipment ( ) const

Returns the energy used for interior equipment from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalInteriorLighting()

boost::optional< double > openstudio::SqlFile::coalInteriorLighting ( ) const

Returns the energy used for interior lighting from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalPumps()

boost::optional< double > openstudio::SqlFile::coalPumps ( ) const

Returns the energy used for pumps from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalRefrigeration()

boost::optional< double > openstudio::SqlFile::coalRefrigeration ( ) const

Returns the energy used for refrigeration from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalTotalEndUses()

boost::optional< double > openstudio::SqlFile::coalTotalEndUses ( ) const

Returns the energy used for all end uses from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ coalWaterSystems()

boost::optional< double > openstudio::SqlFile::coalWaterSystems ( ) const

Returns the energy used for water systems from coal in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ connectionOpen()

bool openstudio::SqlFile::connectionOpen ( ) const

returns whether or not connection is open

◆ createIndexes()

void openstudio::SqlFile::createIndexes ( )

◆ daylightSavingsPeriod()

boost::optional< std::pair< DateTime, DateTime > > openstudio::SqlFile::daylightSavingsPeriod ( ) const

◆ dieselCooling()

boost::optional< double > openstudio::SqlFile::dieselCooling ( ) const

Returns the energy used for cooling from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselExteriorEquipment()

boost::optional< double > openstudio::SqlFile::dieselExteriorEquipment ( ) const

Returns the energy used for exterior equipment from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselExteriorLighting()

boost::optional< double > openstudio::SqlFile::dieselExteriorLighting ( ) const

Returns the energy used for exterior lighting from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselFans()

boost::optional< double > openstudio::SqlFile::dieselFans ( ) const

Returns the energy used for fans from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselGenerators()

boost::optional< double > openstudio::SqlFile::dieselGenerators ( ) const

Returns the energy used for generators from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselHeating()

boost::optional< double > openstudio::SqlFile::dieselHeating ( ) const

Diesel Returns the energy used for heating from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselHeatRecovery()

boost::optional< double > openstudio::SqlFile::dieselHeatRecovery ( ) const

Returns the energy used for heat recovery from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselHeatRejection()

boost::optional< double > openstudio::SqlFile::dieselHeatRejection ( ) const

Returns the energy used for heat rejection from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselHumidification()

boost::optional< double > openstudio::SqlFile::dieselHumidification ( ) const

Returns the energy used for humidification from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselInteriorEquipment()

boost::optional< double > openstudio::SqlFile::dieselInteriorEquipment ( ) const

Returns the energy used for interior equipment from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselInteriorLighting()

boost::optional< double > openstudio::SqlFile::dieselInteriorLighting ( ) const

Returns the energy used for interior lighting from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselPumps()

boost::optional< double > openstudio::SqlFile::dieselPumps ( ) const

Returns the energy used for pumps from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselRefrigeration()

boost::optional< double > openstudio::SqlFile::dieselRefrigeration ( ) const

Returns the energy used for refrigeration from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselTotalEndUses()

boost::optional< double > openstudio::SqlFile::dieselTotalEndUses ( ) const

Returns the energy used for all end uses from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ dieselWaterSystems()

boost::optional< double > openstudio::SqlFile::dieselWaterSystems ( ) const

Returns the energy used for water systems from diesel in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingCooling()

boost::optional< double > openstudio::SqlFile::districtCoolingCooling ( ) const

Returns the district cooling energy used for cooling in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingExteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtCoolingExteriorEquipment ( ) const

Returns the district cooling energy used for exterior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingExteriorLighting()

boost::optional< double > openstudio::SqlFile::districtCoolingExteriorLighting ( ) const

Returns the district cooling energy used for exterior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingFans()

boost::optional< double > openstudio::SqlFile::districtCoolingFans ( ) const

Returns the district cooling energy used for fans in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingGenerators()

boost::optional< double > openstudio::SqlFile::districtCoolingGenerators ( ) const

Returns the district cooling energy used for generators in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingHeating()

boost::optional< double > openstudio::SqlFile::districtCoolingHeating ( ) const

Returns the district cooling energy used for heating in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingHeatRecovery()

boost::optional< double > openstudio::SqlFile::districtCoolingHeatRecovery ( ) const

Returns the district cooling energy used for heat recovery in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingHeatRejection()

boost::optional< double > openstudio::SqlFile::districtCoolingHeatRejection ( ) const

Returns the district cooling energy used for heat rejection in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingHumidification()

boost::optional< double > openstudio::SqlFile::districtCoolingHumidification ( ) const

Returns the district cooling energy used for humidification in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingInteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtCoolingInteriorEquipment ( ) const

Returns the district cooling energy used for interior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingInteriorLighting()

boost::optional< double > openstudio::SqlFile::districtCoolingInteriorLighting ( ) const

Returns the district cooling energy used for interior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingPumps()

boost::optional< double > openstudio::SqlFile::districtCoolingPumps ( ) const

Returns the district cooling energy used for pumps in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingRefrigeration()

boost::optional< double > openstudio::SqlFile::districtCoolingRefrigeration ( ) const

Returns the district cooling energy used for refrigeration in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingTotalEndUses()

boost::optional< double > openstudio::SqlFile::districtCoolingTotalEndUses ( ) const

Returns the district cooling energy used for all end uses in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtCoolingWaterSystems()

boost::optional< double > openstudio::SqlFile::districtCoolingWaterSystems ( ) const

Returns the district cooling energy used for water systems in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingCooling()

boost::optional< double > openstudio::SqlFile::districtHeatingCooling ( ) const

Returns the district heating energy used for cooling in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingExteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtHeatingExteriorEquipment ( ) const

Returns the district heating energy used for exterior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingExteriorLighting()

boost::optional< double > openstudio::SqlFile::districtHeatingExteriorLighting ( ) const

Returns the district heating energy used for exterior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingFans()

boost::optional< double > openstudio::SqlFile::districtHeatingFans ( ) const

Returns the district heating energy used for fans in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingGenerators()

boost::optional< double > openstudio::SqlFile::districtHeatingGenerators ( ) const

Returns the district heating energy used for generators in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingHeating()

boost::optional< double > openstudio::SqlFile::districtHeatingHeating ( ) const

Returns the district heating energy used for heating in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingHeatRecovery()

boost::optional< double > openstudio::SqlFile::districtHeatingHeatRecovery ( ) const

Returns the district heating energy used for heat recovery in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingHeatRejection()

boost::optional< double > openstudio::SqlFile::districtHeatingHeatRejection ( ) const

Returns the district heating energy used for heat rejection in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingHumidification()

boost::optional< double > openstudio::SqlFile::districtHeatingHumidification ( ) const

Returns the district heating energy used for humidification in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingInteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtHeatingInteriorEquipment ( ) const

Returns the district heating energy used for interior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingInteriorLighting()

boost::optional< double > openstudio::SqlFile::districtHeatingInteriorLighting ( ) const

Returns the district heating energy used for interior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingPumps()

boost::optional< double > openstudio::SqlFile::districtHeatingPumps ( ) const

Returns the district heating energy used for pumps in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingRefrigeration()

boost::optional< double > openstudio::SqlFile::districtHeatingRefrigeration ( ) const

Returns the district heating energy used for refrigeration in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamCooling()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamCooling ( ) const

Returns the district heating steam energy used for cooling in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamExteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamExteriorEquipment ( ) const

Returns the district heating steam energy used for exterior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamExteriorLighting()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamExteriorLighting ( ) const

Returns the district heating steam energy used for exterior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamFans()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamFans ( ) const

Returns the district heating steam energy used for fans in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamGenerators()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamGenerators ( ) const

Returns the district heating steam energy used for generators in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamHeating()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamHeating ( ) const

Returns the district heating steam energy used for heating in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamHeatRecovery()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamHeatRecovery ( ) const

Returns the district heating steam energy used for heat recovery in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamHeatRejection()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamHeatRejection ( ) const

Returns the district heating steam energy used for heat rejection in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamHumidification()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamHumidification ( ) const

Returns the district heating steam energy used for humidification in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamInteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamInteriorEquipment ( ) const

Returns the district heating steam energy used for interior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamInteriorLighting()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamInteriorLighting ( ) const

Returns the district heating steam energy used for interior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamPumps()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamPumps ( ) const

Returns the district heating steam energy used for pumps in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamRefrigeration()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamRefrigeration ( ) const

Returns the district heating steam energy used for refrigeration in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamTotalEndUses()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamTotalEndUses ( ) const

Returns the district heating steam energy used for all end uses in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingSteamWaterSystems()

boost::optional< double > openstudio::SqlFile::districtHeatingSteamWaterSystems ( ) const

Returns the district heating steam energy used for water systems in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingTotalEndUses()

boost::optional< double > openstudio::SqlFile::districtHeatingTotalEndUses ( ) const

Returns the district heating energy used for all end uses in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterCooling()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterCooling ( ) const

Returns the district heating water energy used for cooling in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterExteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterExteriorEquipment ( ) const

Returns the district heating water energy used for exterior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterExteriorLighting()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterExteriorLighting ( ) const

Returns the district heating water energy used for exterior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterFans()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterFans ( ) const

Returns the district heating water energy used for fans in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterGenerators()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterGenerators ( ) const

Returns the district heating water energy used for generators in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterHeating()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterHeating ( ) const

Returns the district heating water energy used for heating in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterHeatRecovery()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterHeatRecovery ( ) const

Returns the district heating water energy used for heat recovery in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterHeatRejection()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterHeatRejection ( ) const

Returns the district heating water energy used for heat rejection in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterHumidification()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterHumidification ( ) const

Returns the district heating water energy used for humidification in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterInteriorEquipment()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterInteriorEquipment ( ) const

Returns the district heating water energy used for interior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterInteriorLighting()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterInteriorLighting ( ) const

Returns the district heating water energy used for interior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterPumps()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterPumps ( ) const

Returns the district heating water energy used for pumps in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterRefrigeration()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterRefrigeration ( ) const

Returns the district heating water energy used for refrigeration in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterSystems()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterSystems ( ) const

Returns the district heating energy used for water systems in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterTotalEndUses()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterTotalEndUses ( ) const

Returns the district heating water energy used for all end uses in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ districtHeatingWaterWaterSystems()

boost::optional< double > openstudio::SqlFile::districtHeatingWaterWaterSystems ( ) const

Returns the district heating water energy used for water systems in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ economicsEnergyCost()

boost::optional< double > openstudio::SqlFile::economicsEnergyCost ( ) const

Returns the total energy cost over the analysis period in dollars according to the discounting convention.

Requires EnergyPlus simulation output and LifeCycleCost_Parameters input object to calculate.

◆ electricityCooling()

boost::optional< double > openstudio::SqlFile::electricityCooling ( ) const

Returns the electric energy used for cooling in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityExteriorEquipment()

boost::optional< double > openstudio::SqlFile::electricityExteriorEquipment ( ) const

Returns the electric energy used for exterior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityExteriorLighting()

boost::optional< double > openstudio::SqlFile::electricityExteriorLighting ( ) const

Returns the electric energy used for exterior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityFans()

boost::optional< double > openstudio::SqlFile::electricityFans ( ) const

Returns the electric energy used for fans in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityGenerators()

boost::optional< double > openstudio::SqlFile::electricityGenerators ( ) const

Returns the electric energy used for generators in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityHeating()

boost::optional< double > openstudio::SqlFile::electricityHeating ( ) const

Returns the electric energy used for heating in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityHeatRecovery()

boost::optional< double > openstudio::SqlFile::electricityHeatRecovery ( ) const

Returns the electric energy used for heat recovery in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityHeatRejection()

boost::optional< double > openstudio::SqlFile::electricityHeatRejection ( ) const

Returns the electric energy used for heat rejection in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityHumidification()

boost::optional< double > openstudio::SqlFile::electricityHumidification ( ) const

Returns the electric energy used for humidification in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityInteriorEquipment()

boost::optional< double > openstudio::SqlFile::electricityInteriorEquipment ( ) const

Returns the electric energy used for interior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityInteriorLighting()

boost::optional< double > openstudio::SqlFile::electricityInteriorLighting ( ) const

Returns the electric energy used for interior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityPumps()

boost::optional< double > openstudio::SqlFile::electricityPumps ( ) const

Returns the electric energy used for pumps in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityRefrigeration()

boost::optional< double > openstudio::SqlFile::electricityRefrigeration ( ) const

Returns the electric energy used for refrigeration in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityTotalEndUses()

boost::optional< double > openstudio::SqlFile::electricityTotalEndUses ( ) const

Returns the electric energy used for all uses in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ electricityWaterSystems()

boost::optional< double > openstudio::SqlFile::electricityWaterSystems ( ) const

Returns the electric energy used for water systems in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ endUses()

boost::optional< EndUses > openstudio::SqlFile::endUses ( ) const

Returns an EndUses object containing all end uses for the simulation.

◆ energyConsumptionByMonth()

boost::optional< double > openstudio::SqlFile::energyConsumptionByMonth ( const openstudio::EndUseFuelType & t_fuelType,
const openstudio::EndUseCategoryType & t_categoryType,
const openstudio::MonthOfYear & t_monthOfYear ) const

Returns the energy consumption for the given fuel type, category and month.

Requires BUILDING ENERGY PERFORMANCE tabular report. Value is energy use in J.

◆ energyPlusSqliteFile()

std::string openstudio::SqlFile::energyPlusSqliteFile ( ) const

Energy Plus eplusout.sql file name.

◆ energyPlusVersion()

std::string openstudio::SqlFile::energyPlusVersion ( ) const

Energy plus version number.

◆ environmentType()

boost::optional< openstudio::EnvironmentType > openstudio::SqlFile::environmentType ( const std::string & envPeriod) const

◆ execAndReturnFirstDouble() [1/2]

boost::optional< double > openstudio::SqlFile::execAndReturnFirstDouble ( const std::string & statement) const
inline

◆ execAndReturnFirstDouble() [2/2]

template<typename... Args>
boost::optional< double > openstudio::SqlFile::execAndReturnFirstDouble ( const std::string & statement,
Args &&... args ) const
inline

execute a statement and return the first (if any) value as a double

◆ execAndReturnFirstInt() [1/2]

boost::optional< int > openstudio::SqlFile::execAndReturnFirstInt ( const std::string & statement) const
inline

◆ execAndReturnFirstInt() [2/2]

template<typename... Args>
boost::optional< int > openstudio::SqlFile::execAndReturnFirstInt ( const std::string & statement,
Args &&... args ) const
inline

execute a statement and return the first (if any) value as a int

◆ execAndReturnFirstString() [1/2]

boost::optional< std::string > openstudio::SqlFile::execAndReturnFirstString ( const std::string & statement) const
inline

◆ execAndReturnFirstString() [2/2]

template<typename... Args>
boost::optional< std::string > openstudio::SqlFile::execAndReturnFirstString ( const std::string & statement,
Args &&... args ) const
inline

execute a statement and return the first (if any) value as a string

◆ execAndReturnVectorOfDouble() [1/2]

boost::optional< std::vector< double > > openstudio::SqlFile::execAndReturnVectorOfDouble ( const std::string & statement) const
inline

◆ execAndReturnVectorOfDouble() [2/2]

template<typename... Args>
boost::optional< std::vector< double > > openstudio::SqlFile::execAndReturnVectorOfDouble ( const std::string & statement,
Args &&... args ) const
inline

execute a statement and return the results (if any) in a vector of double

◆ execAndReturnVectorOfInt() [1/2]

boost::optional< std::vector< int > > openstudio::SqlFile::execAndReturnVectorOfInt ( const std::string & statement) const
inline

◆ execAndReturnVectorOfInt() [2/2]

template<typename... Args>
boost::optional< std::vector< int > > openstudio::SqlFile::execAndReturnVectorOfInt ( const std::string & statement,
Args &&... args ) const
inline

execute a statement and return the results (if any) in a vector of int

◆ execAndReturnVectorOfString() [1/2]

boost::optional< std::vector< std::string > > openstudio::SqlFile::execAndReturnVectorOfString ( const std::string & statement) const
inline

◆ execAndReturnVectorOfString() [2/2]

template<typename... Args>
boost::optional< std::vector< std::string > > openstudio::SqlFile::execAndReturnVectorOfString ( const std::string & statement,
Args &&... args ) const
inline

execute a statement and return the results (if any) in a vector of string

◆ execute() [1/2]

int openstudio::SqlFile::execute ( const std::string & statement)
inline

◆ execute() [2/2]

template<typename... Args>
int openstudio::SqlFile::execute ( const std::string & statement,
Args &&... args )
inline

execute a statement and return the error code, used for create/drop tables

◆ expandQuery()

std::vector< SqlFileTimeSeriesQuery > openstudio::SqlFile::expandQuery ( const SqlFileTimeSeriesQuery & query)

Expands query to create a vector of all matching queries.

The returned queries will have one environment period, one reporting frequency, and one time series name specified. The returned queries will also be "vetted".

◆ fuelOilNo1Cooling()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Cooling ( ) const

Returns the energy used for cooling from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1ExteriorEquipment()

boost::optional< double > openstudio::SqlFile::fuelOilNo1ExteriorEquipment ( ) const

Returns the energy used for exterior equipment from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1ExteriorLighting()

boost::optional< double > openstudio::SqlFile::fuelOilNo1ExteriorLighting ( ) const

Returns the energy used for exterior lighting from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1Fans()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Fans ( ) const

Returns the energy used for fans from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1Generators()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Generators ( ) const

Returns the energy used for generators from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1Heating()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Heating ( ) const

Fuel Oil No 1 Returns the energy used for heating from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1HeatRecovery()

boost::optional< double > openstudio::SqlFile::fuelOilNo1HeatRecovery ( ) const

Returns the energy used for heat recovery from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1HeatRejection()

boost::optional< double > openstudio::SqlFile::fuelOilNo1HeatRejection ( ) const

Returns the energy used for heat rejection from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1Humidification()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Humidification ( ) const

Returns the energy used for humidification from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1InteriorEquipment()

boost::optional< double > openstudio::SqlFile::fuelOilNo1InteriorEquipment ( ) const

Returns the energy used for interior equipment from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1InteriorLighting()

boost::optional< double > openstudio::SqlFile::fuelOilNo1InteriorLighting ( ) const

Returns the energy used for interior lighting from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1Pumps()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Pumps ( ) const

Returns the energy used for pumps from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1Refrigeration()

boost::optional< double > openstudio::SqlFile::fuelOilNo1Refrigeration ( ) const

Returns the energy used for refrigeration from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1TotalEndUses()

boost::optional< double > openstudio::SqlFile::fuelOilNo1TotalEndUses ( ) const

Returns the energy used for all end uses from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo1WaterSystems()

boost::optional< double > openstudio::SqlFile::fuelOilNo1WaterSystems ( ) const

Returns the energy used for water systems from fuelOilNo1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Cooling()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Cooling ( ) const

Returns the energy used for cooling from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2ExteriorEquipment()

boost::optional< double > openstudio::SqlFile::fuelOilNo2ExteriorEquipment ( ) const

Returns the energy used for exterior equipment from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2ExteriorLighting()

boost::optional< double > openstudio::SqlFile::fuelOilNo2ExteriorLighting ( ) const

Returns the energy used for exterior lighting from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Fans()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Fans ( ) const

Returns the energy used for fans from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Generators()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Generators ( ) const

Returns the energy used for generators from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Heating()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Heating ( ) const

Fuel Oil No 2 Returns the energy used for heating from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2HeatRecovery()

boost::optional< double > openstudio::SqlFile::fuelOilNo2HeatRecovery ( ) const

Returns the energy used for heat recovery from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2HeatRejection()

boost::optional< double > openstudio::SqlFile::fuelOilNo2HeatRejection ( ) const

Returns the energy used for heat rejection from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Humidification()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Humidification ( ) const

Returns the energy used for humidification from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2InteriorEquipment()

boost::optional< double > openstudio::SqlFile::fuelOilNo2InteriorEquipment ( ) const

Returns the energy used for interior equipment from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2InteriorLighting()

boost::optional< double > openstudio::SqlFile::fuelOilNo2InteriorLighting ( ) const

Returns the energy used for interior lighting from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Pumps()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Pumps ( ) const

Returns the energy used for pumps from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2Refrigeration()

boost::optional< double > openstudio::SqlFile::fuelOilNo2Refrigeration ( ) const

Returns the energy used for refrigeration from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2TotalEndUses()

boost::optional< double > openstudio::SqlFile::fuelOilNo2TotalEndUses ( ) const

Returns the energy used for all end uses from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ fuelOilNo2WaterSystems()

boost::optional< double > openstudio::SqlFile::fuelOilNo2WaterSystems ( ) const

Returns the energy used for water systems from fuelOilNo2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineCooling()

boost::optional< double > openstudio::SqlFile::gasolineCooling ( ) const

Returns the energy used for cooling from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineExteriorEquipment()

boost::optional< double > openstudio::SqlFile::gasolineExteriorEquipment ( ) const

Returns the energy used for exterior equipment from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineExteriorLighting()

boost::optional< double > openstudio::SqlFile::gasolineExteriorLighting ( ) const

Returns the energy used for exterior lighting from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineFans()

boost::optional< double > openstudio::SqlFile::gasolineFans ( ) const

Returns the energy used for fans from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineGenerators()

boost::optional< double > openstudio::SqlFile::gasolineGenerators ( ) const

Returns the energy used for generators from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineHeating()

boost::optional< double > openstudio::SqlFile::gasolineHeating ( ) const

Gasoline Returns the energy used for heating from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineHeatRecovery()

boost::optional< double > openstudio::SqlFile::gasolineHeatRecovery ( ) const

Returns the energy used for heat recovery from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineHeatRejection()

boost::optional< double > openstudio::SqlFile::gasolineHeatRejection ( ) const

Returns the energy used for heat rejection from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineHumidification()

boost::optional< double > openstudio::SqlFile::gasolineHumidification ( ) const

Returns the energy used for humidification from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineInteriorEquipment()

boost::optional< double > openstudio::SqlFile::gasolineInteriorEquipment ( ) const

Returns the energy used for interior equipment from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineInteriorLighting()

boost::optional< double > openstudio::SqlFile::gasolineInteriorLighting ( ) const

Returns the energy used for interior lighting from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolinePumps()

boost::optional< double > openstudio::SqlFile::gasolinePumps ( ) const

Returns the energy used for pumps from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineRefrigeration()

boost::optional< double > openstudio::SqlFile::gasolineRefrigeration ( ) const

Returns the energy used for refrigeration from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineTotalEndUses()

boost::optional< double > openstudio::SqlFile::gasolineTotalEndUses ( ) const

Returns the energy used for all end uses from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ gasolineWaterSystems()

boost::optional< double > openstudio::SqlFile::gasolineWaterSystems ( ) const

Returns the energy used for water systems from gasoline in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ getElecOrGasCost()

OptionalDouble openstudio::SqlFile::getElecOrGasCost ( bool t_getGas = true) const

◆ getElecOrGasUse()

OptionalDouble openstudio::SqlFile::getElecOrGasUse ( bool t_getGas = true) const

◆ getExteriorFenestrationValue()

boost::optional< double > openstudio::SqlFile::getExteriorFenestrationValue ( const std::string & subSurfaceName,
const std::string & columnName ) const

◆ getSummaryData()

std::vector< SummaryData > openstudio::SqlFile::getSummaryData ( ) const

Returns the summary data for each installlocation and fuel type found in report variables.

◆ hasIlluminanceMapYear()

bool openstudio::SqlFile::hasIlluminanceMapYear ( ) const

◆ hasYear()

bool openstudio::SqlFile::hasYear ( ) const

◆ hoursCoolingSetpointNotMet()

boost::optional< double > openstudio::SqlFile::hoursCoolingSetpointNotMet ( ) const

Returns the total number of hours the cooling setpoint is not met.

Requires EnergyPlus simulation output to calculate.

◆ hoursHeatingSetpointNotMet()

boost::optional< double > openstudio::SqlFile::hoursHeatingSetpointNotMet ( ) const

Returns the total number of hours the heating setpoint is not met.

Requires EnergyPlus simulation output to calculate.

◆ hoursSimulated()

boost::optional< double > openstudio::SqlFile::hoursSimulated ( ) const

hours simulated

◆ illuminanceMap() [1/3]

Matrix openstudio::SqlFile::illuminanceMap ( const std::string & name,
const DateTime & dateTime ) const

value (lux) of the illuminance map at date and time value(i,j) is the illuminance at x(i), y(j)

◆ illuminanceMap() [2/3]

Matrix openstudio::SqlFile::illuminanceMap ( int hourlyReportIndex) const

value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j)

◆ illuminanceMap() [3/3]

void openstudio::SqlFile::illuminanceMap ( int hourlyReportIndex,
std::vector< double > & x,
std::vector< double > & y,
std::vector< double > & illuminance ) const

value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j) fills in x,y, illuminance

◆ illuminanceMapDate()

boost::optional< DateTime > openstudio::SqlFile::illuminanceMapDate ( int hourlyReportIndex) const

date time at hourly report index

◆ illuminanceMapHourlyReportIndex()

boost::optional< int > openstudio::SqlFile::illuminanceMapHourlyReportIndex ( int mapIndex,
const DateTime & dateTime ) const

hourly report index for mapIndex at date and time

◆ illuminanceMapHourlyReportIndices() [1/2]

std::vector< int > openstudio::SqlFile::illuminanceMapHourlyReportIndices ( const std::string & name) const

hourly report indices of the illuminance map

◆ illuminanceMapHourlyReportIndices() [2/2]

std::vector< int > openstudio::SqlFile::illuminanceMapHourlyReportIndices ( int mapIndex) const

hourly report indices of the illuminance map

◆ illuminanceMapHourlyReportIndicesDates() [1/2]

std::vector< std::pair< int, DateTime > > openstudio::SqlFile::illuminanceMapHourlyReportIndicesDates ( const std::string & name) const

hourly report indices of the illuminance map

◆ illuminanceMapHourlyReportIndicesDates() [2/2]

std::vector< std::pair< int, DateTime > > openstudio::SqlFile::illuminanceMapHourlyReportIndicesDates ( int mapIndex) const

hourly report indices of the illuminance map

◆ illuminanceMapIndex()

boost::optional< int > openstudio::SqlFile::illuminanceMapIndex ( const std::string & name) const

◆ illuminanceMapMaxValue() [1/4]

boost::optional< double > openstudio::SqlFile::illuminanceMapMaxValue ( const std::string & name) const

maximum value of map

◆ illuminanceMapMaxValue() [2/4]

void openstudio::SqlFile::illuminanceMapMaxValue ( const std::string & name,
double & minValue,
double & maxValue ) const

minimum and maximum of map

◆ illuminanceMapMaxValue() [3/4]

boost::optional< double > openstudio::SqlFile::illuminanceMapMaxValue ( int mapIndex) const

◆ illuminanceMapMaxValue() [4/4]

void openstudio::SqlFile::illuminanceMapMaxValue ( int mapIndex,
double & minValue,
double & maxValue ) const

◆ illuminanceMapMinValue() [1/2]

boost::optional< double > openstudio::SqlFile::illuminanceMapMinValue ( const std::string & name) const

minimum value of map

◆ illuminanceMapMinValue() [2/2]

boost::optional< double > openstudio::SqlFile::illuminanceMapMinValue ( int mapIndex) const

◆ illuminanceMapNames() [1/2]

std::vector< std::string > openstudio::SqlFile::illuminanceMapNames ( ) const

get names of all available illuminance maps

◆ illuminanceMapNames() [2/2]

std::vector< std::string > openstudio::SqlFile::illuminanceMapNames ( const std::string & envPeriod) const

◆ illuminanceMapRefPt() [1/2]

boost::optional< std::string > openstudio::SqlFile::illuminanceMapRefPt ( const std::string & name,
int ptNum ) const

reference point for map - form RefPtn=(x:y:illuminance)

◆ illuminanceMapRefPt() [2/2]

boost::optional< std::string > openstudio::SqlFile::illuminanceMapRefPt ( int mapIndex,
int ptNum ) const

◆ illuminanceMapX() [1/2]

Vector openstudio::SqlFile::illuminanceMapX ( const std::string & name,
const DateTime & dateTime ) const

x position (m) of the illuminance map

◆ illuminanceMapX() [2/2]

Vector openstudio::SqlFile::illuminanceMapX ( int hourlyReportIndex) const

x position (m) of the illuminance map

◆ illuminanceMapY() [1/2]

Vector openstudio::SqlFile::illuminanceMapY ( const std::string & name,
const DateTime & dateTime ) const

y position (m) of the illuminance map

◆ illuminanceMapY() [2/2]

Vector openstudio::SqlFile::illuminanceMapY ( int hourlyReportIndex) const

y position (m) of the illuminance map

◆ illuminanceMapZoneNames() [1/2]

std::vector< std::string > openstudio::SqlFile::illuminanceMapZoneNames ( const std::string & name) const

get zone names of for specified illuminance map

◆ illuminanceMapZoneNames() [2/2]

std::vector< std::string > openstudio::SqlFile::illuminanceMapZoneNames ( int mapIndex) const

◆ insertIlluminanceMap()

void openstudio::SqlFile::insertIlluminanceMap ( const std::string & t_zoneName,
const std::string & t_name,
const std::string & t_environmentName,
const std::vector< DateTime > & t_times,
const std::vector< double > & t_xs,
const std::vector< double > & t_ys,
double t_z,
const std::vector< Matrix > & t_maps )

◆ insertTimeSeriesData()

void openstudio::SqlFile::insertTimeSeriesData ( const std::string & t_variableType,
const std::string & t_indexGroup,
const std::string & t_timestepType,
const std::string & t_keyValue,
const std::string & t_variableName,
const openstudio::ReportingFrequency & t_reportingFrequency,
const boost::optional< std::string > & t_scheduleName,
const std::string & t_variableUnits,
const openstudio::TimeSeries & t_timeSeries )

◆ insertZone()

int openstudio::SqlFile::insertZone ( const std::string & t_name,
double t_relNorth,
double t_originX,
double t_originY,
double t_originZ,
double t_centroidX,
double t_centroidY,
double t_centroidZ,
int t_ofType,
double t_multiplier,
double t_listMultiplier,
double t_minimumX,
double t_maximumX,
double t_minimumY,
double t_maximumY,
double t_minimumZ,
double t_maximumZ,
double t_ceilingHeight,
double t_volume,
int t_insideConvectionAlgo,
int t_outsideConvectionAlgo,
double t_floorArea,
double t_extGrossWallArea,
double t_extNetWallArea,
double t_extWindowArea,
bool t_isPartOfTotalArea )

◆ naturalGasCooling()

boost::optional< double > openstudio::SqlFile::naturalGasCooling ( ) const

Returns the natural gas energy used for cooling in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasExteriorEquipment()

boost::optional< double > openstudio::SqlFile::naturalGasExteriorEquipment ( ) const

Returns the natural gas energy used for exterior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasExteriorLighting()

boost::optional< double > openstudio::SqlFile::naturalGasExteriorLighting ( ) const

Returns the natural gas energy used for exterior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasFans()

boost::optional< double > openstudio::SqlFile::naturalGasFans ( ) const

Returns the natural gas energy used for fans in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasGenerators()

boost::optional< double > openstudio::SqlFile::naturalGasGenerators ( ) const

Returns the natural gas energy used for generators in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasHeating()

boost::optional< double > openstudio::SqlFile::naturalGasHeating ( ) const

Returns the natural gas energy used for heating in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasHeatRecovery()

boost::optional< double > openstudio::SqlFile::naturalGasHeatRecovery ( ) const

Returns the natural gas energy used for heat recovery in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasHeatRejection()

boost::optional< double > openstudio::SqlFile::naturalGasHeatRejection ( ) const

Returns the natural gas energy used for heat rejection in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasHumidification()

boost::optional< double > openstudio::SqlFile::naturalGasHumidification ( ) const

Returns the natural gas energy used for humidification in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasInteriorEquipment()

boost::optional< double > openstudio::SqlFile::naturalGasInteriorEquipment ( ) const

Returns the natural gas energy used for interior equipment in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasInteriorLighting()

boost::optional< double > openstudio::SqlFile::naturalGasInteriorLighting ( ) const

Returns the natural gas energy used for interior lighting in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasPumps()

boost::optional< double > openstudio::SqlFile::naturalGasPumps ( ) const

Returns the natural gas energy used for pumps in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasRefrigeration()

boost::optional< double > openstudio::SqlFile::naturalGasRefrigeration ( ) const

Returns the natural gas energy used for refrigeration in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasTotalEndUses()

boost::optional< double > openstudio::SqlFile::naturalGasTotalEndUses ( ) const

Returns the natural gas energy used for all end uses in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ naturalGasWaterSystems()

boost::optional< double > openstudio::SqlFile::naturalGasWaterSystems ( ) const

Returns the natural gas energy used for water systems in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ netSiteEnergy()

boost::optional< double > openstudio::SqlFile::netSiteEnergy ( ) const

net site energy in GJ

◆ netSourceEnergy()

boost::optional< double > openstudio::SqlFile::netSourceEnergy ( ) const

net source energy in GJ

◆ operator<()

bool openstudio::SqlFile::operator< ( const SqlFile & other) const

◆ operator==()

bool openstudio::SqlFile::operator== ( const SqlFile & other) const

◆ otherFuel1Cooling()

boost::optional< double > openstudio::SqlFile::otherFuel1Cooling ( ) const

Returns the energy used for cooling from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1ExteriorEquipment()

boost::optional< double > openstudio::SqlFile::otherFuel1ExteriorEquipment ( ) const

Returns the energy used for exterior equipment from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1ExteriorLighting()

boost::optional< double > openstudio::SqlFile::otherFuel1ExteriorLighting ( ) const

Returns the energy used for exterior lighting from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1Fans()

boost::optional< double > openstudio::SqlFile::otherFuel1Fans ( ) const

Returns the energy used for fans from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1Generators()

boost::optional< double > openstudio::SqlFile::otherFuel1Generators ( ) const

Returns the energy used for generators from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1Heating()

boost::optional< double > openstudio::SqlFile::otherFuel1Heating ( ) const

Other Fuel 1 Returns the energy used for heating from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1HeatRecovery()

boost::optional< double > openstudio::SqlFile::otherFuel1HeatRecovery ( ) const

Returns the energy used for heat recovery from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1HeatRejection()

boost::optional< double > openstudio::SqlFile::otherFuel1HeatRejection ( ) const

Returns the energy used for heat rejection from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1Humidification()

boost::optional< double > openstudio::SqlFile::otherFuel1Humidification ( ) const

Returns the energy used for humidification from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1InteriorEquipment()

boost::optional< double > openstudio::SqlFile::otherFuel1InteriorEquipment ( ) const

Returns the energy used for interior equipment from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1InteriorLighting()

boost::optional< double > openstudio::SqlFile::otherFuel1InteriorLighting ( ) const

Returns the energy used for interior lighting from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1Pumps()

boost::optional< double > openstudio::SqlFile::otherFuel1Pumps ( ) const

Returns the energy used for pumps from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1Refrigeration()

boost::optional< double > openstudio::SqlFile::otherFuel1Refrigeration ( ) const

Returns the energy used for refrigeration from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1TotalEndUses()

boost::optional< double > openstudio::SqlFile::otherFuel1TotalEndUses ( ) const

Returns the energy used for all end uses from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel1WaterSystems()

boost::optional< double > openstudio::SqlFile::otherFuel1WaterSystems ( ) const

Returns the energy used for water systems from otherFuel1 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Cooling()

boost::optional< double > openstudio::SqlFile::otherFuel2Cooling ( ) const

Returns the energy used for cooling from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2ExteriorEquipment()

boost::optional< double > openstudio::SqlFile::otherFuel2ExteriorEquipment ( ) const

Returns the energy used for exterior equipment from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2ExteriorLighting()

boost::optional< double > openstudio::SqlFile::otherFuel2ExteriorLighting ( ) const

Returns the energy used for exterior lighting from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Fans()

boost::optional< double > openstudio::SqlFile::otherFuel2Fans ( ) const

Returns the energy used for fans from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Generators()

boost::optional< double > openstudio::SqlFile::otherFuel2Generators ( ) const

Returns the energy used for generators from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Heating()

boost::optional< double > openstudio::SqlFile::otherFuel2Heating ( ) const

Other Fuel 2 Returns the energy used for heating from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2HeatRecovery()

boost::optional< double > openstudio::SqlFile::otherFuel2HeatRecovery ( ) const

Returns the energy used for heat recovery from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2HeatRejection()

boost::optional< double > openstudio::SqlFile::otherFuel2HeatRejection ( ) const

Returns the energy used for heat rejection from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Humidification()

boost::optional< double > openstudio::SqlFile::otherFuel2Humidification ( ) const

Returns the energy used for humidification from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2InteriorEquipment()

boost::optional< double > openstudio::SqlFile::otherFuel2InteriorEquipment ( ) const

Returns the energy used for interior equipment from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2InteriorLighting()

boost::optional< double > openstudio::SqlFile::otherFuel2InteriorLighting ( ) const

Returns the energy used for interior lighting from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Pumps()

boost::optional< double > openstudio::SqlFile::otherFuel2Pumps ( ) const

Returns the energy used for pumps from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2Refrigeration()

boost::optional< double > openstudio::SqlFile::otherFuel2Refrigeration ( ) const

Returns the energy used for refrigeration from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2TotalEndUses()

boost::optional< double > openstudio::SqlFile::otherFuel2TotalEndUses ( ) const

Returns the energy used for all end uses from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ otherFuel2WaterSystems()

boost::optional< double > openstudio::SqlFile::otherFuel2WaterSystems ( ) const

Returns the energy used for water systems from otherFuel2 in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ path()

openstudio::path openstudio::SqlFile::path ( ) const

get the path

◆ peakEnergyDemandByMonth()

boost::optional< double > openstudio::SqlFile::peakEnergyDemandByMonth ( const openstudio::EndUseFuelType & t_fuelType,
const openstudio::EndUseCategoryType & t_categoryType,
const openstudio::MonthOfYear & t_monthOfYear ) const

Returns the energy demand for the given fuel type, category and month.

Requires BUILDING ENERGY PERFORMANCE tabular report. Value is energy use in W.

◆ propaneCooling()

boost::optional< double > openstudio::SqlFile::propaneCooling ( ) const

Returns the energy used for cooling from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneExteriorEquipment()

boost::optional< double > openstudio::SqlFile::propaneExteriorEquipment ( ) const

Returns the energy used for exterior equipment from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneExteriorLighting()

boost::optional< double > openstudio::SqlFile::propaneExteriorLighting ( ) const

Returns the energy used for exterior lighting from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneFans()

boost::optional< double > openstudio::SqlFile::propaneFans ( ) const

Returns the energy used for fans from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneGenerators()

boost::optional< double > openstudio::SqlFile::propaneGenerators ( ) const

Returns the energy used for generators from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneHeating()

boost::optional< double > openstudio::SqlFile::propaneHeating ( ) const

Propane Returns the energy used for heating from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneHeatRecovery()

boost::optional< double > openstudio::SqlFile::propaneHeatRecovery ( ) const

Returns the energy used for heat recovery from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneHeatRejection()

boost::optional< double > openstudio::SqlFile::propaneHeatRejection ( ) const

Returns the energy used for heat rejection from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneHumidification()

boost::optional< double > openstudio::SqlFile::propaneHumidification ( ) const

Returns the energy used for humidification from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneInteriorEquipment()

boost::optional< double > openstudio::SqlFile::propaneInteriorEquipment ( ) const

Returns the energy used for interior equipment from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneInteriorLighting()

boost::optional< double > openstudio::SqlFile::propaneInteriorLighting ( ) const

Returns the energy used for interior lighting from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propanePumps()

boost::optional< double > openstudio::SqlFile::propanePumps ( ) const

Returns the energy used for pumps from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneRefrigeration()

boost::optional< double > openstudio::SqlFile::propaneRefrigeration ( ) const

Returns the energy used for refrigeration from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneTotalEndUses()

boost::optional< double > openstudio::SqlFile::propaneTotalEndUses ( ) const

Returns the energy used for all end uses from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ propaneWaterSystems()

boost::optional< double > openstudio::SqlFile::propaneWaterSystems ( ) const

Returns the energy used for water systems from propane in gigajoules.

Requires EnergyPlus simulation output to calculate.

◆ removeIndexes()

void openstudio::SqlFile::removeIndexes ( )

◆ reopen()

bool openstudio::SqlFile::reopen ( )

re-open the file

◆ reportingFrequencyFromDB()

boost::optional< openstudio::ReportingFrequency > openstudio::SqlFile::reportingFrequencyFromDB ( const std::string & dbReportingFrequency)

◆ runPeriodValue()

boost::optional< double > openstudio::SqlFile::runPeriodValue ( const std::string & envPeriod,
const std::string & timeSeriesName,
const std::string & keyValue )

◆ supportedVersion()

bool openstudio::SqlFile::supportedVersion ( ) const
Returns
true if the sqlfile is of a version that's in our supported range

◆ timeSeries() [1/3]

std::vector< TimeSeries > openstudio::SqlFile::timeSeries ( const SqlFileTimeSeriesQuery & query)

Executes query.

ReportingFrequency must be specified. Use expandQuery first to break query down by ReportingFrequency and determine how many TimeSeries will be returned.

◆ timeSeries() [2/3]

std::vector< TimeSeries > openstudio::SqlFile::timeSeries ( const std::string & envPeriod,
const std::string & reportingFrequency,
const std::string & timeSeriesName )

◆ timeSeries() [3/3]

boost::optional< TimeSeries > openstudio::SqlFile::timeSeries ( const std::string & envPeriod,
const std::string & reportingFrequency,
const std::string & timeSeriesName,
const std::string & keyValue )

◆ totalSiteEnergy()

boost::optional< double > openstudio::SqlFile::totalSiteEnergy ( ) const

total site energy in GJ

◆ totalSourceEnergy()

boost::optional< double > openstudio::SqlFile::totalSourceEnergy ( ) const

total source energy in GJ

◆ waterCooling()

boost::optional< double > openstudio::SqlFile::waterCooling ( ) const

Returns the water used for cooling in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterExteriorEquipment()

boost::optional< double > openstudio::SqlFile::waterExteriorEquipment ( ) const

Returns the water used for exterior equipment in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterExteriorLighting()

boost::optional< double > openstudio::SqlFile::waterExteriorLighting ( ) const

Returns the water used for exterior lighting in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterFans()

boost::optional< double > openstudio::SqlFile::waterFans ( ) const

Returns the water used for fans in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterGenerators()

boost::optional< double > openstudio::SqlFile::waterGenerators ( ) const

Returns the water used for generators in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterHeating()

boost::optional< double > openstudio::SqlFile::waterHeating ( ) const

Returns the water used for heating in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterHeatRecovery()

boost::optional< double > openstudio::SqlFile::waterHeatRecovery ( ) const

Returns the water used for heat recovery in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterHeatRejection()

boost::optional< double > openstudio::SqlFile::waterHeatRejection ( ) const

Returns the water used for heat rejection in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterHumidification()

boost::optional< double > openstudio::SqlFile::waterHumidification ( ) const

Returns the water used for humidification in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterInteriorEquipment()

boost::optional< double > openstudio::SqlFile::waterInteriorEquipment ( ) const

Returns the water used for interior equipment in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterInteriorLighting()

boost::optional< double > openstudio::SqlFile::waterInteriorLighting ( ) const

Returns the water used for interior lighting in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterPumps()

boost::optional< double > openstudio::SqlFile::waterPumps ( ) const

Returns the water used for pumps in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterRefrigeration()

boost::optional< double > openstudio::SqlFile::waterRefrigeration ( ) const

Returns the water used for refrigeration in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterTotalEndUses()

boost::optional< double > openstudio::SqlFile::waterTotalEndUses ( ) const

Returns the water used for all uses in cubic meters.

Requires EnergyPlus simulation output to calculate.

◆ waterWaterSystems()

boost::optional< double > openstudio::SqlFile::waterWaterSystems ( ) const

Returns the water used for water systems in cubic meters.

Requires EnergyPlus simulation output to calculate.