AWQ CLOUD BRIEFING

0000Z

UTC ZULU TIME

SYSTEM LIVE

DATABASE: CHECKING

UTC: --:--Z

BOARD: 0 ACTIVE

ALERTS: 0

FLIGHT BOARD

UTC --:--Z

0 flights on board

FLTROUTESCHEDULEA/CALTNENRCGOTAF DEPTAF ARRATCNOTAMREMARK

AWAITING SYSTEM INITIALIZATION...

0

0 SELECTED

Update Date of Flight

NOTAM ANALYSIS DESK

Review and correlate critical operational notices

Sectors Analysed0stations in window

Critical Alerts0impacting schedule

Session StateSTANDBYanalysis cache

OPERATIONAL FLIGHT PLAN CROSS-CHECK & D1 INSPECTOR

OFP BRIEF INSPECTOR READY

Active Board Scope Only • Multi-Sector Splitter (COMPUTED AT) • Mandatory CORTE = R10 Guard Last Check: --:--Z

BOARD: 0 PASS: 0 WARN: 0 FAIL: 0 MISSING: 0

Select an active flight on the left to inspect its Operational Flight Plan cross-check details.

BRIEFING REPORT

SYSTEM READY | BRIEFING PACKAGE COMPILATION v2.4

NOTAM UPDATE

Update the aerodrome NOTAM dataset used for AD briefing

Last dataset update

Loading history…

Mission Data Ingestion (Paste Excel/CSV Content)

Aerodrome dataset in use · AD

Loading aerodrome dataset…

Saved AD NOTAMs used by aerodrome analysis. Validity is shown at the load time in UTC; D) schedules and flight times are checked during briefing analysis. Estimated expiry (EST) requires checking C).

Airport Validity

Current saved dataset

System Standby :: Awaiting Input

ROUTE REGISTRY MANAGER

Central database for all approved flight routing profiles

Registered Profiles0approved routing profiles

Route Pairs0unique city pairs

StatusREGISTRYlive from route DB

WP Coverage0/0with registered waypoints

ALL WIII (CGK) WADD (DPS) WMKK (KUL) WSSS (SIN) YPPH (PER) NO WAYPOINTS

0
PROFILES

WP = REGISTERED IN WAYPOINT DB

VIEW SCOPE

FRESH <6 h STALE 6–24 h EXPIRED >24 h / FUTURE NEW no sync yet order: DEP→ARR→ALT→ENR→MANUAL

Full Registry0all configured stations

Active Stations0DEP · ARR · ALT · ENR

Data FreshnessTRACKINGauto age-check

WEATHER MONITORING

ACTIVE FLIGHT WATCH (UTC OPERATIONS) • LAST UPDATE: --:--:-- Z

Flights Watched0active on board

Restricted0visibility / severe

Monitor0ts / reduced

Operational0no impact

No TAF0missing / out of window

AI MODEL

INITIALIZING WEATHER ENGINE...

[ REFERENCE: loading... ]

WX WARNING

TROPICAL CYCLONE & VOLCANIC ASH OVERLAY • LAST FEED: --

FEED —

0Tropical cyclone

0Volcanic ash

0Affects route

0Manual entries

No active TC / VA warnings in the Asia-Pacific box for this feed.
Paste a product below or press REFRESH.

34 KT danger area 34 KT 50 KT 64 KT wind radii + track Volcanic ash (solid = observed, dashed = forecast) SIGMET polygon Route + waypoints

MANUAL PRODUCT INPUT

Paste JTWC warning or VAAC advisory text — shared with all operators

Flight Board

Loading active flights...

Select a flight to view hazard stack.

0 shown of 0

No hazards yet.

NOTAM: — High Caution Clear

FIR Monitoring Area

LAST UPDATE: —

Query ran at UTC: —

New FIR NOTAM

Location / FIR (ICAO) *

4-letter ICAO required (e.g. WIII)

NOTAM # *

Format A1234/26 required

Class *

Class required

Issue Date

Effective Date

Expiration Date PERM (permanent)

NOTAM Text * 0 chars

NOTAM Text required

