photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.00669097900390625"

View and edit SQL

Suggested facets: ext, ZCURATIONSCORE, 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
421 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 2019-11-02T20:23:27+00:00
[
    "Public"
]
[]
jpeg d597f6879722f4f91e3558f509a859171132b60d7df319ba3fea358fa175d704 4948411     0 0 0 0 0 0 0 0       6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 0.599609375 0.25 0.0 0.02292342267873633 0.10000000149011612 -0.0014667510986328125 0.0130157470703125 0.00669097900390625 0.05999999865889549 -0.1693115234375 -0.10723876953125 0.125732421875 0.0100555419921875 -0.01029205322265625 -0.053619384765625 -0.46923828125 -0.0592041015625 0.12359619140625 0.00830078125 0.00091552734375 -0.0198974609375 0.005260467529296875 0.01262664794921875 -0.0024566650390625 -0.2452392578125 -0.17578125 0.0079345703125
166 A9E26555-0DE9-4416-8C3E-54992AF7AB10 2018-02-20T23:02:11+00:00
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
[]
heic 54525e90a3fda130db87d551bb7a10208980d0d1960ca9b83bac61d2499a67d8 1535168 37.74260833333334 -122.44934166666667 0 0 0 0 0 0 0 0 San Francisco CA United States A9E26555-0DE9-4416-8C3E-54992AF7AB10 0.37646484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0025501251220703125 0.01739501953125 0.00669097900390625 0.009999999776482582 0.058837890625 -0.08062744140625 0.12646484375 0.003692626953125 -0.013427734375 -0.08441162109375 -0.201171875 -0.169189453125 0.0401611328125 -0.0177001953125 0.004955291748046875 -0.036102294921875 0.003482818603515625 0.007724761962890625 -0.0174560546875 -0.05755615234375 0.0003662109375 0.0176849365234375
206 07509762-A841-4CEB-AA42-B65439E9C3DD 2016-11-05T20:50:06+00:00
[
    "Museums",
    "Public"
]
[]
jpeg 679f1f8f0d139dba297bf0d5ecadcaed7259d6c812e6a825e2d3999cc301d5b3 3572478 37.82793 -122.52746666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 07509762-A841-4CEB-AA42-B65439E9C3DD 0.6259765625 0.5 0.0 0.8053737856049574 0.10000000149011612 -0.0006985664367675781 0.037078857421875 0.00669097900390625 0.009999999776482582 0.080078125 -0.0257110595703125 0.2083740234375 0.0021152496337890625 -0.009674072265625 -0.003387451171875 0.104736328125 0.0789794921875 0.060516357421875 0.1619873046875 0.01324462890625 -0.003513336181640625 0.0063629150390625 0.08209228515625 0.025970458984375 0.15087890625 0.417236328125 0.03619384765625

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