tiler
ADVANCED
We currently provide support to create H3 tilesets.
create_spatial_index_tileset
Description
Creates a tileset that uses H3 spatial index, aggregating data from an input table.
Aggregated data is computed for all levels between resolution_min
and resolution_max
. For each resolution level, all tiles for the area covered by the source table are added, with data aggregated at level resolution + aggregation resolution
.
source_table
:STRING
that can either be a quoted qualified table name (e.g.`project-id.dataset-id.table-name`
) or a full query (e.g.SELECT * FROM `project-id.dataset-id.table-name`
).target_table
: Where the resulting table will be stored. It must be aSTRING
of the form`catalog.schema.table-name`
. Thecatalog
andschema
can be omitted (in which case the default ones will be used). The caller needs to have permissions over the schema to create a new table on it. The process will fail if the target table already exists.options
:STRING
containing a valid JSON with the different options. Valid options are described the table below.
Option | Description |
---|---|
| Default: |
| Default: |
| Default: |
| A |
| Default: |
| Default: No properties. A JSON |
| Default: |
Examples
You can execute the H3 Tiler in a databricks notebook (see full example below). The only mandatory args in options argument is the input resolution.
Last updated