Dates are stored as UTC. Use the format YYYY-MM-DD HH:MM (or leave blank).

Paste raw NOTAM → auto-fill

Updated NOTAM Results (0)

Loading results…

FIR NOTAM Map

MAP: — High Med Low Exp

FIR Update

Paste FIR / enroute NOTAMs to append or replace the FIR dataset

Last dataset update

Loading history…

Bulk Import FIR NOTAM Sheet FIR • TSV DINS or Raw ICAO (multi Q) • Append + dedup • TSV from DINS: copy table (Header Location … NOTAM Condition) → paste

Paste TSV (Excel/DINS) or Raw ICAO (multiple Q) → Preview

Paste FIR/enroute NOTAMs as DINS TSV or complete ICAO messages including their NOTAM numbers. Aerodrome-only NOTAMs (Q scope A) belong in UPDATE NOTAM. Append skips existing numbers; overwrite replaces the FIR dataset. PERM supported.

1.0 DOF Date—awaiting data

2.0 NOTAM Update—awaiting data

3.0 TAF Freshness—awaiting data

Loading operational data…

DOF DATE
—

Confirm flight date matches current operational date in UTC.
I have checked this item
UNAVAILABLE
NOTAM LAST UPDATE
—

Confirm NOTAM data is current and relevant to the planned operation.
I have checked this item
UNAVAILABLE
TAF
—

Confirm issue time, amendment status, and validity period.
I have checked this item
UNAVAILABLE

WAYPOINT MANAGER

MANAGE WAYPOINT DATABASE

Current Waypoints

0

ID | Waypoint | Latitude | Longitude

Last Parsed

0

from paste preview

Mode

COLUMN

left top→bottom, then right top→bottom

Paste Coordinates COLUMN order

Paste FIXes per line

Scan Order

Route ID (Variant B — Required)

Update Mode

REPLACE for full database refresh. MERGE for daily patch (preserves other FIXes). APPEND for incremental add.

Loading WAYPOINT database...

Your Access

Single source of authorisation: the account role on the D1 login session

Loading…

Current user—signed-in account

Account role——

Your access——

Role Permission Matrix (RBAC Policy) D1 SESSION AUTHORITY

ADMIN FULL ACCESS

✓ Full operational write (Flights, NOTAM, TAF, FIR, Route, Waypoints)
✓ Full access to Dispatch Assist & Dispatch Agent
✓ Manage users, WX AI, LINKS & System Settings

REGISTERED+ EXTENDED OPS

✓ Update flights, NOTAM, TAF, FIR & ROUTE profiles
✓ Full access to Dispatch Assist & Dispatch Agent; WAYPOINTS read-only
✕ No access to Settings or User Admin

REGISTERED OPERATIONAL WRITE

✓ Update flights, NOTAM, TAF & FIR; ROUTE & Dispatch read-only
✕ No access to WAYPOINTS menu
✕ No access to Settings or User Admin

READ ONLY VIEW ONLY

✓ View operational boards & weather
✕ Cannot modify or save operational data
✕ No access to WAYPOINTS, Dispatch, or Settings

Legacy Migration Archive (Read-Only Evidence) DEPRECATED —

▼ Expand Archive

Legacy Registered-User List ARCHIVE

This list is no longer used for authorisation now that internal login is active. The emails below are kept only as evidence of the migration from the old Script Property.

Raw: (masked)

Legacy Registered-User List — Read Only LEGACY

No longer controls access. Since internal login became active, permissions are determined by the account role on the Internal Users tab (admin / registered+ / registered / readonly). The list below is kept only as migration evidence and can no longer be changed from here — this prevents two sources of truth from diverging.

Legacy registered emails (OCC_ALLOWED_EMAILS, in the meta table) Read-only. To grant access, create or change the account role on the Internal Users tab.

Legacy Settings-Admin List — Read Only LEGACY

No longer controls who may open this page. Settings access follows the account's admin role. The SETTINGS_ADMIN_EMAILS list below is migration evidence only and cannot be changed from here.

Legacy admin emails (SETTINGS_ADMIN_EMAILS, in the meta table) Read-only. Change the account role on the Internal Users tab to add or revoke an admin.

