![]() ![]() when orientation is normalized, files with different orientations can be detected as duplicates (default: C:\Users\Hazzard\AppData\Local\Dobatymo\picture-tool\hashes.sqlite) hashdb PATH Path to sqlite database file to store hashes. `phash` calculates the perceptual hash of the image. `image-hash` hashes the uncompressed image data of the file and normalizes the `file-hash` simply hashes the whole file. ![]() ![]() v, -verbose Verbose output (default: False) r, -recursive Read directories recursively (default: False) GUI: browse image using map based on GPS or other meta data remember pruned files and optionally auto-prune new previously pruned files.standard prune operation: delete to bin, delete, move to dir, copy to dir, replace with (sym/hard-link).set exif time to mod time if exif time not available: UPDATE / SET exif_date = mod_time WHERE exif_date is null.find duplicates (handwavy) SELECT path, hamming_distance(A.sem_hash, B.sem_hash) AS dist FROM / AS A JOIN / AS B ON dist rotate pics correctly UPDATE / SET file_orientation = inferred_orientation WHERE file_orientation != inferred_orientation.move all pics of person to subfolder: UPDATE / SET directory = directory/$person WHERE person = Jack.find all pics in city: SELECT path FROM / WHERE is_close(location, "Tokyo").find best pic in every folder: SELECT max_by(path, quality_score) FROM / GROUP BY directory.count pics in folder and order by largest folder: SELECT count(*) AS num, path FROM / GROUP BY directory SORT BY num DESC.rename files: UPDATE /images/ SET filename = format("$date ($camera)", date, camera) WHERE camera = NIKON. ![]() GUI/CLI: support SQL syntax for finding and mass updating images and metadata Manual meta data: notes, personal-score, photographer Support inferred metadata: technical/aesthetic quality score, orientation, persons, setting, objects Support metadata: filesystem, Exif, IPTC, XMP. py statistics.py -sql "SELECT path, `0th Make`, `0th Model` FROM df WHERE `0th Model` LIKE '%canon eos%'" D:\įind all pictures taken by a Canon EOS camera using SQL query.py statistics.py "C:\Users\Public\Pictures" -filter "0th Model" "iPhone XR" -select pathįind all pictures taken with an iPhone XR and show the file paths.Show a list of all different camera models found with a count of how often they are used. py statistics.py "C:\Users\Public\Pictures" -groupby "0th Model".Reference, GPS GPS longitude reference, GPS GPS satellites, GPS GPS speed reference, File modification time Type, Exif Sharpness, Exif Sub seconds time, Exif Sub seconds time digitized, Exif Sub seconds time original,Įxif Subject area, Exif Subject distance range, Exif White balance, File size, GPS GPS DateStamp, GPS GPSĭestination bearing reference, GPS GPS geodetic datum, GPS GPS image direction reference, GPS GPS latitude Time, Exif Offset time digitized, Exif Offset time original, Exif Pixel X dimension, Exif Pixel Y dimension,Įxif Recommended exposure index, Exif Saturation, Exif Scene capture type, Exif Sensing method, Exif Sensitivity YCbCr positioning, Exif Body serial number, Exif Color space, Exif Contrast, Exif Custom rendered, Exif DateTimeĭigitized, Exif DateTime original, Exif Exposure mode, Exif Exposure program, Exif Flash, Exif Focal length inģ5mm film, Exif Focal plane resolution unit, Exif Gain control, Exif ISO speed ratings, Exif Image unique ID,Įxif Interoperability tag, Exif Lens make, Exif Lense model, Exif Light source, Exif Metering mode, Exif Offset Width, 1st JPEGInterchangeFormat, 1st JPEGInterchangeFormatLength, 1st Orientation, 1st Resolution unit, 1st Software, 0th Tile length, 0th Tile width, 0th YCbCr positioning, 1st Compression, 1st Image length, 1st Image Allowed features are: 0th Artist, 0th Bits per sample, 0th Compression, 0thĬopyright, 0th DateTime, 0th ExifTag, 0th GPSTag, 0th Host computer, 0th Image description, 0th Image length,Ġth Image width, 0th Make, 0th Model, 0th Orientation, 0th Photometric interpretation, 0th Planar configuration,Ġth Processing software, 0th Rating, 0th RatingPercent, 0th Resolution unit, 0th Samples per pixel, 0th groupby FEATURE Collect statistics for feature. out PATH If given write csv output to file sort-values Sort output by value instead of key h, -help show this help message and exit ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |