Returns an XYZ tile URL template (with {z}/{x}/{y} placeholders) for the
msens TiTiler factory. The SQL is canonicalized (whitespace collapsed) then
base64url-encoded. Consistent canonicalization is critical so repeated calls
with equivalent SQL produce identical URLs — Varnish keys on the full URL.
Usage
cell_tile_url(
sql,
colormap = "spectral_r",
rescale = NULL,
color = NULL,
mtime = NULL,
base = "https://titilecache.marinesensitivity.org"
)Arguments
- sql
character(1); SELECT returning
cell_idandvaluecolumns- colormap
character; rio-tiler colormap name (default: "spectral_r")
- rescale
numeric length-2
c(min, max)for normalization;NULLlets the server auto-compute from the SQL result on each tile request (prefer a client-side value fromcell_stats()for cache stability)- color
character(1); hex
#rrggbbor#rrggbbaafor a single-color mask. When set, the server renders every valid pixel in this flat color (ignoringcolormap+rescale) — useful for binary "cell is present / cell is outside X" overlays.- mtime
character; optional cache-bust tag, typically the mtime of the source DuckDB file (e.g. from
file.info(sdm_db)$mtime). Distinct from the data version tag (v6,v7, ...) used in paths.- base
character; base URL of the titilecache service