| Title: | Columnar Query Engine for Larger-than-RAM Data |
|---|---|
| Description: | A minimal columnar query engine with lazy execution on datasets larger than RAM. Provides 'dplyr'-like verbs (filter(), select(), mutate(), group_by(), summarise(), joins, window functions) and common aggregations (n(), sum(), mean(), min(), max(), sd(), first(), last()) backed by a pure C11 pull-based execution engine and a custom on-disk format ('.vtr'). Reads and writes 'GeoTIFF' (including tiled and 'BigTIFF' layouts) and a tiled raster format ('.vec') with overview pyramids and time cubes for larger-than-RAM raster data. Streams vector operations (spatial transforms, point-in-polygon and nearest-feature joins including a two-sided grid-partitioned join, select-by-location, clip, erase, dissolve, rasterization, polygonization, and contouring) through 'sf', and runs raster operations (zonal statistics, focal windows, terrain derivatives, resample or reproject warp, polygon masking, map algebra, and mosaicking) in native C or over the tiled '.vec' format, one batch or tile at a time for data larger than RAM. |
| Authors: | Gilles Colling [aut, cre, cph] (ORCID: <https://orcid.org/0000-0003-3070-6066>) |
| Maintainer: | Gilles Colling <[email protected]> |
| License: | MIT + file LICENSE |
| Version: | 0.9.0 |
| Built: | 2026-06-26 02:47:07 UTC |
| Source: | https://github.com/gcol33/vectra |
Used inside mutate() or summarise() to apply a function to multiple
columns selected with tidyselect. Returns a named list of expressions.
across(.cols, .fns, ..., .names = NULL)across(.cols, .fns, ..., .names = NULL)
.cols |
Column selection (tidyselect). |
.fns |
A function, formula, or named list of functions. |
... |
Additional arguments passed to |
.names |
A glue-style naming pattern. Uses |
A named list used internally by mutate/summarise.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # In summarise (conceptual; across is expanded to individual expressions) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # In summarise (conceptual; across is expanded to individual expressions) unlink(f)
Appends one or more new row groups to the end of an existing .vtr file
without touching or recompressing existing row groups. The schema of x
must exactly match the schema of the target file (same column names and
types, in the same order).
append_vtr(x, path, ...)append_vtr(x, path, ...)
x |
A |
path |
File path of an existing |
... |
Additional arguments passed to methods. |
The operation is not fully atomic: if the process is interrupted after
new row groups are written but before the header is patched, the file
will be in a corrupted state. Use write_vtr() for safety-critical
write-once workloads.
Invisible NULL.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars[1:10, ], f) append_vtr(mtcars[11:20, ], f) result <- tbl(f) |> collect() stopifnot(nrow(result) == 20L) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars[1:10, ], f) append_vtr(mtcars[11:20, ], f) result <- tbl(f) |> collect() stopifnot(nrow(result) == 20L) unlink(f)
Sort rows by column values
arrange(.data, ...)arrange(.data, ...)
.data |
A |
... |
Column names (unquoted). Wrap in |
Uses an external merge sort with a 1 GB memory budget. When data exceeds
this limit, sorted runs are spilled to temporary .vtr files and merged
via a k-way min-heap. NAs sort last in ascending order.
This is a materializing operation.
A new vectra_node with sorted rows.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> arrange(desc(mpg)) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> arrange(desc(mpg)) |> collect() |> head() unlink(f)
Bind rows or columns from multiple vectra tables
bind_rows(..., .id = NULL) bind_cols(...)bind_rows(..., .id = NULL) bind_cols(...)
... |
|
.id |
Optional column name for a source identifier. |
When all inputs are vectra_node objects with identical column names and
types and no .id is requested, bind_rows creates a streaming
ConcatNode that iterates children sequentially without materializing.
Otherwise, inputs are collected and combined in R. Missing columns are filled with NA.
bind_cols requires the same number of rows in each input.
A vectra_node (streaming) when all inputs are vectra_node with
identical schemas and .id is NULL. Otherwise a data.frame.
f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") write_vtr(data.frame(x = 1:3, y = 4:6), f1) write_vtr(data.frame(x = 7:9, y = 10:12), f2) bind_rows(tbl(f1), tbl(f2)) |> collect() bind_cols(tbl(f1), tbl(f2)) unlink(c(f1, f2))f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") write_vtr(data.frame(x = 1:3, y = 4:6), f1) write_vtr(data.frame(x = 7:9, y = 10:12), f2) bind_rows(tbl(f1), tbl(f2)) |> collect() bind_cols(tbl(f1), tbl(f2)) unlink(c(f1, f2))
Computes string distances between query keys and a string column in a materialized block. Optionally uses exact-match blocking on a second column (e.g., genus) to reduce the search space.
block_fuzzy_lookup( block, column, keys, method = "dl", max_dist = 0.2, block_col = NULL, block_keys = NULL, n_threads = 4L )block_fuzzy_lookup( block, column, keys, method = "dl", max_dist = 0.2, block_col = NULL, block_keys = NULL, n_threads = 4L )
block |
A |
column |
Character scalar. Name of the string column to fuzzy-match against. |
keys |
Character vector. Query strings to match. |
method |
Character. Distance method: |
max_dist |
Numeric. Maximum normalized distance (default 0.2). |
block_col |
Optional character scalar. Column name for exact-match blocking
(e.g., genus). When provided, only rows where |
block_keys |
Optional character vector (same length as |
n_threads |
Integer. Number of OpenMP threads (default 4L). |
A data.frame with columns query_idx (1-based position in keys),
fuzzy_dist (normalized distance), plus all columns from the block.
Performs a hash lookup on a string column of a materialized block. Returns all rows where the column value matches one of the query keys. Hash indices are built lazily on first use and cached for subsequent calls.
block_lookup(block, column, keys, ci = FALSE)block_lookup(block, column, keys, ci = FALSE)
block |
A |
column |
Character scalar. Name of the string column to match against. |
keys |
Character vector. Query values to look up. |
ci |
Logical. Case-insensitive matching (default |
A data.frame with column query_idx (1-based position in keys)
plus all columns from the block, for each (query, block_row) match pair.
f <- tempfile(fileext = ".vtr") df <- data.frame(taxonID = 1:2, canonicalName = c("Quercus robur", "Pinus sylvestris")) write_vtr(df, f) blk <- materialize(tbl(f)) hits <- block_lookup(blk, "canonicalName", c("Quercus robur")) ci_hits <- block_lookup(blk, "canonicalName", c("quercus robur"), ci = TRUE) unlink(f)f <- tempfile(fileext = ".vtr") df <- data.frame(taxonID = 1:2, canonicalName = c("Quercus robur", "Pinus sylvestris")) write_vtr(df, f) blk <- materialize(tbl(f)) hits <- block_lookup(blk, "canonicalName", c("Quercus robur")) ci_hits <- block_lookup(blk, "canonicalName", c("quercus robur"), ci = TRUE) unlink(f)
Wraps a query so a pull-based consumer can read it one chunk at a time and
re-read it from the start as many times as needed. The returned closure
follows the data(reset) protocol that biglm::bigglm() expects: called
with reset = TRUE it rewinds to the beginning of the data, and called with
reset = FALSE it returns the next chunk as a data.frame, or NULL once the
data is exhausted. This lets bigglm() fit a generalized linear model on a
dataset larger than RAM, streaming each iteratively reweighted pass through
the engine without ever holding the full design matrix.
chunk_feeder(.source)chunk_feeder(.source)
.source |
Either a function of no arguments returning a fresh
|
Because a vectra node is consumed as it streams, re-reading requires a fresh
node on each pass. chunk_feeder() accepts either form: a factory, a
function of no arguments that returns a new node each time it is called; or an
offloaded node from offload(), which is backed by a file and replays from
disk directly. On every reset = TRUE a fresh stream is started, so the same
query is replayed on each pass.
Prefer feeding an offload() of the prepared query: the pipeline (scan,
joins, mutate) runs once into the spill, and every reweighted pass is then a
disk scan of the prepared columns rather than a re-run of the pipeline.
A function function(reset = FALSE). With reset = TRUE it rewinds
and returns invisible(NULL); with reset = FALSE it returns the next
chunk as a data.frame, or NULL at end of stream.
offload() for the replay cache, and collect_chunked() for
single-pass reductions that vectra drives.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) feed <- chunk_feeder(function() tbl(f) |> select(mpg, wt, hp)) feed(reset = TRUE) # rewind to the start of the stream first <- feed() # first chunk as a data.frame head(first) # Out-of-core GLM: prepare once with offload(), then bigglm() replays it. if (requireNamespace("biglm", quietly = TRUE)) { s <- offload(tbl(f) |> select(mpg, wt, hp)) fit <- biglm::bigglm(mpg ~ wt + hp, data = chunk_feeder(s), family = gaussian()) coef(fit) } unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) feed <- chunk_feeder(function() tbl(f) |> select(mpg, wt, hp)) feed(reset = TRUE) # rewind to the start of the stream first <- feed() # first chunk as a data.frame head(first) # Out-of-core GLM: prepare once with offload(), then bigglm() replays it. if (requireNamespace("biglm", quietly = TRUE)) { s <- offload(tbl(f) |> select(mpg, wt, hp)) fit <- biglm::bigglm(mpg ~ wt + hp, data = chunk_feeder(s), family = gaussian()) coef(fit) } unlink(f)
Pulls all batches from the execution plan and materializes the result as an R data.frame.
collect(x, ...)collect(x, ...)
x |
A |
... |
Ignored. |
A data.frame with the query results.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) result <- tbl(f) |> collect() head(result) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) result <- tbl(f) |> collect() head(result) unlink(f)
Streams a lazy query through R in bounded pieces and reduces them with f,
instead of materializing the whole result the way collect() does. The
engine pulls one batch (a data.frame of up to a few hundred thousand rows)
at a time; f is called as f(acc, chunk) and its return value becomes the
accumulator for the next batch. Peak memory is one batch plus whatever the
accumulator holds, so a result far larger than RAM can be reduced to a small
summary in a single pass.
collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE) ## Default S3 method: collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE) ## S3 method for class 'vectra_node' collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE) ## S3 method for class 'vectra_partition' collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE)collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE) ## Default S3 method: collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE) ## S3 method for class 'vectra_node' collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE) ## S3 method for class 'vectra_partition' collect_chunked(x, f, .init = NULL, combine = NULL, commutative = FALSE)
x |
A |
f |
A function of two arguments |
.init |
Initial accumulator value. Passed to |
combine |
Optional function |
commutative |
Logical; declare that |
This is the streaming counterpart to a fold (Reduce()): use it when the
query returns more rows than fit in memory but the reduction is small. A
running count, per-group sufficient statistics, the cross-products X'X and
X'y behind a linear fit, an online mean or histogram - all accumulate in
bounded space across the stream. When you instead need the model-fitting
consumer to drive the iteration (and to re-read the data on each pass, as an
iteratively reweighted GLM does), use chunk_feeder().
The final accumulator. For a node: f applied left-to-right across
every batch, seeded with .init. For a partition: each shard folded with
f/.init, then those per-shard accumulators merged with combine.
chunk_feeder() for pull-based consumers such as biglm::bigglm(),
offload() for the replay cache and the partitioned monoidal reduce,
group_map() and group_modify() for per-shard application, and
collect() to materialize the full result.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Row count without materializing the result. collect_chunked(tbl(f), function(acc, chunk) acc + nrow(chunk), .init = 0L) # Accumulate the normal-equation pieces X'X and X'y for an exact OLS fit # of mpg ~ wt + hp, in one streaming pass. acc <- collect_chunked( tbl(f) |> select(mpg, wt, hp), function(acc, chunk) { X <- cbind(1, chunk$wt, chunk$hp) y <- chunk$mpg list(XtX = acc$XtX + crossprod(X), Xty = acc$Xty + crossprod(X, y)) }, .init = list(XtX = matrix(0, 3, 3), Xty = matrix(0, 3, 1)) ) solve(acc$XtX, acc$Xty) # same as coef(lm(mpg ~ wt + hp, mtcars)) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Row count without materializing the result. collect_chunked(tbl(f), function(acc, chunk) acc + nrow(chunk), .init = 0L) # Accumulate the normal-equation pieces X'X and X'y for an exact OLS fit # of mpg ~ wt + hp, in one streaming pass. acc <- collect_chunked( tbl(f) |> select(mpg, wt, hp), function(acc, chunk) { X <- cbind(1, chunk$wt, chunk$hp) y <- chunk$mpg list(XtX = acc$XtX + crossprod(X), Xty = acc$Xty + crossprod(X, y)) }, .init = list(XtX = matrix(0, 3, 3), Xty = matrix(0, 3, 1)) ) solve(acc$XtX, acc$Xty) # same as coef(lm(mpg ~ wt + hp, mtcars)) unlink(f)
Collects a vectra_node (typically the result of spatial_map() or
spatial_join()) into memory and rebuilds an sf object from its hex-WKB
geometry column. The CRS defaults to the one carried on the node.
collect_sf(x, geom = "geometry", crs = NULL)collect_sf(x, geom = "geometry", crs = NULL)
x |
A |
geom |
Name of the geometry column. Default |
crs |
Override the coordinate reference system. Defaults to the CRS the node carries, or unknown. |
This is the spatial counterpart to collect(): use it when the final result
fits in memory as sf. For a result still larger than RAM, keep it as a node
and write it out with write_vtr() (the geometry stays as a WKB string
column) or reduce it with collect_chunked().
An sf object.
spatial_map(), spatial_join(), collect().
nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) f <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), f) result <- tbl(f) |> spatial_map(~ sf::st_centroid(.x), crs = sf::st_crs(nc)) collect_sf(result) unlink(f)nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) f <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), f) result <- tbl(f) |> spatial_map(~ sf::st_centroid(.x), crs = sf::st_crs(nc)) collect_sf(result) unlink(f)
Traces contour lines at one or more levels from a .vec raster with marching
squares, reading the raster one tile-row strip at a time (each strip expanded
by one row so a cell straddling the strip boundary is traced once). Each strip
contributes line segments, which are accumulated into a lazy vectra_node
carrying a level column and hex-WKB geometry. With merge = TRUE the
segments of each level are joined into continuous lines.
contours(x, levels, band = 1L, merge = TRUE, crs = NA, flush_rows = NULL)contours(x, levels, band = 1L, merge = TRUE, crs = NA, flush_rows = NULL)
x |
A |
levels |
Numeric vector of contour levels to trace. |
band |
Band to contour (1-based). Default 1. |
merge |
If |
crs |
Coordinate reference system recorded on the node. Defaults to the raster's EPSG, else unknown. |
flush_rows |
Rows buffered before a spill flush. Defaults to
|
Extraction is the sort / partition tier of the spatial toolbox: bounded to one haloed strip at a time. The optional final merge collects the segment set, which is small relative to the raster, and joins it per level; this is the small all-to-all step on the output, not on the grid. Geometry assembly and the merge are delegated to sf (an optional dependency).
A vectra_node with a level column and a hex-WKB geometry column,
materialise it with collect_sf().
polygonize() for area features, terrain() for the DEM
derivatives contours often accompany, collect_sf() to materialise as sf.
z <- outer(1:20, 1:20, function(r, c) r + c) f <- tempfile(fileext = ".vec") vec_write_raster(z, f, dtype = "f64", extent = c(0, 0, 20, 20)) iso <- contours(f, levels = c(15, 25, 35)) collect_sf(iso) unlink(f)z <- outer(1:20, 1:20, function(r, c) r + c) f <- tempfile(fileext = ".vec") vec_write_raster(z, f, dtype = "f64", extent = c(0, 0, 20, 20)) iso <- contours(f, levels = c(15, 25, 35)) collect_sf(iso) unlink(f)
Count observations by group
count(x, ..., wt = NULL, sort = FALSE, name = NULL) tally(x, wt = NULL, sort = FALSE, name = NULL)count(x, ..., wt = NULL, sort = FALSE, name = NULL) tally(x, wt = NULL, sort = FALSE, name = NULL)
x |
A |
... |
Grouping columns (unquoted). |
wt |
Column to weight by (unquoted). If |
sort |
If |
name |
Name of the count column (default |
Equivalent to group_by(...) |> summarise(n = n()). When wt is
provided, uses sum(wt) instead of n(). When sort = TRUE, results
are sorted in descending order of the count column.
A vectra_node with group columns and a count column.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> count(cyl) |> collect() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> count(cyl) |> collect() unlink(f)
Builds a persistent hash index stored as a .vtri sidecar file alongside
the .vtr file. The index maps key hashes to row group indices, enabling
O(1) row group identification for equality predicates (filter(col == value)).
create_index(path, column, ci = FALSE)create_index(path, column, ci = FALSE)
path |
Path to a |
column |
Character vector. Name(s) of column(s) to index. |
ci |
Logical. Build a case-insensitive index? Default |
For composite indexes on multiple columns, pass a character vector.
Composite indexes accelerate AND-combined equality predicates
(e.g., filter(col1 == "a", col2 == "b")).
The index is automatically loaded by tbl() when present. It composes with
zone-map pruning and binary search on sorted columns.
Invisible NULL. The index is written as a .vtri sidecar file.
f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = letters, val = 1:26, stringsAsFactors = FALSE), f) create_index(f, "id") tbl(f) |> filter(id == "m") |> collect() unlink(c(f, paste0(f, ".id.vtri")))f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = letters, val = 1:26, stringsAsFactors = FALSE), f) create_index(f, "id") tbl(f) |> filter(id == "m") |> collect() unlink(c(f, paste0(f, ".id.vtri")))
Returns every combination of rows from x and y (Cartesian product).
Both tables are collected before joining.
cross_join(x, y, suffix = c(".x", ".y"), ...)cross_join(x, y, suffix = c(".x", ".y"), ...)
x |
A |
y |
A |
suffix |
Suffixes for disambiguating column names (default |
... |
Ignored. |
A data.frame with nrow(x) * nrow(y) rows.
f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") write_vtr(data.frame(a = 1:2), f1) write_vtr(data.frame(b = c("x", "y", "z"), stringsAsFactors = FALSE), f2) cross_join(tbl(f1), tbl(f2)) unlink(c(f1, f2))f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") write_vtr(data.frame(a = 1:2), f1) write_vtr(data.frame(b = c("x", "y", "z"), stringsAsFactors = FALSE), f2) cross_join(tbl(f1), tbl(f2)) unlink(c(f1, f2))
Marks the specified 0-based physical row indices as deleted by writing (or
updating) a tombstone side file (<path>.del). The original .vtr file is
never modified. The next call to tbl() on the same path will automatically
exclude the deleted rows.
delete_vtr(path, row_ids)delete_vtr(path, row_ids)
path |
File path of the |
row_ids |
A numeric vector of 0-based physical row indices to delete. Out-of-range indices are silently ignored on read (they will never match a real row). |
Tombstone files are cumulative: calling delete_vtr() multiple times on the
same file merges all deletions (union, deduplicated). To undo deletions,
remove the .del file manually with unlink(paste0(path, ".del")).
Invisible NULL.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Delete the first and third rows (0-based indices 0 and 2) delete_vtr(f, c(0, 2)) result <- tbl(f) |> collect() stopifnot(nrow(result) == nrow(mtcars) - 2L) unlink(c(f, paste0(f, ".del")))f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Delete the first and third rows (0-based indices 0 and 2) delete_vtr(f, c(0, 2)) result <- tbl(f) |> collect() stopifnot(nrow(result) == nrow(mtcars) - 2L) unlink(c(f, paste0(f, ".del")))
Used inside arrange() to sort a column in descending order.
desc(x)desc(x)
x |
A column name. |
A marker used by arrange().
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> arrange(desc(mpg)) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> arrange(desc(mpg)) |> collect() |> head() unlink(f)
Streams both files and computes a set-level diff keyed on key_col.
Returns a list with two elements:
diff_vtr(old_path, new_path, key_col)diff_vtr(old_path, new_path, key_col)
old_path |
Path to the older |
new_path |
Path to the newer |
key_col |
Name of the column to use as the row key (must exist in both files with the same type). |
added: a vectra_node (lazy tbl()) of rows present in new_path
but not old_path (matched on key_col). Call collect() to
materialise. The underlying temp file is deleted when the node is
garbage-collected or when the calling R session ends via
on.exit().
deleted: a vector of key values present in old_path but not
new_path.
This is a logical diff (key-based set difference), not a binary file
diff. Rows with the same key that have changed values are not reported
as modified — use added and deleted together to detect updates (a key
that appears in both means a row was replaced).
A named list with elements added (a vectra_node) and deleted
(a vector of key values).
f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") df1 <- data.frame(id = 1:5, val = letters[1:5], stringsAsFactors = FALSE) df2 <- data.frame(id = c(3L, 4L, 5L, 6L, 7L), val = c("C", "d", "e", "f", "g"), stringsAsFactors = FALSE) write_vtr(df1, f1) write_vtr(df2, f2) d <- diff_vtr(f1, f2, "id") # Rows 1 and 2 deleted; rows 6 and 7 added stopifnot(all(d$deleted %in% c(1, 2))) stopifnot(all(collect(d$added)$id %in% c(6, 7))) unlink(c(f1, f2))f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") df1 <- data.frame(id = 1:5, val = letters[1:5], stringsAsFactors = FALSE) df2 <- data.frame(id = c(3L, 4L, 5L, 6L, 7L), val = c("C", "d", "e", "f", "g"), stringsAsFactors = FALSE) write_vtr(df1, f1) write_vtr(df2, f2) d <- diff_vtr(f1, f2, "id") # Rows 1 and 2 deleted; rows 6 and 7 added stopifnot(all(d$deleted %in% c(1, 2))) stopifnot(all(collect(d$added)$id %in% c(6, 7))) unlink(c(f1, f2))
Keep distinct/unique rows
distinct(.data, ..., .keep_all = FALSE)distinct(.data, ..., .keep_all = FALSE)
.data |
A |
... |
Column names (unquoted). If empty, uses all columns. |
.keep_all |
If |
Uses hash-based grouping with zero aggregations. When .keep_all = TRUE
with a column subset, falls back to R's duplicated() with a message.
This is a materializing operation.
A vectra_node with unique rows.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> distinct(cyl) |> collect() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> distinct(cyl) |> collect() unlink(f)
Shows the node types, column schemas, and structure of the lazy query plan.
explain(x, ...)explain(x, ...)
x |
A |
... |
Ignored. |
Invisible x.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> filter(cyl > 4) |> select(mpg, cyl) |> explain() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> filter(cyl > 4) |> select(mpg, cyl) |> explain() unlink(f)
Filter rows of a vectra query
filter(.data, ...)filter(.data, ...)
.data |
A |
... |
Filter expressions (combined with |
Filter uses zero-copy selection vectors: matching rows are indexed without
copying data. Multiple conditions are combined with &. Supported
expression types: arithmetic (+, -, *, /, %%), comparison
(==, !=, <, <=, >, >=), boolean (&, |, !), is.na(),
and string functions (nchar(), substr(), grepl() with fixed patterns).
NA comparisons return NA (SQL semantics). Use is.na() to filter NAs
explicitly.
This is a streaming operation (constant memory per batch).
A new vectra_node with the filter applied.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> filter(cyl > 4) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> filter(cyl > 4) |> collect() |> head() unlink(f)
Applies a moving window to a .vec raster, reading the input one tile-row
strip at a time – each strip expanded by the kernel radius (a halo read) so
window neighbours are available without ever holding the whole grid resident.
The per-window statistic is computed in C. When path is given the output is
streamed straight back to a new .vec one tile-row at a time, so neither the
input nor the output band is ever fully in memory; this is the raster op that
runs out of core where an in-memory engine needs the whole raster at once.
focal( x, w = matrix(1, 3, 3), fun = c("mean", "sum", "min", "max", "sd", "median"), na.rm = TRUE, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )focal( x, w = matrix(1, 3, 3), fun = c("mean", "sum", "min", "max", "sd", "median"), na.rm = TRUE, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
x |
A |
w |
A numeric weight matrix with odd dimensions, or a single positive
odd integer |
fun |
Window statistic: one of |
na.rm |
Skip nodata cells inside the window ( |
band |
Band to read (1-based). Default 1. |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
This is the sort / partition tier of the spatial toolbox: bounded to one haloed strip at a time, exploiting tile locality.
The window w is a numeric weight matrix with odd dimensions (or a single
odd integer k, shorthand for a k x k matrix of ones). NA weights mark
cells outside the window. For fun = "sum"/"mean" the weights scale the
values (sum is sum(w * x), mean is sum(w * x) / sum(w)); for the other
statistics a finite weight only marks membership. With na.rm = TRUE (the
default) nodata cells inside the window are skipped; with na.rm = FALSE any
nodata cell – including a window that runs off the raster edge – makes the
result NA, matching the resident behaviour.
When path is NULL, a numeric matrix (row 1 northmost) carrying
gt, extent, crs, and fun attributes. When path is given, the
written vectra_raster handle (invisibly).
terrain() for DEM derivatives built on the same strip pass,
zonal() for per-zone summaries.
m <- matrix(1:36, 6, 6, byrow = TRUE) f <- tempfile(fileext = ".vec") vec_write_raster(m, f, dtype = "f64", extent = c(0, 0, 6, 6)) # 3x3 mean smoother; edge cells see off-raster neighbours. focal(f, w = matrix(1, 3, 3), fun = "mean") unlink(f)m <- matrix(1:36, 6, 6, byrow = TRUE) f <- tempfile(fileext = ".vec") vec_write_raster(m, f, dtype = "f64", extent = c(0, 0, 6, 6)) # 3x3 mean smoother; edge cells see off-raster neighbours. focal(f, w = matrix(1, 3, 3), fun = "mean") unlink(f)
Joins two tables using approximate string matching on key columns. Optionally blocks by a second column (e.g., genus) for performance — only rows sharing the same blocking key are compared.
fuzzy_join( x, y, by, method = "dl", max_dist = 0.2, block_by = NULL, n_threads = 4L, suffix = ".y" )fuzzy_join( x, y, by, method = "dl", max_dist = 0.2, block_by = NULL, n_threads = 4L, suffix = ".y" )
x |
A |
y |
A |
by |
A named character vector of length 1: |
method |
Character. Distance algorithm: |
max_dist |
Numeric. Maximum normalized distance (0-1) to keep a match.
Default |
block_by |
Optional named character vector of length 1:
|
n_threads |
Integer. Number of OpenMP threads for parallel distance
computation over partitions. Default |
suffix |
Character. Suffix appended to build-side column names that
collide with probe-side names. Default |
A vectra_node with all probe columns, all build columns (suffixed
on collision), and a fuzzy_dist column (double).
Shows column names, types, and a preview of the first few values without collecting the full result.
glimpse(x, width = 5L, ...)glimpse(x, width = 5L, ...)
x |
A |
width |
Maximum number of preview rows to fetch (default 5). |
... |
Ignored. |
Invisible x.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> glimpse() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> glimpse() unlink(f)
Describes the regular grid that spatial_join() uses to partition two
streamed layers for the both-sides-larger-than-RAM case. Cell (cx, cy)
covers [origin_x + cx * cellsize_x, origin_x + (cx + 1) * cellsize_x) and
likewise in y, so a coordinate maps to the cell floor((coord - origin) / cellsize). Pick a cellsize comparable to the scale of the join (large
enough that most cells hold a workable shard, small enough that one cell's
features fit in memory); for an extended-on-extended join choose it larger
than the left features.
grid(cellsize, origin = c(0, 0))grid(cellsize, origin = c(0, 0))
cellsize |
Cell size: a single number for square cells, or
|
origin |
Grid origin |
A vectra_grid specification to pass as spatial_join(partition =).
spatial_join() for the join it partitions.
grid(1000) grid(c(0.5, 0.25), origin = c(-180, -90))grid(1000) grid(c(0.5, 0.25), origin = c(-180, -90))
Group a vectra query by columns
group_by(.data, ...)group_by(.data, ...)
.data |
A |
... |
Grouping column names (unquoted). |
A vectra_node with grouping information stored.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> group_by(cyl) |> summarise(avg = mean(mpg)) |> collect() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> group_by(cyl) |> summarise(avg = mean(mpg)) |> collect() unlink(f)
Run a function once per shard of a partition (offload(x, by = ...)) and
gather the results. Each shard is read into memory as a data.frame and passed
to .f together with its key, so a model that couples rows within a group
becomes a set of independent per-shard fits. This is the per-group
counterpart to collect_chunked(), which instead merges every shard into a
single accumulator.
group_map(.data, .f, ...) ## S3 method for class 'vectra_partition' group_map(.data, .f, ...) group_modify(.data, .f, ...) ## S3 method for class 'vectra_partition' group_modify(.data, .f, ...)group_map(.data, .f, ...) ## S3 method for class 'vectra_partition' group_map(.data, .f, ...) group_modify(.data, .f, ...) ## S3 method for class 'vectra_partition' group_modify(.data, .f, ...)
.data |
A |
.f |
A function applied to each shard. It receives the shard as a
data.frame and the shard key (a string) as its first two arguments; any
further arguments in |
... |
Additional arguments passed on to |
group_map() returns a named list, one element per shard keyed by the shard
key, and places no constraint on what .f returns. Use it for per-group
results that do not rebind into a table, such as fitted models.
group_modify() expects .f to return a data.frame for each shard and binds
those frames into one. When a shard's result does not already carry the
partition key column, the key is added as a leading column (named after the
partition's by), so every row records the shard it came from. Use it for
per-group summaries that recombine into a single table.
Each shard is materialized in full before .f sees it, so partition the
query on a key whose groups fit in memory. For a reduction that stays bounded
without ever holding a whole group, fold the partition with
collect_chunked() instead.
group_map() returns a named list with one element per shard.
group_modify() returns a single data.frame: the per-shard results
row-bound, with the shard key restored as a column when .f dropped it.
offload() to build a partition, and collect_chunked() for the
partitioned monoidal reduce.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) p <- offload(tbl(f), by = "cyl") # One fit per shard, returned as a named list keyed by cyl. fits <- group_map(p, function(d, cyl) coef(lm(mpg ~ wt, data = d))) fits # Per-shard summaries recombined into one table, key restored as a column. group_modify(p, function(d, cyl) data.frame(n = nrow(d), mean_mpg = mean(d$mpg))) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) p <- offload(tbl(f), by = "cyl") # One fit per shard, returned as a named list keyed by cyl. fits <- group_map(p, function(d, cyl) coef(lm(mpg ~ wt, data = d))) fits # Per-shard summaries recombined into one table, key restored as a column. group_modify(p, function(d, cyl) data.frame(n = nrow(d), mean_mpg = mean(d$mpg))) unlink(f)
Check if a hash index exists for a .vtr column
has_index(path, column)has_index(path, column)
path |
Path to a |
column |
Character vector. Name(s) of column(s). |
Logical scalar: TRUE if a .vtri index file exists.
f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = letters, val = 1:26, stringsAsFactors = FALSE), f) has_index(f, "id") # FALSE create_index(f, "id") has_index(f, "id") # TRUE unlink(c(f, paste0(f, ".id.vtri")))f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = letters, val = 1:26, stringsAsFactors = FALSE), f) has_index(f, "id") # FALSE create_index(f, "id") has_index(f, "id") # TRUE unlink(c(f, paste0(f, ".id.vtri")))
Limit results to first n rows
## S3 method for class 'vectra_node' head(x, n = 6L, ...)## S3 method for class 'vectra_node' head(x, n = 6L, ...)
x |
A |
n |
Number of rows to return. |
... |
Ignored. |
A data.frame with the first n rows.
Join two vectra tables
left_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) inner_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) right_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) full_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) semi_join(x, y, by = NULL, ...) anti_join(x, y, by = NULL, ...)left_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) inner_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) right_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) full_join(x, y, by = NULL, suffix = c(".x", ".y"), ...) semi_join(x, y, by = NULL, ...) anti_join(x, y, by = NULL, ...)
x |
A |
y |
A |
by |
A character vector of column names to join by, or a named vector
like |
suffix |
A character vector of length 2 for disambiguating non-key
columns with the same name (default |
... |
Ignored. |
All joins use a build-right, probe-left hash join. The entire right-side table is materialized into a hash table; left-side batches stream through. Memory cost is proportional to the right-side table size.
NA keys never match (SQL NULL semantics). Key types are auto-coerced
following the bool < int64 < double hierarchy. Joining string against
numeric keys is an error.
A vectra_node with the joined result.
f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = c(1, 2, 3), x = c(10, 20, 30)), f1) write_vtr(data.frame(id = c(1, 2, 4), y = c(100, 200, 400)), f2) left_join(tbl(f1), tbl(f2), by = "id") |> collect() unlink(c(f1, f2))f1 <- tempfile(fileext = ".vtr") f2 <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = c(1, 2, 3), x = c(10, 20, 30)), f1) write_vtr(data.frame(id = c(1, 2, 4), y = c(100, 200, 400)), f2) left_join(tbl(f1), tbl(f2), by = "id") |> collect() unlink(c(f1, f2))
Creates a link descriptor that specifies how to join a dimension table to a fact table via one or more key columns.
link(key, node)link(key, node)
key |
A character vector or named character vector specifying join keys.
Unnamed: same column name in both tables. Named: |
node |
A |
A vectra_link object.
f_obs <- tempfile(fileext = ".vtr") f_sp <- tempfile(fileext = ".vtr") write_vtr(data.frame(sp_id = 1:3, value = c(10, 20, 30)), f_obs) write_vtr(data.frame(sp_id = 1:3, name = c("A", "B", "C")), f_sp) lnk <- link("sp_id", tbl(f_sp)) unlink(c(f_obs, f_sp))f_obs <- tempfile(fileext = ".vtr") f_sp <- tempfile(fileext = ".vtr") write_vtr(data.frame(sp_id = 1:3, value = c(10, 20, 30)), f_obs) write_vtr(data.frame(sp_id = 1:3, name = c("A", "B", "C")), f_sp) lnk <- link("sp_id", tbl(f_sp)) unlink(c(f_obs, f_sp))
Resolves columns from dimension tables registered in a vtr_schema(),
automatically building the necessary join tree. Reports unmatched keys
as a diagnostic message.
lookup(.schema, ..., .join = "left", .report = TRUE)lookup(.schema, ..., .join = "left", .report = TRUE)
.schema |
A |
... |
Column references: bare names for fact columns, or
|
.join |
Join type: |
.report |
Logical. If |
Column references use dimension$column syntax (e.g., species$name).
Columns from the fact table can be referenced by name directly.
When .report = TRUE, each needed dimension is checked for unmatched keys
by opening fresh scans of the fact and dimension tables. This adds one
extra read pass per dimension but does not affect the lazy result node.
Only dimensions referenced in ... are joined. Unreferenced dimensions
are never scanned.
A vectra_node with the selected columns.
f_obs <- tempfile(fileext = ".vtr") f_sp <- tempfile(fileext = ".vtr") f_ct <- tempfile(fileext = ".vtr") write_vtr(data.frame(sp_id = 1:4, ct_code = c("AT", "DE", "FR", "XX"), value = 10:13), f_obs) write_vtr(data.frame(sp_id = 1:3, name = c("Oak", "Beech", "Pine")), f_sp) write_vtr(data.frame(ct_code = c("AT", "DE", "FR"), gdp = c(400, 3800, 2700)), f_ct) s <- vtr_schema( fact = tbl(f_obs), species = link("sp_id", tbl(f_sp)), country = link("ct_code", tbl(f_ct)) ) # Pull columns from any linked dimension result <- lookup(s, value, species$name, country$gdp) collect(result) unlink(c(f_obs, f_sp, f_ct))f_obs <- tempfile(fileext = ".vtr") f_sp <- tempfile(fileext = ".vtr") f_ct <- tempfile(fileext = ".vtr") write_vtr(data.frame(sp_id = 1:4, ct_code = c("AT", "DE", "FR", "XX"), value = 10:13), f_obs) write_vtr(data.frame(sp_id = 1:3, name = c("Oak", "Beech", "Pine")), f_sp) write_vtr(data.frame(ct_code = c("AT", "DE", "FR"), gdp = c(400, 3800, 2700)), f_ct) s <- vtr_schema( fact = tbl(f_obs), species = link("sp_id", tbl(f_sp)), country = link("ct_code", tbl(f_ct)) ) # Pull columns from any linked dimension result <- lookup(s, value, species$name, country$gdp) collect(result) unlink(c(f_obs, f_sp, f_ct))
Keeps the pixels of a .vec raster whose cell centre falls inside a resident
polygon layer and sets the rest to background, reading the raster one
tile-row strip at a time so the whole grid is never resident. It is the raster
counterpart of spatial_clip(): the streamed side is the (large) raster and
the small mask layer stays in memory. With inverse = TRUE the inside is
cleared and the outside kept.
mask( x, mask, inverse = FALSE, band = NULL, background = NA_real_, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )mask( x, mask, inverse = FALSE, band = NULL, background = NA_real_, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
x |
A |
mask |
An |
inverse |
If |
band |
Band(s) to mask (1-based). Default |
background |
Value written to cleared pixels. Default |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
This is the monoid fold tier of the spatial toolbox: bounded to one strip plus the resident mask, a single streaming pass, no spill. A pixel is tested against the mask only when its centre falls in the mask bounding box, so the point-in-polygon work stays proportional to the overlap rather than the whole grid. Point-in-polygon is delegated to sf (an optional dependency); topology and CRS handling are sf's.
When path is NULL, a numeric matrix (one band) or a list of
matrices (several), each carrying gt, extent, and crs attributes
(row 1 northmost). When path is given, the written vectra_raster handle
(invisibly).
spatial_clip() for the vector analogue, zonal() for per-zone
summaries over the same pixel-in-polygon assignment.
vals <- matrix(1:100, 10, 10, byrow = TRUE) f <- tempfile(fileext = ".vec") vec_write_raster(vals, f, dtype = "f64", extent = c(0, 0, 10, 10)) disc <- sf::st_buffer(sf::st_sfc(sf::st_point(c(5, 5))), 3) inside <- mask(f, disc) sum(!is.na(inside)) unlink(f)vals <- matrix(1:100, 10, 10, byrow = TRUE) f <- tempfile(fileext = ".vec") vec_write_raster(vals, f, dtype = "f64", extent = c(0, 0, 10, 10)) disc <- sf::st_buffer(sf::st_sfc(sf::st_point(c(5, 5))), 3) inside <- mask(f, disc) sum(!is.na(inside)) unlink(f)
Consumes a vectra node (pulling all batches) and stores the result as a
persistent columnar block in memory. Unlike nodes, blocks can be probed
repeatedly via block_lookup() without re-scanning.
materialize(.data)materialize(.data)
.data |
A |
A vectra_block object (external pointer to C-level ColumnBlock).
f <- tempfile(fileext = ".vtr") df <- data.frame(taxonID = 1:3, canonicalName = c("Quercus robur", "Pinus sylvestris", "Fagus sylvatica")) write_vtr(df, f) blk <- materialize(tbl(f) |> select(taxonID, canonicalName)) hits <- block_lookup(blk, "canonicalName", c("Quercus robur", "Pinus sylvestris")) unlink(f)f <- tempfile(fileext = ".vtr") df <- data.frame(taxonID = 1:3, canonicalName = c("Quercus robur", "Pinus sylvestris", "Fagus sylvatica")) write_vtr(df, f) blk <- materialize(tbl(f) |> select(taxonID, canonicalName)) hits <- block_lookup(blk, "canonicalName", c("Quercus robur", "Pinus sylvestris")) unlink(f)
Combines several .vec rasters that share a resolution and cell grid into one
raster spanning their union, resolving overlap with fun. The output is
walked one tile-row strip at a time and each input contributes only the window
overlapping the current strip, so neither the inputs nor the output are held
whole in memory.
mosaic( rasters, fun = c("first", "last", "mean", "sum", "min", "max"), band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )mosaic( rasters, fun = c("first", "last", "mean", "sum", "min", "max"), band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
rasters |
A list of |
fun |
Overlap rule where inputs cover the same cell: |
band |
Band read from every input (1-based). Default 1. |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
This is the monoid fold tier of the spatial toolbox: each output strip folds
the overlapping input windows, bounded memory, no spill. The inputs must share
resolution and lie on a common cell grid; warp() them onto a shared grid
first if they do not. No sf is needed.
When path is NULL, a numeric matrix on the union grid (row 1
northmost) carrying gt, extent, and crs attributes. When path is
given, the written vectra_raster handle (invisibly).
warp() to bring rasters onto a shared grid, rast_calc() for
cellwise combination of already-aligned rasters.
a <- matrix(1, 4, 4); b <- matrix(2, 4, 4) fa <- tempfile(fileext = ".vec"); fb <- tempfile(fileext = ".vec") vec_write_raster(a, fa, dtype = "f64", extent = c(0, 0, 4, 4)) vec_write_raster(b, fb, dtype = "f64", extent = c(2, 2, 6, 6)) m <- mosaic(list(fa, fb), fun = "mean") dim(m) unlink(c(fa, fb))a <- matrix(1, 4, 4); b <- matrix(2, 4, 4) fa <- tempfile(fileext = ".vec"); fb <- tempfile(fileext = ".vec") vec_write_raster(a, fa, dtype = "f64", extent = c(0, 0, 4, 4)) vec_write_raster(b, fb, dtype = "f64", extent = c(2, 2, 6, 6)) m <- mosaic(list(fa, fb), fun = "mean") dim(m) unlink(c(fa, fb))
Add or transform columns
mutate(.data, ...)mutate(.data, ...)
.data |
A |
... |
Named expressions for new or transformed columns. |
Supported expression types: arithmetic (+, -, *, /, %%),
comparison, boolean, is.na(), nchar(), substr(), grepl() (fixed
match only). Window functions (row_number(), rank(), dense_rank(),
lag(), lead(), cumsum(), cummean(), cummin(), cummax()) are
detected automatically and routed to a dedicated window node.
When grouped, window functions respect partition boundaries.
This is a streaming operation for regular expressions; window functions materialize all rows within each partition.
A new vectra_node with mutated columns.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> mutate(kpl = mpg * 0.425144) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> mutate(kpl = mpg * 0.425144) |> collect() |> head() unlink(f)
Materializes a query once to disk and returns a stream that holds the same
rows, so every later pass is a disk scan instead of a re-run of the upstream
pipeline. The materialization streams batch by batch, so peak memory stays at
one batch regardless of result size. This is the bridge from the bounded
single-pass world of collect_chunked() to out-of-core fits.
offload( x, by = NULL, n = NULL, method = c("auto", "level", "range", "hash"), path = NULL, compress = c("fast", "small", "none") )offload( x, by = NULL, n = NULL, method = c("auto", "level", "range", "hash"), path = NULL, compress = c("fast", "small", "none") )
x |
A |
by |
Optional name (string) of a partition key column. When supplied, the result is a partition rather than a single node. |
n |
Number of buckets for |
method |
Partition strategy: |
path |
Optional file path for a durable replay-cache spill (used only
when |
compress |
Compression for spill files, passed to |
With no by, offload() returns a replay cache: a vectra_node backed
by one .vtr file. Feed it to a pull-based consumer such as
biglm::bigglm() through chunk_feeder(), which accepts an offloaded node
directly, so each iteratively reweighted pass reads the prepared columns from
disk rather than rebuilding them. Bake the selects and mutates into the query
you offload, and replay does no further work.
With by, offload() returns a partition: the rows split into disjoint
shards, one per key value (discrete key) or per value range (method = "range", or any numeric key), written in a single streaming pass. A
partition prints as a list of shards and behaves like one: length(),
names() (the keys), p[["key"]] (a shard node), and lapply(p, ...) all
work. Fold it with collect_chunked() (supplying combine). The union of
the shards reproduces the input; row totals are checked.
A vectra_node (no by) or a vectra_partition (with by), each
carrying a cost grade shown by print() and explain().
chunk_feeder() (accepts an offloaded node), collect_chunked()
for the partitioned monoidal reduce, and arrange() for the external-sort
instance.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Replay cache: same rows, now on disk. s <- offload(tbl(f) |> filter(cyl > 4) |> select(mpg, wt, hp)) nrow(collect(s)) # Partition by a key: a list of per-shard nodes. p <- offload(tbl(f), by = "cyl") names(p) length(p) nrow(collect(p[[1]])) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Replay cache: same rows, now on disk. s <- offload(tbl(f) |> filter(cyl > 4) |> select(mpg, wt, hp)) nrow(collect(s)) # Partition by a key: a list of per-shard nodes. p <- offload(tbl(f), by = "cyl") names(p) length(p) nrow(collect(p[[1]])) unlink(f)
Converts a .vec raster into polygon features, the inverse of rasterize().
The raster is read one tile-row strip at a time; within each strip equal-valued
cells along a row collapse to a rectangle, and (with dissolve = TRUE) the
rectangles are then merged by value through spatial_dissolve() so each
distinct value becomes a single polygon spanning the whole raster. The result
is a lazy vectra_node carrying a value column and hex-WKB geometry.
polygonize( x, band = 1L, dissolve = TRUE, na_rm = TRUE, values = "value", crs = NA, flush_rows = NULL )polygonize( x, band = 1L, dissolve = TRUE, na_rm = TRUE, values = "value", crs = NA, flush_rows = NULL )
x |
A |
band |
Band to vectorise (1-based). Default 1. |
dissolve |
If |
na_rm |
Drop nodata cells ( |
values |
Name of the output value column. Default |
crs |
Coordinate reference system recorded on the node. Defaults to the raster's EPSG, else unknown. |
flush_rows |
Rows buffered before a spill flush. Defaults to
|
Extraction is the monoid fold tier (one strip at a time); the by-value
dissolve rides the sort / partition tier of spatial_dissolve(), localising
each value to a shard before the union. Geometry assembly is delegated to
sf (an optional dependency).
A vectra_node with the value column and a hex-WKB geometry column,
materialise it with collect_sf().
rasterize() for the inverse, contours() for iso-lines,
collect_sf() to materialise as sf.
m <- matrix(c(1, 1, 2, 2, 1, 1, 2, 2, 3, 3, 3, 3, 3, 3, 3, 3), 4, 4, byrow = TRUE) f <- tempfile(fileext = ".vec") vec_write_raster(m, f, dtype = "f64", extent = c(0, 0, 4, 4)) polys <- polygonize(f) collect_sf(polys) unlink(f)m <- matrix(c(1, 1, 2, 2, 1, 1, 2, 2, 3, 3, 3, 3, 3, 3, 3, 3), 4, 4, byrow = TRUE) f <- tempfile(fileext = ".vec") vec_write_raster(m, f, dtype = "f64", extent = c(0, 0, 4, 4)) polys <- polygonize(f) collect_sf(polys) unlink(f)
Print a vectra query node
## S3 method for class 'vectra_node' print(x, ...)## S3 method for class 'vectra_node' print(x, ...)
x |
A |
... |
Ignored. |
Invisible x.
Computes, for every cell of a .vec raster, the straight-line Euclidean
distance to the nearest feature cell, in CRS units. Feature cells are the
non-NA cells by default, or the cells whose value is in target. This is the
raster proximity / Euclidean-distance staple, the distance companion to
rasterize().
proximity( x, target = NULL, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )proximity( x, target = NULL, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
x |
A |
target |
Optional numeric vector of feature values. When |
band |
Band to read (1-based). Default 1. |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
The exact Euclidean distance transform is separable (Felzenszwalb and Huttenlocher 2012): a one-dimensional lower-envelope-of-parabolas transform along the rows, then the same transform along the columns, each linear in the line length and each line independent. vectra runs it as four streamed passes over tile-row strips, with an out-of-core transpose between the row pass and the column pass, so the whole grid is never resident. The row pass scales squared distances by the x resolution and the column pass by the y resolution, so the result is exact on anisotropic (non-square) cells. This places proximity on the sort / partition tier of the spatial toolbox.
Distances are straight-line Euclidean in the raster CRS units. Cost-distance,
which accumulates a per-cell friction along the path, is a global
shortest-path problem and stays resident: collect() the raster and run a
resident solver for that.
When path is NULL, a numeric matrix (row 1 northmost) carrying
gt, extent, and crs attributes, with distance in CRS units and NA
where the raster holds no feature anywhere. When path is given, the
written vectra_raster handle (invisibly).
rasterize() to build a raster from streamed points, mask() to
clip a raster to a polygon layer.
m <- matrix(NA_real_, 12, 12) m[3, 4] <- 1; m[9, 10] <- 1 f <- tempfile(fileext = ".vec") vec_write_raster(m, f, dtype = "f64", extent = c(0, 0, 12, 12)) d <- proximity(f) round(d[1:3, 1:3], 2) unlink(f)m <- matrix(NA_real_, 12, 12) m[3, 4] <- 1; m[9, 10] <- 1 f <- tempfile(fileext = ".vec") vec_write_raster(m, f, dtype = "f64", extent = c(0, 0, 12, 12)) d <- proximity(f) round(d[1:3, 1:3], 2) unlink(f)
Extract a single column as a vector
pull(.data, var = -1)pull(.data, var = -1)
.data |
A |
var |
Column name (unquoted) or positive integer position. |
A vector.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> pull(mpg) |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> pull(mpg) |> head() unlink(f)
Evaluates an expression cell by cell across one or more .vec rasters that
share a grid, reading every input one tile-row strip at a time so no whole
band is ever resident. Inside expr each name in rasters refers to that
raster's strip as a numeric vector, so ordinary vectorised R expresses the
calculation: a band index (nir - red) / (nir + red), a reclassification
cut(dem, breaks), a threshold ifelse(slope > 30, 1L, 0L), or arithmetic
across layers. The result is written one strip at a time to a single-band
output.
rast_calc( rasters, expr, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )rast_calc( rasters, expr, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
rasters |
A named list of |
expr |
An expression in those names producing one value per cell (or a scalar, recycled). Evaluated against each strip with the caller's environment as the enclosing scope. |
band |
Band read from every input (1-based). Default 1. |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
This is the monoid fold tier of the spatial toolbox: bounded to one strip
per input, a single streaming pass, no spill. The rasters must share
dimensions and geotransform; warp() them onto a common grid first if they
do not. No sf is needed.
When path is NULL, a numeric matrix (row 1 northmost) carrying
gt, extent, and crs attributes. When path is given, the written
vectra_raster handle (invisibly).
warp() to align rasters onto a shared grid first, focal() for
neighbourhood rather than cellwise calculation.
nir <- matrix(c(40, 50, 60, 70), 2, 2) red <- matrix(c(10, 20, 30, 40), 2, 2) fn <- tempfile(fileext = ".vec"); fr <- tempfile(fileext = ".vec") vec_write_raster(nir, fn, dtype = "f64", extent = c(0, 0, 2, 2)) vec_write_raster(red, fr, dtype = "f64", extent = c(0, 0, 2, 2)) ndvi <- rast_calc(list(nir = fn, red = fr), (nir - red) / (nir + red)) round(ndvi, 3) unlink(c(fn, fr))nir <- matrix(c(40, 50, 60, 70), 2, 2) red <- matrix(c(10, 20, 30, 40), 2, 2) fn <- tempfile(fileext = ".vec"); fr <- tempfile(fileext = ".vec") vec_write_raster(nir, fn, dtype = "f64", extent = c(0, 0, 2, 2)) vec_write_raster(red, fr, dtype = "f64", extent = c(0, 0, 2, 2)) ndvi <- rast_calc(list(nir = fn, red = fr), (nir - red) / (nir + red)) round(ndvi, 3) unlink(c(fn, fr))
Folds a larger-than-RAM stream of points into a fixed raster grid one batch
at a time. The grid (template) is held resident in memory while the points
flow past the engine, so peak memory is the grid plus one batch regardless of
how many points there are – the streaming counterpart to running
terra::rasterize() on a point set that has to fit in RAM. Each point's
coordinate is mapped to its grid cell through the raster geotransform and the
per-cell value is accumulated in C.
rasterize( x, template = NULL, field = NULL, fun = c("count", "sum", "mean", "min", "max"), extent = NULL, res = NULL, dims = NULL, coords = c("x", "y"), geom = NULL, crs = NA, background = NA_real_, path = NULL, dtype = "f32" )rasterize( x, template = NULL, field = NULL, fun = c("count", "sum", "mean", "min", "max"), extent = NULL, res = NULL, dims = NULL, coords = c("x", "y"), geom = NULL, crs = NA, background = NA_real_, path = NULL, dtype = "f32" )
x |
A |
template |
Optional grid to borrow geometry and CRS from: a
|
field |
Name of a numeric column to aggregate. Required for every |
fun |
Reduction over the points in each cell: one of |
extent |
Numeric |
res |
Cell size: a single number for square cells, or |
dims |
Grid shape |
coords |
Length-2 character vector naming the x and y coordinate
columns. Default |
geom |
Name of a hex-WKB point-geometry column to rasterize instead of coordinate columns. Requires sf. |
crs |
Coordinate reference system recorded on the output, in any form
|
background |
Value for cells that receive no point. Default |
path |
Optional output path. When given, the grid is written to a |
dtype |
Storage dtype for the |
The reduction fun is a monoid over the points falling in each cell:
"count" tallies points (no field needed); "sum", "mean", "min",
"max" aggregate a numeric field. Cells that receive no point take the
background value (NA by default). This is the monoid fold tier of the
spatial toolbox: bounded memory, a single streaming pass, no spill.
Points arrive either as two numeric coordinate columns (coords, the default
and fully sf-free path – the headline larger-than-RAM case) or decoded
from a hex-WKB point-geometry column (geom, which needs sf). Geometry
input is expected to be points (one coordinate per row); line and polygon
coverage rasterization is out of scope here.
When path is NULL, a numeric matrix with nrow grid rows
(row 1 northmost) and ncol grid columns, carrying gt, extent, res,
crs, and fun attributes. When path is given, the written
vectra_raster handle (invisibly).
vec_write_raster() and vec_to_tiff() for raster output,
spatial_join() to instead tag points with polygon attributes.
set.seed(1) n <- 1e4 pts <- data.frame(x = runif(n, 0, 10), y = runif(n, 0, 10), z = rnorm(n)) f <- tempfile(fileext = ".vtr") write_vtr(pts, f) # Point density on a 10x10 grid, streamed: the grid is resident, the # points are not. counts <- tbl(f) |> rasterize(extent = c(0, 0, 10, 10), dims = c(10, 10)) counts # Mean of z per cell. zmean <- tbl(f) |> rasterize(extent = c(0, 0, 10, 10), dims = c(10, 10), field = "z", fun = "mean") unlink(f)set.seed(1) n <- 1e4 pts <- data.frame(x = runif(n, 0, 10), y = runif(n, 0, 10), z = rnorm(n)) f <- tempfile(fileext = ".vtr") write_vtr(pts, f) # Point density on a 10x10 grid, streamed: the grid is resident, the # points are not. counts <- tbl(f) |> rasterize(extent = c(0, 0, 10, 10), dims = c(10, 10)) counts # Mean of z per cell. zmean <- tbl(f) |> rasterize(extent = c(0, 0, 10, 10), dims = c(10, 10), field = "z", fun = "mean") unlink(f)
Like summarise() but allows expressions that return more than one row
per group. Currently implemented via collect() fallback.
reframe(.data, ...)reframe(.data, ...)
.data |
A |
... |
Named expressions. |
A data.frame (not a lazy node).
f <- tempfile(fileext = ".vtr") write_vtr(data.frame(g = c("a", "a", "b"), x = c(1, 2, 3)), f) tbl(f) |> group_by(g) |> reframe(range_x = range(x)) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(data.frame(g = c("a", "a", "b"), x = c(1, 2, 3)), f) tbl(f) |> group_by(g) |> reframe(range_x = range(x)) unlink(f)
Relocate columns
relocate(.data, ..., .before = NULL, .after = NULL)relocate(.data, ..., .before = NULL, .after = NULL)
.data |
A |
... |
Column names to move. |
.before |
Column name to place before (unquoted). |
.after |
Column name to place after (unquoted). |
A new vectra_node with reordered columns.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> relocate(hp, wt, .before = cyl) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> relocate(hp, wt, .before = cyl) |> collect() |> head() unlink(f)
Rename columns
rename(.data, ...)rename(.data, ...)
.data |
A |
... |
Rename pairs: |
A new vectra_node with renamed columns.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> rename(miles_per_gallon = mpg) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> rename(miles_per_gallon = mpg) |> collect() |> head() unlink(f)
Select columns from a vectra query
select(.data, ...)select(.data, ...)
.data |
A |
... |
Column names (unquoted). |
A new vectra_node with only the selected columns.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> select(mpg, cyl) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> select(mpg, cyl) |> collect() |> head() unlink(f)
Select rows by position
slice(.data, ...)slice(.data, ...)
.data |
A |
... |
Integer row indices (positive or negative). |
A data.frame with the selected rows.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> slice(1, 3, 5) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> slice(1, 3, 5) unlink(f)
Select first or last rows
slice_head(.data, n = 1L) slice_tail(.data, n = 1L) slice_min(.data, order_by, n = 1L, with_ties = TRUE) slice_max(.data, order_by, n = 1L, with_ties = TRUE)slice_head(.data, n = 1L) slice_tail(.data, n = 1L) slice_min(.data, order_by, n = 1L, with_ties = TRUE) slice_max(.data, order_by, n = 1L, with_ties = TRUE)
.data |
A |
n |
Number of rows to select. |
order_by |
Column to order by (for |
with_ties |
If |
When slice_min()/slice_max() follow group_by(), the n smallest/largest
rows are taken within each group and the whole winning row is kept (every
column, including geometry carried as a string). with_ties = FALSE returns
exactly n rows per group via a deterministic ordered row_number();
with_ties = TRUE keeps rows tied at the nth value via min-rank. The grouped
path buffers its input (like all window operations) rather than streaming.
A vectra_node for slice_head(), for grouped
slice_min()/slice_max(), and for ungrouped slice_min/max(..., with_ties = FALSE). A data.frame for slice_tail() and ungrouped
slice_min/max(..., with_ties = TRUE) (the default), since these must
materialize all rows.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> slice_head(n = 3) |> collect() tbl(f) |> slice_min(order_by = mpg, n = 3) |> collect() tbl(f) |> slice_max(order_by = mpg, n = 3) |> collect() # earliest row per group, geometry/attrs preserved: tbl(f) |> group_by(cyl) |> slice_min(mpg, n = 1, with_ties = FALSE) |> collect() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> slice_head(n = 3) |> collect() tbl(f) |> slice_min(order_by = mpg, n = 3) |> collect() tbl(f) |> slice_max(order_by = mpg, n = 3) |> collect() # earliest row per group, geometry/attrs preserved: tbl(f) |> group_by(cyl) |> slice_min(mpg, n = 1, with_ties = FALSE) |> collect() unlink(f)
Streams a large layer x through the engine and cuts each batch's geometry
against a small resident mask (a study boundary, a buffer, a set of
patches). By default this clips – the intersection with the mask, the GIS
"Clip" tool – keeping only the parts of x that fall inside mask. With
erase = TRUE it instead erases – the difference, the "Erase"/"Difference"
tool – keeping the parts of x outside mask. The mask is dissolved to a
single geometry once and held resident while the billion-row left stream
flows past one batch at a time.
spatial_clip( x, mask, erase = FALSE, geom = "geometry", coords = NULL, crs = NA, out_geom = NULL, flush_rows = NULL )spatial_clip( x, mask, erase = FALSE, geom = "geometry", coords = NULL, crs = NA, out_geom = NULL, flush_rows = NULL )
x |
A |
mask |
An |
erase |
If |
geom |
Name of the input geometry column holding hex-WKB or WKT strings.
Default |
coords |
Optional length-2 character vector naming the x and y
coordinate columns to assemble point geometry from (e.g. |
crs |
Coordinate reference system of the input geometry, in any form
|
out_geom |
Name of the output geometry column. Defaults to |
flush_rows |
Transformed rows buffered before a spill flush. Larger
values mean fewer, bigger temporary files. Defaults to
|
Geometry travels through the engine as hex-encoded WKB in a string column and
the CRS is carried on the returned node; use collect_sf() to materialize.
Topology is sf/GEOS's; vectra supplies the streaming. When mask
carries no CRS it inherits the stream's.
A vectra_node of the cut geometry with x's attributes, backed by
temporary .vtr spills and carrying the input CRS.
spatial_filter() to keep whole features by location without
cutting them, spatial_map() for per-feature transforms, collect_sf().
nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) mask <- sf::st_union(nc[nc$NAME %in% c("Ashe", "Alleghany"), ]) f <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), f) # Clip every county polygon to the two-county mask, streaming. clipped <- tbl(f) |> spatial_clip(mask, crs = sf::st_crs(nc)) collect_sf(clipped) unlink(f)nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) mask <- sf::st_union(nc[nc$NAME %in% c("Ashe", "Alleghany"), ]) f <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), f) # Clip every county polygon to the two-county mask, streaming. clipped <- tbl(f) |> spatial_clip(mask, crs = sf::st_crs(nc)) collect_sf(clipped) unlink(f)
Unions the geometries within each by group into a single feature (the GIS
"Dissolve" tool), optionally summarising attributes. Unlike the streamed
per-batch verbs, dissolve needs every geometry of a group together to union
them, so it rides the partition tier: x is spilled once and routed into
one disjoint shard per group in a single bounded pass, then each shard is read
in and unioned with sf. Peak memory is the routing budget during the
pass, then one group's geometries while it is unioned – partition the input
on a key whose groups fit in memory. With no by, the whole layer dissolves
into one feature.
spatial_dissolve( x, by = NULL, ..., geom = "geometry", crs = NA, .fun = NULL, flush_rows = NULL )spatial_dissolve( x, by = NULL, ..., geom = "geometry", crs = NA, .fun = NULL, flush_rows = NULL )
x |
A |
by |
Character vector of attribute columns to dissolve within: one
output feature per distinct combination of their values. |
... |
Further arguments passed to |
geom |
Name of the input geometry column holding hex-WKB or WKT strings.
Default |
crs |
Coordinate reference system of the input geometry, in any form
|
.fun |
Optional named list of attribute summaries. Each element is a
function taking the group's data.frame and returning a length-1 value; the
list name becomes the output column (e.g.
|
flush_rows |
Transformed rows buffered before a spill flush. Larger
values mean fewer, bigger temporary files. Defaults to
|
Geometry travels through the engine as hex-encoded WKB in a string column and
the CRS is carried on the returned node; use collect_sf() to materialize.
Topology is sf/GEOS's; vectra supplies the streaming partition. The
sf package is an optional dependency (Suggests).
A vectra_node of one row per group – the by columns, any .fun
summaries, and the dissolved geometry – backed by temporary .vtr spills
removed when the node is garbage-collected, carrying the input CRS for
collect_sf().
spatial_overlay() to split overlaps apart rather than merge them,
offload() for the partition tier this rides on, collect_sf().
nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) nc$band <- nc$SID74 > 5 # an attribute to dissolve within f <- tempfile(fileext = ".vtr") write_vtr(data.frame( band = nc$band, BIR74 = nc$BIR74, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), f) # Merge the counties into two features by `band`, summing births. merged <- tbl(f) |> spatial_dissolve(by = "band", crs = sf::st_crs(nc), .fun = list(births = function(d) sum(d$BIR74))) collect_sf(merged) unlink(f)nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) nc$band <- nc$SID74 > 5 # an attribute to dissolve within f <- tempfile(fileext = ".vtr") write_vtr(data.frame( band = nc$band, BIR74 = nc$BIR74, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), f) # Merge the counties into two features by `band`, summing births. merged <- tbl(f) |> spatial_dissolve(by = "band", crs = sf::st_crs(nc), .fun = list(births = function(d) sum(d$BIR74))) collect_sf(merged) unlink(f)
Streams a large left side x through the engine and keeps each row whose
geometry satisfies an sf binary predicate against a small resident
layer y (select by location). This is the spatial counterpart to a
semi_join(): rows are filtered, never duplicated, and no columns are added,
so the output carries x's schema unchanged. With negate = TRUE it keeps
the rows that do not match (select by location, inverted). The billion-row
left stream never materializes; y (a study region, habitat patches, a
coastline buffer, ...) stays resident.
spatial_filter( x, y, predicate = NULL, negate = FALSE, geom = "geometry", coords = NULL, crs = NA, flush_rows = NULL )spatial_filter( x, y, predicate = NULL, negate = FALSE, geom = "geometry", coords = NULL, crs = NA, flush_rows = NULL )
x |
A |
y |
An |
predicate |
An sf binary predicate function, e.g.
sf::st_intersects (default), sf::st_within, sf::st_covered_by,
sf::st_is_within_distance. A left row is kept when the predicate reports
at least one match against |
negate |
If |
geom |
Name of the input geometry column holding hex-WKB or WKT strings.
Default |
coords |
Optional length-2 character vector naming the x and y
coordinate columns to assemble point geometry from (e.g. |
crs |
Coordinate reference system of the input geometry, in any form
|
flush_rows |
Transformed rows buffered before a spill flush. Larger
values mean fewer, bigger temporary files. Defaults to
|
Topology and CRS handling are sf's; vectra supplies the stream. When
y carries no CRS it inherits the stream's so the predicate does not reject
on a mismatch.
A vectra_node of the kept rows with x's schema, backed by
temporary .vtr spills and carrying the input CRS.
spatial_join() to tag rows with y's attributes, spatial_clip()
to cut geometry against a mask, filter() for attribute predicates.
nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) region <- nc[nc$NAME %in% c("Ashe", "Alleghany", "Surry"), "NAME"] set.seed(1) pts <- sf::st_coordinates(sf::st_sample(nc, 300)) f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = seq_len(nrow(pts)), x = pts[, 1], y = pts[, 2]), f) # Keep only the points that fall inside the three-county region, streaming. inside <- tbl(f) |> spatial_filter(region, coords = c("x", "y"), crs = sf::st_crs(nc)) nrow(collect(inside)) unlink(f)nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) region <- nc[nc$NAME %in% c("Ashe", "Alleghany", "Surry"), "NAME"] set.seed(1) pts <- sf::st_coordinates(sf::st_sample(nc, 300)) f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = seq_len(nrow(pts)), x = pts[, 1], y = pts[, 2]), f) # Keep only the points that fall inside the three-county region, streaming. inside <- tbl(f) |> spatial_filter(region, coords = c("x", "y"), crs = sf::st_crs(nc)) nrow(collect(inside)) unlink(f)
Streams a large left side x through the engine and joins each batch against
a small right side y held resident in memory, using an sf binary
predicate (st_intersects by default). This is the spatial analogue of a
hash join with the small side on the build side: the billion-row left stream
never materializes, while y (admin polygons, habitat patches, ...) stays in
RAM. The dominant real workload it serves is tagging huge point sets with the
polygon they fall in.
spatial_join( x, y, join = NULL, geom = "geometry", coords = NULL, crs = NA, left = TRUE, suffix = c(".x", ".y"), partition = NULL, y_geom = NULL, y_coords = NULL, out_geom = NULL, flush_rows = NULL, ... )spatial_join( x, y, join = NULL, geom = "geometry", coords = NULL, crs = NA, left = TRUE, suffix = c(".x", ".y"), partition = NULL, y_geom = NULL, y_coords = NULL, out_geom = NULL, flush_rows = NULL, ... )
x |
A |
y |
The right side of the join: an |
join |
An sf binary predicate function, e.g. sf::st_intersects (default), sf::st_within, sf::st_contains, sf::st_nearest_feature. |
geom |
Name of the input geometry column holding hex-WKB or WKT strings.
Default |
coords |
Optional length-2 character vector naming the x and y
coordinate columns to assemble point geometry from (e.g. |
crs |
Coordinate reference system of the input geometry, in any form
|
left |
If |
suffix |
Length-2 character vector disambiguating columns present on
both sides. Default |
partition |
Optional |
y_geom, y_coords
|
Geometry transport for a streamed |
out_geom |
Name of the output geometry column. Defaults to |
flush_rows |
Transformed rows buffered before a spill flush. Larger
values mean fewer, bigger temporary files. Defaults to
|
... |
Further arguments passed to |
When both sides are larger than RAM, pass partition = grid(cellsize) and a
streamed vectra_node as y: both inputs are binned to a uniform spatial
grid, then joined one shard at a time. Each left feature is assigned to the
single grid cell of its reference point while each right feature is
replicated to every cell its bounding box overlaps, so a left row is emitted
exactly once and the result equals the resident join. This is exact for point
left geometries (the dominant case – tagging a huge point set with the
polygon it falls in) and finds, for an extended left feature, the matches
whose right bounding box overlaps the left reference cell; choose a cellsize
larger than the left features for an extended-on-extended join. The partition
path serves topological predicates (intersects, within, contains, overlaps,
covers, covered by). It also serves sf::st_nearest_feature: because nearest
is not local to one cell, each left feature then searches its own cell and the
eight around it, so the true nearest is found when it lies within one cell of
the left reference cell (pick a cellsize at least the largest expected
nearest distance). Topology and CRS handling are sf's; vectra supplies
the stream and the grid partition.
A vectra_node of the joined stream, backed by temporary .vtr
spills and carrying the left CRS.
spatial_map() for per-feature transforms, collect_sf() to
materialize as sf, offload() to partition both-sides-huge joins.
nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) # A stream of points, stored with x/y coordinate columns. set.seed(1) pts <- sf::st_coordinates(sf::st_sample(nc, 200)) f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = seq_len(nrow(pts)), x = pts[, 1], y = pts[, 2]), f) # Tag each point with the county it falls in, streaming. tagged <- tbl(f) |> spatial_join(nc["NAME"], join = sf::st_intersects, coords = c("x", "y"), crs = sf::st_crs(nc)) head(collect(tagged)) # Both sides streamed: bin to a grid and join per shard. Here y is a # vectra_node rather than a resident sf object. g <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), g) tagged2 <- tbl(f) |> spatial_join(tbl(g), coords = c("x", "y"), crs = sf::st_crs(nc), partition = grid(0.5)) head(collect(tagged2)) unlink(c(f, g))nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) # A stream of points, stored with x/y coordinate columns. set.seed(1) pts <- sf::st_coordinates(sf::st_sample(nc, 200)) f <- tempfile(fileext = ".vtr") write_vtr(data.frame(id = seq_len(nrow(pts)), x = pts[, 1], y = pts[, 2]), f) # Tag each point with the county it falls in, streaming. tagged <- tbl(f) |> spatial_join(nc["NAME"], join = sf::st_intersects, coords = c("x", "y"), crs = sf::st_crs(nc)) head(collect(tagged)) # Both sides streamed: bin to a grid and join per shard. Here y is a # vectra_node rather than a resident sf object. g <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_geometry(nc), hex = TRUE) ), g) tagged2 <- tbl(f) |> spatial_join(tbl(g), coords = c("x", "y"), crs = sf::st_crs(nc), partition = grid(0.5)) head(collect(tagged2)) unlink(c(f, g))
Applies a per-feature sf operation (buffer, centroid, area, CRS
transform, simplify, ...) to a lazy vectra query one batch at a time and
returns a new lazy node. The engine pulls one batch, hands it to fn as an
sf object, encodes the result back into the stream, and spills to disk, so
peak memory is one batch regardless of result size. This is the streaming,
larger-than-RAM counterpart to running the same sf call on a whole
in-memory table.
spatial_map( x, fn, geom = "geometry", coords = NULL, crs = NA, out_geom = NULL, flush_rows = NULL )spatial_map( x, fn, geom = "geometry", coords = NULL, crs = NA, out_geom = NULL, flush_rows = NULL )
x |
A |
fn |
A function (or purrr-style formula such as |
geom |
Name of the input geometry column holding hex-WKB or WKT strings.
Default |
coords |
Optional length-2 character vector naming the x and y
coordinate columns to assemble point geometry from (e.g. |
crs |
Coordinate reference system of the input geometry, in any form
|
out_geom |
Name of the output geometry column. Defaults to |
flush_rows |
Transformed rows buffered before a spill flush. Larger
values mean fewer, bigger temporary files. Defaults to
|
Geometry travels through the engine as hex-encoded WKB in an ordinary string
column (vectra has no native geometry type), and the coordinate reference
system is carried on the returned node rather than in the .vtr file. Use
collect_sf() to materialize the result as an sf object, or collect()
to get the underlying data.frame with the WKB string column.
Topology is delegated entirely to sf/GEOS; vectra only supplies the
streaming. The sf package is an optional dependency (Suggests).
A vectra_node backed by temporary .vtr spills (removed when the
node is garbage-collected), carrying the output CRS for collect_sf().
spatial_join() to join a streamed side against a resident sf
object, collect_sf() to materialize as sf.
nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) f <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_centroid(sf::st_geometry(nc)), hex = TRUE) ), f) # Buffer every county centroid by 0.1 degree, streaming. buffered <- tbl(f) |> spatial_map(~ sf::st_buffer(.x, 0.1), crs = sf::st_crs(nc)) collect_sf(buffered) unlink(f)nc <- sf::st_read(system.file("shape/nc.shp", package = "sf"), quiet = TRUE) f <- tempfile(fileext = ".vtr") write_vtr(data.frame( NAME = nc$NAME, geometry = sf::st_as_binary(sf::st_centroid(sf::st_geometry(nc)), hex = TRUE) ), f) # Buffer every county centroid by 0.1 degree, streaming. buffered <- tbl(f) |> spatial_map(~ sf::st_buffer(.x, 0.1), crs = sf::st_crs(nc)) collect_sf(buffered) unlink(f)
Splits a polygon layer along all its own overlaps into disjoint pieces and
returns a lazy node with one row per piece per covering polygon: where k
polygons overlap, that piece appears k times, each row carrying one source
polygon's attributes. This is the union overlay GIS tools expose as
"Union (single layer)", with the overlap retained once per contributing
feature rather than dissolved. Resolve the duplicates with a grouped
slice_min() / slice_max() – for example earliest designation year wins:
group_by(piece_id) |> slice_min(year).
spatial_overlay( x, vars = NULL, piece = "piece_id", geom = "geometry", flush_rows = NULL, mem_limit = NULL, threads = NULL, quiet = TRUE )spatial_overlay( x, vars = NULL, piece = "piece_id", geom = "geometry", flush_rows = NULL, mem_limit = NULL, threads = NULL, quiet = TRUE )
x |
An |
vars |
Character vector of attribute columns of |
piece |
Name of the integer piece-id column added to the output (the key
you group by to resolve overlaps). Default |
geom |
Name of the output hex-WKB geometry column. Default |
flush_rows |
Exploded rows buffered before a spill flush. Defaults to
|
mem_limit |
Approximate peak working-set budget in bytes. Components are
grouped into chunks within this budget and each chunk is overlaid then
spilled before the next, so memory stays bounded regardless of layer size.
Raise it for more parallel throughput, lower it for tighter memory. Defaults
to |
threads |
Number of OpenMP threads for the per-component overlay within a
chunk. |
quiet |
If |
The topology is done once with sf/GEOS and tiled over connected overlap
clusters (disjoint clusters never share a piece, so the tiling is exact and
bounded in memory), then the exploded pieces are streamed to a .vtr and
handed back as a lazy node. Geometry rides through the engine as hex-encoded
WKB in a string column; the CRS is carried on the node for collect_sf().
The overlay runs on a fixed-precision model: coordinates are snapped to a
grid derived from their own magnitude so the pieces come out disjoint and
their areas reconstruct the union of the inputs, instead of drifting by the
fraction of a percent that floating-point sliver artefacts on invalid input
otherwise introduce. Inputs are also passed through sf::st_make_valid().
The input x must be a resident sf object: building the overlap graph and
intersecting needs the geometries in memory. The exploded result, which is
typically several times larger, is what streams to disk.
A vectra_node over the exploded overlay (one row per piece per
covering polygon), backed by temporary .vtr spills removed when the node
is garbage-collected, carrying the CRS of x for collect_sf().
slice_min() / slice_max() to resolve each piece to one winner,
collect_sf() to materialize as sf.
# Two overlapping squares designated in different years. sq <- function(a, b) sf::st_polygon(list(rbind( c(a, 0), c(b, 0), c(b, 1), c(a, 1), c(a, 0)))) polys <- sf::st_sf(year = c(1990L, 2010L), geometry = sf::st_sfc(sq(0, 2), sq(1, 3))) # Split into disjoint pieces; earliest year wins where they overlap. first <- spatial_overlay(polys) |> group_by(piece_id) |> slice_min(year, n = 1, with_ties = FALSE) |> collect_sf() first# Two overlapping squares designated in different years. sq <- function(a, b) sf::st_polygon(list(rbind( c(a, 0), c(b, 0), c(b, 1), c(a, 1), c(a, 0)))) polys <- sf::st_sf(year = c(1990L, 2010L), geometry = sf::st_sfc(sq(0, 2), sq(1, 3))) # Split into disjoint pieces; earliest year wins where they overlap. first <- spatial_overlay(polys) |> group_by(piece_id) |> slice_min(year, n = 1, with_ties = FALSE) |> collect_sf() first
Summarise grouped data
summarise(.data, ..., .groups = NULL) summarize(.data, ..., .groups = NULL)summarise(.data, ..., .groups = NULL) summarize(.data, ..., .groups = NULL)
.data |
A grouped |
... |
Named aggregation expressions using |
.groups |
How to handle groups in the result. One of |
Aggregation is hash-based by default. When the engine detects it is advantageous, it switches to a sort-based path that can spill to disk, keeping memory bounded regardless of group count.
All aggregation functions accept na.rm = TRUE to skip NA values.
Without na.rm, any NA in a group poisons the result (returns NA).
R-matching edge cases: sum(na.rm = TRUE) on all-NA returns 0,
mean(na.rm = TRUE) on all-NA returns NaN, min/max(na.rm = TRUE) on
all-NA returns Inf/-Inf with a warning.
This is a materializing operation.
A vectra_node with one row per group.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> group_by(cyl) |> summarise(avg_mpg = mean(mpg)) |> collect() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> group_by(cyl) |> summarise(avg_mpg = mean(mpg)) |> collect() unlink(f)
Opens a vectra1 file and returns a lazy query node. No data is read until
collect() is called.
tbl(path)tbl(path)
path |
Path to a |
A vectra_node object representing a lazy scan of the file.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) node <- tbl(f) print(node) unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) node <- tbl(f) print(node) unlink(f)
Opens a CSV file for lazy, streaming query execution. Column types are
inferred from the first 1000 rows. No data is read until collect() is
called. Gzip-compressed files (.csv.gz) are supported transparently.
tbl_csv(path, batch_size = .DEFAULT_BATCH_SIZE)tbl_csv(path, batch_size = .DEFAULT_BATCH_SIZE)
path |
Path to a |
batch_size |
Number of rows per batch (default 65536). |
A vectra_node object representing a lazy scan of the CSV file.
f <- tempfile(fileext = ".csv") write.csv(mtcars, f, row.names = FALSE) node <- tbl_csv(f) print(node) unlink(f)f <- tempfile(fileext = ".csv") write.csv(mtcars, f, row.names = FALSE) node <- tbl_csv(f) print(node) unlink(f)
Opens a SQLite database and lazily scans a table. Column types are inferred
from declared types in the CREATE TABLE statement. All filtering, grouping,
and aggregation is handled by vectra's C engine — no SQL parsing needed.
No data is read until collect() is called.
tbl_sqlite(path, table, batch_size = .DEFAULT_BATCH_SIZE)tbl_sqlite(path, table, batch_size = .DEFAULT_BATCH_SIZE)
path |
Path to a SQLite database file. |
table |
Name of the table to scan. |
batch_size |
Number of rows per batch (default 65536). |
A vectra_node object representing a lazy scan of the table.
f <- tempfile(fileext = ".sqlite") write_sqlite(mtcars, f, "cars") node <- tbl_sqlite(f, "cars") node |> filter(cyl == 6) |> collect() unlink(f)f <- tempfile(fileext = ".sqlite") write_sqlite(mtcars, f, "cars") node <- tbl_sqlite(f, "cars") node |> filter(cyl == 6) |> collect() unlink(f)
Opens a GeoTIFF file and returns a lazy query node. Each pixel becomes a row
with columns x, y, band1, band2, etc. Coordinates are pixel centers
derived from the affine geotransform. NoData values become NA.
tbl_tiff(path, batch_size = .TIFF_BATCH_SIZE)tbl_tiff(path, batch_size = .TIFF_BATCH_SIZE)
path |
Path to a GeoTIFF file. |
batch_size |
Number of raster rows per batch (default 256). |
Use filter(x >= ..., y <= ...) for extent-based cropping and
filter(band1 > ...) for value-based cropping. Results can be converted
back to a raster with terra::rast(df, type = "xyz").
A vectra_node object representing a lazy scan of the raster.
f <- tempfile(fileext = ".tif") df <- data.frame(x = as.double(rep(1:4, 3)), y = as.double(rep(1:3, each = 4)), band1 = as.double(1:12)) write_tiff(df, f) node <- tbl_tiff(f) node |> filter(band1 > 6) |> collect() unlink(f)f <- tempfile(fileext = ".tif") df <- data.frame(x = as.double(rep(1:4, 3)), y = as.double(rep(1:3, each = 4)), band1 = as.double(1:12)) write_tiff(df, f) node <- tbl_tiff(f) node |> filter(band1 > 6) |> collect() unlink(f)
Reads a sheet from an Excel workbook into a vectra node for lazy query
execution. The sheet is read into memory via
openxlsx2::read_xlsx() and then converted
to vectra's internal format. Requires the openxlsx2 package.
tbl_xlsx(path, sheet = 1L, batch_size = .DEFAULT_BATCH_SIZE)tbl_xlsx(path, sheet = 1L, batch_size = .DEFAULT_BATCH_SIZE)
path |
Path to an |
sheet |
Sheet to read: either a name (character) or 1-based index
(integer). Default |
batch_size |
Number of rows per batch (default 65536). |
A vectra_node object representing a lazy scan of the sheet.
if (requireNamespace("openxlsx2", quietly = TRUE)) { f <- tempfile(fileext = ".xlsx") openxlsx2::write_xlsx(mtcars, f) node <- tbl_xlsx(f) node |> filter(cyl == 6) |> collect() unlink(f) }if (requireNamespace("openxlsx2", quietly = TRUE)) { f <- tempfile(fileext = ".xlsx") openxlsx2::write_xlsx(mtcars, f) node <- tbl_xlsx(f) node |> filter(cyl == 6) |> collect() unlink(f) }
Computes DEM derivatives from a .vec elevation raster with Horn's 3x3
method, on the same haloed tile-row strip pass as focal() – the input is
read one strip at a time and, when path is given, the outputs are streamed
straight back to a multi-band .vec. Matches terra's
terrain() / shade() conventions.
terrain( x, v = c("slope", "aspect", "hillshade", "TPI", "roughness", "TRI"), unit = c("degrees", "radians"), azimuth = 315, altitude = 45, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )terrain( x, v = c("slope", "aspect", "hillshade", "TPI", "roughness", "TRI"), unit = c("degrees", "radians"), azimuth = 315, altitude = 45, band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
x |
A |
v |
Derivatives to compute, any of |
unit |
Angular unit for |
azimuth, altitude
|
Sun position for |
band |
Band to read (1-based). Default 1. |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
Slope and aspect use the Horn (1981) finite-difference gradient over
the 3x3 neighbourhood; aspect is degrees clockwise from north (flat cells
return 90). hillshade is the cosine of the incidence angle for the given
sun position, clamped at 0. TPI is the cell minus the mean of its eight
neighbours; roughness is the range over the 3x3; TRI is the mean
absolute difference to the eight neighbours. Cells whose 3x3 neighbourhood
touches a nodata value or the raster edge return NA.
When path is NULL: a numeric matrix for a single v, or a named
list of matrices for several, each carrying gt, extent, and crs
attributes (row 1 northmost). When path is given, the written multi-band
vectra_raster handle (invisibly).
focal() for arbitrary moving windows.
# A tilted surface so slope and aspect are well defined. z <- outer(1:8, 1:8, function(r, c) 10 + 2 * c + r) f <- tempfile(fileext = ".vec") vec_write_raster(z, f, dtype = "f64", extent = c(0, 0, 8, 8)) slp <- terrain(f, v = "slope") deriv <- terrain(f, v = c("slope", "aspect", "hillshade")) names(deriv) unlink(f)# A tilted surface so slope and aspect are well defined. z <- outer(1:8, 1:8, function(r, c) 10 + 2 * c + r) f <- tempfile(fileext = ".vec") vec_write_raster(z, f, dtype = "f64", extent = c(0, 0, 8, 8)) slp <- terrain(f, v = "slope") deriv <- terrain(f, v = c("slope", "aspect", "hillshade")) names(deriv) unlink(f)
Returns the band names embedded in the file's GDAL_METADATA XML
(TIFF tag 42112). GDAL writes per-band names as
<Item name="DESCRIPTION" sample="N" role="description">...</Item> entries,
where sample is the 0-based band index. Bands without a name in the XML
are reported as NA. Files with no GDAL_METADATA tag at all return a
length-nbands vector of NA_character_.
tiff_band_names(path)tiff_band_names(path)
path |
Path to a GeoTIFF file. |
This is a small, dependency-free scanner intended for the common case
(terra::names(r) <- ... and similar). For arbitrary XML, parse the raw
string from tiff_metadata() yourself.
A character vector of length nbands. Element i is the name
of band i (or NA_character_ if the file does not name it).
f <- tempfile(fileext = ".tif") df <- data.frame(x = rep(1:2, 2), y = rep(1:2, each = 2), band1 = as.double(1:4), band2 = as.double(5:8)) xml <- paste0( "<GDALMetadata>", "<Item name=\"DESCRIPTION\" sample=\"0\" role=\"description\">temperature</Item>", "<Item name=\"DESCRIPTION\" sample=\"1\" role=\"description\">humidity</Item>", "</GDALMetadata>") write_tiff(df, f, metadata = xml) tiff_band_names(f) unlink(f)f <- tempfile(fileext = ".tif") df <- data.frame(x = rep(1:2, 2), y = rep(1:2, each = 2), band1 = as.double(1:4), band2 = as.double(5:8)) xml <- paste0( "<GDALMetadata>", "<Item name=\"DESCRIPTION\" sample=\"0\" role=\"description\">temperature</Item>", "<Item name=\"DESCRIPTION\" sample=\"1\" role=\"description\">humidity</Item>", "</GDALMetadata>") write_tiff(df, f, metadata = xml) tiff_band_names(f) unlink(f)
Returns the spatial reference system embedded in a GeoTIFF, parsed from
the GeoKey directory (TIFF tag 34735). The projected CRS EPSG
(PCSTypeGeoKey 3072) is preferred over the geographic CRS EPSG
(GeographicTypeGeoKey 2048). Citation strings are read from
GeoAsciiParams (tag 34737) with priority PCS > GeoTIFF > geographic.
tiff_crs(path)tiff_crs(path)
path |
Path to a GeoTIFF file. |
Files written without a GeoKey directory return NA for both fields.
A list with elements epsg (integer or NA_integer_) and
citation (character or NA_character_).
f <- tempfile(fileext = ".tif") df <- data.frame(x = 1:4, y = rep(1:2, each = 2), band1 = as.double(1:4)) write_tiff(df, f) tiff_crs(f) # epsg = NA, citation = NA — vectra writer omits GeoKeys unlink(f)f <- tempfile(fileext = ".tif") df <- data.frame(x = 1:4, y = rep(1:2, each = 2), band1 = as.double(1:4)) write_tiff(df, f) tiff_crs(f) # epsg = NA, citation = NA — vectra writer omits GeoKeys unlink(f)
Samples band values from a GeoTIFF at specific (x, y) locations using the file's affine geotransform. Only the strips containing query points are read, making this efficient for sparse point sets on large rasters.
tiff_extract_points(path, x, y = NULL)tiff_extract_points(path, x, y = NULL)
path |
Path to a GeoTIFF file. |
x |
Numeric vector of x coordinates, or a data.frame / matrix with
columns named |
y |
Numeric vector of y coordinates (ignored if |
Points that fall outside the raster extent return NA for all bands.
Pixel assignment uses nearest-pixel rounding (i.e., the point is assigned to
the pixel whose center is closest).
A data.frame with columns x, y, band1, band2, etc.
One row per input point, in the same order as the input.
f <- tempfile(fileext = ".tif") df <- data.frame(x = as.double(rep(1:4, 3)), y = as.double(rep(1:3, each = 4)), band1 = as.double(1:12)) write_tiff(df, f) # Sample at specific locations via data.frame pts <- data.frame(x = c(2, 3), y = c(1, 2)) tiff_extract_points(f, pts) # Or pass x and y separately tiff_extract_points(f, x = c(2, 3), y = c(1, 2)) unlink(f)f <- tempfile(fileext = ".tif") df <- data.frame(x = as.double(rep(1:4, 3)), y = as.double(rep(1:3, each = 4)), band1 = as.double(1:12)) write_tiff(df, f) # Sample at specific locations via data.frame pts <- data.frame(x = c(2, 3), y = c(1, 2)) tiff_extract_points(f, pts) # Or pass x and y separately tiff_extract_points(f, x = c(2, 3), y = c(1, 2)) unlink(f)
Returns the GDAL_METADATA XML string (TIFF tag 42112) embedded in a
GeoTIFF file. Returns NA if the tag is not present.
tiff_metadata(path)tiff_metadata(path)
path |
Path to a GeoTIFF file. |
A single character string containing the XML, or NA_character_.
f <- tempfile(fileext = ".tif") df <- data.frame(x = 1:4, y = rep(1:2, each = 2), band1 = as.double(1:4)) write_tiff(df, f, metadata = "<GDALMetadata></GDALMetadata>") tiff_metadata(f) unlink(f)f <- tempfile(fileext = ".tif") df <- data.frame(x = 1:4, y = rep(1:2, each = 2), band1 = as.double(1:4)) write_tiff(df, f, metadata = "<GDALMetadata></GDALMetadata>") tiff_metadata(f) unlink(f)
Like mutate() but drops all other columns.
transmute(.data, ...)transmute(.data, ...)
.data |
A |
... |
Named expressions. |
A new vectra_node with only the computed columns.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> transmute(kpl = mpg * 0.425) |> collect() |> head() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> transmute(kpl = mpg * 0.425) |> collect() |> head() unlink(f)
Remove grouping from a vectra query
ungroup(x, ...)ungroup(x, ...)
x |
A |
... |
Ignored. |
An ungrouped vectra_node.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> group_by(cyl) |> ungroup() unlink(f)f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) tbl(f) |> group_by(cyl) |> ungroup() unlink(f)
Appends n_levels - 1 reduced-resolution copies of the raster to the
file. Each level is computed by 2x downsampling the previous level
with the chosen kernel. Reading via vec_read_window(level = L)
picks tiles at level L; the file's n_levels is updated in place.
vec_build_overviews( path, levels, resampling = c("average", "nearest", "bilinear", "mode", "gauss"), compression = c("fast", "balanced", "max") )vec_build_overviews( path, levels, resampling = c("average", "nearest", "bilinear", "mode", "gauss"), compression = c("fast", "balanced", "max") )
path |
Path to a |
levels |
Total levels including level 0 (so |
resampling |
One of |
compression |
Compression effort for the new tiles. Defaults to
|
Invisible NULL.
Idempotent. The handle is also auto-released by R's garbage collector.
vec_close_raster(r)vec_close_raster(r)
r |
A |
Invisible NULL.
Extract band values at (x, y) points from a .vec raster
vec_extract_points(r, x, y)vec_extract_points(r, x, y)
r |
A |
x |
Numeric vector of x coordinates in CRS units. |
y |
Numeric vector of y coordinates, same length as |
A data.frame with columns x, y, then one column per band
(named after r$band_names if recorded, otherwise band1, band2,
...). NA marks pixels outside the raster or matching nodata.
Lazy open: parses the header and tile index but does not decode any
tiles. Returns a list with metadata and an external pointer handle.
The pointer is auto-finalized when garbage collected; call
vec_close_raster() to release earlier.
vec_open_raster(path)vec_open_raster(path)
path |
Path to a |
A vectra_raster list with elements:
ptr, width, height, n_bands, tile_size, dtype, gt,
epsg, nodata, band_names.
Returns "image" (default Phase 6 layout — one tile per
(band, time, ty, tx)) or "pixel" (Phase 6b transpose layout — one
tile per (band, ty, tx) holding the full time stack).
vec_raster_layout(r)vec_raster_layout(r)
r |
A |
Character(1) "image" or "pixel".
Returns the ascending vector of time stamps recorded for the given (band, level). Pixel-major files store one consolidated table; image- major files derive the list from the per-tile time field.
vec_raster_times(r, band = 1L, level = 0L)vec_raster_times(r, band = 1L, level = 0L)
r |
A |
band |
1-based band index. |
level |
Overview level. |
Numeric vector of stamps (length 0 when the file has no time information).
Returns a numeric vector of length n_time — one value per time step
recorded in the file, in ascending time-stamp order.
vec_read_pixel_series( r, x = NULL, y = NULL, col = NULL, row = NULL, band = 1L, level = 0L )vec_read_pixel_series( r, x = NULL, y = NULL, col = NULL, row = NULL, band = 1L, level = 0L )
r |
A |
x, y
|
Pixel coordinates. Either both |
col, row
|
1-based pixel coordinates (alternative to x/y). |
band |
Band index (1-based). |
level |
Overview level. Default 0. |
For pixel-major files (written with
vec_write_time_cube(layout = "pixel")) this is the optimal access
pattern: a single tile decode yields all time values for the pixel.
For image-major files the reader scans the index for distinct time
stamps, decodes one spatial tile per stamp, and extracts the pixel
from each — correct but n_time slower than the optimal layout.
A numeric vector of length n_time. NA marks pixels outside
the raster or matching nodata. The corresponding time stamps can
be obtained from vec_raster_times(r, band, level).
Performs a linear scan of the index for tiles with time == time and
decodes the matching window. The lookup is O(n_tiles) per call — Phase
6's optimized hash-map lookup is a follow-up.
vec_read_time_slice(r, time, band = 1L, level = 0L, cols = NULL, rows = NULL)vec_read_time_slice(r, time, band = 1L, level = 0L, cols = NULL, rows = NULL)
r |
A |
time |
Time value to match (numeric/integer). |
band |
Band index (1-based). |
level |
Overview level. Default 0. |
cols, rows
|
1-based ranges, same as |
A numeric matrix.
Decodes only the tiles overlapping the requested window. Pixels outside
the raster extent come back as NA.
vec_read_window(r, band = 1L, level = 0L, cols = NULL, rows = NULL)vec_read_window(r, band = 1L, level = 0L, cols = NULL, rows = NULL)
r |
A |
band |
Band index (1-based). Default 1. |
level |
Overview level — 0 = full resolution, 1 = half, 2 =
quarter, etc. Must be < |
cols |
1-based column range |
rows |
1-based row range |
A numeric matrix with nrow = row_max - row_min + 1 and
ncol = col_max - col_min + 1. Nodata pixels become NA.
Writes the level-0 pixels of a .vec raster to a GeoTIFF file. The
TIFF inherits dtype, geotransform, EPSG, and nodata from the source.
Strip layout; the writer supports "none", "deflate", and "lzw"
compression. LZW also applies horizontal differencing (Predictor 2)
for integer pixel types, which dramatically improves compression on
smooth raster data and matches the layout most production GIS tools
produce by default. Tiled and BigTIFF output land in a follow-up.
vec_to_tiff(r, path, compression = c("deflate", "lzw", "none"))vec_to_tiff(r, path, compression = c("deflate", "lzw", "none"))
r |
Either a path to a |
path |
Output |
compression |
One of |
Invisible NULL.
Writes a row-major raster (one band) or a band-major 3D array (multi-band) to the VECR raster format. Each tile is encoded as a self-describing tdc block (PRED_2D + BYTE_SHUFFLE + LZ).
vec_write_raster( x, path, dtype = "f32", tile_size = 512L, extent = NULL, gt = NULL, epsg = 0L, nodata = NA_real_, band_names = NULL, compression = c("fast", "balanced", "max") )vec_write_raster( x, path, dtype = "f32", tile_size = 512L, extent = NULL, gt = NULL, epsg = 0L, nodata = NA_real_, band_names = NULL, compression = c("fast", "balanced", "max") )
x |
A numeric matrix |
path |
Output file path. |
dtype |
Storage dtype, one of |
tile_size |
Square tile edge in pixels. Default 512. |
extent |
Numeric vector |
gt |
Numeric(6) GDAL-style geotransform. Overrides |
epsg |
EPSG code (integer) or 0L for none. |
nodata |
Nodata value, or |
band_names |
Optional character vector of length equal to the number of bands. |
compression |
Compression effort, one of |
Invisible NULL.
Each (band, time) combination becomes a stack of tiles tagged with the
chosen time stamp. Stamps are stored as int64 in the per-tile index
entry; a value of 0 is reserved for "untimed" so this writer remaps
any caller-supplied 0 to 1 internally.
vec_write_time_cube( x, times, path, dtype = "f32", tile_size = 512L, layout = c("image", "pixel"), extent = NULL, gt = NULL, epsg = 0L, nodata = NA_real_, band_names = NULL, compression = c("fast", "balanced", "max") )vec_write_time_cube( x, times, path, dtype = "f32", tile_size = 512L, layout = c("image", "pixel"), extent = NULL, gt = NULL, epsg = 0L, nodata = NA_real_, band_names = NULL, compression = c("fast", "balanced", "max") )
x |
Numeric 4D array |
times |
Numeric/integer vector with |
path |
Output |
dtype |
Storage dtype (see |
tile_size |
Tile edge in pixels. |
layout |
Tile layout — one of |
extent, gt, epsg, nodata, band_names, compression
|
Same semantics as
|
Invisible NULL.
Registers a fact table with named dimension links. The schema enables
lookup() to resolve columns from dimension tables without writing
explicit joins.
vtr_schema(fact, ...)vtr_schema(fact, ...)
fact |
A |
... |
Named |
A vectra_schema object.
f_obs <- tempfile(fileext = ".vtr") f_sp <- tempfile(fileext = ".vtr") f_ct <- tempfile(fileext = ".vtr") write_vtr(data.frame(sp_id = 1:3, ct_code = c("AT", "DE", "FR"), value = 10:12), f_obs) write_vtr(data.frame(sp_id = 1:3, name = c("Oak", "Beech", "Pine")), f_sp) write_vtr(data.frame(ct_code = c("AT", "DE", "FR"), gdp = c(400, 3800, 2700)), f_ct) s <- vtr_schema( fact = tbl(f_obs), species = link("sp_id", tbl(f_sp)), country = link("ct_code", tbl(f_ct)) ) print(s) unlink(c(f_obs, f_sp, f_ct))f_obs <- tempfile(fileext = ".vtr") f_sp <- tempfile(fileext = ".vtr") f_ct <- tempfile(fileext = ".vtr") write_vtr(data.frame(sp_id = 1:3, ct_code = c("AT", "DE", "FR"), value = 10:12), f_obs) write_vtr(data.frame(sp_id = 1:3, name = c("Oak", "Beech", "Pine")), f_sp) write_vtr(data.frame(ct_code = c("AT", "DE", "FR"), gdp = c(400, 3800, 2700)), f_ct) s <- vtr_schema( fact = tbl(f_obs), species = link("sp_id", tbl(f_sp)), country = link("ct_code", tbl(f_ct)) ) print(s) unlink(c(f_obs, f_sp, f_ct))
Warps a .vec raster onto a target grid, walking the output one tile-row
strip at a time. For each strip the target pixel-centre coordinates are built,
projected into the source coordinate reference system when the two CRSs differ
(delegated to PROJ via sf), mapped through the source geotransform to
fractional source pixels, and sampled from the bounded source window those
coordinates fall in. The output is assembled in memory or streamed straight
back to a new .vec, so the whole output grid is never resident; the source
is read in bounded windows rather than held whole.
warp( x, template, method = c("near", "bilinear", "cubic"), band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )warp( x, template, method = c("near", "bilinear", "cubic"), band = 1L, path = NULL, dtype = "f32", compression = c("fast", "balanced", "max") )
x |
A |
template |
The target grid: a |
method |
Resampling method: |
band |
Band to warp (1-based). Default 1. |
path |
Optional output |
dtype |
Storage dtype for |
compression |
Compression effort for |
This is the sort / partition tier of the spatial toolbox: each output strip reads the source window it projects onto. For a mild reprojection or a plain resample that window is a thin band; a strong reprojection can make it large, but the output stays streamed throughout.
Sampling follows the GDAL / terra convention (pixel centres at
half-integer coordinates). "near" takes the nearest source cell;
"bilinear" the 2x2 weighted mean; "cubic" the 4x4 cubic convolution
(Catmull-Rom, a = -0.5). A target cell whose sampling kernel reaches outside
the source extent, or touches a nodata cell, comes back NA.
Reprojection happens only when both rasters carry a known EPSG code and the
codes differ; otherwise warp() resamples within a shared CRS and needs no
sf.
When path is NULL, a numeric matrix on the target grid (row 1
northmost) carrying gt, extent, and crs attributes. When path is
given, the written vectra_raster handle (invisibly).
rasterize() to build a raster from streamed vector features,
focal() for moving-window statistics.
z <- outer(1:8, 1:8, function(r, c) r + 2 * c) f <- tempfile(fileext = ".vec") vec_write_raster(z, f, dtype = "f64", extent = c(0, 0, 8, 8)) # Resample onto a finer grid over the same extent. fine <- warp(f, list(extent = c(0, 0, 8, 8), res = 0.5), method = "bilinear") dim(fine) unlink(f)z <- outer(1:8, 1:8, function(r, c) r + 2 * c) f <- tempfile(fileext = ".vec") vec_write_raster(z, f, dtype = "f64", extent = c(0, 0, 8, 8)) # Resample onto a finer grid over the same extent. fine <- warp(f, list(extent = c(0, 0, 8, 8), res = 0.5), method = "bilinear") dim(fine) unlink(f)
For vectra_node inputs, data is streamed batch-by-batch to disk without
materializing the full result in memory. For data.frame inputs, the data
is written directly.
write_csv(x, path, ...)write_csv(x, path, ...)
x |
A |
path |
File path for the output CSV file. |
... |
Reserved for future use. |
Invisible NULL.
f <- tempfile(fileext = ".vtr") write_vtr(mtcars[1:5, ], f) csv <- tempfile(fileext = ".csv") tbl(f) |> write_csv(csv) unlink(c(f, csv))f <- tempfile(fileext = ".vtr") write_vtr(mtcars[1:5, ], f) csv <- tempfile(fileext = ".csv") tbl(f) |> write_csv(csv) unlink(c(f, csv))
For vectra_node inputs, data is streamed batch-by-batch to disk without
materializing the full result in memory. For data.frame inputs, the data
is written directly.
write_sqlite(x, path, table, ...)write_sqlite(x, path, table, ...)
x |
A |
path |
File path for the SQLite database. |
table |
Name of the table to create/write into. |
... |
Reserved for future use. |
Invisible NULL.
db <- tempfile(fileext = ".sqlite") f <- tempfile(fileext = ".vtr") write_vtr(mtcars[1:5, ], f) tbl(f) |> write_sqlite(db, "cars") unlink(c(f, db))db <- tempfile(fileext = ".sqlite") f <- tempfile(fileext = ".vtr") write_vtr(mtcars[1:5, ], f) tbl(f) |> write_sqlite(db, "cars") unlink(c(f, db))
The data must contain x and y columns (pixel center coordinates) and
one or more numeric band columns. Grid dimensions and geotransform are
inferred from the x/y coordinate arrays. Missing pixels are written as NaN
(or the type-appropriate nodata value for integer pixel types).
write_tiff( x, path, compress = FALSE, pixel_type = "float64", metadata = NULL, crs = NULL, tiled = FALSE, tile_size = 256L, bigtiff = "auto", ... )write_tiff( x, path, compress = FALSE, pixel_type = "float64", metadata = NULL, crs = NULL, tiled = FALSE, tile_size = 256L, bigtiff = "auto", ... )
x |
A |
path |
File path for the output GeoTIFF file. |
compress |
Logical; use DEFLATE compression? Default |
pixel_type |
Character string specifying the output pixel type.
One of |
metadata |
Optional character string of GDAL_METADATA XML to embed
in the file (tag 42112). Use |
crs |
Optional CRS to embed as a GeoKey directory (TIFF tag 34735).
Accepts an integer EPSG code, an |
tiled |
Logical; write a tiled GeoTIFF (TIFF tags 322/323/324/325)
instead of strips. Default |
tile_size |
Integer; tile edge length in pixels. Must be a positive
multiple of 16 (TIFF spec). Either a single value (square tiles) or a
length-2 vector |
bigtiff |
Controls BigTIFF dispatch. |
... |
Reserved for future use. |
Invisible NULL.
# Write as int16 with DEFLATE compression and an EPSG:4326 GeoKey df <- data.frame(x = 1:4, y = rep(1:2, each = 2), band1 = c(100, 200, 300, 400)) f <- tempfile(fileext = ".tif") write_tiff(df, f, compress = TRUE, pixel_type = "int16", crs = 4326L) tiff_crs(f) unlink(f)# Write as int16 with DEFLATE compression and an EPSG:4326 GeoKey df <- data.frame(x = 1:4, y = rep(1:2, each = 2), band1 = c(100, 200, 300, 400)) f <- tempfile(fileext = ".tif") write_tiff(df, f, compress = TRUE, pixel_type = "int16", crs = 4326L) tiff_crs(f) unlink(f)
For vectra_node inputs (lazy queries from any format: CSV, SQLite, TIFF,
or another .vtr), data is streamed batch-by-batch to disk without
materializing the full result in memory. Each batch becomes one row group.
The output file is written atomically (via temp file + rename) so readers
never see a partial file.
write_vtr( x, path, compress = c("fast", "small", "none"), batch_size = NULL, col_types = NULL, quantize = NULL, spatial = NULL, ... )write_vtr( x, path, compress = c("fast", "small", "none"), batch_size = NULL, col_types = NULL, quantize = NULL, spatial = NULL, ... )
x |
A |
path |
File path for the output .vtr file. |
compress |
Compression level: |
batch_size |
Target number of rows per row group in the output file.
Defaults to 131072 for data.frames (1 MB per double column, cache-friendly
for decompression). For nodes, defaults to |
col_types |
Optional named character vector specifying narrow integer
storage types. Names must match column names; values must be |
quantize |
Optional named list for lossy quantization of |
spatial |
Optional list for 2D spatial predictor encoding. Either a
global spec applied to all numeric columns ( |
... |
Additional arguments passed to methods. |
For data.frame inputs, the data is written directly from memory.
Invisible NULL.
# From a data.frame f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Streaming format conversion (CSV -> VTR) csv <- tempfile(fileext = ".csv") write.csv(mtcars, csv, row.names = FALSE) f2 <- tempfile(fileext = ".vtr") tbl_csv(csv) |> write_vtr(f2) unlink(c(f, f2, csv))# From a data.frame f <- tempfile(fileext = ".vtr") write_vtr(mtcars, f) # Streaming format conversion (CSV -> VTR) csv <- tempfile(fileext = ".csv") write.csv(mtcars, csv, row.names = FALSE) f2 <- tempfile(fileext = ".vtr") tbl_csv(csv) |> write_vtr(f2) unlink(c(f, f2, csv))
Reduces a raster to one summary row per zone, streaming the raster one
tile-row strip at a time so the whole grid never has to be resident. Zones
come either from a second raster aligned to the value grid (each pixel's zone
is that raster's value, the terra::zonal pattern) or from an sf
polygon layer (each pixel is assigned the polygon its centre falls in). The
per-zone running moments (count, sum, sum of squares, min, max) are folded in
memory as strips arrive, so peak memory is one strip plus the small per-zone
table regardless of raster size. This is the monoid fold tier of the
spatial toolbox: bounded memory, a single streaming pass, no spill.
zonal( raster, zones, fun = "mean", band = 1L, zone_band = 1L, zone_field = NULL, na.rm = TRUE )zonal( raster, zones, fun = "mean", band = 1L, zone_band = 1L, zone_field = NULL, na.rm = TRUE )
raster |
A |
zones |
The zones to summarise within: a |
fun |
One or more of |
band |
Band of the value |
zone_band |
Band of a raster |
zone_field |
For an |
na.rm |
If |
sd is derived from the streamed moments
(sqrt((sum2 - sum^2 / n) / (n - 1))), so it needs no second pass. With
na.rm = TRUE (the default) nodata pixels are skipped; with na.rm = FALSE
any nodata pixel in a zone makes that zone's sum/mean/min/max/sd
NA, matching the resident behaviour. count always reports the number of
non-nodata cells in the zone.
Polygon zones delegate point-in-polygon to sf (an optional dependency); raster zones are fully sf-free. The zone raster must share the value raster's dimensions and geotransform.
A data.frame with a zone column (sorted) followed by one column per
fun, one row per zone.
rasterize() to build a value raster from streamed points,
vec_open_raster() to open the inputs.
# A value raster and an aligned 2x2-block zone raster on a 4x4 grid. vals <- matrix(1:16, 4, 4, byrow = TRUE) zone <- matrix(c(1, 1, 2, 2, 1, 1, 2, 2, 3, 3, 4, 4, 3, 3, 4, 4), 4, 4, byrow = TRUE) fv <- tempfile(fileext = ".vec"); fz <- tempfile(fileext = ".vec") vec_write_raster(vals, fv, dtype = "f64", extent = c(0, 0, 4, 4)) vec_write_raster(zone, fz, dtype = "f64", extent = c(0, 0, 4, 4)) zonal(fv, fz, fun = c("mean", "sum", "count")) unlink(c(fv, fz))# A value raster and an aligned 2x2-block zone raster on a 4x4 grid. vals <- matrix(1:16, 4, 4, byrow = TRUE) zone <- matrix(c(1, 1, 2, 2, 1, 1, 2, 2, 3, 3, 4, 4, 3, 3, 4, 4), 4, 4, byrow = TRUE) fv <- tempfile(fileext = ".vec"); fz <- tempfile(fileext = ".vec") vec_write_raster(vals, fv, dtype = "f64", extent = c(0, 0, 4, 4)) vec_write_raster(zone, fz, dtype = "f64", extent = c(0, 0, 4, 4)) zonal(fv, fz, fun = c("mean", "sum", "count")) unlink(c(fv, fz))