Skip to contents

Executes the read-only SELECT cell_id, value, n produced by obis_h3t_sql(), obis_eov_sql() or obis_spue_sql() with the {{res}} placeholder bound to one resolution, and returns the cells keyed on the hex string (H3 BIGINT ids exceed R's double precision, so never carry them as numbers in R).

Usage

obis_h3t_query(con, sql, res, res_placeholder = "{{res}}")

Arguments

con

connection from obis_store_connect().

sql

tile SQL containing {{res}} (or already resolved).

res

H3 resolution to bind (1-7).

res_placeholder

the placeholder string in sql.

Value

data frame with cell (hex string), value, n.