Skip to page content

USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Site Notification

Site Notification

United States Department of TransportationUnited States Department of Transportation

Filter Options for Charts

For specific questions/comments about airports and/or procedures, please use the "E-Mail FAA" links next to the appropriate Procedure(s). For general questions/comments, please submit an .

Page last modified:

 ColdBox Debugging Information
   

Framework Info:
ColdBox SEEK 3.8.1.00076 1 John 5:12-13
Application Name:
AeroNav Information Gateway (environment=production)
TimeStamp:
Nov-334-2023 10:05:55 PM
Server Instance:
IP-0A1BE514
Current Event:
procedure.filterCharts
Current Layout:
layout.main.cfm (Module: )
Current View:
procedure/filters/charts
Current Route:
N/A
Routed URL:
N/A
Routed Namespace:
N/A
LogBox Appenders:
DBAPPENDER
RootLogger Levels:
FATAL - WARN
Loaded Modules:
Timestamp Execution Time Framework Method
10:05:55.701 PM 0 ms invoking runEvent [Lifecycle.onSessionStart]
10:05:55.701 PM 0 ms invoking runEvent [Lifecycle.onRequestStart]
10:05:55.717 PM 16 ms invoking runEvent [procedure.filterCharts]
10:05:55.733 PM 0 ms rendering View [procedure/filters/charts.cfm]
10:05:55.748 PM 15 ms rendering Layout [layout.main.cfm]
10:05:55.764 PM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 63 ms
 CacheBox Monitor
Refresh Monitor: Loading...
CacheBox ID
26515518
Configured Caches
TEMPLATE,default
Scope Registration
{SCOPE={server},ENABLED={false},KEY={cachebox}}

Performance Report For Cache Loading...

Cache Name
default [class=coldbox.system.cache.providers.CacheBoxColdBoxProvider]
Performance
Hit Ratio: 99.34% ==> Hits: 547139 | Misses: 3637 | Evictions: 0 | Garbage Collections: 0 | Object Count: 10
JVM Memory Stats
13.20 % Free | Max: 2,796,544 KB Total: 2,247,168 KB | Free: 369,044 KB
Last Reap
Nov-334-2023 10:04:10 PM

Cache Configuration

Cache Content Report

Please Wait, Processing...
Object Hits Timeout Idle Timeout Created Last Accessed Status CMDS
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.airport 38 120 30 Nov-30
08:20:49 PM		 Nov-30
10:05:32 PM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 44 120 30 Nov-30
09:50:00 PM		 Nov-30
10:04:01 PM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 750 120 30 Nov-30
09:18:00 PM		 Nov-30
10:05:55 PM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 8 120 30 Nov-30
09:33:13 PM		 Nov-30
10:05:10 PM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 44 120 30 Nov-30
09:49:04 PM		 Nov-30
10:05:55 PM		 Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 266 120 30 Nov-30
09:18:00 PM		 Nov-30
10:05:55 PM		 Alive
wirebox-coldbox.system.plugins.json 2 120 30 Nov-30
09:18:00 PM		 Nov-30
09:38:48 PM		 Alive
wirebox-coldbox.system.plugins.jvmutils 180 120 30 Nov-30
09:32:00 PM		 Nov-30
10:05:55 PM		 Alive
wirebox-coldbox.system.plugins.messagebox 3 120 30 Nov-30
09:38:48 PM		 Nov-30
09:56:46 PM		 Alive
wirebox-coldbox.system.plugins.utilities 6 120 30 Nov-30
09:16:13 PM		 Nov-30
10:00:38 PM		 Alive
 ColdBox Modules

Below you can see the loaded application modules.

Module Author Version V.P.L L.P.L Load Time CMDS

* V.P.L = View Parent Lookup Order
* L.P.L = Layout Parent Lookup Order

 ColdBox Request Structures
Public Collection
selectedtab: N/A
tab: charts
pagehead: N/A
nasrid: FSE
title: Filter Options for Charts
flags:
query
RESULTSET
query [Filtered - Top 2 of 3 rows]
  DESCRIPTION FLAG
1 Added since last cycle A
2 Changed since last cycle C
CACHED false
EXECUTIONTIME 16
SQL SELECT f.flag, f.description FROM flag f ORDER BY lower(f.flag)
content: N/A
xe:
query
RESULTSET
query [Filtered - Top 2 of 4 rows]
  AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE AMDTNUM CHARTSEQ FILENAME FLAG ISSUBSCRIBED PROCEDURENAME RNUM TYPE VOL
1 SPRINGFIELD M91 KM91 SPRINGFIELD ROBERTSON COUNTY TN [empty string] 10100 SE1TO.PDF [empty string] 0 TAKEOFF MINIMUMS 1 MIN SE-1
2 SPRINGFIELD M91 KM91 SPRINGFIELD ROBERTSON COUNTY TN 1D 53525 06740R4.PDF [empty string] 0 RNAV (GPS) RWY 04 2 IAP SE-1
CACHED false
EXECUTIONTIME 0
SQL SELECT a.*, 0 AS isSubscribed FROM ( SELECT DISTINCT o.chartSeq, o.procedureName,o.amdtnum, a.NFDC_ARPT_ID as AIRPORT_CODE, a.AIRNAV_ARPT_ID as AIRPORT_ICAO, a.ARPT_NM as AIRPORT_NAME, a.ARPT_CHART_LOC_CITY_TXT as AIRPORT_CITY, a.ST_CD as AIRPORT_STATE, o.volume AS vol, o.userAction AS flag, o.code AS type, o.fileName, row_number() OVER (ORDER BY chartseq, a.NFDC_ARPT_ID, o.procedurename) AS rnum FROM procedure o INNER JOIN NON_OFFICIAL_USE_ACTIVE_AIRPORT a ON a.NFDC_ARPT_ID = o.airportCode LEFT JOIN state s ON a.ST_CD = s.stateAbbreviation INNER JOIN cycle c ON o.cycleId = c.cycleId WHERE 1 = 1 AND c.startDate = (SELECT cycleDate FROM currentCycle) AND lower(a.NFDC_ARPT_ID) = ? ) a WHERE rnum BETWEEN 1 AND 50 ORDER BY chartseq, a.AIRPORT_CODE, a.procedurename
SQLPARAMETERS
array - Top 1 of 1 rows
1 m91
querystring: N/A
event: procedure.filterCharts
postcontent: N/A
Private Collection
cbox_incomingcontexthash: EE5FF2F0D7E7FC0EDFA39349D832AC59
currentlayout: layout.main.cfm
currentview: procedure/filters/charts
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 516 ms