Example: ST_3DDistance - 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™
INSERT INTO sample_shapes VALUES(1,'Point(10 20 30)');
INSERT INTO sample_shapes VALUES(2,
 'MultiPoint((10 20 30),(40 50 60), (70 80 80))');
INSERT INTO sample_shapes VALUES(3,
 'Linestring(10 20 30,40 50 60, 70 80 80)');
INSERT INTO sample_shapes VALUES(4,
 'MultiLinestring((10 20 30,40 50 60), (70 80 80, 90 100 110))');

SELECT skey
FROM sample_shapes
WHERE shape.ST_3DDistance('POINT(10 20 30)') < 1E0;