Usage
Many UDFs are available to analyze and manipulate spatial data. These functions can be called in SQL statements with Spatial Extender data types. Table 19.3 lists some of the UDFs.
| Function | Description |
|---|---|
| ST_AppendPoint | Extends the curve by a given point |
| ST_AsShape | Returns the Environmental Systems Research Institute (ESRI) shape representation of a geometry |
| ST_AsText | Returns the text representation of a geometry |
| ST_Boundary | Returns the boundary geometry of a geometry |
| ST_Centroid | Returns the geometric center of a geometry |
| ST_ChangePoint | Changes a point in a curve |
| ST_ConvexHull | Returns the convex hull of a geometry |
| ST_CoordDim | Returns the dimensionality of a geometry's coordinates |
| ST_Dimension | Returns the dimensionality of a geometry ... |
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
