Baselight

ASHRAE Global Thermal Comfort Database II

81,846 sets of indoor climatic observations with subjective evaluations

@kaggle.claytonmiller_ashrae_global_thermal_comfort_database_ii

Loading...
Loading...

About this Dataset

ASHRAE Global Thermal Comfort Database II

Dataset Source: https://datadryad.org/stash/dataset/doi:10.6078/D1F671

Abstract

Recognizing the value of open-source research databases in advancing the art and science of
HVAC, in 2014 the ASHRAE Global Thermal Comfort Database II project was launched under
the leadership of University of California at Berkeley’s Center for the Built Environment and
The University of Sydney’s Indoor Environmental Quality (IEQ) Laboratory.
The exercise began with a systematic collection and harmonization of raw data from the last
two decades of thermal comfort field studies around the world. The final database is comprised
of field studies conducted between 1995 and 2015 from around the world, with contributors
releasing their raw data to the project for wider dissemination to the thermal comfort research
community. After the quality-assurance process, there was a total of 81,846 rows of data of
paired subjective comfort votes and objective instrumental measurements of thermal comfort
parameters. An additional 25,617 rows of data from the original ASHRAE RP-884 database are
included, bringing the total number of entries to 107,463.

The database is intended to support diverse inquiries about thermal comfort in field settings.
To achieve this goal, two web-based tools were developed to accompany the database:

  1. Interactive visualization tool: provides a user-friendly interface for researchers and
    practitioners to explore and navigate their way around the large volume of data in ASHRAE
    Global Thermal Comfort Database II
  2. Query builder tool: allows users to filter the database according to a set of selection criteria,
    and then download the results of that query in a generic comma-separated-values (.csv) file

Methods

In order to ensure that the quality of the database would permit end-users to conduct robust
hypothesis testing, the team built the data collection methodology on specific requirements, as
follows:

  • Data needed to come from field experiments rather than climate chamber research, so
    that it represented research conducted in “real” buildings occupied by “real” people doing
    their normal day-to-day activities, rather than paid college students sitting in a controlled
    indoor environment of a climate chamber.
  • Both instrumental (indoor climatic) and subjective (questionnaire) data were required,
    such that they were recorded in the same space at the same time
  • The database needed to be built up from the raw data files generated by the original
    researchers, instead of their processed or published findings.
  • The raw data needed to come with a supporting codebook explaining the coding
    conventions used by the data contributor, to allow harmonization with the standardized
    Földváry Ličina, Veronika et al. (2018), ASHRAE Global ... doi:10.6078/D1F671
    data formatting within the database.
  • Data must have been published either in a peer-reviewed journal or conference paper.

All datasets from individual studies were subject to a stringent quality assurance process
before being assimilated into the database. The research team conducted a final
validation by first comparing each raw dataset with its related publication provided by the data
contributor to prevent transmission errors. Systematic quality control of each study was
performed to ensure that records within the database were reasonable. Firstly, distributions of
each variable were visualized to identify aberrant values. Then, cross-plots between two
variables (e.g. thermal sensation and thermal comfort) were used to check for incorrectly coded
data. Finally, a few rows from each study were randomly selected to verify consistency between
the original dataset and the standardized database. Since the data came from multiple
independent studies, every record did not necessarily include all of the thermal comfort
variables. Where data were missing, that particular range of cells was filled with a null value.

Usage Notes

The dataset is provided as a comma-separated value (.csv) file using UTF-8 character encoding.
The first row contains human-readable column headers. Each row represents an individual’s
questionnaire responses, and the associated instrumental measurements, thermal index values
and outdoor meteorological observations where available. Full details can be found in the
related work.

Funding

American Society of Heating, Refrigerating and Air Conditioning Engineers, Award: URP 1656

References

This dataset is supplement to https://doi.org/10.1016/j.buildenv.2018.06.022

Tables

Ashrae Db2–01

@kaggle.claytonmiller_ashrae_global_thermal_comfort_database_ii.ashrae_db2_01
  • 1.99 MB
  • 107583 rows
  • 70 columns
Loading...

CREATE TABLE ashrae_db2_01 (
  "publication_citation" VARCHAR,
  "data_contributor" VARCHAR,
  "year" DOUBLE,
  "season" VARCHAR,
  "koppen_climate_classification" VARCHAR,
  "climate" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "building_type" VARCHAR,
  "cooling_startegy_building_level" VARCHAR,
  "cooling_startegy_operation_mode_for_mm_buildings" VARCHAR,
  "heating_strategy_building_level" VARCHAR,
  "age" DOUBLE,
  "sex" VARCHAR,
  "thermal_sensation" DOUBLE,
  "thermal_sensation_acceptability" DOUBLE,
  "thermal_preference" VARCHAR,
  "air_movement_acceptability" DOUBLE,
  "air_movement_preference" VARCHAR,
  "thermal_comfort" VARCHAR,
  "pmv" DOUBLE,
  "ppd" DOUBLE,
  "set" DOUBLE,
  "clo" DOUBLE,
  "met" DOUBLE,
  "activity_10" DOUBLE,
  "activity_20" DOUBLE,
  "activity_30" DOUBLE,
  "activity_60" DOUBLE,
  "air_temperature_c" DOUBLE,
  "air_temperature_f" DOUBLE,
  "ta_h_c" DOUBLE,
  "ta_h_f" DOUBLE,
  "ta_m_c" DOUBLE,
  "ta_m_f" VARCHAR,
  "ta_l_c" DOUBLE,
  "ta_l_f" DOUBLE,
  "operative_temperature_c" DOUBLE,
  "operative_temperature_f" DOUBLE,
  "radiant_temperature_c" DOUBLE,
  "radiant_temperature_f" DOUBLE,
  "globe_temperature_c" DOUBLE,
  "globe_temperature_f" DOUBLE,
  "tg_h_c" DOUBLE,
  "tg_h_f" DOUBLE,
  "tg_m_c" DOUBLE,
  "tg_m_f" DOUBLE,
  "tg_l_c" DOUBLE,
  "tg_l_f" DOUBLE,
  "relative_humidity" DOUBLE,
  "humidity_preference" VARCHAR,
  "humidity_sensation" DOUBLE,
  "air_velocity_m_s" DOUBLE,
  "air_velocity_fpm" DOUBLE,
  "velocity_h_m_s" DOUBLE,
  "velocity_h_fpm" DOUBLE,
  "velocity_m_m_s" DOUBLE,
  "velocity_m_fpm" DOUBLE,
  "velocity_l_m_s" DOUBLE,
  "velocity_l_fpm" DOUBLE,
  "subject_s_height_cm" DOUBLE,
  "subject_s_weight_kg" DOUBLE,
  "blind_curtain" DOUBLE,
  "fan" DOUBLE,
  "window" DOUBLE,
  "door" DOUBLE,
  "heater" DOUBLE,
  "outdoor_monthly_air_temperature_c" DOUBLE,
  "outdoor_monthly_air_temperature_f" DOUBLE,
  "database" VARCHAR
);

Share link

Anyone who has the link will be able to view this.