ST_Level

语法

integer ST_Level(geomgrid gridcode);
integer[] ST_Level(geomgrid[] gridcode);
integer ST_Level(h3grid gridcode);

参数

描述

获取单个地理网格或地理网格数组的层级，对于地理网格数组，返回层级范围。

示例

select st_level(ST_GridFromText('GZ0026206440'));
 st_level 
----------
       10

select st_level(st_as3dgrid('srid=4490;GEOMETRYCOLLECTION Z (MULTIPOLYGON Z (((116 39 5000,116.12 39 5000,116.12 39.09 5000,116 39.09 5000,116 39 5000),
(116.024 39.018 5000,116.024 39.045 5000,116.06 39.045 5000,116.06 39.018 5000,116.024 39.018 5000))),
POINT Z (116 39 5000),MULTILINESTRING Z ((116 39 5000,116.024 39 5000),(116.012 39.009 5000,116.024 39.018 5000)),
POLYHEDRALSURFACE Z (((116 39 0,116 39 1000,116 39.009 0,116 39 0)),((116 39 0,116 39.009 0,116.012 39 0,116 39 0)),
((116 39 0,116.012 39 0,116 39 1000,116 39 0)),((116.012 39 0,116 39.009 0,116 39 1000,116.012 39 0))))'::geometry, 
20,true));
 st_level 
----------
 {19,20}

-- H3编码
select st_level(st_h3frombinary('\x010100ffff9f6826a18408'));
 st_level 
----------
        8