vertex_extract()

Extracts the specified coordinate (X, Y, Z, M) from a point geometry

Reference: DuckDB 2.0.0

Arguments & returns

vertex_extract(geom, coordinate)

Scalar
Overload link geomcoordinate Returns
#01 GEOMETRYVARCHAR DOUBLE

Catalog examples

SELECT
  vertex_extract ('POINT(1 2 3)', 'Z');