photos_with_apple_metadata (view)

3 rows where ZPLEASANTSYMMETRYSCORE = "0.0027904510498046875"

View and edit SQL

Suggested facets: albums, persons, ext, favorite, ZCURATIONSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (array)

rowid photo uuid date albums persons ext sha256 size latitude longitude favorite portrait screenshot slow_mo time_lapse hdr selfie panorama place_city place_state_province place_country ZUUID ZOVERALLAESTHETICSCORE ZCURATIONSCORE ZPROMOTIONSCORE ZHIGHLIGHTVISIBILITYSCORE ZBEHAVIORALSCORE ZFAILURESCORE ZHARMONIOUSCOLORSCORE ZIMMERSIVENESSSCORE ZINTERACTIONSCORE ZINTERESTINGSUBJECTSCORE ZINTRUSIVEOBJECTPRESENCESCORE ZLIVELYCOLORSCORE ZLOWLIGHT ZNOISESCORE ZPLEASANTCAMERATILTSCORE ZPLEASANTCOMPOSITIONSCORE ZPLEASANTLIGHTINGSCORE ZPLEASANTPATTERNSCORE ZPLEASANTPERSPECTIVESCORE ZPLEASANTPOSTPROCESSINGSCORE ZPLEASANTREFLECTIONSSCORE ZPLEASANTSYMMETRYSCORE ZSHARPLYFOCUSEDSUBJECTSCORE ZTASTEFULLYBLURREDSCORE ZWELLCHOSENSUBJECTSCORE ZWELLFRAMEDSUBJECTSCORE ZWELLTIMEDSHOTSCORE
431 50572BE9-4D25-4D5E-8C39-9C413FEAB7FE 2020-04-21T21:51:03+00:00
[
    "Public"
]
[]
jpeg d9668136b02a64f8fd334852d774fa2532cc81b501276c9e1e12014c62be438f 6031319     0 0 0 0 0 0 0 0       50572BE9-4D25-4D5E-8C39-9C413FEAB7FE 0.70654296875 0.5 0.0 0.0450937015409688 0.10000000149011612 -0.043609619140625 0.00765228271484375 0.01337432861328125 0.009999999776482582 -0.491455078125 -0.05419921875 -0.0845947265625 0.1483154296875 -0.131103515625 -0.046844482421875 -0.35986328125 -0.45068359375 0.036163330078125 -0.025604248046875 0.0085906982421875 -0.00960540771484375 0.0027904510498046875 0.00395965576171875 -0.1129150390625 -0.0090179443359375 -0.234619140625 -0.007171630859375
128 B2F26E79-7A85-497E-AD2F-D599633EA720 2019-08-21T11:43:53+00:00
[
    "Public"
]
[]
jpeg 3bd461b7f1c5b8c4de844951f86168d510082ae55c2a23223b7cc5ada0ce29f5 7020346     1 0 0 0 0 0 0 0       B2F26E79-7A85-497E-AD2F-D599633EA720 0.57568359375 0.75 0.0 0.061105291352017234 0.10000000149011612 -0.005889892578125 0.0174102783203125 0.0021572113037109375 0.05999999865889549 -0.1673583984375 -0.08465576171875 0.066162109375 0.01282501220703125 -0.0211181640625 -0.022796630859375 -0.159423828125 -0.1455078125 0.0416259765625 0.03692626953125 0.0023956298828125 -0.00726318359375 0.0027904510498046875 0.0987548828125 0.1475830078125 0.02117919921875 0.413818359375 0.025848388671875
354 A6C2C9FE-D032-450F-B0FC-AF6191226FA9 2018-02-20T23:15:38+00:00
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
[
    "_UNKNOWN_"
]
heic abb62ed287656b13ebdd9963dcb71d17831ccb5501f9523c0bfa2e556e8805c2 1898626 37.74283833333333 -122.44926333333333 0 0 0 0 0 0 0 0 San Francisco CA United States A6C2C9FE-D032-450F-B0FC-AF6191226FA9 0.50341796875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0165863037109375 0.020751953125 0.00646209716796875 0.009999999776482582 -0.52392578125 -0.09600830078125 -0.0655517578125 0.039276123046875 -0.01322174072265625 -0.01092529296875 -0.2071533203125 -0.216064453125 0.0210113525390625 0.0928955078125 0.00466156005859375 -0.0024623870849609375 0.0027904510498046875 0.049224853515625 0.1353759765625 0.01953125 0.07037353515625 0.038360595703125

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW photos_with_apple_metadata AS 
    select
        apple_photos.rowid,
        json_object(
            'img_src',
            'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=600'
        ) as photo,
        apple_photos.uuid,
        apple_photos.date,
        apple_photos.albums,
        apple_photos.persons,
        uploads.ext,
        uploads.sha256,
        uploads.size,
        latitude,
        longitude,
        favorite,
        portrait,
        screenshot,
        slow_mo,
        time_lapse,
        hdr,
        selfie,
        panorama,
        place_city,
        place_state_province,
        place_country,
        apple_photos_scores.*
    from
        apple_photos
    join
        uploads on apple_photos.sha256 = uploads.sha256
    left join
        apple_photos_scores on apple_photos.uuid = apple_photos_scores.ZUUID
    order by
        apple_photos.date desc;
Powered by Datasette · Query took 184.393ms · About: dogsheep/dogsheep-photos