16.20 - Example: Tessellate_Index Method - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Geospatial Data Types

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1181-162K
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;