New article
Recently updated
Reporting gate penetrations with the Query Generator
Who is this article for?Noise analysts who need to report on gate penetrations.
Access to the ANOMS Noise Analyst Workbench is required.
Once Gate and Corridor Analysis has run, you can report on gate penetrations using the Query Generator.
Building the query
This example builds a report of all gate penetrations for departures on a specified date.
To create the query:
- On the main menu, select Data.
- Select Query Gen.
- In the Criteria, enter Gate Analysis.Gate or Corridor equal to your gate name.
- Enter Gate Analysis.Penetration time between Interactive and Interactive.
- Include the following fields in the report output: gate name, penetration time, gate direction, altitude, and operation number.
- Send the report output to an Excel workbook.
- Save the query.
- Execute the query.
Note: Using Interactive values for the penetration time means the query prompts you for the date range each time it runs, so the same saved query can be reused for any period.