Convert latitude and longitude to H3Grid using ST_H3FromLatLng - PolarDB

Converts a latitude and longitude pair into an H3Grid object.

Syntax

h3grid ST_H3FromLatLng(float lat, float lng, Integer level)

Parameter	Description
`lat`	The latitude.
`lng`	The longitude.
`level`	The layer of the grid. Default value: 15.

The following examples convert a latitude-longitude pair to an H3Grid object.

Default level (15)

select st_astext(st_h3fromlatlng(20.5,128.2));
    st_astext
-----------------
 8f4a1266884c4f0

Explicit level (8)

select st_astext(st_h3fromlatlng(20.5,128.2,8));
    st_astext
-----------------
 884a126689fffff