Augment a Handler with External Data
Description
Section titled “Description”Join external data (a local data frame or a lazy database table) onto a
specific table level of a handler. This is useful for attaching reference
information such as species common names, county names, or plot-level
covariates. Columns added via augment() become available to subsequent
transform(), subset(), partition(), and
aggregate() calls.
Details
Section titled “Details”The target table and join are specified using the scopes
(e.g., tree(), cond(), etc.) The first, unnamed argument
to the helper is the data to join; named arguments configure the join:
by: Join key(s), passed to the underlyingdplyrjoin. A character vector or a named character vector (e.g.c("SPCD" = "code")). If omitted, a natural join on common columns is used.type: Join type: one of"left"(default),"inner","right", or"full".copy: Logical controlling whether a local data frame is uploaded to the remote database. If omitted, local data is copied automatically (with a warning) when joined against a remote table.
augment(handler, ...)Arguments
Section titled “Arguments”handler: A handler object....: One or more scopes describing the data to join, e.g.tree(species_ref, by = "SPCD", type = "left").
The handler with pending augmentations queued.
Examples
Section titled “Examples”species_ref <- data.frame(SPCD = c(1, 2), COMMON_NAME = c("Pine", "Oak"))handler |> augment(tree(species_ref, by = "SPCD", type = "left")) |> partition(tree(COMMON_NAME))