CS50x Final Project

AVIAMAP

Video Demo: https://youtu.be/H4_hAgqPQ54

Description:

Foreword

The project is a website with aircrafts and airports database and real-time aircraft flight tracking information on a map.

URL: martynov.ddns.net

Brief information about the data

ICAO - International Civil Aviation Organization

Each airraft has an ID - ICAO24 24-bit unique code, and if known, it's possible to find a lot of info about the aircraft - manufacturer, ICAO type, model, owner (airline, private etc.), description, engine type and quantity and so on. Example from the project:

ICAO24 aircraft ID: 4bb142
Boeing B77W
LandPlane 2 Jet engines
Origin: Turkey
Owner: Turkish Airlines
Flag: THY
Registration: TC-LJB

Most aircraft, but not all, are equipped with ADS-B - Automatic Dependent Surveillance–Broadcastdevice, thanks to which its current position (latitude and longitude), altitude, speed and direction are known.

Aircraft on air has a Callsign - almost the same as a flight number, but not exactly - Aviation call signs. Knowing the callsign, it is possible to obtain flight data, for example, the airport of departure and destination, example from the project:

Airports also have unique IDs - ICAO airport code that allow you to get the location and details of the airport:

JFK
Airport: John F Kennedy Intl
City: New York
Country: United States
Geo: 40.64, -73.78
Runway: 4442.0 m
Altitude: 4.0 m

Project data sources

• The OpenSky Network API
• hexdb.io API
• open-meteo.com API

Project programming languages

• Python
• JavaScript
• SQL

Project framework

• Django

Project environment

• OS: Microsoft Windows 10 Pro
• Web-server: Microsoft IIS
• DBMS: MySQL

Resources used

• Pusher - for user presence and real-time communicatin
• LeafletJS - for dynamic map
• Folium -for map with clusters
• Plotly - for charts
• Bootstrap 5

Project Django apps

• main - project layout, navbar, mmessages and some other common functions
• account - user login, logout, registration and visits database
• avia - the project itself, aircraafts/airports database and live flight map.
• knowledgedb - simple small knowledge base on wep development, programming.
• rtc - pusher realtime communication
• wall - let users to write comments and likes/dislikes.

Project database schema

Project file structure

├───account
│   ├───migrations
│   │   └───__pycache__
│   ├───templates
│   │   └───account
│   └───__pycache__
├───avia
│   ├───migrations
│   │   └───__pycache__
│   ├───templates
│   │   └───avia
│   └───__pycache__
├───knowledgedb
│   ├───migrations
│   │   └───__pycache__
│   ├───templates
│   │   └───knowledgedb
│   └───__pycache__
├───main
│   ├───migrations
│   │   └───__pycache__
│   ├───templates
│   │   └───main
│   └───__pycache__
├───martynov
│   └───__pycache__
├───media
│   ├───account
│   │   ├───avatars
│   │   └───ext_avatars
│   ├───avia
│   │   └───symbols
│   ├───download
│   ├───images
│   ├───knowledgedb
│   │   ├───analog_instruments
│   │   ├───books
│   │   ├───django_listview
│   │   ├───homesite
│   │   ├───pusher_django
│   │   ├───python
│   │   ├───rabbit
│   │   └───rabbitmq
│   └───upload
├───rtc
│   ├───migrations
│   │   └───__pycache__
│   └───__pycache__
├───static
│   ├───account
│   │   ├───images
│   │   │   └───avatars
│   │   └───js
│   ├───admin
│   │   ├───css
│   │   │   └───vendor
│   │   │       └───select2
│   │   ├───fonts
│   │   ├───img
│   │   │   └───gis
│   │   └───js
│   │       ├───admin
│   │       └───vendor
│   │           ├───jquery
│   │           ├───select2
│   │           │   └───i18n
│   │           └───xregexp
│   ├───avia
│   │   ├───css
│   │   ├───icons
│   │   │   └───meteo
│   │   ├───images
│   │   └───js
│   ├───bootstrap
│   │   └───fonts
│   ├───css
│   ├───images
│   │   ├───backgrounds
│   │   └───cursors
│   ├───leaflet
│   │   └───images
│   ├───main
│   │   ├───images
│   │   │   ├───about_me
│   │   │   └───about_project
│   │   └───js
│   ├───manifest
│   ├───utils
│   │   └───css
│   └───wall
│       └───js
├───utils
│   ├───migrations
│   │   └───__pycache__
│   ├───templates
│   │   └───utils
│   └───__pycache__
└───wall
    ├───migrations
    │   └───__pycache__
    └───__pycache__