Class: CommercialBuildingEnergyConsumptionSurveyResponse

Inherits:

ActiveRecord::Base

• Object
• ActiveRecord::Base
• CommercialBuildingEnergyConsumptionSurveyResponse

Extended by:

Earth::Model

Defined in:

lib/earth/hospitality/commercial_building_energy_consumption_survey_response.rb

Constant Summary

TABLE_STRUCTURE =

"\nCREATE TABLE cbecs_responses\n  (\n     id                                 INTEGER NOT NULL PRIMARY KEY,\n     census_region_number               INTEGER,\n     census_division_number             INTEGER,\n     climate_zone_number                INTEGER,\n     heating_degree_days                FLOAT,\n     heating_degree_days_units          CHARACTER VARYING(255),\n     cooling_degree_days                FLOAT,\n     cooling_degree_days_units          CHARACTER VARYING(255),\n     construction_year                  INTEGER,\n     area                               FLOAT,\n     area_units                         CHARACTER VARYING(255),\n     floors                             INTEGER,\n     lodging_rooms                      INTEGER,\n     percent_cooled                     FLOAT,\n     food_prep_room                     BOOLEAN,\n     laundry_onsite                     BOOLEAN,\n     indoor_pool                        BOOLEAN,\n     principal_activity                 CHARACTER VARYING(255),\n     detailed_activity                  CHARACTER VARYING(255),\n     first_activity                     CHARACTER VARYING(255),\n     second_activity                    CHARACTER VARYING(255),\n     third_activity                     CHARACTER VARYING(255),\n     first_activity_share               FLOAT,\n     second_activity_share              FLOAT,\n     third_activity_share               FLOAT,\n     months_used                        INTEGER,\n     weekly_hours                       INTEGER,\n     electricity_use                    FLOAT,\n     electricity_use_units              CHARACTER VARYING(255),\n     electricity_energy                 FLOAT,\n     electricity_energy_units           CHARACTER VARYING(255),\n     natural_gas_use                    FLOAT,\n     natural_gas_use_units              CHARACTER VARYING(255),\n     natural_gas_energy                 FLOAT,\n     natural_gas_energy_units           CHARACTER VARYING(255),\n     fuel_oil_use                       FLOAT,\n     fuel_oil_use_units                 CHARACTER VARYING(255),\n     fuel_oil_energy                    FLOAT,\n     fuel_oil_energy_units              CHARACTER VARYING(255),\n     district_heat_use                  FLOAT,\n     district_heat_use_units            CHARACTER VARYING(255),\n     district_heat_energy               FLOAT,\n     district_heat_energy_units         CHARACTER VARYING(255),\n     stratum                            INTEGER,\n     pair                               INTEGER,\n     weighting                          FLOAT,\n     room_nights                        FLOAT,\n     /* what follow are for lodging fuzzy weighting */\n     electricity_per_room_night         FLOAT,\n     electricity_per_room_night_units   CHARACTER VARYING(255),\n     natural_gas_per_room_night         FLOAT,\n     natural_gas_per_room_night_units   CHARACTER VARYING(255),\n     fuel_oil_per_room_night            FLOAT,\n     fuel_oil_per_room_night_units      CHARACTER VARYING(255),\n     district_heat_per_room_night       FLOAT,\n     district_heat_per_room_night_units CHARACTER VARYING(255)\n  );\n\n"

Class Method Summary

• .lodging_records ⇒ Object

Methods included from Earth::Model

extend_mining, extended, registry

Class Method Details

.lodging_records ⇒ Object

# File 'lib/earth/hospitality/commercial_building_energy_consumption_survey_response.rb', line 73

def self.lodging_records
  where(:detailed_activity => ['Hotel', 'Motel or inn'], :first_activity => nil)
end