DuckDB Extensions
Measurement (native) functions in the GeoSilo DuckDB extension
Function category
Measurement (native)
3 functionsST_* overloads for area, length, and perimeter computed directly on the integer delta stream (shoelace on int64 for area). No WKB decode, no GEOS dependency surface for these calls.
Signature
ST_Area(col0: GEOSILO) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
GEOSILO
|
Mode Positional | Description |
Description
Native GEOSILO overload — polygon area computed via the shoelace formula directly on int64 coordinates rebuilt from the delta stream. Skips the WKB decode entirely.
Related functions
Signature
ST_Length(col0: GEOSILO) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
GEOSILO
|
Mode Positional | Description |
Description
Native GEOSILO overload — total length of linear geometries, computed on the integer delta stream without rehydrating a GEOMETRY.
Related functions
Signature
ST_Perimeter(col0: GEOSILO) → DOUBLE
Arguments (Positional)
| Argument | Type | Mode | Description |
|---|---|---|---|
Argument
col0
|
Type
GEOSILO
|
Mode Positional | Description |
Description
Native GEOSILO overload — perimeter of polygonal geometries, computed on the integer delta stream without rehydrating a GEOMETRY.