photos_with_apple_metadata (view)

4 rows where ZPLEASANTSYMMETRYSCORE = "0.0026836395263671875"

View and edit SQL

Suggested facets: favorite, ZCURATIONSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZSHARPLYFOCUSEDSUBJECTSCORE, 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
201 5FCADAE8-4708-4E56-B6B0-F718EE9446F7 2019-11-02T20:31:19+00:00
[
    "Public"
]
[]
jpeg 64d4969938ae0359e40e8450801788ee372e29e5f755d3c5a1f671f2212bc809 4462558     0 0 0 0 0 0 0 0       5FCADAE8-4708-4E56-B6B0-F718EE9446F7 0.82177734375 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.002124786376953125 0.000396728515625 0.0029125213623046875 0.009999999776482582 -0.150390625 -0.09027099609375 0.29443359375 0.003376007080078125 -0.0162200927734375 -0.07568359375 -0.42333984375 -0.1134033203125 0.151123046875 -0.0860595703125 -0.005008697509765625 -0.04974365234375 0.0026836395263671875 0.01267242431640625 -0.005584716796875 -0.470947265625 -0.1773681640625 -0.07421875
286 41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D 2019-11-02T20:30:04+00:00
[
    "Public"
]
[]
jpeg 88cb2bf7299d65b53c69b24b13848fa2daeaeeeab75f98affaccf522c0dc7d42 4484642     0 0 0 0 0 0 0 0       41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D 0.70703125 0.5 0.0 0.043530952384453696 0.10000000149011612 -0.004364013671875 0.0061187744140625 0.004718780517578125 0.019999999552965164 -0.42724609375 -0.1483154296875 0.0650634765625 0.01332855224609375 -0.015838623046875 -0.08636474609375 -0.61962890625 -0.1812744140625 0.07196044921875 -0.0423583984375 -0.00017547607421875 -0.047637939453125 0.0026836395263671875 0.01016998291015625 -0.01580810546875 -0.1910400390625 -0.31103515625 -0.016571044921875
23 39333D7D-3020-4A1B-970D-44F2DD6D5C52 2019-05-19T23:50:19+00:00
[
    "Public"
]
[]
jpeg 0d2584a5003fb23424777e259d0c437f3bfc567318f8e4cd4298570bf8da6947 5078550     0 0 0 0 0 0 0 0       39333D7D-3020-4A1B-970D-44F2DD6D5C52 0.68408203125 0.5 0.0 0.04356772708528824 0.10000000149011612 -0.0016813278198242188 0.00276947021484375 0.00453948974609375 0.05999999865889549 -0.255859375 -0.09027099609375 0.2310791015625 0.004180908203125 -0.014007568359375 -0.055145263671875 -0.4873046875 -0.0653076171875 0.17822265625 -0.05279541015625 -0.005138397216796875 -0.0148162841796875 0.0026836395263671875 0.01267242431640625 0.0071868896484375 -0.35205078125 -0.310546875 -0.05792236328125
306 BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 2018-02-09T17:34:41+00:00
[
    "Public"
]
[]
jpeg 945618e1454a17db6e8f66f5a72266b3e47c4c14f99a38c9792e9b10133e55bd 5522490     1 0 0 0 0 0 0 0       BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 0.65625 0.75 0.0 0.06109191898171228 0.10000000149011612 -0.0017137527465820312 0.021484375 0.0060272216796875 0.009999999776482582 -0.91748046875 -0.021331787109375 0.2049560546875 0.0011119842529296875 -0.0050201416015625 -0.0079498291015625 -0.02685546875 0.02593994140625 0.0287628173828125 0.036224365234375 -0.029022216796875 -0.0055999755859375 0.0026836395263671875 0.050811767578125 0.01702880859375 0.08807373046875 0.1494140625 0.0010223388671875

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