Materials and Products Database

Repository of materials and products properties and fire test data to improve fire modeling and fire investigation.

This project was supported in part by Award No. 2019-DU-BX-0018, awarded by the National Institute of Justice, Office of Justice Programs, U.S. Department of Justice. The opinions, findings, and conclusions or recommendations expressed in this publication / program / exhibition are those of the author(s) and do not necessarily reflect those of the Department of Justice.

Cite this database: "McKinnon, M., Weinschenk, C., Dow, N., DiDomizio, M., and Madrzykowski, D. Materials and Products Database (Version 1.0.0), Fire Safety Research Institute, UL Research Institutes. Columbia, MD 21045, 2023."

Cite the Technical Reference Guide: "McKinnon, M., Weinschenk, C., and Madrzykowski, D. Materials and Products Database - Technical Reference Guide, Fire Safety Research Institute, UL Research Institutes. Columbia, MD 21045, 2023."

Cite the User Guide: "McKinnon, M., and Weinschenk, C. Materials and Products Database - User Guide, Fire Safety Research Institute, UL Research Institutes. Columbia, MD 21045, 2023."

Database Structure

01_Data/

Raw data generated from each apparatus are included here in plain-text format. The data is organized first by material, next by the short name of test apparatus used, and where applicable additional filtering by test settings.

Test Apparatus and Data File Structure

Cone Calorimeter (Cone)
- Data file structure includes the material, the short name for the apparatus, heat flux setting and scan/scalar, date of test, and replicate number. Scan is for the raw output data and scalar is for the initial conditions and high-level test parameters.
  - Example: MDF_Cone_HF25scalar_210323_R1 stands for the first replicate of scalar data generated from a medium density fiber board test in cone calorimeter exposed to 25 kW/m² on March 23, 2021.
- A _ConeNotes.csv is generated for each material from the plot_Cone_data.py script. For materials whose experiments deviated from typical behavior relevant pictures are included in the respective material directory.
Fourier Transform Infrared Spectrometer (FTIR)
- The FTIR directory contains subdirectories for the Attenuated Total Reflectance method (ATR) and the Integrating Sphere (IS)
- Data file structure for the ATR experiment files includes the material, the abbreviated name for the apparatus, date of test, and replicate number.
  - Example: __MDF_ATR_210323_R5__ stands for the fifth replicate of data collected with the ATR accessory conducted on June 8, 2021.
- Data file structure for the IS experiment files includes the material, the abbreviated name for the apparatus, the measurand, whether the test is a sample measurement or standard reference, date of test, and replicate number.
  - Example: __OSB_IS_REFLECT_MEAS_210623_R2__ stands for the second replicate conducted on oriented strand board to measure spectral reflection in the integrating sphere on June 23, 2021.
Heat Flow Meter (HFM)
- Data file structure is the material, the abbreviated name for the apparatus, whether test was dry or wet, whether test was for thermal conductivity or heat capacity, date of test, and replicate number. Scan is for the raw output data and scalar is for the initial conditions and high-level test parameters.
  - Example: __OSB_HFM_Dry_Conductivity_210315_R3.tst__ stands for the third replicate of the data generated from an oriented strand board test in the heat flow meter tested dry for thermal conductivity on March 15, 2021.
Micro-scale Combustion Calorimeter (MCC)
- Data file structure is the material, the abbreviated name for the apparatus, the heating rate in Kelvin per minute, date of test, and replicate number. Additionally, the final mass of the sample after the test is included in a separate text file named with the appendix 'FINAL_MASS'.
  - Example: Polyester_Fabric_MCC_30K_min_210308_R1.csv stands for the first replicate of the data generated from a test on polyester fabric in the micro-scale combustion calorimeter tested with a heating rate of 30 Kelvin per minute on March 8, 2021.
Simultaneous Thermal Analyzer (STA)
- Data file structure is the material, the abbreviated name for the apparatus, the atmosphere tested in, the heating rate in Kelvin per minute and data/meta, date of test, and replicate number. Data is for the raw output data and meta is for the initial conditions and high-level test parameters.
  - Example: Polyester_Batting_STA_N2_3KData_210215_R1.csv stands for the first replicate of the data generated from a polyester batting board test in the simultaneous thermal analyzer tested in nitrogen with a heating rate of 3 Kelvin per minute on March 15, 2021.
This directory also includes representative photographs of the respective material.

Additional Data Files

material.json Each material has a json file that links the data stored in the repository and data and graphs produced by the accompanying scripts to the respective landing page for the material on the front-end website. The file also contains a brief description of the material and alternate names of the material to facilitate search.
Photos A full-size and thumbnail photo are included of materials for visualization on front-end website.

02_Scripts/

Python processing scripts exist for analyzing the experimental data to generate derived quantities and to plot the experimental data. The scripts are apparatus specific and cycle through all materials upon execution. Each apparatus has a pair of scripts: data.py and __data_html.py__.

The data.py script computes derived quantities, produces reduced data .csv files, and produces .pdf graphs in __03_Charts/Material/Apparatus__.
- Derived quantities and/or reduced data files will get dropped into __01_Data/Material/Apparatus__. These files get updated each time the script gets executed.
The data_html.py script produces interactive .html files that allow interactions such as hover, zoom, and pan and .html tables of relevant processed data. Similar to the data.py script, .html graphs are output to 03_Charts/Material/Apparatus and can be opened in a web browser.
run_all .bat and .sh files exist for both the set of data.py scripts and the data_html.py scripts. These files will execute the respective python scripts for all data in the repository.
- If there are issues executing the script, in particular the .sh script, a change mode may be needed. In a command prompt type:
```
chmod +x run_all_data.sh OR chmod +x run_all_data_html.sh
```
When the scripts, either data.py or __data_html.py__, are run, the current version of the repository (i.e., Github hash) is appended to the figure.

To successfully execute the Python scripts in this repository, several additional packages (outside of base Python) will need to be installed. One way to do this is through pip with following commands:

pip install pandas              #used for data wrangling/processing
pip install numpy               #used for math analysis
pip install scipy               #used for stats analysis
pip install matplotlib          #used for plot styling and pdf plots
pip install plotly              #used for interactive html plots
pip install GitPython           #used for add repo hash to plots
pip install pybaselines         #used for melting analysis in STA

03_Charts

The material sub directories get generated upon executing of the plotting scripts. The sub directories are broken down by material and further by test apparatus.

ulfsri / fsri_materials_database

readme