Skip to main content
Returns the numeric index (a long integer) representing the XZ2 value. Only supports data in lon/lat format. XZ2 is a 2D space filling curve that is used to index 2D data. Compared to a GeoHash, it provides improved sorting for non-point data that takes into account the bounding box of the geometry.

​
Signatures

ST_XZ2(geom: Geometry, precision: Integer)

​
Parameters

​
geom
Geometry
required
The input geometry.
​
precision
Integer
required
The number of decimal places.

​
Return type

The numeric XZ2 index value.

​
Example

SELECT ST_XZ2(ST_GeomFromText('POLYGON ((-1 -11, 0 10, 1 11, 2 12, -1 -11))'), 6)

1281