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