Hello everyone, I was wondering if anyone has any suggestions or workflows on organising all the data collected from drones.  At the moment I have a folder system, with date, log files, images etc, but worried it may soon grow out of control. I have been thinking about linking it to a database of some sort, perhaps excel or something like that, where I could run search queries.

I know there are quite a few web services that provide this but I was looking for an in-house solution, anyone heard of ant handy apps or ways of doing this ?

I'll keep experimenting and post any progress.

Thanks

Nick

You need to be a member of diydrones to add comments!

Join diydrones

Email me when people reply –

Replies

  • This is a good question.  I haven't started collecting data yet (next week) but it's something I've been thinking about as well.  I am planning to use PostgreSQL with PostGIS to keep track of all the imagery that we collect.  It's a database system that can be installed on a local machine and once the images have been imported, they can be exported in most anything.  It's a steep learning curve, but it's a very capable platform and is used in all kinds of Geographic Information Systems.  QGIS is a great program that can be used as a visual frontend to query and display the datasets.  Between the two of them there are a lot of functions to manipulate the data and get it into a format that the end user can use.  The advantage of using these systems is that they keep track of the geographic information too.  So you can use spatial queries to find data/images.  These are free and open source.  However, where there's no monetary investment, it will take a substantial time investment to get up and running, but that's always the trade off.  If you find something else, let me know...

    http://www.postgresql.org/
    http://postgis.net/
    http://www.qgis.org/en/site/

    • Thanks Thomas, yeah that's a great idea with SQL. I'll look into it. Do you reckon there are any plugins or even website addons which could help in the "importing" process ?

      I'll Check it out and post any news.

      Thanks

      Nick

This reply was deleted.

Activity

Gremsy liked Gremsy's profile
Mar 12
DIY Robocars via Twitter
RT @chr1sa: Donkeycar 4.4 released with tons of new features, including path learning (useful with GPS outdoors), better Web and Lidar supp…
Nov 27, 2022
DIY Robocars via Twitter
RT @NXP: We are already biting our nails in anticipation of the #NXPCupEMEA challenge! 😉 Did you know there are great cash prizes to be won…
Nov 24, 2022
DIY Robocars via Twitter
RT @gclue_akira: レースまであと3日。今回のコースは激ムズかも。あと一歩 #jetracer https://t.co/GKcEjImQ3t
Nov 24, 2022
DIY Robocars via Twitter
UC Berkeley's DIY robocar program https://roar.berkeley.edu/
Nov 24, 2022
DIY Robocars via Twitter
RT @chr1sa: The next @DIYRobocars autonomous car race at @circuitlaunch will be on Sat, Dec 10. Thrills, spills and a Brazilian BBQ. Fun…
Nov 24, 2022
DIY Robocars via Twitter
RT @arthiak_tc: Donkey car platform ... Still training uses behavioral cloning #TCXpo #diyrobocar @OttawaAVGroup https://t.co/PHBYwlFlnE
Nov 20, 2022
DIY Robocars via Twitter
RT @emurmur77: Points for style. @donkeycar racing in @diyrobocars at @UCSDJacobs thanks @chr1sa for taking the video. https://t.co/Y2hMyj1…
Nov 20, 2022
DIY Robocars via Twitter
RT @SmallpixelCar: Going to @diyrobocars race at @UCSDJacobs https://t.co/Rrf9vDJ8TJ
Nov 8, 2022
DIY Robocars via Twitter
RT @SmallpixelCar: Race @diyrobocars at @UCSDJacobs thanks @chr1sa for taking the video. https://t.co/kK686Hb9Ej
Nov 8, 2022
DIY Robocars via Twitter
RT @PiWarsRobotics: Presenting: the Hacky Racers Robotic Racing Series in collaboration with #PiWars. Find out more and register your inter…
Oct 23, 2022
DIY Robocars via Twitter
RT @Hacky_Racers: There will be three classes at this event: A4, A2, and Hacky Racer! A4 and A2 are based around UK paper sizing and existi…
Oct 23, 2022
DIY Robocars via Twitter
Oct 23, 2022
DIY Robocars via Twitter
Oct 19, 2022
DIY Robocars via Twitter
Oct 18, 2022
DIY Robocars via Twitter
RT @NeaveEng: Calling all UK based folks interested in @diyrobocars, @f1tenth, @donkey_car, and similar robot racing competitions! @hacky_r…
Oct 13, 2022
More…