Wrapper function to generate a single combined or separate SQL files for 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 — wrap_gen_query_fire_base_full_feat

Wrapper function to generate a single combined or separate SQL files for 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

wrap_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,
  ind_comb_qry = TRUE
)

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
ind_comb_qry	(logical) : If `TRUE` then produces a single combined `sql` query for all features combined. If `FALSE` then produces a separate `sql` queries for individual GHCN-D feature

Value

(tibble) : A single or separate SQL files for single GHCN features joined to MTBS fire_ids by specified spatial and temporal parameters

Examples

if (FALSE) {
library("tidyverse")
wrap_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",
                                    ind_comb_qry = TRUE)
}