PointInPolygon Function Syntax Elements | Teradata Vantage - PointInPolygon Syntax Elements - Teradata Vantage

Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.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.