Microsoft Photos App is the App that comes with Windows 10.
I turns out you can back it up or move it to another user if you copy the following directory:
C:\Users\<your_username>\AppData\Local\Packages\Microsoft.Windows.Photos_8wekyb3d8bbwe-av.zip\Microsoft.Windows.Photos_8wekyb3d8bbwe
Where <your_username> is your username. This contains things like the photos, albums, face recognition data, tags, etc.
Microsoft has conveniently placed all this information in a SQLite database which is located at:
C:\Users\<your_username>\AppData\Local\Packages\Microsoft.Windows.Photos_8wekyb3d8bbwe\LocalState\MediaDb.v1.sqlite
To view the data you can easily do so using DB Browser for SQLite.
If you are a developer this gives you a lot of information along with a pretty nice UI backed by Cognitive Services Face API (or so I assume). The difference is you don't have to pay for use of it because Microsoft is giving it to you for free with the Photos App (indirectly). All you have to do is query the SQLite database for any data you might want. Pretty nice. Thanks Microsoft.
Some tables you might find useful are:
TagVarient - the name of the tag (airplane, ocean, house, etc)
Tag - related to TagVarient and
Item - your photo or video name, size, location, duration, metadata, etc
ItemTags - joins the Tag and Item tables includes confidence score
Folder - the folders that contain your pictures and their sub folders.
Location - cities where the photos / videos were taken
Person - the people that it tagged and you grouped or it grouped. Represents the items on the People tab in the app. Includes count of people that match that face.
Face - information of where the faces are in each picture
Album - albums (generated). Not sure if self-created ones are here, but I assume they are.
23 comments:
If you are looking software development company in Jaipur check out here.
http://www.systemlogicsolution.com/software-development.aspx
Nice Post thanks for the information, good information & very helpful for others. For more information or For any Search Engine Optimization, Local SEO, Social Media Marketing, Google Ads & PPC, Website Designing, Email Marketing, Website Editing, and Audit Visit Digital Shout!
Apparrant is the best Mobile App Development Company in Noida and Web Application Development Company in Noida, Delhi NCR, Gurgaon, Faridabad, India, Toronto, and Canada. We are a leading Software Quality Assurance and App Testing company in Noida, India. We also provide IoT App Development Services in Noida as well as the best Project Management Services in Noida, Delhi NCR.
VidMate App allows you to convert music video into audio files, download your favourite movies in HD format non-stop from over 200 supported platforms, and all of these for free.!
Vidmate Apk
VidMate App allows you to convert music video into audio files, download your favourite movies in HD format non-stop from over 200 supported platforms, and all of these for free.!
Vidmate 2021
It looks like I may be the only comment not trying to sell something :-) Hopefully its useful because I havent seen similar info anywhere else.
I wanted to be able to create a query against the Photos database to output the People groups it identified through face recognition and the names I assigned to those recognition groups. I could then use this as input to a script to put those names as Tags in the actual pics and video files(still working on this). I used DB Browser to look at a copy of the MediaDb.v1.sqlite database(I would recommend not using the live database) and after some hours of trial and error, came up with the below query which will output the folder path and filename of the pic/video file, along with the Person Name assigned to the Photos face recognition group.
select folder_path,item_filename,person_name
from folder
join item on folder.folder_id = item.item_parentfolderid
join face on item.item_id=face.face_itemid join person on face.face_personid=person.person_id
where face_personid is not null and folder_path is not NULL and person_name is not NULL
order by face.face_personid
Jeewan Garg is a leading Website Designing Company in Delhi. It is all about professional web development and emerging technology where, you can get an excellent web application solution or a corporate web Application with web design as per your requirement. We are providing best suitable website design and conversion on the different types of spaces such as, Corporate Web Application Development in Delhi, Healthy Websites Development in Delhi, Website Migration from Existing Web Site Development in Delhi. We provide highly optimized websites on various platforms including Apple App Store, Microsoft Windows Store, Google Android Market, Samsung Apps Galaxy Apps and so on.
Bengal beauty parlour in meerut
Bengal beauty parlour meerut
Kanag
Best ENT Centre in Meerut
Maharashtra's own Makeup Academy BHI Makeup College located at Andheri West, Mumbai has been doing wonders in the field of this glamor world. The Academy was founded with an ultimate motive to serve the people in need of makeup courses who wants to get skilled in makeup field, but lacks proper training and knowledge about it. So take a risk to opt for this most reliable place where you will get yourself at - Affordable fee for best Makeup courses in Mumbai.
Dermatologist in Meerut
Nice blog. You make your point very clear about how to hire app developer. Freelancing platforms are very particular about the developer's skills and qualifications. I came across Eiliana.com, and it is a new yet great platform for technical experts. They hire developers according to their skills only.
Your info is really amazing with impressive content..Excellent blog with informative concept. Really I feel happy to see this useful blog, Thanks for sharing such a nice blog..
eniac full form in computer
dvd full form
sit full form
pcc full form
iucn full form
full form of lcd
brics full form
tally erp full form
full form of ctbt
crpf full form
This website is an online directory of all the smtp relay service providers. It has a very easy to use interface with a lot of information.
Frontier Airlines Albany NY
Frontier Airlines Albany NY
Frontier Airlines Albany NY
Frontier Airlines Albany NY
Frontier Airlines Albany NY
Frontier Airlines Albany NY
Frontier Airlines Albany NY
Frontier Airlines Albany NY
United Airlines Tampa Airport
United Airlines Tampa Airport
United Airlines Tampa Airport
United Airlines Tampa Airport
United Airlines Tampa Airport
So informative post ever I Read Dpi Web
Nice blog.
Repute Digital Business Agency is one of the top digital marketing agencies in Coimbatore that can help you grow your business online. Learn about their services and success stories to find the best fit for your needs.
Superb blog post guys. Chukra is the Top Digital marketing company in Coimbatore Grab the best opportunity to hike your business digitally across the globe. As well as reach up effectively to your target audience.
You have great content, Thank you so much. Digital Marketing Training in Ujjain offer the best digital marketing course and and training.
Hii
Thank you for the Sharing this information. This website serves as a comprehensive online directory, cataloging a wide array of SMTP relay service providers. Here is sharing some Netsuite Functional Training journey information may be its helpful to you.
Netsuite Functional Training
Post a Comment