Skip to content
DuckDB Extensions All extensions GeoSilo

Introspection (native) functions in the GeoSilo DuckDB extension

Function category

Introspection (native)

9 functions

ST_* overloads with native GEOSILO implementations — type, emptiness, point count, X/Y, and the four bounding-box accessors. They read the silo header / delta stream directly without round-tripping through WKB, which is where the speed-up on bounding-box prefilters and per-row coordinate access comes from.

ST_GeometryType

Scalar function Introspection (native)
Signature
ST_GeometryType(col0: GEOSILO) → VARCHAR
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — returns the geometry type (e.g. POINT, POLYGON) by reading a single byte of the silo header. No WKB decode.

Related functions

ST_IsEmpty

Scalar function Introspection (native)
Signature
ST_IsEmpty(col0: GEOSILO) → BOOLEAN
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — TRUE if the encoded geometry has no vertices.

Related functions

ST_NPoints

Scalar function Introspection (native)
Signature
ST_NPoints(col0: GEOSILO) → INTEGER
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — total vertex count, read from the silo header.

Related functions

ST_X

Scalar function Introspection (native)
Signature
ST_X(col0: GEOSILO) → DOUBLE
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — X coordinate of a single-point geometry, decoded from the silo header without materializing a GEOMETRY.

Related functions

ST_XMax

Scalar function Introspection (native)
Signature
ST_XMax(col0: GEOSILO) → DOUBLE
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — maximum X across the geometry. Walks the integer delta stream; no WKB decode.

Related functions

ST_XMin

Scalar function Introspection (native)
Signature
ST_XMin(col0: GEOSILO) → DOUBLE
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — minimum X across the geometry, computed by walking the integer delta stream. Pair with ST_XMax / ST_YMin / ST_YMax for native bounding-box prefilters.

Related functions

ST_Y

Scalar function Introspection (native)
Signature
ST_Y(col0: GEOSILO) → DOUBLE
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — Y coordinate of a single-point geometry, decoded from the silo header without materializing a GEOMETRY.

Related functions

ST_YMax

Scalar function Introspection (native)
Signature
ST_YMax(col0: GEOSILO) → DOUBLE
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — maximum Y across the geometry. Walks the integer delta stream; no WKB decode.

Related functions

ST_YMin

Scalar function Introspection (native)
Signature
ST_YMin(col0: GEOSILO) → DOUBLE
Arguments (Positional)
Argument col0 Type GEOSILO Mode Positional Description
Description

Native GEOSILO overload — minimum Y across the geometry. Walks the integer delta stream; no WKB decode.

Related functions