17.10 - Example: Tessellate_Index Method - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Geospatial Data Types

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1181-171K
Language
English (United States)
CREATE TABLE sample_shapes(skey INTEGER, shape ST_Geometry);

INSERT INTO sample_shapes 
  values(1067, NEW ST_Geometry('LineString(-43.5 20.2, -43.6 20.3)'));

   CREATE TABLE shapes_index
      (skey INTEGER
      ,cellid INTEGER);

   INSERT INTO shapes_index
   SELECT skey,
      shape.Tessellate_Index(-180, 0, 0, 90, 500, 500, 1, 0.01, 0)
   FROM sample_shapes;