ST_GridPath_云原生数据库 PolarDB(PolarDB)-阿里云帮助中心

获取两个H3格网之间的路径。

语法

setof h3grid ST_GridPath(h3grid start, h3grid end);

参数

参数名称	描述
start	起始h3grid网格对象。
end	终止h3grid网格对象。

示例

SELECT ST_GridPath(st_h3fromlatlng(25.1,123.1,8),st_h3fromlatlng(25.2,123.2,8));
      st_gridpath
------------------------
 010100FFFF1F63C5BA8408
 010100FFFFBF63C5BA8408
 010100FFFF7F61C5BA8408
 010100FFFF3F61C5BA8408
 010100FFFFDF6CC5BA8408
 010100FFFF1F6CC5BA8408
 010100FFFFBF6CC5BA8408
 010100FFFF7F93C1BA8408
 010100FFFF3F93C1BA8408
 010100FFFFDF9EC1BA8408
 010100FFFF9F9EC1BA8408
 010100FFFF5F9CC1BA8408
 010100FFFF1F9CC1BA8408
 010100FFFF3F9CC1BA8408
 010100FFFFDF9DC1BA8408
 010100FFFF9F9DC1BA8408
 010100FFFF5F8EC1BA8408
 010100FFFF1F8EC1BA8408
(18 rows)