Returns the geographical area of a geometry object.


MI_Area ( geometry, unit, calculationType )


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.


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'


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:

Value Description
sq mi square miles
sq km square kilometers
sq in square inches
sq ft square feet
sq yd square yards
sq mm square millimeters
sq cm square centimeters
sq m square meters
sq survey ft square US Survey feet
sq nmi square nautical miles
sq twip square twips
sq pt square points
sq pica square picas
sq degree square degrees
acre acres
hectare hectares
sq li square links
sq ch square chains
sq rd square rods
perch perches
rood roods