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 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