Data Visualization

Live Flight Map — Canada

Real-time Canadian aircraft positions sourced from the OpenSky Network API, updated every 15 minutes. Each marker shows callsign, altitude, speed, and country of origin.

Connecting…

Flight data provided by The OpenSky Network under their terms of use. Data is used for non-commercial, educational purposes only.

✈️

Aircraft Visible

—

in bounding box

🏔️

Avg Altitude

—

💨

Avg Speed

—

kts

🌍

Top Origin

—

by aircraft count

Top Countries

Speed Distribution

Under the Hood

Architecture & Data Pipeline

Two complementary visualization layers built on top of a fully automated backend pipeline.

🗺️

Leaflet.js — Live Map

The interactive map is powered by Leaflet.js, an open-source JavaScript mapping library. Aircraft markers are rendered as SVG icons, rotated to match each flight’s heading and colour-coded by country of registration. Clicking a marker shows callsign, altitude, speed, and origin country.

🗄️

Oracle APEX — SQL Analytics

The APEX dashboard queries an Oracle Autonomous Database that accumulates historical snapshots every 15 minutes. SQL-driven charts cover flights by country, altitude distribution, and traffic trends over the last 24 hours — enabling time-series analysis beyond a single snapshot.

🍓

Raspberry Pi 5 — Data Collector

A Raspberry Pi 5 runs a Python script every 10 minutes on clock boundaries (:00, :10, :20…). It authenticates with the OpenSky Network API via OAuth2 Client Credentials Flow, obtaining a fresh Bearer token on each run. The script queries a bounding box covering Canadian airspace and pushes flights.json to the web server via SCP.

⏱️

Oracle DBMS_SCHEDULER — DB Ingestion

On the Oracle Cloud side, a DBMS_SCHEDULER job runs every 15 minutes. It fetches the latest flights.json via UTL_HTTP, parses it with APEX_JSON, and inserts each record into the flights table — building the historical dataset that powers the APEX charts and trend analysis.

Oracle APEX Dashboard

Database-driven reporting

An Oracle APEX dashboard connected to a live database will be embedded here, showcasing SQL-based analytics, drill-down reports, and interactive charts — all built on Oracle’s Always Free cloud tier.

Flight Stats Dashboard

SQL-based analytics on live flight data — built with Oracle APEX and Oracle Autonomous Database (Always Free).

Open Dashboard