7.00.02 - Output - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The output table shows all passengers, whether or not they are in a terminal.

PointInPolygon Example 1 Output Table (Columns 1-2)
source_location_point ref_reference_location_polygon
POINT (30 10) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (30 10) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
POINT (300 10) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (300 10) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
POINT (300 20) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (300 20) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
POINT (400 20) POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0))
POINT (400 20) POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0))
PointInPolygon Example 1 Output Table (Columns 3-6)
ref_terminal_name pip_flag customer_id customer_name
Terminal B 0 1 Jeff
Terminal A 1 1 Jeff
Terminal B 1 2 John
Terminal A 0 2 John
Terminal B 1 3 Maria
Terminal A 0 3 Maria
Terminal B 0 4 Macy
Terminal A 0 4 Macy