Skip to main content
Return the geometry at index n (1-based) of a multi-geometry column. SQL reference: ST_GeometryN

Signature

Parameters

ColumnOrName
required
Multi-geometry column to get from.
Union[ColumnOrName, int]
required
Index to select, given as an integer or integer column, 1-based index, returns null if index is greater than maximum index.

Returns

Column
Geometry located at index n in multi_geometry as a geometry column.

Raises

  • ValueError: If n is an integer and less than 1.