PointInPolygon Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
8.10
1.1
Published
October 2019
Language
English (United States)
Last Update
2019-12-31
dita:mapPath
ima1540829771750.ditamap
dita:ditavalPath
jsj1481748799576.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.