Dump1090 MySQL Database Script with Alert and Filter

[TomMuc]

Dump1090 MySQL Database Script - E-Mail-Alert Lat/Lon/Alt/Hex/Flight-Filter

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 …