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:
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 |