MI_NumGeometries - spectrum_spatial - Latest

Spectrum Spatial Guide

Product type
Software
Portfolio
Locate
Product family
Spectrumâ„¢ software
Product
Spectrumâ„¢ software > Spatial > Spectrum Spatial
Version
Latest
ft:locale
en-US
Product name
Spectrum Technology Platform
ft:title
Spectrum Spatial Guide
Copyright
2025
First publish date
2007
ft:lastEdition
2025-03-07
ft:lastPublication
2025-03-07T10:28:48.112000

Description

Returns the number of geometries in a MultiGeometry.

Syntax

MI_NumGeometries ( geometry )

Argument

geometry is an expression that returns a geometry.

Example

Returns the number of geometries in Canada, Brazil, and China put together.

select MI_NumGeometries([Geometry_Column]) as MI_NumGeometries from "/countries" where country in ('Canada','Brazil','China')

Remarks

The value returned is an integer and represents a number of geometries in a MultiGeometry (MultiPoint, MultiCurve, and MultiPolygon). If the input geometry is not a MultiGeometry, then 1 is returned.