 |
OpenStudio:utilities |
|
OpenStudio:utilities |
#include <SqlFile.hpp>
Public Member Functions | |
Constructors | |
| SqlFile () | |
| default constructor More... | |
| 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 More... | |
| 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 More... | |
| virtual | ~SqlFile ()=default |
| void | removeIndexes () |
| void | createIndexes () |
File Queries and Operations | |
| bool | connectionOpen () const |
| returns whether or not connection is open More... | |
| openstudio::path | path () const |
| get the path More... | |
| 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 More... | |
| bool | reopen () |
| re-open the file More... | |
| std::string | energyPlusSqliteFile () const |
| Energy Plus eplusout.sql file name. More... | |
Standard Queries | |
| boost::optional< double > | hoursSimulated () const |
| hours simulated More... | |
| boost::optional< double > | netSiteEnergy () const |
| net site energy in GJ More... | |
| boost::optional< double > | netSourceEnergy () const |
| net source energy in GJ More... | |
| boost::optional< double > | totalSiteEnergy () const |
| total site energy in GJ More... | |
| boost::optional< double > | totalSourceEnergy () const |
| total source energy in GJ More... | |
| boost::optional< double > | annualTotalCost (const FuelType &fuel) const |
| Returns the annual total cost associated with the given fuel type in dollars. More... | |
| 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. More... | |
| 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. More... | |
| boost::optional< double > | annualTotalUtilityCost () const |
| Returns the annual total cost for all fuel types in dollars. Requires EnergyPlus simulation output to calculate. More... | |
| boost::optional< double > | economicsEnergyCost () const |
| Returns the total energy cost over the analysis period in dollars according to the discounting convention. More... | |
| OptionalDouble | getElecOrGasUse (bool t_getGas=true) const |
| OptionalDouble | getElecOrGasCost (bool t_getGas=true) const |
| boost::optional< EndUses > | endUses () const |
| Returns an EndUses object containing all end uses for the simulation. More... | |
| 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. More... | |
| 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. More... | |
| boost::optional< double > | electricityHeating () const |
| Returns the electric energy used for heating in gigajoules. More... | |
| boost::optional< double > | electricityCooling () const |
| Returns the electric energy used for cooling in gigajoules. More... | |
| boost::optional< double > | electricityInteriorLighting () const |
| Returns the electric energy used for interior lighting in gigajoules. More... | |
| boost::optional< double > | electricityExteriorLighting () const |
| Returns the electric energy used for exterior lighting in gigajoules. More... | |
| boost::optional< double > | electricityInteriorEquipment () const |
| Returns the electric energy used for interior equipment in gigajoules. More... | |
| boost::optional< double > | electricityExteriorEquipment () const |
| Returns the electric energy used for exterior equipment in gigajoules. More... | |
| boost::optional< double > | electricityFans () const |
| Returns the electric energy used for fans in gigajoules. More... | |
| boost::optional< double > | electricityPumps () const |
| Returns the electric energy used for pumps in gigajoules. More... | |
| boost::optional< double > | electricityHeatRejection () const |
| Returns the electric energy used for heat rejection in gigajoules. More... | |
| boost::optional< double > | electricityHumidification () const |
| Returns the electric energy used for humidification in gigajoules. More... | |
| boost::optional< double > | electricityHeatRecovery () const |
| Returns the electric energy used for heat recovery in gigajoules. More... | |
| boost::optional< double > | electricityWaterSystems () const |
| Returns the electric energy used for water systems in gigajoules. More... | |
| boost::optional< double > | electricityRefrigeration () const |
| Returns the electric energy used for refrigeration in gigajoules. More... | |
| boost::optional< double > | electricityGenerators () const |
| Returns the electric energy used for generators in gigajoules. More... | |
| boost::optional< double > | electricityTotalEndUses () const |
| Returns the electric energy used for all uses in gigajoules. More... | |
| boost::optional< double > | naturalGasHeating () const |
| Returns the natural gas energy used for heating in gigajoules. More... | |
| boost::optional< double > | naturalGasCooling () const |
| Returns the natural gas energy used for cooling in gigajoules. More... | |
| boost::optional< double > | naturalGasInteriorLighting () const |
| Returns the natural gas energy used for interior lighting in gigajoules. More... | |
| boost::optional< double > | naturalGasExteriorLighting () const |
| Returns the natural gas energy used for exterior lighting in gigajoules. More... | |
| boost::optional< double > | naturalGasInteriorEquipment () const |
| Returns the natural gas energy used for interior equipment in gigajoules. More... | |
| boost::optional< double > | naturalGasExteriorEquipment () const |
| Returns the natural gas energy used for exterior equipment in gigajoules. More... | |
| boost::optional< double > | naturalGasFans () const |
| Returns the natural gas energy used for fans in gigajoules. More... | |
| boost::optional< double > | naturalGasPumps () const |
| Returns the natural gas energy used for pumps in gigajoules. More... | |
| boost::optional< double > | naturalGasHeatRejection () const |
| Returns the natural gas energy used for heat rejection in gigajoules. More... | |
| boost::optional< double > | naturalGasHumidification () const |
| Returns the natural gas energy used for humidification in gigajoules. More... | |
| boost::optional< double > | naturalGasHeatRecovery () const |
| Returns the natural gas energy used for heat recovery in gigajoules. More... | |
| boost::optional< double > | naturalGasWaterSystems () const |
| Returns the natural gas energy used for water systems in gigajoules. More... | |
| boost::optional< double > | naturalGasRefrigeration () const |
| Returns the natural gas energy used for refrigeration in gigajoules. More... | |
| boost::optional< double > | naturalGasGenerators () const |
| Returns the natural gas energy used for generators in gigajoules. More... | |
| boost::optional< double > | naturalGasTotalEndUses () const |
| Returns the natural gas energy used for all end uses in gigajoules. More... | |
| boost::optional< double > | gasolineHeating () const |
| Gasoline Returns the energy used for heating from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineCooling () const |
| Returns the energy used for cooling from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineInteriorLighting () const |
| Returns the energy used for interior lighting from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineExteriorLighting () const |
| Returns the energy used for exterior lighting from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineInteriorEquipment () const |
| Returns the energy used for interior equipment from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineExteriorEquipment () const |
| Returns the energy used for exterior equipment from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineFans () const |
| Returns the energy used for fans from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolinePumps () const |
| Returns the energy used for pumps from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineHeatRejection () const |
| Returns the energy used for heat rejection from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineHumidification () const |
| Returns the energy used for humidification from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineHeatRecovery () const |
| Returns the energy used for heat recovery from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineWaterSystems () const |
| Returns the energy used for water systems from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineRefrigeration () const |
| Returns the energy used for refrigeration from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineGenerators () const |
| Returns the energy used for generators from gasoline in gigajoules. More... | |
| boost::optional< double > | gasolineTotalEndUses () const |
| Returns the energy used for all end uses from gasoline in gigajoules. More... | |
| boost::optional< double > | dieselHeating () const |
| Diesel Returns the energy used for heating from diesel in gigajoules. More... | |
| boost::optional< double > | dieselCooling () const |
| Returns the energy used for cooling from diesel in gigajoules. More... | |
| boost::optional< double > | dieselInteriorLighting () const |
| Returns the energy used for interior lighting from diesel in gigajoules. More... | |
| boost::optional< double > | dieselExteriorLighting () const |
| Returns the energy used for exterior lighting from diesel in gigajoules. More... | |
| boost::optional< double > | dieselInteriorEquipment () const |
| Returns the energy used for interior equipment from diesel in gigajoules. More... | |
| boost::optional< double > | dieselExteriorEquipment () const |
| Returns the energy used for exterior equipment from diesel in gigajoules. More... | |
| boost::optional< double > | dieselFans () const |
| Returns the energy used for fans from diesel in gigajoules. More... | |
| boost::optional< double > | dieselPumps () const |
| Returns the energy used for pumps from diesel in gigajoules. More... | |
| boost::optional< double > | dieselHeatRejection () const |
| Returns the energy used for heat rejection from diesel in gigajoules. More... | |
| boost::optional< double > | dieselHumidification () const |
| Returns the energy used for humidification from diesel in gigajoules. More... | |
| boost::optional< double > | dieselHeatRecovery () const |
| Returns the energy used for heat recovery from diesel in gigajoules. More... | |
| boost::optional< double > | dieselWaterSystems () const |
| Returns the energy used for water systems from diesel in gigajoules. More... | |
| boost::optional< double > | dieselRefrigeration () const |
| Returns the energy used for refrigeration from diesel in gigajoules. More... | |
| boost::optional< double > | dieselGenerators () const |
| Returns the energy used for generators from diesel in gigajoules. More... | |
| boost::optional< double > | dieselTotalEndUses () const |
| Returns the energy used for all end uses from diesel in gigajoules. More... | |
| boost::optional< double > | coalHeating () const |
| Coal Returns the energy used for heating from coal in gigajoules. More... | |
| boost::optional< double > | coalCooling () const |
| Returns the energy used for cooling from coal in gigajoules. More... | |
| boost::optional< double > | coalInteriorLighting () const |
| Returns the energy used for interior lighting from coal in gigajoules. More... | |
| boost::optional< double > | coalExteriorLighting () const |
| Returns the energy used for exterior lighting from coal in gigajoules. More... | |
| boost::optional< double > | coalInteriorEquipment () const |
| Returns the energy used for interior equipment from coal in gigajoules. More... | |
| boost::optional< double > | coalExteriorEquipment () const |
| Returns the energy used for exterior equipment from coal in gigajoules. More... | |
| boost::optional< double > | coalFans () const |
| Returns the energy used for fans from coal in gigajoules. More... | |
| boost::optional< double > | coalPumps () const |
| Returns the energy used for pumps from coal in gigajoules. More... | |
| boost::optional< double > | coalHeatRejection () const |
| Returns the energy used for heat rejection from coal in gigajoules. More... | |
| boost::optional< double > | coalHumidification () const |
| Returns the energy used for humidification from coal in gigajoules. More... | |
| boost::optional< double > | coalHeatRecovery () const |
| Returns the energy used for heat recovery from coal in gigajoules. More... | |
| boost::optional< double > | coalWaterSystems () const |
| Returns the energy used for water systems from coal in gigajoules. More... | |
| boost::optional< double > | coalRefrigeration () const |
| Returns the energy used for refrigeration from coal in gigajoules. More... | |
| boost::optional< double > | coalGenerators () const |
| Returns the energy used for generators from coal in gigajoules. More... | |
| boost::optional< double > | coalTotalEndUses () const |
| Returns the energy used for all end uses from coal in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Heating () const |
| Fuel Oil No 1 Returns the energy used for heating from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Cooling () const |
| Returns the energy used for cooling from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1InteriorLighting () const |
| Returns the energy used for interior lighting from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1ExteriorLighting () const |
| Returns the energy used for exterior lighting from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1InteriorEquipment () const |
| Returns the energy used for interior equipment from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1ExteriorEquipment () const |
| Returns the energy used for exterior equipment from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Fans () const |
| Returns the energy used for fans from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Pumps () const |
| Returns the energy used for pumps from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1HeatRejection () const |
| Returns the energy used for heat rejection from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Humidification () const |
| Returns the energy used for humidification from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1HeatRecovery () const |
| Returns the energy used for heat recovery from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1WaterSystems () const |
| Returns the energy used for water systems from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Refrigeration () const |
| Returns the energy used for refrigeration from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1Generators () const |
| Returns the energy used for generators from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo1TotalEndUses () const |
| Returns the energy used for all end uses from fuelOilNo1 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Heating () const |
| Fuel Oil No 2 Returns the energy used for heating from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Cooling () const |
| Returns the energy used for cooling from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2InteriorLighting () const |
| Returns the energy used for interior lighting from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2ExteriorLighting () const |
| Returns the energy used for exterior lighting from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2InteriorEquipment () const |
| Returns the energy used for interior equipment from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2ExteriorEquipment () const |
| Returns the energy used for exterior equipment from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Fans () const |
| Returns the energy used for fans from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Pumps () const |
| Returns the energy used for pumps from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2HeatRejection () const |
| Returns the energy used for heat rejection from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Humidification () const |
| Returns the energy used for humidification from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2HeatRecovery () const |
| Returns the energy used for heat recovery from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2WaterSystems () const |
| Returns the energy used for water systems from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Refrigeration () const |
| Returns the energy used for refrigeration from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2Generators () const |
| Returns the energy used for generators from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | fuelOilNo2TotalEndUses () const |
| Returns the energy used for all end uses from fuelOilNo2 in gigajoules. More... | |
| boost::optional< double > | propaneHeating () const |
| Propane Returns the energy used for heating from propane in gigajoules. More... | |
| boost::optional< double > | propaneCooling () const |
| Returns the energy used for cooling from propane in gigajoules. More... | |
| boost::optional< double > | propaneInteriorLighting () const |
| Returns the energy used for interior lighting from propane in gigajoules. More... | |
| boost::optional< double > | propaneExteriorLighting () const |
| Returns the energy used for exterior lighting from propane in gigajoules. More... | |
| boost::optional< double > | propaneInteriorEquipment () const |
| Returns the energy used for interior equipment from propane in gigajoules. More... | |
| boost::optional< double > | propaneExteriorEquipment () const |
| Returns the energy used for exterior equipment from propane in gigajoules. More... | |
| boost::optional< double > | propaneFans () const |
| Returns the energy used for fans from propane in gigajoules. More... | |
| boost::optional< double > | propanePumps () const |
| Returns the energy used for pumps from propane in gigajoules. More... | |
| boost::optional< double > | propaneHeatRejection () const |
| Returns the energy used for heat rejection from propane in gigajoules. More... | |
| boost::optional< double > | propaneHumidification () const |
| Returns the energy used for humidification from propane in gigajoules. More... | |
| boost::optional< double > | propaneHeatRecovery () const |
| Returns the energy used for heat recovery from propane in gigajoules. More... | |
| boost::optional< double > | propaneWaterSystems () const |
| Returns the energy used for water systems from propane in gigajoules. More... | |
| boost::optional< double > | propaneRefrigeration () const |
| Returns the energy used for refrigeration from propane in gigajoules. More... | |
| boost::optional< double > | propaneGenerators () const |
| Returns the energy used for generators from propane in gigajoules. More... | |
| boost::optional< double > | propaneTotalEndUses () const |
| Returns the energy used for all end uses from propane in gigajoules. More... | |
| boost::optional< double > | otherFuel1Heating () const |
| Other Fuel 1 Returns the energy used for heating from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1Cooling () const |
| Returns the energy used for cooling from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1InteriorLighting () const |
| Returns the energy used for interior lighting from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1ExteriorLighting () const |
| Returns the energy used for exterior lighting from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1InteriorEquipment () const |
| Returns the energy used for interior equipment from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1ExteriorEquipment () const |
| Returns the energy used for exterior equipment from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1Fans () const |
| Returns the energy used for fans from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1Pumps () const |
| Returns the energy used for pumps from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1HeatRejection () const |
| Returns the energy used for heat rejection from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1Humidification () const |
| Returns the energy used for humidification from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1HeatRecovery () const |
| Returns the energy used for heat recovery from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1WaterSystems () const |
| Returns the energy used for water systems from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1Refrigeration () const |
| Returns the energy used for refrigeration from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1Generators () const |
| Returns the energy used for generators from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel1TotalEndUses () const |
| Returns the energy used for all end uses from otherFuel1 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Heating () const |
| Other Fuel 2 Returns the energy used for heating from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Cooling () const |
| Returns the energy used for cooling from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2InteriorLighting () const |
| Returns the energy used for interior lighting from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2ExteriorLighting () const |
| Returns the energy used for exterior lighting from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2InteriorEquipment () const |
| Returns the energy used for interior equipment from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2ExteriorEquipment () const |
| Returns the energy used for exterior equipment from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Fans () const |
| Returns the energy used for fans from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Pumps () const |
| Returns the energy used for pumps from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2HeatRejection () const |
| Returns the energy used for heat rejection from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Humidification () const |
| Returns the energy used for humidification from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2HeatRecovery () const |
| Returns the energy used for heat recovery from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2WaterSystems () const |
| Returns the energy used for water systems from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Refrigeration () const |
| Returns the energy used for refrigeration from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2Generators () const |
| Returns the energy used for generators from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | otherFuel2TotalEndUses () const |
| Returns the energy used for all end uses from otherFuel2 in gigajoules. More... | |
| boost::optional< double > | districtCoolingHeating () const |
| Returns the district cooling energy used for heating in gigajoules. More... | |
| boost::optional< double > | districtCoolingCooling () const |
| Returns the district cooling energy used for cooling in gigajoules. More... | |
| boost::optional< double > | districtCoolingInteriorLighting () const |
| Returns the district cooling energy used for interior lighting in gigajoules. More... | |
| boost::optional< double > | districtCoolingExteriorLighting () const |
| Returns the district cooling energy used for exterior lighting in gigajoules. More... | |
| boost::optional< double > | districtCoolingInteriorEquipment () const |
| Returns the district cooling energy used for interior equipment in gigajoules. More... | |
| boost::optional< double > | districtCoolingExteriorEquipment () const |
| Returns the district cooling energy used for exterior equipment in gigajoules. More... | |
| boost::optional< double > | districtCoolingFans () const |
| Returns the district cooling energy used for fans in gigajoules. More... | |
| boost::optional< double > | districtCoolingPumps () const |
| Returns the district cooling energy used for pumps in gigajoules. More... | |
| boost::optional< double > | districtCoolingHeatRejection () const |
| Returns the district cooling energy used for heat rejection in gigajoules. More... | |
| boost::optional< double > | districtCoolingHumidification () const |
| Returns the district cooling energy used for humidification in gigajoules. More... | |
| boost::optional< double > | districtCoolingHeatRecovery () const |
| Returns the district cooling energy used for heat recovery in gigajoules. More... | |
| boost::optional< double > | districtCoolingWaterSystems () const |
| Returns the district cooling energy used for water systems in gigajoules. More... | |
| boost::optional< double > | districtCoolingRefrigeration () const |
| Returns the district cooling energy used for refrigeration in gigajoules. More... | |
| boost::optional< double > | districtCoolingGenerators () const |
| Returns the district cooling energy used for generators in gigajoules. More... | |
| boost::optional< double > | districtCoolingTotalEndUses () const |
| Returns the district cooling energy used for all end uses in gigajoules. More... | |
| boost::optional< double > | districtHeatingHeating () const |
| Returns the district heating energy used for heating in gigajoules. More... | |
| boost::optional< double > | districtHeatingCooling () const |
| Returns the district heating energy used for cooling in gigajoules. More... | |
| boost::optional< double > | districtHeatingInteriorLighting () const |
| Returns the district heating energy used for interior lighting in gigajoules. More... | |
| boost::optional< double > | districtHeatingExteriorLighting () const |
| Returns the district heating energy used for exterior lighting in gigajoules. More... | |
| boost::optional< double > | districtHeatingInteriorEquipment () const |
| Returns the district heating energy used for interior equipment in gigajoules. More... | |
| boost::optional< double > | districtHeatingExteriorEquipment () const |
| Returns the district heating energy used for exterior equipment in gigajoules. More... | |
| boost::optional< double > | districtHeatingFans () const |
| Returns the district heating energy used for fans in gigajoules. More... | |
| boost::optional< double > | districtHeatingPumps () const |
| Returns the district heating energy used for pumps in gigajoules. More... | |
| boost::optional< double > | districtHeatingHeatRejection () const |
| Returns the district heating energy used for heat rejection in gigajoules. More... | |
| boost::optional< double > | districtHeatingHumidification () const |
| Returns the district heating energy used for humidification in gigajoules. More... | |
| boost::optional< double > | districtHeatingHeatRecovery () const |
| Returns the district heating energy used for heat recovery in gigajoules. More... | |
| boost::optional< double > | districtHeatingWaterSystems () const |
| Returns the district heating energy used for water systems in gigajoules. More... | |
| boost::optional< double > | districtHeatingRefrigeration () const |
| Returns the district heating energy used for refrigeration in gigajoules. More... | |
| boost::optional< double > | districtHeatingGenerators () const |
| Returns the district heating energy used for generators in gigajoules. More... | |
| boost::optional< double > | districtHeatingTotalEndUses () const |
| Returns the district heating energy used for all end uses in gigajoules. More... | |
| boost::optional< double > | waterHeating () const |
| Returns the water used for heating in cubic meters. More... | |
| boost::optional< double > | waterCooling () const |
| Returns the water used for cooling in cubic meters. More... | |
| boost::optional< double > | waterInteriorLighting () const |
| Returns the water used for interior lighting in cubic meters. More... | |
| boost::optional< double > | waterExteriorLighting () const |
| Returns the water used for exterior lighting in cubic meters. More... | |
| boost::optional< double > | waterInteriorEquipment () const |
| Returns the water used for interior equipment in cubic meters. More... | |
| boost::optional< double > | waterExteriorEquipment () const |
| Returns the water used for exterior equipment in cubic meters. More... | |
| boost::optional< double > | waterFans () const |
| Returns the water used for fans in cubic meters. More... | |
| boost::optional< double > | waterPumps () const |
| Returns the water used for pumps in cubic meters. More... | |
| boost::optional< double > | waterHeatRejection () const |
| Returns the water used for heat rejection in cubic meters. More... | |
| boost::optional< double > | waterHumidification () const |
| Returns the water used for humidification in cubic meters. More... | |
| boost::optional< double > | waterHeatRecovery () const |
| Returns the water used for heat recovery in cubic meters. More... | |
| boost::optional< double > | waterWaterSystems () const |
| Returns the water used for water systems in cubic meters. More... | |
| boost::optional< double > | waterRefrigeration () const |
| Returns the water used for refrigeration in cubic meters. More... | |
| boost::optional< double > | waterGenerators () const |
| Returns the water used for generators in cubic meters. More... | |
| boost::optional< double > | waterTotalEndUses () const |
| Returns the water used for all uses in cubic meters. More... | |
| boost::optional< double > | hoursHeatingSetpointNotMet () const |
| Returns the total number of hours the heating setpoint is not met. More... | |
| boost::optional< double > | hoursCoolingSetpointNotMet () const |
| Returns the total number of hours the cooling setpoint is not met. More... | |
| boost::optional< std::pair < DateTime, DateTime > > | daylightSavingsPeriod () const |
| std::string | energyPlusVersion () const |
| Energy plus version number. More... | |
Generic TimeSeries Interface | |
| std::vector< std::string > | availableTimeSeries () |
| boost::optional < openstudio::EnvironmentType > | environmentType (const std::string &envPeriod) const |
| std::vector< std::string > | availableEnvPeriods () const |
| std::vector< std::string > | availableReportingFrequencies (const std::string &envPeriod) |
| boost::optional < openstudio::ReportingFrequency > | reportingFrequencyFromDB (const std::string &dbReportingFrequency) |
| std::vector< std::string > | availableVariableNames (const std::string &envPeriod, const std::string &reportingFrequency) const |
| std::vector< TimeSeries > | timeSeries (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< TimeSeries > | timeSeries (const std::string &envPeriod, const std::string &reportingFrequency, const std::string &timeSeriesName, const std::string &keyValue) |
| std::vector < SqlFileTimeSeriesQuery > | expandQuery (const SqlFileTimeSeriesQuery &query) |
| Expands query to create a vector of all matching queries. More... | |
| std::vector< TimeSeries > | timeSeries (const SqlFileTimeSeriesQuery &query) |
| Executes query. More... | |
Illuminance Map Interface | |
| std::vector< std::string > | illuminanceMapNames () const |
| get names of all available illuminance maps More... | |
| 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 More... | |
| 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) More... | |
| boost::optional< std::string > | illuminanceMapRefPt (int mapIndex, int ptNum) const |
| boost::optional< double > | illuminanceMapMinValue (const std::string &name) const |
| minimum value of map More... | |
| boost::optional< double > | illuminanceMapMinValue (int mapIndex) const |
| boost::optional< double > | illuminanceMapMaxValue (const std::string &name) const |
| maximum value of map More... | |
| boost::optional< double > | illuminanceMapMaxValue (int mapIndex) const |
| void | illuminanceMapMaxValue (const std::string &name, double &minValue, double &maxValue) const |
| minimum and maximum of map More... | |
| void | illuminanceMapMaxValue (int mapIndex, double &minValue, double &maxValue) const |
| boost::optional< int > | illuminanceMapIndex (const std::string &name) const |
| Vector | illuminanceMapX (const std::string &name, const DateTime &dateTime) const |
| x position (m) of the illuminance map More... | |
| Vector | illuminanceMapY (const std::string &name, const DateTime &dateTime) const |
| y position (m) of the illuminance map More... | |
| Vector | illuminanceMapX (int hourlyReportIndex) const |
| x position (m) of the illuminance map More... | |
| Vector | illuminanceMapY (int hourlyReportIndex) const |
| y position (m) of the illuminance map More... | |
| boost::optional< int > | illuminanceMapHourlyReportIndex (int mapIndex, const DateTime &dateTime) const |
| hourly report index for mapIndex at date and time More... | |
| boost::optional< DateTime > | illuminanceMapDate (int hourlyReportIndex) const |
| date time at hourly report index More... | |
| std::vector< int > | illuminanceMapHourlyReportIndices (const std::string &name) const |
| hourly report indices of the illuminance map More... | |
| std::vector< std::pair< int, DateTime > > | illuminanceMapHourlyReportIndicesDates (int mapIndex) const |
| hourly report indices of the illuminance map More... | |
| std::vector< std::pair< int, DateTime > > | illuminanceMapHourlyReportIndicesDates (const std::string &name) const |
| hourly report indices of the illuminance map More... | |
| std::vector< int > | illuminanceMapHourlyReportIndices (int mapIndex) const |
| hourly report indices of the illuminance map More... | |
| 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) More... | |
| Matrix | illuminanceMap (int hourlyReportIndex) const |
| value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j) More... | |
| 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 More... | |
| std::vector< SummaryData > | getSummaryData () const |
| Returns the summary data for each installlocation and fuel type found in report variables. More... | |
| 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 More... | |
| boost::optional< double > | execAndReturnFirstDouble (const std::string &statement) const |
| template<typename... Args> | |
| boost::optional< int > | execAndReturnFirstInt (const std::string &statement, Args &&...args) const |
| execute a statement and return the first (if any) value as a int More... | |
| boost::optional< int > | execAndReturnFirstInt (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 More... | |
| 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 More... | |
| 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 More... | |
| 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 More... | |
| 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 More... | |
| 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 |
SqlFile class is a transaction script around the sql output of EnergyPlus.
| openstudio::SqlFile::SqlFile | ( | ) |
default constructor
|
explicit |
constructor from path Creates indexes by default, pass in false for no new indexes and quicker opening
| 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
|
virtualdefault |
| 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.
| 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.
| 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.
| boost::optional<double> openstudio::SqlFile::annualTotalUtilityCost | ( | ) | const |
Returns the annual total cost for all fuel types in dollars. Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::assemblySHGC | ( | const std::string & | subSurfaceName | ) | const |
| boost::optional<double> openstudio::SqlFile::assemblyUFactor | ( | const std::string & | subSurfaceName | ) | const |
| boost::optional<double> openstudio::SqlFile::assemblyVisibleTransmittance | ( | const std::string & | subSurfaceName | ) | const |
| std::vector<std::string> openstudio::SqlFile::availableEnvPeriods | ( | ) | const |
| std::vector<std::string> openstudio::SqlFile::availableKeyValues | ( | const std::string & | envPeriod, |
| const std::string & | reportingFrequency, | ||
| const std::string & | timeSeriesName | ||
| ) |
| std::vector<std::string> openstudio::SqlFile::availableReportingFrequencies | ( | const std::string & | envPeriod | ) |
| std::vector<std::string> openstudio::SqlFile::availableTimeSeries | ( | ) |
| std::vector<std::string> openstudio::SqlFile::availableVariableNames | ( | const std::string & | envPeriod, |
| const std::string & | reportingFrequency | ||
| ) | const |
| bool openstudio::SqlFile::close | ( | ) |
close the file
| boost::optional<double> openstudio::SqlFile::coalCooling | ( | ) | const |
Returns the energy used for cooling from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalFans | ( | ) | const |
Returns the energy used for fans from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalGenerators | ( | ) | const |
Returns the energy used for generators from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalHeating | ( | ) | const |
Coal Returns the energy used for heating from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalHeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalHeatRejection | ( | ) | const |
Returns the energy used for heat rejection from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalHumidification | ( | ) | const |
Returns the energy used for humidification from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalInteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalInteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalPumps | ( | ) | const |
Returns the energy used for pumps from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::coalRefrigeration | ( | ) | const |
Returns the energy used for refrigeration from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::coalWaterSystems | ( | ) | const |
Returns the energy used for water systems from coal in gigajoules.
Requires EnergyPlus simulation output to calculate.
| bool openstudio::SqlFile::connectionOpen | ( | ) | const |
returns whether or not connection is open
| void openstudio::SqlFile::createIndexes | ( | ) |
| boost::optional<std::pair<DateTime, DateTime> > openstudio::SqlFile::daylightSavingsPeriod | ( | ) | const |
| boost::optional<double> openstudio::SqlFile::dieselCooling | ( | ) | const |
Returns the energy used for cooling from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselFans | ( | ) | const |
Returns the energy used for fans from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselGenerators | ( | ) | const |
Returns the energy used for generators from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselHeating | ( | ) | const |
Diesel Returns the energy used for heating from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselHeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselHeatRejection | ( | ) | const |
Returns the energy used for heat rejection from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselHumidification | ( | ) | const |
Returns the energy used for humidification from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselInteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselInteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselPumps | ( | ) | const |
Returns the energy used for pumps from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::dieselRefrigeration | ( | ) | const |
Returns the energy used for refrigeration from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::dieselWaterSystems | ( | ) | const |
Returns the energy used for water systems from diesel in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingCooling | ( | ) | const |
Returns the district cooling energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingExteriorEquipment | ( | ) | const |
Returns the district cooling energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingExteriorLighting | ( | ) | const |
Returns the district cooling energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingFans | ( | ) | const |
Returns the district cooling energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingGenerators | ( | ) | const |
Returns the district cooling energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingHeating | ( | ) | const |
Returns the district cooling energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingHeatRecovery | ( | ) | const |
Returns the district cooling energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingHeatRejection | ( | ) | const |
Returns the district cooling energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingHumidification | ( | ) | const |
Returns the district cooling energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingInteriorEquipment | ( | ) | const |
Returns the district cooling energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingInteriorLighting | ( | ) | const |
Returns the district cooling energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingPumps | ( | ) | const |
Returns the district cooling energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtCoolingRefrigeration | ( | ) | const |
Returns the district cooling energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::districtCoolingWaterSystems | ( | ) | const |
Returns the district cooling energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingCooling | ( | ) | const |
Returns the district heating energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingExteriorEquipment | ( | ) | const |
Returns the district heating energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingExteriorLighting | ( | ) | const |
Returns the district heating energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingFans | ( | ) | const |
Returns the district heating energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingGenerators | ( | ) | const |
Returns the district heating energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingHeating | ( | ) | const |
Returns the district heating energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingHeatRecovery | ( | ) | const |
Returns the district heating energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingHeatRejection | ( | ) | const |
Returns the district heating energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingHumidification | ( | ) | const |
Returns the district heating energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingInteriorEquipment | ( | ) | const |
Returns the district heating energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingInteriorLighting | ( | ) | const |
Returns the district heating energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingPumps | ( | ) | const |
Returns the district heating energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::districtHeatingRefrigeration | ( | ) | const |
Returns the district heating energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::districtHeatingWaterSystems | ( | ) | const |
Returns the district heating energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::electricityCooling | ( | ) | const |
Returns the electric energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityExteriorEquipment | ( | ) | const |
Returns the electric energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityExteriorLighting | ( | ) | const |
Returns the electric energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityFans | ( | ) | const |
Returns the electric energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityGenerators | ( | ) | const |
Returns the electric energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityHeating | ( | ) | const |
Returns the electric energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityHeatRecovery | ( | ) | const |
Returns the electric energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityHeatRejection | ( | ) | const |
Returns the electric energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityHumidification | ( | ) | const |
Returns the electric energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityInteriorEquipment | ( | ) | const |
Returns the electric energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityInteriorLighting | ( | ) | const |
Returns the electric energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityPumps | ( | ) | const |
Returns the electric energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityRefrigeration | ( | ) | const |
Returns the electric energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityTotalEndUses | ( | ) | const |
Returns the electric energy used for all uses in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::electricityWaterSystems | ( | ) | const |
Returns the electric energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<EndUses> openstudio::SqlFile::endUses | ( | ) | const |
Returns an EndUses object containing all end uses for the simulation.
| 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.
| std::string openstudio::SqlFile::energyPlusSqliteFile | ( | ) | const |
Energy Plus eplusout.sql file name.
| std::string openstudio::SqlFile::energyPlusVersion | ( | ) | const |
Energy plus version number.
| boost::optional<openstudio::EnvironmentType> openstudio::SqlFile::environmentType | ( | const std::string & | envPeriod | ) | const |
|
inline |
execute a statement and return the first (if any) value as a double
|
inline |
|
inline |
execute a statement and return the first (if any) value as a int
|
inline |
|
inline |
execute a statement and return the first (if any) value as a string
|
inline |
|
inline |
execute a statement and return the results (if any) in a vector of double
|
inline |
|
inline |
execute a statement and return the results (if any) in a vector of int
|
inline |
|
inline |
execute a statement and return the results (if any) in a vector of string
|
inline |
|
inline |
execute a statement and return the error code, used for create/drop tables
|
inline |
| 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".
| boost::optional<double> openstudio::SqlFile::fuelOilNo1Cooling | ( | ) | const |
Returns the energy used for cooling from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1ExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1ExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1Fans | ( | ) | const |
Returns the energy used for fans from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1Generators | ( | ) | const |
Returns the energy used for generators from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1HeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1HeatRejection | ( | ) | const |
Returns the energy used for heat rejection from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1Humidification | ( | ) | const |
Returns the energy used for humidification from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1InteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1InteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1Pumps | ( | ) | const |
Returns the energy used for pumps from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1Refrigeration | ( | ) | const |
Returns the energy used for refrigeration from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::fuelOilNo1WaterSystems | ( | ) | const |
Returns the energy used for water systems from fuelOilNo1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2Cooling | ( | ) | const |
Returns the energy used for cooling from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2ExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2ExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2Fans | ( | ) | const |
Returns the energy used for fans from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2Generators | ( | ) | const |
Returns the energy used for generators from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2HeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2HeatRejection | ( | ) | const |
Returns the energy used for heat rejection from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2Humidification | ( | ) | const |
Returns the energy used for humidification from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2InteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2InteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2Pumps | ( | ) | const |
Returns the energy used for pumps from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2Refrigeration | ( | ) | const |
Returns the energy used for refrigeration from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::fuelOilNo2WaterSystems | ( | ) | const |
Returns the energy used for water systems from fuelOilNo2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineCooling | ( | ) | const |
Returns the energy used for cooling from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineFans | ( | ) | const |
Returns the energy used for fans from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineGenerators | ( | ) | const |
Returns the energy used for generators from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineHeating | ( | ) | const |
Gasoline Returns the energy used for heating from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineHeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineHeatRejection | ( | ) | const |
Returns the energy used for heat rejection from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineHumidification | ( | ) | const |
Returns the energy used for humidification from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineInteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineInteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolinePumps | ( | ) | const |
Returns the energy used for pumps from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::gasolineRefrigeration | ( | ) | const |
Returns the energy used for refrigeration from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::gasolineWaterSystems | ( | ) | const |
Returns the energy used for water systems from gasoline in gigajoules.
Requires EnergyPlus simulation output to calculate.
| OptionalDouble openstudio::SqlFile::getElecOrGasCost | ( | bool | t_getGas = true | ) | const |
| OptionalDouble openstudio::SqlFile::getElecOrGasUse | ( | bool | t_getGas = true | ) | const |
| boost::optional<double> openstudio::SqlFile::getExteriorFenestrationValue | ( | const std::string & | subSurfaceName, |
| const std::string & | columnName | ||
| ) | const |
| std::vector<SummaryData> openstudio::SqlFile::getSummaryData | ( | ) | const |
Returns the summary data for each installlocation and fuel type found in report variables.
| bool openstudio::SqlFile::hasIlluminanceMapYear | ( | ) | const |
| bool openstudio::SqlFile::hasYear | ( | ) | const |
| 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.
| 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.
| boost::optional<double> openstudio::SqlFile::hoursSimulated | ( | ) | const |
hours simulated
| 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)
value (lux) of the illuminance map at hourlyReportIndex value(i,j) is the illuminance at x(i), y(j)
| 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
date time at hourly report index
| boost::optional<int> openstudio::SqlFile::illuminanceMapHourlyReportIndex | ( | int | mapIndex, |
| const DateTime & | dateTime | ||
| ) | const |
hourly report index for mapIndex at date and time
| std::vector<int> openstudio::SqlFile::illuminanceMapHourlyReportIndices | ( | const std::string & | name | ) | const |
hourly report indices of the illuminance map
hourly report indices of the illuminance map
| std::vector<std::pair<int, DateTime> > openstudio::SqlFile::illuminanceMapHourlyReportIndicesDates | ( | int | mapIndex | ) | const |
hourly report indices of the illuminance map
| std::vector<std::pair<int, DateTime> > openstudio::SqlFile::illuminanceMapHourlyReportIndicesDates | ( | const std::string & | name | ) | const |
hourly report indices of the illuminance map
| boost::optional<int> openstudio::SqlFile::illuminanceMapIndex | ( | const std::string & | name | ) | const |
| boost::optional<double> openstudio::SqlFile::illuminanceMapMaxValue | ( | const std::string & | name | ) | const |
maximum value of map
| boost::optional<double> openstudio::SqlFile::illuminanceMapMaxValue | ( | int | mapIndex | ) | const |
| void openstudio::SqlFile::illuminanceMapMaxValue | ( | const std::string & | name, |
| double & | minValue, | ||
| double & | maxValue | ||
| ) | const |
minimum and maximum of map
| void openstudio::SqlFile::illuminanceMapMaxValue | ( | int | mapIndex, |
| double & | minValue, | ||
| double & | maxValue | ||
| ) | const |
| boost::optional<double> openstudio::SqlFile::illuminanceMapMinValue | ( | const std::string & | name | ) | const |
minimum value of map
| boost::optional<double> openstudio::SqlFile::illuminanceMapMinValue | ( | int | mapIndex | ) | const |
| std::vector<std::string> openstudio::SqlFile::illuminanceMapNames | ( | ) | const |
get names of all available illuminance maps
| std::vector<std::string> openstudio::SqlFile::illuminanceMapNames | ( | const std::string & | envPeriod | ) | const |
| boost::optional<std::string> openstudio::SqlFile::illuminanceMapRefPt | ( | const std::string & | name, |
| int | ptNum | ||
| ) | const |
reference point for map - form RefPtn=(x:y:illuminance)
| boost::optional<std::string> openstudio::SqlFile::illuminanceMapRefPt | ( | int | mapIndex, |
| int | ptNum | ||
| ) | const |
| Vector openstudio::SqlFile::illuminanceMapX | ( | const std::string & | name, |
| const DateTime & | dateTime | ||
| ) | const |
x position (m) of the illuminance map
x position (m) of the illuminance map
| Vector openstudio::SqlFile::illuminanceMapY | ( | const std::string & | name, |
| const DateTime & | dateTime | ||
| ) | const |
y position (m) of the illuminance map
y position (m) of the illuminance map
| std::vector<std::string> openstudio::SqlFile::illuminanceMapZoneNames | ( | const std::string & | name | ) | const |
get zone names of for specified illuminance map
| std::vector<std::string> openstudio::SqlFile::illuminanceMapZoneNames | ( | int | mapIndex | ) | const |
| 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 | ||
| ) |
| 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 | ||
| ) |
| 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 | ||
| ) |
| boost::optional<double> openstudio::SqlFile::naturalGasCooling | ( | ) | const |
Returns the natural gas energy used for cooling in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasExteriorEquipment | ( | ) | const |
Returns the natural gas energy used for exterior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasExteriorLighting | ( | ) | const |
Returns the natural gas energy used for exterior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasFans | ( | ) | const |
Returns the natural gas energy used for fans in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasGenerators | ( | ) | const |
Returns the natural gas energy used for generators in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasHeating | ( | ) | const |
Returns the natural gas energy used for heating in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasHeatRecovery | ( | ) | const |
Returns the natural gas energy used for heat recovery in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasHeatRejection | ( | ) | const |
Returns the natural gas energy used for heat rejection in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasHumidification | ( | ) | const |
Returns the natural gas energy used for humidification in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasInteriorEquipment | ( | ) | const |
Returns the natural gas energy used for interior equipment in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasInteriorLighting | ( | ) | const |
Returns the natural gas energy used for interior lighting in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasPumps | ( | ) | const |
Returns the natural gas energy used for pumps in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::naturalGasRefrigeration | ( | ) | const |
Returns the natural gas energy used for refrigeration in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::naturalGasWaterSystems | ( | ) | const |
Returns the natural gas energy used for water systems in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::netSiteEnergy | ( | ) | const |
net site energy in GJ
| boost::optional<double> openstudio::SqlFile::netSourceEnergy | ( | ) | const |
net source energy in GJ
| bool openstudio::SqlFile::operator< | ( | const SqlFile & | other | ) | const |
| bool openstudio::SqlFile::operator== | ( | const SqlFile & | other | ) | const |
| boost::optional<double> openstudio::SqlFile::otherFuel1Cooling | ( | ) | const |
Returns the energy used for cooling from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1ExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1ExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1Fans | ( | ) | const |
Returns the energy used for fans from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1Generators | ( | ) | const |
Returns the energy used for generators from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::otherFuel1HeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1HeatRejection | ( | ) | const |
Returns the energy used for heat rejection from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1Humidification | ( | ) | const |
Returns the energy used for humidification from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1InteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1InteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1Pumps | ( | ) | const |
Returns the energy used for pumps from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel1Refrigeration | ( | ) | const |
Returns the energy used for refrigeration from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::otherFuel1WaterSystems | ( | ) | const |
Returns the energy used for water systems from otherFuel1 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2Cooling | ( | ) | const |
Returns the energy used for cooling from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2ExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2ExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2Fans | ( | ) | const |
Returns the energy used for fans from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2Generators | ( | ) | const |
Returns the energy used for generators from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::otherFuel2HeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2HeatRejection | ( | ) | const |
Returns the energy used for heat rejection from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2Humidification | ( | ) | const |
Returns the energy used for humidification from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2InteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2InteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2Pumps | ( | ) | const |
Returns the energy used for pumps from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::otherFuel2Refrigeration | ( | ) | const |
Returns the energy used for refrigeration from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::otherFuel2WaterSystems | ( | ) | const |
Returns the energy used for water systems from otherFuel2 in gigajoules.
Requires EnergyPlus simulation output to calculate.
| openstudio::path openstudio::SqlFile::path | ( | ) | const |
get the path
| 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.
| boost::optional<double> openstudio::SqlFile::propaneCooling | ( | ) | const |
Returns the energy used for cooling from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneExteriorEquipment | ( | ) | const |
Returns the energy used for exterior equipment from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneExteriorLighting | ( | ) | const |
Returns the energy used for exterior lighting from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneFans | ( | ) | const |
Returns the energy used for fans from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneGenerators | ( | ) | const |
Returns the energy used for generators from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneHeating | ( | ) | const |
Propane Returns the energy used for heating from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneHeatRecovery | ( | ) | const |
Returns the energy used for heat recovery from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneHeatRejection | ( | ) | const |
Returns the energy used for heat rejection from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneHumidification | ( | ) | const |
Returns the energy used for humidification from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneInteriorEquipment | ( | ) | const |
Returns the energy used for interior equipment from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneInteriorLighting | ( | ) | const |
Returns the energy used for interior lighting from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propanePumps | ( | ) | const |
Returns the energy used for pumps from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::propaneRefrigeration | ( | ) | const |
Returns the energy used for refrigeration from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| 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.
| boost::optional<double> openstudio::SqlFile::propaneWaterSystems | ( | ) | const |
Returns the energy used for water systems from propane in gigajoules.
Requires EnergyPlus simulation output to calculate.
| void openstudio::SqlFile::removeIndexes | ( | ) |
| bool openstudio::SqlFile::reopen | ( | ) |
re-open the file
| boost::optional<openstudio::ReportingFrequency> openstudio::SqlFile::reportingFrequencyFromDB | ( | const std::string & | dbReportingFrequency | ) |
| boost::optional<double> openstudio::SqlFile::runPeriodValue | ( | const std::string & | envPeriod, |
| const std::string & | timeSeriesName, | ||
| const std::string & | keyValue | ||
| ) |
| bool openstudio::SqlFile::supportedVersion | ( | ) | const |
| std::vector<TimeSeries> openstudio::SqlFile::timeSeries | ( | const std::string & | envPeriod, |
| const std::string & | reportingFrequency, | ||
| const std::string & | timeSeriesName | ||
| ) |
| boost::optional<TimeSeries> openstudio::SqlFile::timeSeries | ( | const std::string & | envPeriod, |
| const std::string & | reportingFrequency, | ||
| const std::string & | timeSeriesName, | ||
| const std::string & | keyValue | ||
| ) |
| 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.
| boost::optional<double> openstudio::SqlFile::totalSiteEnergy | ( | ) | const |
total site energy in GJ
| boost::optional<double> openstudio::SqlFile::totalSourceEnergy | ( | ) | const |
total source energy in GJ
| boost::optional<double> openstudio::SqlFile::waterCooling | ( | ) | const |
Returns the water used for cooling in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterExteriorEquipment | ( | ) | const |
Returns the water used for exterior equipment in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterExteriorLighting | ( | ) | const |
Returns the water used for exterior lighting in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterFans | ( | ) | const |
Returns the water used for fans in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterGenerators | ( | ) | const |
Returns the water used for generators in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterHeating | ( | ) | const |
Returns the water used for heating in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterHeatRecovery | ( | ) | const |
Returns the water used for heat recovery in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterHeatRejection | ( | ) | const |
Returns the water used for heat rejection in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterHumidification | ( | ) | const |
Returns the water used for humidification in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterInteriorEquipment | ( | ) | const |
Returns the water used for interior equipment in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterInteriorLighting | ( | ) | const |
Returns the water used for interior lighting in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterPumps | ( | ) | const |
Returns the water used for pumps in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterRefrigeration | ( | ) | const |
Returns the water used for refrigeration in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterTotalEndUses | ( | ) | const |
Returns the water used for all uses in cubic meters.
Requires EnergyPlus simulation output to calculate.
| boost::optional<double> openstudio::SqlFile::waterWaterSystems | ( | ) | const |
Returns the water used for water systems in cubic meters.
Requires EnergyPlus simulation output to calculate.