The output table shows all passengers, whether or not they are in a terminal.
| 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)) |
| 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 |