例: ST_Area - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - 地理空間データ型

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
2020年6月
ft:locale
ja-JP
ft:lastEdition
2021-03-30
dita:mapPath
ja-JP/vci1556127188517.ditamap
dita:ditavalPath
ja-JP/vci1556127188517.ditaval
dita:id
B035-1181
Product Category
Software
Teradata Vantage
   CREATE TABLE sample_shapes (skey INTEGER, shape ST_Geometry);

   INSERT sample_shapes 
     (1,'Polygon((30 30, 30 60, 60 60, 60 30, 30 30))');

   SELECT skey
   FROM sample_shapes
   WHERE (shape.ST_Area() < 100.5);