database design for video data entry.

Discussion created by jonathannolan on Oct 5, 2016
Latest reply on Oct 6, 2016 by twelvetens

I have a difficult database design and I'm not sure how to figure it out.



I have two videos taken at the same time using an action camera. The video has associated data like GPS and accelerometer data. The data is stored currently in CSV format and can be linked to the video by timestamp.


I want to create a data entry field where users can watch both videos playing at the same time, and occasionally click pause where an event happens and enter more information.


e.g. in our case it is cars passing bikes and we want users to press pause and say "that car was a toyota carolla" and for that information to be stored as a row in a database.


Is there anyway to achieve this? It seems very difficult conceptually, I'm interested in your ideas.