Skip to contents

Build an h3t tile SQL query for the SPUE effort proxy

Source: R/taxon.R
obis_spue_sql.Rd

Live per-cell value = records(target subtree) / records(effort subtree), restricted to the effort taxon's footprint. Both subtrees are resolved with recursive CTEs over the baked taxon table, so this works for arbitrary ranks. Projects exactly cell_id, value, n (with n = effort record count), as the h3t service requires. See calc_spue() for the pinned R reference.

Usage

obis_spue_sql(
  num_aphiaid,
  den_aphiaid,
  res_max = 7L,
  res_placeholder = "{{res}}"
)

Arguments

num_aphiaid

target-taxon AphiaID(s) (numerator subtree).

den_aphiaid

effort-taxon AphiaID(s) (denominator subtree); typically a higher-order taxon such as the target's parent class.

res_max

cap on H3 resolution (1-7); see obis_h3t_sql().

res_placeholder

resolution placeholder; default "{{res}}". The h3t tile server prunes each tile automatically via hex_prune (see obis_h3t_sql()), so the emitted SQL carries no client-side bbox.

Value

a SQL string.