ST_Area(VARCHAR(128)) method

Syntax

multisurface-expression.ST_Area(VARCHAR(128) unit_name)

Parameters

• unit_name – 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'.

Returns

DOUBLE Returns the area of the multi-surface.

Examples

• Example 1 – 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

Standards

SQL/MM (ISO/IEC 13249-3: 2006) 9.5.3