Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1022
Product Category
Software

The PointInPolygon function requires two input tables, source and reference. These tables must have the same coordinate reference system.

PointInPolygon Source Table Schema
Column Name Data Type Description
source_location_point_column If you specify only this column:

CHAR, VARCHAR, or TEXT

If you specify two columns:

SMALLINT, INTEGER, BIGINT, DOUBLE PRECISION, NUMERIC, or DECIMAL

If you specify only this column: Contains WKT content.

If you specified two columns: Contains the x coordinates of the points.

source_location_point_column_2 SMALLINT, INTEGER, BIGINT, DOUBLE PRECISION, NUMERIC, or DECIMAL Contains the y coordinates of the points.
accumulate_column Any Column to copy to the output table.
PointInPolygon Reference Table Schema
Column Name Data Type Description
reference_location_polygon_column CHAR, VARCHAR, or TEXT Polygon description.
reference_location_column Any Polygon name.