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, 'unixepoch', 'localtime') AS visited_at,
 l.ZMAPITEMNAME AS place,
 l.ZMAPITEMADDRESS AS address,
 l.ZMAPITEMCITY AS city,
 l.ZLATITUDE AS latitude,
 l.ZLONGITUDE AS longitude,
 v.ZVISITCLASSIFICATION AS classification
FROM ZVISIT v
LEFT JOIN ZVISITEDLOCATION l
 ON v.ZLOCATION = l.Z_PK
ORDER BY v.ZSTARTDATE;
" > ~/Desktop/apple-maps-visits.csv

This exported 349 places, harvested starting October 9, 2025 (Mucho Burrito) and continuing to last night (Sobeys).

I’m not clear on what the threshold for “visited” is, but clearly there’s a relatively high bar, as I’ve certainly visited many more places than those 349.

For each place I get:

• Date and time: 2026-08-15 16:02:00
• Place name: Sobeys
• Street Address: 400 University Ave, Charlottetown PE C1A 4N6, Canada
• City: Charlottetown
• Latitude: 46.246187
• Longitude: -63.133117
• Classification: 7

I haven’t figure out what the “classifications” map to — my values are limited to 1, 4, 5, and 7, and there’s no rhyme nor reason as to what they represent.