ST_Perimeter(VARCHAR(128)) method

Syntax

surface-expression.ST_Perimeter(VARCHAR(128) unit_name)

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

DOUBLE Returns the perimeter of the surface in the specified unit of measure.

Examples

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

  SELECT TREAT( Shape as ST_Surface ).ST_Perimeter()
  FROM SpatialShapes WHERE ShapeID = 3

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

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

Standards

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