Spatial functions according to input type

List of spatial functions according to the type of input that they can accept.

Important: As noted elsewhere, the spatial data types form a hierarchy, with ST_Geometry as the root. When the documentation for Db2® Spatial Extender indicates that a value of a super type in this hierarchy can be used as input to a function, alternatively, a value of any subtype of this super type can also be used as input to the function.

For example, the first entries in Table 1 indicate that ST_Area and a number of other functions can take values of the ST_Geometry data type as input. Therefore, input to these functions can also be values of any subtype of ST_Geometry: ST_Point, ST_Curve, ST_LineString, and so on.
Table 1. Spatial functions listed according to input type
Data type of input parameter Function
ST_Geometry
ST_Geometry, continued
ST_Point
ST_Curve
ST_LineString
ST_Surface
ST_GeomCollection
ST_MultiPoint ST_PointN
ST_MultiCurve
ST_MultiLineString
ST_MultiSurface
ST_MultiPolygon