7.00.02 - Input - 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 parsed location file formats are grouped as in the input table source_passenger. Four passengers have known x and y coordinates. The goal is to determine in which of two airport terminals (A or B) the passengers are located. The geographical location of the terminals is specified as polygon coordinates, using WKT syntax, in the table reference_terminal.

PointInPolygon Example 1 Input Table source_passenger
customer_id source_location_point customer_name
3 POINT (300 20) Maria
2 POINT (300 10) John
1 POINT (30 10) Jeff
4 POINT (400 20) Macy
PointInPolygon Example 1 Input Table reference_terminal
terminal_id reference_location_polygon terminal_name
1 POLYGON ((0 0, 100 0, 100 100, 0 100, 0 0)) Terminal A
2 POLYGON ((200 0, 400 0, 400 200, 200 200, 200 0)) Terminal B