15.10 - ST_Area - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns the area measurement of an ST_Polygon or ST_MultiPolygon. For ST_MultiPolygon, returns the sum of the area measurements of the component polygons.

Returns a FLOAT value.

ST_Polygon and ST_MultiPolygon

   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);