Example: Tessellate_Index UDF

Teradata Vantageā„¢ Geospatial Data Types

brand
Software
Teradata Vantage
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;