Reporting corridor violations with the Query Generator
Who is this article for?Noise analysts who need to report flights that deviated from a corridor.
Access to the ANOMS Noise Analyst Workbench is required.
Corridor analysis results are reported through the Query Generator, allowing you to create basic corridor usage reports and reusable interactive queries that identify flights violating corridor boundaries.
Reporting corridor usage
This example creates a report of all corridor usage for departures on a specified date.
To create a corridor usage report:
- On the main menu, select Data.
- Select Query Gen.
- In the Criteria, enter Gate Analysis.Gate or Corridor equal to your corridor name.
- Enter Gate Analysis.Penetration time between Interactive and Interactive.
- Include the following fields in the report output: corridor name, penetration time, corridor side, gate direction, altitude, and operation number.
- Send the report output to an Excel workbook.
- Save the query.
- Execute the query.
Note: For more detail on creating a new query, see the Query Generator articles.
Creating an interactive corridor violations query
This query finds all operations in the last month that were assigned a specific corridor but did not pass through it correctly. Each violating flight will have violated the left, right, ceiling, or floor of the corridor.
To create an interactive corridor violations query:
- On the main menu, click Data.
- Click Query Gen.
- In the Datasources list, click ANOMS.
- In the Relations list, click Operations.
- In the Criteria area, click Supplied Value.
- Select Last Month from the Operations list.
- Click Add.
- In the Fields list, click A/D/O.
- In the Criteria area, click Supplied Value.
- Select Equal from the Operations list.
- Enter D (for departures) in the Text field.
- Click Add.
- In the Relations list, click Gate Analysis.
- In the Fields list, click Gate or Corridor Name.
- In the Criteria area, click Interactive.
- Click Add.
- In the Fields list, click Corridor Side.
- In the Criteria area, click Supplied Value.
- Select Not Equal from the Operations list.
- Enter T (for Through) in the Text field.
- Click Add.
- In the Output Type section, select Browser.
- Click Execute to run the query.
Note: The query will prompt for the corridor name each time it runs because the Interactive option was selected for the corridor name field.