cmbahadir / PlaneSpotter

Trace and Analyze the ADS-B data of the overhead aircrafts and predict the location of the nearest airport/field.
Apache License 2.0
3 stars 1 forks source link

Meaningless Data on ADSBDATA Table and GUI #1

Closed cmbahadir closed 5 years ago

cmbahadir commented 6 years ago

Test Environment: Apache2 - Raspberry Pi - MySQL DB Version: v0.0

Test Steps: 1- Run httppost_adsb.py 2- mysql - select * from ADSBDATA. 3- Navigate to http://192.168.1.12

Test Data: modes1.bin

Expected Result:

image

Actual Result:

On GUI:

image

On MySQL:

image

hsynercn commented 6 years ago

Ya nasil oluyormus bakalim

cmbahadir commented 6 years ago

Selam Huseyin,

Decode icin https://github.com/antirez/dump1090'i kullaniyorum, problem burdan gelen basliklari filtrelemeden db'ye insert etmem. Aklimda 3 secenek var.

1- dump1090'daki asagidaki printfleri silmek. (Onceden boyle yapmistim.)

https://github.com/antirez/dump1090/blob/d4be3b8a25765de9f36f2aff697f61f914c65f13/dump1090.c#L1810

2- add.php'de insert ederken baslik satirini filtrelemek.

https://github.com/cmbahadir/PlaneSpotter/blob/master/add.php

3- HTTP Post sirasinda filtrelemek.

https://github.com/cmbahadir/PlaneSpotter/blob/master/raspberrypi/httppost_adsb.py

Not: Bu arada su anda development environment ayakta degil :)