1.1 - 8.10 - GeometryOverlay Syntax Elements - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
SourceLocationColumn
Specify the name of the SourceTable column that contains the polygon description in WKT format.
ReferenceLocationColumn
Specify the name of the ReferenceTable column that contains the location of the polygon description in WKT format.
ReferenceNameColumns
Specify the names of the ReferenceTable columns that contain the names of the polygons.
BoundaryOperator
Specify a boundary (geometry overlay) operator from the following table.
Boundary Operator Result Description
UNION

UNION of overlapping polygons (Machine Learning Engine function GeometryOverlay)
Result contains area covered by source polygon and area covered by reference polygon (blue area in figure).
INTERSECTION

INTERSECTION of overlapping polygons (Machine Learning Engine function GeometryOverlay)
Result contains area that is common to source and reference polygons (blue area in figure).
DIFFERENCE

DIFFERENCE of overlapping polygons (Machine Learning Engine function GeometryOverlay)
Result contains area covered only by source polygon (blue area in figure).
SYMDIFFERENCE

SYMDIFFERENCE of overlapping polygons (Machine Learning Engine function GeometryOverlay)
Result contains area covered by only source polygon or only reference polygon (blue area in figure).
CONVEXHULL

CONVEXHULL of overlapping polygons (Machine Learning Engine function GeometryOverlay)
Result contains smallest convex set that contains source polygon in Euclidean plane (blue area in figure).
BUFFER

Positive BUFFER of overlapping polygons (Machine Learning Engine function GeometryOverlay)

Negative BUFFER of overlapping polygons (Machine Learning Engine function GeometryOverlay)
Result contains source polygon and specified buffer.

A positive buffer extends area of polygon. In upper figure, result includes both buffer (blue) and source polygon (pale pink).

A negative buffer decreases area of polygon. In lower figure, result includes only source polygon (blue).

For buffer operation, eight segments is adopted in curve approximation for corners.

Distance
[Required with BoundaryOperator('BUFFER').] Specify the distance by which to extend or decrease the polygon.
OutputAll
[Optional] Specify whether to include the result of nonintersection geometries in the output table.
Default: 'false'
Accumulate
[Optional] Specify the source table columns to copy to the output table.