ST_Polygon Methods (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

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.

ST_Polygon Methods
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.