This SQL element is a shortcut for the User Defined Method SQL element with the User Defined Type field set to ST_POLYGON. Selecting this element will display a listing of methods for the ST_POLYGON type, described in the following table.
Method | Definition |
---|---|
ST_Area | Returns the area measurement of an ST_Polygon or ST_MultiPolygon. For ST_MultiPolygon, returns the sum of the area measurements of the component polygons. |
ST_ExteriorRing_GET | Get the exterior ring of an ST_Geometry type that represents an ST_Polygon value. |
ST_ExteriorRing_SET | Set the exterior ring of an ST_Geometry type that represents an ST_Polygon value. |
ST_InteriorRingN | Returns the specified interior ring of an ST_Geometry type that represents an ST_Polygon value. |
ST_NumInteriorRing | Returns the number of interior rings of an ST_Geometry type that represents an ST_Polygon value. |
ST_Perimeter | Returns the boundary length of an ST_Polygon, or the sum of the boundary lengths of the component polygons of an ST_MultiPolygon. |
ST_PointOnSurface | Returns a point that is guaranteed to spatially intersect an ST_Polygon, or at least one of the component polygons of an ST_MultiPolygon. |
This feature requires Teradata 13.00 or later.