Expedition Data

MP4

Data engineering

Digging into video files for geolocations

So far I’ve found geolocations in XML metadata that my actioncam stores on disk as seperate .XML files and I’ve found them in JPG files. When I showed the cool maps I made to my father, he asked if I could create maps from his holiday videos. So that he can show cool maps in his video compilations.

 

Where do locations get stored in video files?

My father has a Sony PJ650VE video camera that makes videos in AVCHD format. Even the camera itself can show you a map of a video location. So I knew it should store geolocations somewhere. But looking on disk I saw no handy metadata files for me to read. So where did the locations go?

I learned that video formats like MP4, Quicktime (.mov) and AVCHD have EXIF metadata stored in them, just like JPG files. Luckily I had all the videos my father had made of our trip to the east coast of the USA in 2013. So I had lots of examples of AVCHD files to work with.

(more…)

By Marcel-Jan Krijgsman, 4 yearsMay 21, 2022 ago

Recent Posts

  • Let them eat cake. For better security.
  • Migrating from Evernote to Obsidian
  • Data modelling – the detective work you need to do to understand your source data.
  • Data engineering in the European cloud – Part 3: Adding data and visualisations
  • Data engineering in the European cloud – Part 2: Scaleway

Recent Comments

  1. Vincent on inkystarmap – an always up to date starmap on the wall
  2. Data modelling – the detective work you need to do to understand your source data. – Expedition Data on Profiling data with ydata in PySpark
  3. Data engineering in the European cloud – Part 3: Adding data and visualisations – Expedition Data on Data engineering in the European cloud – Part 1: the plan
  4. Data engineering in the European cloud – Part 2: Scaleway – Expedition Data on Data engineering in the European cloud – Part 1: the plan
  5. What I learned from using OCR to get data from my weighing scale | Expedition Data on Using OCR to get data from my Robi scale

Archives

  • September 2026
  • June 2026
  • February 2026
  • January 2026
  • November 2025
  • July 2025
  • June 2025
  • May 2025
  • April 2025
  • November 2024
  • May 2024
  • April 2023
  • December 2022
  • October 2022
  • August 2022
  • July 2022
  • May 2022
  • April 2022
  • March 2022
  • January 2022
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • February 2021
  • October 2020
  • November 2019
  • September 2019
  • June 2019
  • April 2019
  • March 2019
  • October 2018
  • September 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • February 2017

Categories

  • Active Learning
  • AI and LLMs
  • Apache Atlas
  • Apache Products for Outsiders
  • Azure
  • Cloud
  • Conferences
  • Data engineering
  • Data engineering in the European cloud
  • Data management
  • Events
  • Howto
  • Kubernetes
  • NoSQL
  • Python
  • Spark
  • Tech dossier
  • Things I Learned
  • Uncategorized
  • Weekendlinks
  • Weird experiments

Hestia | Developed by ThemeIsle