ST_GeometryType() method

Returns the name of the type of the ST_Geometry value.

Syntax

geometry-expression.ST_GeometryType()

Returns

VARCHAR_0123128321_ Returns the data type of the geometry value as a text string. This method can be used to determine the dynamic type of a value.

Examples

Example 1 – The following returns the result 2,3,6,16,22,24,25, which is the list of ShapeIDs whose corresponding Shape is one of the specified types.
```
SELECT LIST( ShapeID ORDER BY ShapeID )
FROM SpatialShapes
WHERE Shape.ST_GeometryType() IN( 'ST_Polygon', 'ST_CurvePolygon' )
```

Standards

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

Parent topic: ST_Geometry type

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com