This repository contains the code used for the Plane Spotting with Redis shows that are part of my Things on Thursdays live streaming series.
If you want to hear the GIF demo above with glorious sound too, check out the YouTube video. I wish GitHub would do proper embedding of YouTube videos in README files...
The videos for this project can be found on YouTube:
- Episode 1: Project introduction, live coding the radio receiver component.
- Episode 2: Enriching the flight data with the FlightAware API
- Episode 3: Searching the data with Redis Stack's Search capability
- Episode 4: Building the notifier component
- Episode 5: Building notification devices (Scheduled: March 14 1pm UTC)
- Further episodes coming soon, watch the Redis Developer Relations Streaming Schedule for details!
TODO
Almost all components of this project are written in Node.js. They use features of JavaScript that require a recent version of Node. I've tested them all with Node 16.15.1 on both macOS Ventura and Raspberry Pi OS (Debian 11 - "bullseye" version).
All of the components connect to a single Redis Stack database. This is where they store data and communicate with each other in a variety of ways.
Get a free cloud hosted database here, or use the redis-stack Docker image (here) or use the Docker compose file at the root of this repository.
It's also a good idea to download and install RedisInsight, a free tool for managing and visualising data in Redis. Use this to see what's going on with your Redis Stack instance.
TODO describe these properly...
Which Easyjet (U2) Airbus 319 aircraft have we seen, and where were they going to/from?:
ft.search idx:flights "@operator_iata:{U2} @aircraft_type:{A319}" return 3 origin_name destination_name registration limit 0 2
Example response:
1) "9"
2) "flight:400E59"
3) 1) "origin_name"
2) "Charles de Gaulle/Roissy"
3) "destination_name"
4) "Glasgow Int'l"
5) "registration"
6) "G-EZAW"
4) "flight:4010EB"
5) 1) "origin_name"
2) "London Luton"
3) "destination_name"
4) "Inverness"
5) "registration"
6) "G-EZBW"
Whose Airbus A350-1000 or Boeing 787-9 aircraft have we seen?
ft.search idx:flights "@aircraft_type:{A35K|B789}" return 3 operator_iata registration aircraft_type
Example response:
1) "6"
2) "flight:A31A54"
3) 1) "operator_iata"
2) "UA"
3) "registration"
4) "N29975"
5) "aircraft_type"
6) "B789"
4) "flight:C07B42"
5) 1) "operator_iata"
2) "WS"
3) "registration"
4) "C-GURP"
5) "aircraft_type"
6) "B789"
6) "flight:407AF3"
7) 1) "operator_iata"
2) "BA"
3) "registration"
4) "G-XWBI"
5) "aircraft_type"
6) "A35K"
8) "flight:407AF4"
9) 1) "operator_iata"
2) "BA"
3) "registration"
4) "G-XWBK"
5) "aircraft_type"
6) "A35K"
10) "flight:40771A"
11) 1) "operator_iata"
2) "VS"
3) "registration"
4) "G-VDOT"
5) "aircraft_type"
6) "A35K"
12) "flight:4077D3"
13) 1) "operator_iata"
2) "VS"
3) "registration"
4) "G-VTEA"
5) "aircraft_type"
6) "A35K"
Which aircraft have passed within 20,000 metres of central Nottingham? Return them sorted by distance, closest first.
ft.aggregate idx:flights "*" load 3 @position @operator_iata @flight_number filter "exists(@position)" filter "exists(@operator_iata)" apply "geodistance(@position, \"-1.148369,52.953150\")" as dist filter "@dist < 20000" sortby 2 @dist asc limit 0 3
Example response:
1) "102"
2) 1) "position"
2) "-1.30989,53.01416"
3) "operator_iata"
4) "BA"
5) "flight_number"
6) "85"
7) "dist"
8) "12768.43"
3) 1) "position"
2) "-1.30926,53.01676"
3) "operator_iata"
4) "AA"
5) "flight_number"
6) "135"
7) "dist"
8) "12888.89"
4) 1) "position"
2) "-1.35093,53.02886"
3) "operator_iata"
4) "AC"
5) "flight_number"
6) "861"
7) "dist"
8) "15963.52"
Which aircraft are flying at 32,000ft or higher?
ft.search idx:flights "@altitude:[32000 +inf]" sortby operator_iata asc return 4 operator_iata destination_name aircraft_type altitude limit 0 3
Example response:
1) "29"
2) "flight:A80A8F"
3) 1) "operator_iata"
2) "5X"
3) "destination_name"
4) "Cologne Bonn"
5) "aircraft_type"
6) "B748"
7) "altitude"
8) "37000"
4) "flight:405A48"
5) 1) "operator_iata"
2) "BA"
3) "destination_name"
4) "George Best Belfast City"
5) "aircraft_type"
6) "A320"
7) "altitude"
8) "33225"
6) "flight:407464"
7) 1) "operator_iata"
2) "BA"
3) "destination_name"
4) "Inverness"
5) "aircraft_type"
6) "A20N"
7) "altitude"
8) "36750"
What different types of aircraft are out there?
ft.aggregate idx:flights "*" load 1 @aircraft_type filter "exists(@aircraft_type)" groupby 1 @aircraft_type reduce count 0 as num sortby 2 @num desc limit 0 9999
Example response:
1) "18"
2) 1) "aircraft_type"
2) "A320"
3) "num"
4) "16"
3) 1) "aircraft_type"
2) "A319"
3) "num"
4) "10"
4) 1) "aircraft_type"
2) "B738"
3) "num"
4) "7"
5) 1) "aircraft_type"
2) "A20N"
3) "num"
4) "5"
6) 1) "aircraft_type"
2) "A35K"
3) "num"
4) "4"
...
Find the closest "interesting" aircraft that passed by most recently since a given timestamp. Interesting is defined as "it's a widebody aircraft, or some other types such as a 757". Check out Wikipedia's table of aircraft type codes.
ft.aggregate idx:flights "*" load 4 @__key @position @aircraft_type @last_updated filter "exists(@position)" filter "exists(@aircraft_type)" filter "@last_updated > 1677087696402" filter "@aircraft_type=='A124' || @aircraft_type=='A388' || @aircraft_type=='A35K' || @aircraft_type=='A359' || @aircraft_type=='A346' || @aircraft_type=='A345' || @aircraft_type=='A343' || @aircraft_type=='A342' || @aircraft_type=='A332' || @aircraft_type=='A333' || @aircraft_type=='A339' || @aircraft_type=='A337' || @aircraft_type == 'A310' || @aircraft_type=='A306' || @aircraft_type=='A30B' || @aircraft_type=='A3ST' || @aircraft_type=='B788' || @aircraft_type=='B789' || @aircraft_type=='B78X' || @aircraft_type=='B744' || @aircraft_type=='B748' || @aircraft_type=='B752' || @aircraft_type=='B753' || @aircraft_type=='B762' || @aircraft_type=='B763' || @aircraft_type=='B764' || @aircraft_type=='B772' || @aircraft_type=='B773' || @aircraft_type=='B77W' || @aircraft_type=='B77L'" apply "geodistance(@position, \"-1.148369,52.953150\")" as dist filter "@dist < 20000" sortby 2 @last_updated desc limit 0 1
Example response:
1) "102"
2) 1) "__key"
2) "flight:405BFD"
3) "position"
4) "-1.30989,53.01416"
5) "aircraft_type"
6) "B772"
7) "last_updated"
8) "1677087696405"
9) "dist"
10) "12768.43"