Daily Video Log from Overland/Swarm data

[gloriouslyawkwardlife]

UPDATE 23 Dec 2024: I started posting the resulting vids to my Notion: https://is.gd/1R9Cmn

---

As I'm a visual guy, I started playing with a combination of Overland data and Swarm checkins to come up with this daily video:

https://drive.google.com/file/d/1MaY_pcUPVU7CUUYhcC27orznusamAXwj/view?usp=sharing

Checkins appear in the lower left of the frame when they occur. The video is basically one frame per GPS fix (which is once per second) and 60 fps, so one second of video is one minute of real time.

I save the original Overland data JSON in a CouchDB database, as it works directly with JSON over an HTTP API, and then have the relevant info also put into a MariaDB database as it's faster to query than CouchDB. The video frames are created using a Python script with py-staticmaps to create the map with OSM tiles, PIL (pillow/Python Image Library) to add the text, and then ffmpeg to compile the frames into an H.264 video.

I also regularly import my Apple Health data into the same database so at some point I may add health metrics to this as well so I can more easily identify what I'm doing/where I am when, say, my heart rate jumps over 120 (usually after trudging up the ramp to the Disney World Monorail at EPCOT).

BTW, I notice that the 'activity' field in the data packet is always empty. What should that be used for? Also, I think the speed being provided in the data package is reporting too low (would help if I read to know it's meters/second instead of miles/hour.)