Internal Auth Users

Manage internal login accounts. The role determines access: admin (manage users + settings), registered+ (operational + route write, dispatch full, waypoints read-only), registered (operational write, route & dispatch read-only), readonly (view only). A temporary password must be changed at first login.

Provision New Account

Audit Log — Security-Sensitive Changes

—

Read-only. Every change to the legacy allowlist, roles, active status, password resets, profiles, and the WX AI configuration is recorded together with the actor, the outcome, and a redacted summary. Passwords and tokens never enter this log.

—

Operational Data Readiness & Master Data Registry READY D1 MASTER

—

1. Operational Data Readiness & Drift Monitor Cross-check of airports, FIRs, routes, TAFs, and fleet across Flight Board

Airport & FIR Coverage — Master registry & Flight Board

TAF Station Freshness — Station health & staleness

Route & Waypoint Profiles — Active sectors & latlong points

Aircraft Fleet Registry — Tail registrations & type codes

Latest Flight Readiness — OFP & validation breakdown

AIP Minima & Documents — Approved vs expiring charts

Per-FIR & Hub NOTAM Freshness

2. Operational Airports & FIR Mapping Editor

ICAO	IATA	Airport Name	Country	FIR Codes	Timezone	Coordinates	Status	Actions
Loading airports…

3A. FIR Regions

ID	Name	Risk	Coordinates	Actions
Loading FIRs…

3B. Curfew & Airport Notes

ICAO	Days	Hours	Type	Note	Actions
Loading notes…

4. Aircraft Fleet Registry

Registration	Aircraft Type	Type Code	Created At	Actions
Loading fleet…

WX AI Models Last changed: —

—

AI model catalogue for the WX page + master kill-switch. Stored in the D1 meta table as WX_AI_CATALOG / WX_AI_ENABLED. API keys are never stored here.

AI Enabled (Master Kill-Switch)

Controls whether AI weather analysis models are active across the WX module

LINKS Menu Last changed: —

—

Entries in the navbar LINKS dropdown. Stored in the D1 meta table as EXT_LINKS. Only https:// addresses are accepted.

System Health & Maintenance Console HEALTHY CLOUDFLARE D1

—

1. Live Service & Bridge Connectivity D1 verified · Click "⚡ Live Probe All" to test external VPS & Worker

Cloudflare D1 (awq-db) ONLINE

— ms

Primary SQLite edge database

Hermes AI VPS STANDBY

hermes-api

Click Live Probe to verify /health

Dispatch Assist Worker STANDBY

assist worker

Click Live Probe to verify worker

Google Briefing Bridge CHECKING

—

MailApp & DriveApp PDF archiver

2. Background Cron & Operational Feed Freshness Automated worker schedules & latest ingested timestamps

TAF Cron (*/30m) —

—

Schedule: */30 * * * *

WX Warning (*/4h) —

—

JTWC · Darwin VAAC · SIGMET

NOTAM Registry —

—

AD & FIR active notices

Flight Board & Sync —

—

OFP · CGO · ACFT Allocation

3. One-Click Admin Maintenance & Self-Healing Logged to D1 security audit trail

4. AI Quota, Minima Queue & 24h Security Posture Daily rate-limiter & authentication health

Gemini WX AI Daily Quota — / 500

Master switch & API key status

Airport Minima Extraction Queue — jobs Pending · Running · Succeeded · Failed

24h Security & Session Posture — active sessions Locked users · Denied RPCs · Audit capacity

5. D1 Database Inventory & Core Environment —

flights — notams — tafs — wx_warnings — ofp_plans — routes — waypoints —

Data source—

Timezone—

Last refresh—

Configuration status—

Operational data is stored in Cloudflare D1 (awq-db), no longer in a Google Spreadsheet. The legacy fields above are shown only when needed for migration checks.

Crew Briefing Email & Google Drive PDF Bridge INTEGRATION

Integrates Open Editable Form (/briefing-form) with Google Apps Script (MailApp + DriveApp) to email signing links to PIC/Pilots and automatically archive signed PDFs into Google Drive subfolder YYYY-MM (replacing old PDFs on revision).