1.1 - 8.10 - PointInPolygon 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 names of the SourceTable columns that contain the point coordinate values.

If you specify only one column, specify the point coordinates in well-known text (WKT) syntax. For example, the string 'POINT (30 10)' is the WKT markup syntax that describes a point with x coordinate 30 and y coordinate 10.

If you specify two columns, they represent the two coordinates of the input points (for example, latitude and longitude).

Tip: When you specify two columns, the output of the IPGeo function can be input to this function.
ReferenceLocationColumn
Specify the name of the ReferenceTable column that contains the polygon coordinate values. The column content must be of type WKT.
ReferenceNameColumns
Specify the names of the ReferenceTable columns that contain the polygon names. The function copies these columns to the output table.
OutputAll
[Optional] Specify whether to indicate in the output table when the point is not in a polygon.
Default: 'false'
Accumulate
[Optional] Specify the SourceTable columns to copy to the output table.