TomMuc
October 17, 2017, 5:53pm
53
ok - so we’ll see tomorrow what the result is …
some short examples what you can do with your own harvested data
count the distinct number of aircrafts you got messages from:
select count(distinct hex) from aircrafts;
count how many messages you received per aircrafts:
SELECT hex, COUNT(hex) number FROM aircrafts GROUP BY hex
combine your data with e.g. basestation.sqb - see output below sql sample:
select * from aircrafts inner join basestation on aircrafts.hex = basestation.ModeS
sample output:
id date now …
writes Dump1090 data to database and e-mail alerts on special events. you can set how often the script writes to database and looks for alert condition. you can specify the area (lat/lon/alt) to be observed and filter for special hex and/or flight numbers.
[screen]
[screen]
please do not abuse my script to generate and publish the flightaware-mlat-data anywhere - this data is only meant for your personal use. you find additional information here: FlightAware MLAT Network Announcement
git i…
