System Functions (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

See the Teradata Reference Manual SQL Geospatial Types, B035-1181, for a detailed description of the following functions.

System Functions
Function Description
AggGeomIntersection Aggregate function that returns the intersection of all objects in the aggregation group.
AggGeomUnion Aggregate function that returns the union of all spatial objects in the aggregation group.
GeoJSONFromGeom Converts an ST_Geometry object into a JSON document that conforms to the GeoJSON standards. For more information on this system function, see Teradata JSON, B035-1150.
This feature requires Teradata 15.00 or later.
GeomFromGeoJSON Converts a JSON document that conforms to the GeoJSON standards into an ST_Geometry object. For more information about this system function, see Teradata JSON, B035-1150.
This feature requires Teradata 15.00 or later.
FROM_MGRS Converts a coordinate in the Military Grid Reference System (MGRS) to an ST_GEOMETRY point object.
This function was developed using GEOTRANS, a product of the National Geospatial-Intelligence Agency (NGA) and U.S. Army Engineering Research and Development Center.
TO_MGRS Converts an ST_GEOMETRY point object to a coordinate in the Military Grid Reference System (MGRS).
This function was developed using GEOTRANS, a product of the National Geospatial-Intelligence Agency (NGA) and U.S. Army Engineering Research and Development Center.