The file media.db may only be found on Samsung devices running Android 11.� The file is located at /data/data/com.samsung.android.providers.media/databases/media.db.

Tables of Interest:

files

location

location_datetime_idx

tag_view � contains location data pertaining to the EXIF

The column �File Path� will have artifacts also being stored in Samsung Secure Folder. You may find additional tables of interest, so it�s worth examining all of them that contain information.

SQLite Query:

select
files._id,
files.media_id as "Media ID",
scene.parent_name as "Scene Parent Name",
scene.scene_name as "Scene Name",
files._data as "File Path",
files._size as "File Size (bytes)",
--File size is recorded in bytes and converts to Mebibytes to most accurately reflect the file size displayed on the device.
datetime(files.datetaken,'unixepoch','localtime') as "Date Taken",
datetime(files.date_added,'unixepoch','localtime') as "Date Added",
datetime(files.date_modified,'unixepoch','localtime') as "Date Modified",
files.mime_type as "MIME Type",
files._display_name as "Display Name",
files.bucket_display_name as "Bucket Display Name",
files.duration/1000.0 as "Duration (secs)",
CASE
when files.is_trashed = 0 then "No"
when files.is_trashed = 1 then "Yes"
end as "Is Trashed",
files.volume_name as "Volume Name",
files.latitude as "Latitude",
files.longitude as "Longitude",
location.country_code as "Country Code",
location.country_name as "Country Name",
location.admin_area as "Admin Area",
location.locality as "Locality",
location.addr as "Address",
location.street_name as "Street Name",
location.street_number as "Street Number",
location.postal_code as "Postal Code",
files.video_codec_info as "Video Codec",
files.audio_codec_info as "Audio Codec",
CASE
when files.is_cloud = 1 then "Yes"
when files.is_cloud = 0 then "No"
end as "Is Cloud",
scene.scene_score as "Scene Score"
from files
left join scene on scene.sec_media_id=files._id
left join location on location.latitude=files.latitude