OnTime dynamic html_map dashboard

Highest daily hops for one aircraft on one flight number

Tracks the most hop-dense day flown by a single aircraft on a single flight number, keeps the KPI strip anchored to the highest-ranked itinerary, and maps any selected itinerary after one shared airport-coordinate enrichment pass.

Enter a JWE token or use the saved one, then run the query.

Lead itinerary map

Airport-coordinate enrichment will appear here when the query runs.
Selected itinerary Airport stop Context route reference
Map panel is ready. Run the primary query to load itinerary data, then airport-coordinate enrichment will upgrade the route geometry.
The map remains visible even before enrichment completes. If airport coordinates are unavailable for the selected itinerary, this panel stays visible and explains the degraded state.

Route sequence and detail

The first returned itinerary becomes the default selection.

Itinerary table

Click any row to redraw the map and refresh route details.
Aircraft Flight Carrier Date Route Hops

Query ledger

Every browser query is listed here with status, row count, and expandable SQL.