Generate all fire features joined in the mtbs table for modeling the ground process and fire size. This joins all of the lagged aggregated time summaries mapped to individual MTBS fires by specified spatial degrees over a 180 day lag period for each fire

Generate all fire features joined in the mtbs table for modeling the ground process and fire size. This joins all of the lagged aggregated time summaries mapped to individual MTBS fires by specified spatial degrees over a 180 day lag period for each fire

gen_query_fire_base_full_feat_180d(
  fire_base_start_date = base::as.Date("2000-01-01"),
  max_lag_fire_base_days = 180,
  spat_deg_rad = 0.5,
  summary_type = "AVG",
  out_qry_dir,
  out_tbl_name_pfx,
  fire_base_tbl_name
)

Arguments

fire_base_start_date	(date) : The minimum date to filter MTBS fire data, we will i.e. dataset will only contain MTBS fires after this date
max_lag_fire_base_days	(integer) : The number of days for NOAA SWDI weather data to lag behind the fire_base_start_date
spat_deg_rad	(double) : The spatial degree radius to consider around each fire when joining weather data (default value is 0.5)
summary_type	(character) : The SQL summary function to apply to the GHCN-D weather data e.g. "AVG", "MEDIAN" (default value is "AVG")
out_qry_dir	(character) : The directory to save the query. A full file path will be generated as part of the output

Value

(tibble) : A tibble with the query string, file path to store the query, and a check of whether the filepath exists

Examples

if (FALSE) {
library("tidyverse")
gen_query_fire_base_full_feat_180d(fire_base_start_date = base::as.Date("2000-01-01"),
                               max_lag_fire_base_days = 180,
                               spat_deg_rad = 0.5,
                               summary_type = "AVG",
                               out_qry_dir = ".",
                               out_tbl_name_pfx = "mtbs",
                               fire_base_tbl_name = "mtbs_base_01")
}