PolarDB:ST_AsBinary

Syntax

bytea ST_AsBinary(geomgrid grid)
bytea ST_AsBinary(h3grid grid)

Parameters

Examples

Convert a 2D GeomGrid to binary

The following example creates a GeomGrid from a POINT geometry at SRID 4490, grid level 15, then converts it to binary using ST_AsBinary.

WITH g AS (
  SELECT unnest(ST_AsGrid(
    ST_GeomFromText('POINT(116.31522216796875 39.910277777777778)', 4490), 15)) AS grid
)
SELECT ST_AsBinary(grid) FROM g;

Result:

   st_asbinary
--------------------
 \x0102000f74271236

Convert a 3D GeomGrid to binary

The following example creates a 3D GeomGrid from a point with Z coordinate 1001.8 at SRID 4490, grid level 20, then converts it to binary.

SELECT ST_AsBinary(unnest(ST_As3DGrid(
  'srid=4490;POINT(116.31522216796875 39.910277777777778 1001.8)'::geometry, 20)));

Result:

          st_asbinary
--------------------------------
 \x0102401474271236362412000000

Convert an H3Grid to binary

The following example creates an H3Grid from a latitude/longitude coordinate at resolution 8, then converts it to binary.

-- H3Grid
SELECT ST_AsBinary(ST_H3FromLatLng(20.5, 128.2, 8));

Result:

       st_asbinary
--------------------------
 \x010100ffff9f6826a18408