Categories:: Geospatial functions

H3_UNCOMPACT_CELLS_STRINGS¶

Returns an array of VARIANT values that contain the VARCHAR hexadecimal IDs of H3 cells at the specified resolution that cover the same area as the H3 cells in the input.

语法

H3_UNCOMPACT_CELLS_STRINGS( <array_of_cell_ids> , <target_resolution> )

实参

array_of_cell_ids

An array of VARIANT values that contain VARCHAR hexadecimal values that represent H3 cell IDs (indexes (https://h3geo.org/docs/core-library/h3Indexing)).

target_resolution

An INTEGER value between 0 and 15 (inclusive) specifying the H3 resolution (https://h3geo.org/docs/core-library/restable) that you want to use for the returned H3 cells.

指定其他任何 INTEGER 值都会导致错误。

返回 ARRAY 数据类型的值或 NULL。

If the input is an array of VARIANT values that contain VARCHAR hexadecimal values, returns an array of VARIANT values that contain the VARCHAR hexadecimal values that represent the set of H3 cells at the specified resolution.
如果输入为 NULL，则返回 NULL，不报错。

使用说明

输入中的所有 VARCHAR 十六进制值都必须代表有效的 H3 单元格。
The input cells cannot have a higher resolution than the resolution specified in the target_resolution argument.

示例

The following example returns an uncompacted set of H3 cells that represent valid H3 cell IDs and a target resolution of 10.

SELECT H3_UNCOMPACT_CELLS_STRINGS(
  [
    '8a2a1072339ffff',
    '892a1072377ffff'
  ],
  10
) AS uncompacted;

+----------------------+
| UNCOMPACTED          |
%----------------------%
| [                    |
|   "8a2a1072339ffff", |
|   "8a2a10723747fff", |
|   "8a2a1072374ffff", |
|   "8a2a10723757fff", |
|   "8a2a1072375ffff", |
|   "8a2a10723767fff", |
|   "8a2a1072376ffff", |
|   "8a2a10723777fff"  |
| ]                    |
+----------------------+