Description
The ST_HexagonBoundary function returns a WritableGeometry that defines
the boundary of a cell in a grid if given a unique ID for the location. It also can return
the boundary of the cell that contains the given point at the specified precision. The shape
of the cell is a hexagon.
Syntax
ST_HexagonBoundary(String UNIQUE_ID)
Parameters
| Parameter |
Type |
Description |
|
UNIQUE_ID
|
String |
The unique geohash identifier of a cell in a grid. |
Return Values
| Return Type |
Description |
| WritableGeometry |
A representation of the boundary of a cell in a grid. |
Examples
SELECT ST_HexagonBoundary(hashStringId) FROM table;
SELECT ST_HexagonBoundary("PF625028642");
Syntax
ST_HexagonBoundary(Number|String X, Number|String Y, Number precision)
Parameters
| Parameter |
Type |
Description |
|
X
|
Number or String |
The longitude value of the point. |
|
Y
|
Number or String |
The latitude value of the point. |
|
precision
|
Number |
The length of the string key to be returned. The precision determines how large
the grid cells are (longer strings means higher precision and smaller grid
cells). |
Return Values
| Return Type |
Description |
| WritableGeometry |
The boundary of the grid cell at the given precision that the point falls
into. |
Examples
SELECT ST_HexagonBoundary(x, y, precision) FROM table;
SELECT ST_HexagonBoundary(-73.750333, 42.736103, 3);