guycole / mellow-hyena Goto Github PK

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.

expose collection stats to prometheus

last dump1090/978 sample time and sample population

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

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

old version was not in Documents directory

skip adsb exchange call if key equals "bogus"

rename s3 bucket and not have name in repository

dump978?

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

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?

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

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

see subject

restrict S3 ops

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

ACARS collection experiments