例: Tessellate_Indexメソッド - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ 地理空間データ型

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
2019年3月
Language
日本語
Last Update
2019-10-29
dita:mapPath
ja-JP/swn1512082023009.ditamap
dita:ditavalPath
ja-JP/swn1512082023009.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;