Page 2 of 2 FirstFirst 12
Results 11 to 19 of 19

Thread: Raspberry Pi using DUMP1090 to a csv file?

  1. #11
    Passenger
    Join Date
    Feb 2014
    Posts
    4
    Quote Originally Posted by k6rtm View Post
    I'm also interested in harvesting data from dump1090 for other purposes; early code perfectly acceptable!
    Hai guys

    Please see

    https://github.com/DE8MSH/dump1090-sqlite

    which gives you an option to save data to sqlite database. i did not test it since I don t have linux to compile.

    Please check and give feed back if possible

    Regards

    Manoj

  2. #12
    Passenger
    Join Date
    Mar 2014
    Posts
    4
    Hi!

    I use this bit of linux magic to log all the ADS-B packets with position info into a .csv file:

    nc 127.0.0.1 30003 | grep --line-buffered MSG,3, >> /folder/somewhere/positions.20141124.csv

    Leaving out ">> positions.20141124.csv" brings packets into console.

    Then I import this file in www.cartodb.com, a little bit of cleanup and then in ten minutes I have a map like this:

    flights.jpg

    It's a .csv file, so you can use that data anyway you want

    Hope this is what you're looking for...

    -Tomi
    Last edited by tsimola; 2014-11-25 at 18:14.

  3. #13
    First officer nzradar's Avatar
    Join Date
    Apr 2011
    Location
    Palmerston North, New Zealand (T-NZPM21)
    Posts
    273
    Thanks Tomi, that's very interesting, I'm now gathering my MSG3 lines to see what size file I get for a day. I did try running a second instance to get MSG1 lines that gather the callsigns but when I did it stopped the first netcat instance so I need to figure out how to collect both lines. Google is so my best friend these days!
    Michael
    Palmerston North,
    New Zealand
    ex-FR24 Feeder

  4. #14
    First officer nzradar's Avatar
    Join Date
    Apr 2011
    Location
    Palmerston North, New Zealand (T-NZPM21)
    Posts
    273
    I used this to get multiple MSG lines:

    nc 192.168.1.5 30003 | egrep --line-buffered 'MSG,1,|MSG,3,' >> /folder/somewhere/tracks_callsigns.csv

    Note the use of egrep instead of grep

    Cool
    Last edited by nzradar; 2014-11-26 at 00:26.
    Michael
    Palmerston North,
    New Zealand
    ex-FR24 Feeder

  5. #15
    Passenger
    Join Date
    Mar 2014
    Posts
    4
    Glad to help! I have a setup in Southern Finland in my parents place which can see around 140 planes a day (mostly flights to Far East). Position only csv is 2+ megabytes for 24 hrs..

  6. #16
    First officer nzradar's Avatar
    Join Date
    Apr 2011
    Location
    Palmerston North, New Zealand (T-NZPM21)
    Posts
    273
    I started my combined netcat at around 1.30pm local today and it's only 9Mb for six hours so far with the quiet time to come so I wouldn't expect too much over 20Mb for a busy day down here. I'm not sure what I can do with it after but at least the positions can be plotted on cartodb.com.
    Michael
    Palmerston North,
    New Zealand
    ex-FR24 Feeder

  7. #17
    Passenger
    Join Date
    Mar 2014
    Posts
    4
    One guy in Reddit put the data into MATLAB and made 3D visualisation of flights:

    http://i.imgur.com/smRgo5W.gif
    http://www.reddit.com/r/RTLSDR/comme..._my_area_levc/

    Also cartodb.com has one map option which makes an animation of the data...

    I would like to see these made of Queenstown flights :-)

  8. #18
    Purser
    Join Date
    Apr 2015
    Location
    Switzerland
    Posts
    129
    Quote Originally Posted by nzradar View Post
    I used this to get multiple MSG lines:

    nc 192.168.1.5 30003 | egrep --line-buffered 'MSG,1,|MSG,3,' >> /folder/somewhere/tracks_callsigns.csv

    Note the use of egrep instead of grep

    Cool
    someone can tell if this method run on non stop? how can i stop or start again?
    thanks in advanced

  9. #19
    Purser
    Join Date
    Apr 2015
    Location
    Switzerland
    Posts
    129
    well i find a great way to do this, without any others software, make sure you have enabled raw data on port 30003 (dump1090 --raw) or 192.168.x.x:8754 in dump arguments write --raw, restart dump1090.

    Go to console terminal and type:

    sudo wget -O - -q http://myreceiver:30003 > log.txt .csv .kml or wathever format you want, press ctrl+c to stop it, type in terminal ls and you see your file in root directory, there are many options , make a executable sh or automate the process with crontab. you can upload data to catodb.com or in google earth. Enjoy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •