MI_Area

Description

Returns the geographical area of a geometry object.

Syntax

MI_Area ( geometry, unit, calculationType )

Arguments

geometry is an expression which returns a geometry,

unit is an area unit specification, and

calculationType is a string that indicates whether to perform a Spherical or Cartesian calculation. There is no default.

Example

Returns the area of the country canada in square miles.

select MI_Area(Obj,'sq mi','Spherical') as mi_area from countries where country='Canada'

Remarks

The value returned is a double and represents a value in the units specified by the units argument. MI_Area is applicable only to geometries of type Envelope, Polygon, Multipolygon, and Ring. Any other type of input geometry results in a value of zero.

Valid values for unit are the following area units: