Example: ST_GeomFromText - 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ā„¢
CREATE TABLE varchar_tab1 (a int, b VARCHAR (60000));
INSERT INTO varchar_tab1 VALUES (1001, 'Point(10 20 30)');
CREATE TABLE sample_shapes(skey INTEGER, shape ST_Geometry);
INSERT INTO sample_shapes
SELECT a, SYSSPATIAL.ST_GeomFromText(b) FROM varchar_tab1;
SELECT * FROM sample_shapes;