17.10 - ST_Relate Syntax - 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)
ST_Relate ( ageometry, amatrix )

Syntax Elements

ageometry
The other ST_Geometry value.
amatrix
A CHARACTER(9) value where each character corresponds to a cell in the DE-9IM pattern matrix.

The mapping for amatrix, as defined by SQL/MM Spatial, is as follows:

Position DE-9IM Cell
1 (Interior(SELF) ∩ Interior(ageometry)).ST_Dimension
2 (Interior(SELF) ∩ Boundary(ageometry)).ST_Dimension
3 (Interior(SELF) ∩ Exterior(ageometry)).ST_Dimension
4 (Boundary(SELF) ∩ Interior(ageometry)).ST_Dimension
5 (Boundary(SELF) ∩ Boundary(ageometry)).ST_Dimension
6 (Boundary(SELF) ∩ Exterior(ageometry)).ST_Dimension
7 (Exterior(SELF) ∩ Interior(ageometry)).ST_Dimension
8 (Exterior(SELF) ∩ Boundary(ageometry)).ST_Dimension
9 (Exterior(SELF) ∩ Exterior(ageometry)).ST_Dimension

Valid values for each character are: 'T', 'F', '0', '1', '2', and '*'.

The value specifies the set of acceptable values for an intersection at that given cell. The meaning is as follows.

Cell Value Intersection Set Results
'T' { 0, 1, 2 }
'F' { -1 }
'0' { 0 }
'1' { 1 }
'2' { 2 }
'*' { -1, 0, 1, 2 }