ST_Area(VARCHAR(128)) method

Syntax

Parameters

• unit_name – The units in which the length 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

Examples

• Example 1 – The following example returns the result 12.5.

  SELECT TREAT( Shape AS ST_Polygon ).ST_Area()
  FROM SpatialShapes WHERE ShapeID = 22

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

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

Standards

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