17.05 - Example: Tessellate_Index UDF - Teradata Database

Teradata Vantage™ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K
   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;