This topic describes the ST_Tile function, which generates a MVT-formatted standard binary structure based on the ID of a tile from a pyramid.
Syntax
bytea ST_Tile(cstring name, cstring key);
bytea ST_Tile(cstring name, int x, int y, int z);Parameters
| Parameter | Description |
|---|---|
| name | The name of the pyramid. |
| key | The ID of the tile. |
| x | The x value in the tile ID. |
| y | The y value in the tile ID. |
| z | The z value in the tile ID. |
Description
This function returns a MVT-formatted standard binary structure that is generated
based on the ID of a tile from a pyramid. The tile ID that is specified by the key
parameter is encoded in the 'z_x_y' format based on the EPSG:4326 or EPSG:3857 coordinate system.
Note If the
EPSG:4326 coordinate system is used, the number of chunks on the x axis is twice the number
of chunks on the y axis. The z value starts from 1. If the z value is 1, the tile
ID can only be 1_0_0 or 1_1_0.
Example
select ST_Tile('roads', '3_1_6');
st_tile
----------
0xFFAABB8D8A6678...
select ST_Tile('roads', 1, 6, 3);
st_tile
----------
0xFFAABB8D8A6678...