guycole/mellow-hyena

ADS-B/UAT aviation monitoring

mellow-hyena's Issues

expose collection stats to prometheus

expose collection stats to prometheus

last dump1090/978 sample time and sample population

write only AWS S3 policy

restrict S3 ops

add test device

if device ends in test, i.e. rpi3b-adsb-test then it should not be loaded into production database

postgres on boris displays local time instead of UTC

load_log.obs time and load time are in local
observation.obs_time also uses local
might be others
is pgsql configured to show UTC?

update path in scripts

should be /home/gsc/Documents/github/mellow-hyena

old version was not in Documents directory

ACARS collection experiments

ACARS collection experiments

enhanced daily reporting

should include total by aircraft type and flags (i.e. military, privacy, etc)

observation row should include bearing and distance from receiver

new columns for observation row: range, bearing
bearing in degrees, 0 north positive clockwise (integer is ok)
distance in nautical miles? kilometers? some observations are > 100 nm.

collect mode-s transponders

Some aircraft are only trackable via "mlat" which requires collecting mode-s transponders.

https://mode-s.org/decode/content/quickstart.html

add TIS-B support

dump978?

control power switch via ethernet

see subject

skip adsb exchange call if key equals "bogus"

skip adsb exchange call if key equals "bogus"

deduplicate observations before loading into postgres

some observations have duplicate information, i.e. same adsb_hex, timestamp, location
test for adsb_hex, obs_time before insertion, make this a unique index in postgres