ST_Point 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_POINT. Selecting this element will display a listing of methods for the ST_POINT type, described in the following table.

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