ST_Area method

multisurface-expression.ST_Area([ unit-name])

Name	Type	Description
unit-name	VARCHAR(128)	The units in which the area should be computed. Defaults to the unit of the spatial reference system. The unit name must match the UNIT_NAME column of a row in the ST_UNITS_OF_MEASURE view where UNIT_TYPE is 'LINEAR'.

Computes the area of the multi-surface in the specified units. The area of the multi-surface is the sum of the areas of the contained surfaces.

This method can not be used with geometries in round-Earth spatial reference system.

The following example returns the result 8.

SELECT TREAT( Shape AS ST_MultiSurface ).ST_Area()
FROM SpatialShapes WHERE ShapeID = 27

The following returns the area of the multipoly_geometry column in square miles from the fictional region table.

SELECT name, multipoly_geometry.ST_Area( 'Statute Mile' )
FROM region