Use ST_Degeneralize to decompose low-level grids into high-level grids - ApsaraDB RDS

Decomposes a geographic grid or grid array into a higher-resolution grid array.

Syntax

geomgrid[] ST_Degeneralize(geomgrid gridcode, integer precision);

geomgrid[] ST_Degeneralize(geomgrid[] gridarray, integer precision);

Parameter	Description
`gridcode`	The geographic grid object.
`gridarray`	The array of geographic grids.
`precision`	The decomposition level.

Returns a geomgrid[] array of geographic grids.

Decompose a single grid G01 to decomposition level 3:

SELECT ST_AsText(ST_Degeneralize(ST_GridFromText('G01'), 3));

Result:

{G010,G011,G012,G013}

Decompose a grid array to decomposition level 2:

SELECT ST_AsText(ST_Degeneralize(ARRAY[ST_GridFromText('GZ01'), ST_GridFromText('GZ1')], 2));

Result:

{GZ01,GZ10,GZ12,GZ14,GZ16,GZ11,GZ13,GZ15,GZ17}