Generate single feature GHCN-D lagged aggregated time summaries mapped to individual MTBS fires by specified spatial degrees over a 180 day lag period for each fire

Generate single feature GHCN-D 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_ghcnd_sfeat_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",
  sfeat,
  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 GHCN-D 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")
sfeat	(character) : The GHCN-D feature to summarize for each given fire. Aggregated and lagged versions of each feature are produced
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_ghcnd_sfeat_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",
                                sfeat = "TOBS",
                                out_qry_dir = ".",
                                out_tbl_name_pfx = "mtbs",
                                fire_base_tbl_name = "mtbs_base_01")
}