Arguments - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Argument Category Description
SourceLocationColumn Required Specifies the names of the source input table columns that contain the point coordinate values.

If you specify only one column, you must specify the coordinates of the point 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. For more information about WKT, see http://www.geoapi.org/3.0/javadoc/org/opengis/referencing/doc-files/WKT.html.

Tip: This function can process the output of the GeometryLoader function, which is expressed in WKT. For example, you can use the GeometryLoader function to convert GIS data formats (for example, shapefile (.shp), MapInfo TAB (.tab), Keyhole Markup Language (KML), and GeoJSON) to WKT and use the PointInPolygon function to process the resulting WKT data.

If you specify two columns, the function interprets them as 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 Required Specifies the reference table column that contains the polygon coordinate values. The column content must be of type WKT.
ReferenceNameColumns Required Specifies the names of the reference table columns that contain the polygon names. The function copies these columns to the output table.
OutputAll Optional Specifies whether to indicate in the output table when the point is not in a polygon. The default value is 'false'.
Accumulate Optional Specifies the source table columns to copy to the output table. By default, the function copies no columns to the output table.