ST_GridFromText-PolarDB(PolarDB)-阿里云帮助中心

Converts a grid object string into the geomgrid data type.

Syntax

geomgrid ST_GridFromText(text  XYCode);
geomgrid ST_GridFromText(text  XYCode, text  ZCode);

Parameters

Parameter	Description
XYCode	The 2D grid code expressed in string format.
ZCode	The height code in 3D grid split encoding.

Examples

SELECT ST_GridFromText('G0013103220310313');

   st_gridfromtext    
----------------------
 0102001074271B122020

SELECT ST_AsText(ST_GridFromText('G00131032223023031031','+10010'));
       st_astext        
------------------------
 GZ00262064446046072072