This SQL element is a shortcut for the User Defined Method SQL element with the User Defined Type field set to ST_POINT. Selecting this element will display a listing of methods for the ST_POINT type, described in the following table.
Method | Definition |
---|---|
Constructor_Method(1) | ST_Geometry Constructor (ST_Point Form) Returns an ST_Geometry value that represents a 2D ST_Point. |
Constructor_Method(2) | ST_Geometry Constructor (ST_Point Form) Returns an ST_Geometry value that represents a 2D ST_Point, with reference to an external spatial reference system identifier (asrid). |
Constructor_Method(3) | ST_Geometry Constructor (ST_Point Form) Returns an ST_Geometry value that represents a 3D ST_Point, with reference to an external spatial reference system identifier (asrid). |
ST_SphericalBufferMBR | Returns an MBR that represents the minimum and maximum latitude and longitude of all points within a given distance from a point. The earth is modeled as a sphere. |
ST_SphericalDistance | Returns the spherical distance between two spherical coordinates on the planet using the Haversine Formula. Both coordinates must be specified as ST_Point values. |
ST_SpheroidalBufferMBR | Returns an MBR that represents the minimum and maximum latitude and longitude of all points within a given distance from the point. The earth is modeled as a spheroid. |
ST_SpheroidalDistance | Returns the distance, in meters, between two spherical coordinates. |
ST_X_GET | Get the X coordinate of an ST_Point value. |
ST_X_SET | Set the X coordinate of an ST_Point value. |
ST_Y_GET | Get and set the Y coordinate of an ST_Point value. |
ST_Y_SET | Get and set the Y coordinate of an ST_Point value. |
ST_Z_GET | Get the z coordinate of an ST_Point value. Requires Teradata 15.00 or later.
|
ST_Z_SET | Set the z coordinate of an ST_Point value. Requires Teradata 15.00 or later.
|
This feature requires Teradata 13.00 or later and the three-dimensional functions (as specified in the above table) require Teradata 15.00 or later.