Example: Tessellate_Index UDF - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantage™ Geospatial Data Types

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1181-162K
   CREATE TABLE shapes_index
      (skey INTEGER
      ,cellID INTEGER);

   INSERT INTO shapes_index
   SELECT SYSSPATIAL.Tessellate_Index(shape.ST_MBR_Xmin(),
      shape.ST_MBR_Ymin(), shape.ST_MBR_Xmax(), shape.ST_MBR_Ymax(),
      -180, 0, 0, 90, 500, 500, 1, 0.01, 0)
   FROM sample_shapes;