About this Dataset

Data And Code From: Environmental Influences On Drying Rate Of Spray Applied Disinfestants From Horticultural Production Services

This dataset includes all the data and R code needed to reproduce the analyses in a forthcoming manuscript:

Copes, W. E., Q. D. Read , and B. J. Smith. Environmental influences on drying rate of spray applied disinfestants from horticultural production services. PhytoFrontiers , DOI pending.

Study description: Instructions for disinfestants typically specify a dose and a contact time to kill plant pathogens on production surfaces. A problem occurs when disinfestants are applied to large production areas where the evaporation rate is affected by weather conditions. The common contact time recommendation of 10 min may not be achieved under hot, sunny conditions that promote fast drying. This study is an investigation into how the evaporation rates of six commercial disinfestants vary when applied to six types of substrate materials under cool to hot and cloudy to sunny weather conditions. Initially, disinfestants with low surface tension spread out to provide 100% coverage and disinfestants with high surface tension beaded up to provide about 60% coverage when applied to hard smooth surfaces. Disinfestants applied to porous materials were quickly absorbed into the body of the material, such as wood and concrete. Even though disinfestants evaporated faster under hot sunny conditions than under cool cloudy conditions, coverage was reduced considerably in the first 2.5 min under most weather conditions and reduced to less than or equal to 50% coverage by 5 min.

Dataset contents: This dataset includes R code to import the data and fit Bayesian statistical models using the model fitting software CmdStan, interfaced with R using the packages brms and cmdstanr. The models (one for 2022 and one for 2023) compare how quickly different spray-applied disinfestants dry, depending on what chemical was sprayed, what surface material it was sprayed onto, and what the weather conditions were at the time. Next, the statistical models are used to generate predictions and compare mean drying rates between the disinfestants, surface materials, and weather conditions. Finally, tables and figures are created.

These files are included:

Drying2022.csv : drying rate data for the 2022 experimental run
Weather2022.csv : weather data for the 2022 experimental run
Drying2023.csv : drying rate data for the 2023 experimental run
Weather2023.csv : weather data for the 2023 experimental run
disinfestant_drying_analysis.Rmd : RMarkdown notebook with all data processing, analysis, and table creation code
disinfestant_drying_analysis.html : rendered output of notebook
MS_figures.R : additional R code to create figures formatted for journal requirements
fit2022_discretetime_weather_solar.rds : fitted brms model object for 2022. This will allow users to reproduce the model prediction results without having to refit the model, which was originally fit on a high-performance computing cluster
fit2023_discretetime_weather_solar.rds : fitted brms model object for 2023
data_dictionary.xlsx : descriptions of each column in the CSV data files
Organization: Department of Agriculture
Last updated: 2024-05-31T22:58:23.796102
Tags: alcohol, bleach, disinfectant, disinfestant, greenhouse, horticulture, peroxygen, qac, quaternary-ammonium, sanitizer

Tables

Drying2023

@usgov.usda_gov_data_and_code_from_environmental_influences_o_3c0c859f.drying2023

13.54 kB
6,804 rows
12 columns

CREATE TABLE drying2023 (
  "study" VARCHAR,
  "year" BIGINT,
  "jdate" BIGINT,
  "bin" VARCHAR,
  "dsnfst" VARCHAR,
  "mtrl" VARCHAR,
  "absrb" VARCHAR,
  "rater" VARCHAR,
  "rep" BIGINT,
  "subs" BIGINT,
  "time" DOUBLE,
  "prcntc" VARCHAR
);

Weather2022

@usgov.usda_gov_data_and_code_from_environmental_influences_o_3c0c859f.weather2022

12.91 kB
126 rows
12 columns

CREATE TABLE weather2022 (
  "test" VARCHAR,
  "bin" BIGINT,
  "material" VARCHAR,
  "dsnfst" VARCHAR,
  "jdate" BIGINT,
  "year" BIGINT,
  "tm" DOUBLE,
  "rh" DOUBLE,
  "vpd" DOUBLE,
  "lwslope" DOUBLE,
  "solar" DOUBLE,
  "wind" DOUBLE
);

Weather2023

@usgov.usda_gov_data_and_code_from_environmental_influences_o_3c0c859f.weather2023

21.16 kB
63 rows
22 columns

CREATE TABLE weather2023 (
  "test" VARCHAR,
  "year" BIGINT,
  "jdate" BIGINT,
  "stime" VARCHAR,
  "bin" VARCHAR,
  "dsnfst" VARCHAR,
  "rep" BIGINT,
  "run" BIGINT,
  "tc_mean" DOUBLE,
  "tc_sd" DOUBLE,
  "rh_mean" DOUBLE,
  "rh_sd" DOUBLE,
  "solar_mean" DOUBLE,
  "solar_sd" DOUBLE,
  "lw1slope" DOUBLE,
  "lw1_95ci" DOUBLE,
  "lw2slope" DOUBLE,
  "lw2_95ci" DOUBLE,
  "wind" DOUBLE,
  "windsd" DOUBLE,
  "gust" DOUBLE,
  "gustsd" DOUBLE
);