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 |