例: Tessellate_Indexメソッド - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - 地理空間データ型

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
2020年6月
Language
日本語
Last Update
2021-03-30
dita:mapPath
ja-JP/vci1556127188517.ditamap
dita:ditavalPath
ja-JP/vci1556127188517.ditaval
dita:id
B035-1181
Product Category
Software
Teradata Vantage
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;