Builds the SQL for the four serving paths at each resolution: the
precomputed all-taxa layer (idx_h3), the precomputed EOV layer
(idx_h3_eov), the live EOV subtree over occ_h3, and the SPUE effort
proxy (two recursive subtrees).
Usage
obis_bench_queries(
res = c(3L, 5L, 7L),
eov = "fish",
num_aphiaid = 137092L,
den_aphiaid = 2688L,
esn = 50L
)Value
named character vector of SQL, ready for obis_bench().