photos_with_apple_metadata (view)

3 rows where ZFAILURESCORE = "-0.0008935928344726562"

View and edit SQL

Suggested facets: ext, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, date (date), albums (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
487 BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 2019-12-28T10:55:13+00:00
[
    "Public"
]
[]
heic faec04a4c5576d2de8af17460c22c79fd1926e889e3d0073ea188994c82507ac 3569228 50.697155 -3.19187 1 0 0 0 0 0 0 0 Sidmouth England United Kingdom BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 0.49267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.024658203125 0.0289764404296875 0.009999999776482582 -0.22119140625 -0.033905029296875 0.13232421875 0.00392913818359375 -0.00916290283203125 -0.0421142578125 -0.09619140625 0.0260009765625 0.2198486328125 0.092041015625 0.010162353515625 -0.0087127685546875 0.0165863037109375 0.0103302001953125 -0.000217437744140625 -0.0215911865234375 -0.09661865234375 0.00095367431640625
185 398058A8-F11E-4306-8272-05A438B6E523 2019-11-02T20:30:21+00:00
[
    "Public"
]
[]
jpeg 5bad707a8d2196bdb37eaea0501f8745535af125cc5bf5725451258a6247847d 4283013     0 0 0 0 0 0 0 0       398058A8-F11E-4306-8272-05A438B6E523 0.74365234375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0008935928344726562 0.0330810546875 0.0116424560546875 0.009999999776482582 -0.833984375 -0.0160980224609375 0.050872802734375 0.0024433135986328125 -0.0033245086669921875 -0.001247406005859375 0.362548828125 0.1444091796875 0.02447509765625 0.1607666015625 -0.00890350341796875 -0.001003265380859375 0.01433563232421875 0.11376953125 0.025970458984375 0.2293701171875 0.56982421875 0.01476287841796875
36 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 2019-09-16T16:26:37+00:00
[
    "Public"
]
[]
heic 14101f33adc465139279ae9a80118d2b388f4350c9b1b5ed06596282646d000b 2027028 37.44983333333333 -122.1864 1 0 0 0 0 0 0 0 Menlo Park CA United States 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 0.300048828125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.032806396484375 0.0007948875427246094 0.019999999552965164 -0.158447265625 -0.049957275390625 0.421630859375 0.0026721954345703125 -0.007904052734375 0.01885986328125 -0.05377197265625 0.057647705078125 0.08465576171875 0.02484130859375 0.0040283203125 -0.014495849609375 0.001934051513671875 0.43359375 0.56494140625 0.025390625 0.62744140625 -0.0088653564453125

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 160.134ms · About: dogsheep/dogsheep-photos