All Products
Search
Document Center

ApsaraDB RDS:ST_Children

Last Updated:Sep 22, 2023

This topic describes the ST_Children function. This function obtains the child grid of an H3-encoded geographic grid object at a specified layer.

Syntax

setof h3grid ST_Children(h3grid code, integer level);

Parameters

Parameter

Description

code

The H3-encoded geographic grid object.

level

The layer. By default, the layer above the layer at which the H3-encoded geographic grid object resides is used.

Examples

-- By default, the layer below the layer at which the H3-encoded geographic grid object resides is used.
select st_astext(st_children(st_h3fromtext('884a126689fffff')));
    st_astext    
-----------------
 894a1266883ffff
 894a1266887ffff
 894a126688bffff
 894a126688fffff
 894a1266893ffff
 894a1266897ffff
 894a126689bffff