How to export raw telemetry/trajectory data? - Export trajectories to csv

What you see is what you get. Export movement and location data about each object in raw format.

DataFromSky avatar
Written by DataFromSky
Updated over a week ago

Do you want to analyze the behavior of each object? You can export raw telemetry data of each detected object to a .CSV file, where you can get information about position, speed, acceleration, and other useful information for each millisecond of the video needed for further analysis.

To export raw telemetry data, go to Analysis - Export Trajectories to CSV File or click the icon on the main toolbar. Choose what kind of data you do want to export and submit your requirements for the export.

Once you export data to .CSV file, you can open the file by Microsoft Excel. Now you can see the following document.

The extracted file includes information about objects and their trajectories defined by:

  • Track ID and Type of object - Unique ID and type of identified object.

  • Entry Gate and its Entry Time [s] - Exact time when the vehicle passed through the entry gate that you have set.

  • Exit Gate and its Exit Time [s] - Exact Time when the vehicle passed through the exit gate that you have set.

  • Traveled Dist. [m] and Its Avg. Speed [km/h] - Traveled distance and average speed between gates.

And the following columns are repeated for each frame of the video. Each set of columns interprets one frame of the video when the vehicle was moving between set entry and exit gate.

  • Trajectory - x [deg], y [deg] - Position of the object within UTM or WGS84 system (based on your settings). The settings can be found under Settings/Application settings/Unit settings - Position unit.

  • Speed [km/h] - Speed of an object at a specific moment.

  • Tan. Acc. [ms-2], Lat. Acc. [ms-2] - Tangential and Lateral acceleration of the object at a specific moment.

  • Time [s] - Seconds from the beginning of the video, where the position, speed, and acceleration of the vehicle are measured.

  • Angle [rad] - Vehicle angle for each exported position of a Trajectory.

  • Traffic Regions (list) - Information about which Traffic Region a given Trajectory belongs to (which Traffic Region or Regions it is currently located for the given exporting step) This can be used for further analysis, e.g. if you define Traffic Regions as a road lane, you can detect the moment when a vehicle has moved from one lane to another, detect jaywalking and more...

  • Image x [px]; Image y [px] - position of the trajectory at a given time in regards to the image pixel coordinates, this is useful for doing your own heatmaps and for aggregating data from multiple files or traffic event types. Please note this data is affected by what you select in the Image Coordinates System dropdown menu in the export dialog window.

See other useful articles on how to export data about detected objects:

We will be happy to answer any questions you may have. Contact us!

Did this answer your question?