Usage Notes - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K

For the distance calculation, the planet is modeled as a spheroid.

If you do not pass in values for the semimajor and invf arguments, the computation uses the semimajor axis and the inverse flattening ratio from the World Geodetic System, WGS84. A value of 6,378,137.0 meters is used for the semimajor axis, and a value of 298.257223563 is used for the inverse flattening ratio.

Distance calculations between antipodal or nearly antipodal points using the SYSSPATIAL.SpheroidalDistance UDF may fail to converge, generating a Teradata Database error. For these distance calculations use instead the SYSSPATIAL.SphericalDistance UDF.