Example: FROM_MGRS - Analytics Database - Teradata Vantage

Geospatial Data Types

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-08-30
dita:mapPath
qgk1628112272483.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ghz1472251264557
lifecycle
latest
Product Category
Teradata Vantage™

This example converts coordinates in the MGRS system to Geodetic coordinates in the “WGS 84” spatial reference system.

SELECT FROM_MGRS(
  '36TTQ6355387329', 
  (SELECT SRTEXT FROM SYSSPATIAL.SPATIAL_REF_SYS WHERE SRID = 1619),
  1619);

Returns:

FROM_MGRS('36TTQ6355387329',<Scalar Subquery>,1619)
--------------------------------------------------------------------
POINT (29.999987897221764 44.999995138532547)