Extracting “Visited Places” from Apple Maps

Recent versions the Maps application on iOS and macOS can automate, at your opt-in, the gathering of “Visited Places,” which Apple describes like this:The Visited Places feature helps you keep track of places you’ve been, so you can easily revisit or share them later. Use it to find past locations—like restaurants from a recent trip—and organize them into guides or share them with others. Visited Places are end-to-end encrypted, can’t be read by Apple, and appear on all your synced devices.I’ve had an interest, for more than 20 years, in this sort of “personal geolocation archive,” so I’m interested in this feature. There’s no built-in way to export the details of these places; a little bit of research reveals, however, that the data is there for the exporting, as it’s simply an SQLite database sitting on my Mac. Here’s how I exported it:sqlite3 -readonly -header -csv \ ~/Library/Containers/com.apple.Maps/Data/Maps/MapsSync_0.0.1 \ " SELECT datetime(v.ZSTARTDATE + 978307200,…