Skip to content
Jeremy Peterson edited this page Mar 14, 2026 · 5 revisions

PERTI Wiki

Welcome to the PERTI (Plan, Execute, Review, Train, and Improve) wiki - a comprehensive traffic flow management platform for VATSIM.

Production URL: https://perti.vatcscc.org


Comprehensive Guides

These in-depth documents cover everything needed to deploy and understand PERTI:

Guide Description
Deployment Guide Full deployment walkthrough: Azure provisioning, 7-database schema deployment, stored procedures, reference data import, daemon setup, i18n, multi-org configuration, code standards, and operational procedures
Computational Reference Complete algorithm documentation: ADL ingest cycle, ETA calculation, route parsing, boundary detection, GDP/GS slot assignment, TMI compliance, trajectory tiering, and performance tuning

Quick Links

Section Description
Navigation Helper Find the right documentation quickly
Getting Started Installation, prerequisites, and first steps
Architecture System design, data flow, and components
Configuration Environment setup and configuration options
API Reference Complete API documentation
Database Schema Tables, columns, and relationships
Deployment Azure deployment and CI/CD pipeline
Contributing How to contribute to PERTI
FAQ Frequently asked questions

Features Overview

Public Tools (No Login Required)

  • JATOC - Joint Air Traffic Operations Command incident monitor
  • NOD - NAS Operations Dashboard with active TMIs and advisories

Traffic Management (Authenticated)

  • GDT - Ground Delay Tool with FSM-style GDP interface
  • Route Plotter - TSD-style live flight map with weather radar
  • Playbook - Pre-coordinated route play catalog with map visualization
  • TMI Publisher - NTML/advisory publishing to Discord with multi-org support
  • Reroutes - Reroute authoring and compliance monitoring
  • Splits - Sector/position split configuration with strata filtering and scheduled splits
  • Demand Analysis - Airport demand/capacity visualization with rate suggestions

Training (Authenticated)

  • ATFM Simulator - Training simulator for TMU personnel (NEW v17)

Planning & Scheduling (Authenticated)

  • Plan - Traffic management planning worksheets
  • Schedule - Staff scheduling
  • Data Sheet - Operational data sheets
  • Review - Plan review with StatSim integration

System Scale (as of March 2026)

Metric Count
Total flights tracked 1,625,115
Flight plans parsed 1,620,920
Route waypoints extracted 9,295,153
Boundary crossings predicted 20,548,518
Navigation fixes 268,998
Airports in database 27,231 (ADL) / 37,527 (GIS)
Airlines tracked 228
ARTCC/sector boundaries 3,033 (ADL) / 1,004 ARTCC + 1,023 TRACON (GIS)
Airways 1,515
DPs/STARs 10,314
Coded Departure Routes 41,138
Playbook routes 55,682
TMI programs issued 172 (139 GDP, 29 GS, 4 AFP)
TMI advisories published 1,020
Reroutes defined 268
PERTI plans created 239
Registered users 25
Translation keys 7,276 (en-US)
Supported locales 4 (en-US, fr-CA, en-CA, en-EU)

Data reflects cumulative totals. System hibernated since March 9, 2026.


Technology Stack

Component Technology
Backend PHP 8.2+
Frontend JavaScript (ES6+), jQuery, Bootstrap 4.5
Mapping MapLibre GL JS
Charts Chart.js
Databases MySQL, Azure SQL, PostgreSQL/PostGIS
Hosting Azure App Service
Auth VATSIM Connect (OAuth)
Weather IEM NEXRAD/MRMS tiles

Current Version

v18 (with ongoing enhancements through March 2026) - Includes:

System Status: HIBERNATED (since March 9, 2026) - Core daemons only, pages redirect to /hibernation, Azure resources downscaled. See docs/HIBERNATION_RUNBOOK.md for exit procedure.

  • GDP Algorithm Redesign (Phases 1-4 complete) - CASA-FPFS + RBD hybrid slot assignment, compression, reoptimization, reversal metrics, anti-gaming flags
  • vATCSCC Playbook - Pre-coordinated route play catalog with CRUD, route grouping/coloring, consolidation, compaction, auto-filters, FIR pattern expansion, and shareable links
  • Canadian FIR Sectors - 377 sector boundaries across 7 Canadian FIRs (CZYZ, CZWG, CZEG, CZUL, CZVR, CZQM, CZQX)
  • FIR Pattern Expansion - International ICAO prefix matching, FIR-to-ARTCC code expansion, pseudo-fix audit
  • Route Analysis Tools - Route consolidation, compaction, auto-filters for playbook management
  • ARTCC Code Normalization - US ICAO codes (KZAB→ZAB, PAZA→ZAN) normalized sitewide
  • Splits Enhancements - Scheduled splits layer with low/high/superhigh strata filtering, sector map on plan pages
  • Multi-Organization Support - Org-scoped TMI/JATOC authorization, multi-org Discord posting, CANOC/ECFMP integration
  • Traffic Management Review (TMR) - Guided NTMO-style post-event review reports
  • NOD TMI Enhancements - Rich TMI sidebar cards, map status layer, facility flow configs, FEA integration
  • Internationalization (i18n) - 7,276 translation keys across 4 locales (en-US, fr-CA, en-CA, en-EU), 30 PHP pages, 45 JS modules
  • PERTI_MYSQL_ONLY Optimization - ~98 endpoints skip Azure SQL connections (~500-1000ms faster)

See Changelog for full version history.


Getting Help


Last updated: 2026-03-11

Clone this wiki locally