photos_with_apple_metadata (view)

4 rows where ZPLEASANTSYMMETRYSCORE = "0.0035381317138671875"

View and edit SQL

Suggested facets: persons, ext, favorite, hdr, ZCURATIONSCORE, 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
253 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 2019-08-24T12:32:07+00:00
[
    "Public"
]
[]
heic 7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458 2400763 48.86095 2.342538333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 0.3662109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0092315673828125 0.02105712890625 0.00626373291015625 0.009999999776482582 -0.17333984375 -0.09271240234375 -0.000732421875 0.0139007568359375 -0.00609588623046875 -0.00481414794921875 -0.09033203125 -0.0902099609375 0.0135345458984375 0.09149169921875 0.00372314453125 -0.0022525787353515625 0.0035381317138671875 0.09466552734375 0.0888671875 0.042938232421875 0.44677734375 0.119384765625
307 CE82D764-5190-4817-8027-18562D6C4E44 2018-02-09T17:09:01+00:00
[
    "Public"
]
[]
jpeg 9482db6d0ad87c6629f59ad3a1952b14be4efe363fc7f6b7d52d9d63c6c5529b 4737344     0 0 0 0 0 0 0 0       CE82D764-5190-4817-8027-18562D6C4E44 0.7080078125 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.00106048583984375 0.00131988525390625 0.0025310516357421875 0.009999999776482582 0.1129150390625 -0.0872802734375 0.288330078125 0.0020198822021484375 -0.0216217041015625 -0.09893798828125 -0.33544921875 -0.074951171875 0.2939453125 -0.1087646484375 -0.0019989013671875 -0.0322265625 0.0035381317138671875 0.01049041748046875 -0.00115203857421875 -0.4990234375 -0.13134765625 -0.06817626953125
239 11D38304-FE06-43AD-B3F0-18FCB7697365 2018-02-09T17:08:15+00:00
[
    "Public"
]
[]
jpeg 75acbbcbf1e97c8a33742aff62ac0255ed9eb67de35bcae0d51d9176a4f6ffe7 4604119     1 0 0 0 0 0 0 0       11D38304-FE06-43AD-B3F0-18FCB7697365 0.7958984375 0.75 0.0 0.06264114652881185 0.10000000149011612 -0.0010042190551757812 0.0269622802734375 0.001483917236328125 0.009999999776482582 -0.148681640625 -0.04345703125 0.1900634765625 0.005405426025390625 -0.00974273681640625 0.0116119384765625 0.0089111328125 0.07745361328125 0.054901123046875 0.1292724609375 0.01070404052734375 -0.00806427001953125 0.0035381317138671875 0.342041015625 0.37939453125 0.143798828125 0.662109375 0.0079345703125
240 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 2016-04-09T20:12:10+00:00
[
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
jpeg 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 2689457 37.78550333333333 -122.43043666666667 0 0 0 0 0 1 0 0 San Francisco CA United States 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 0.486572265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004314422607421875 -0.00701141357421875 0.002452850341796875 0.009999999776482582 -0.121826171875 -0.1026611328125 0.11175537109375 0.005619049072265625 -0.0521240234375 -0.133544921875 -0.4990234375 -0.270263671875 0.165283203125 -0.1573486328125 -0.0026302337646484375 -0.0262451171875 0.0035381317138671875 0.00557708740234375 -0.07470703125 -0.5068359375 -0.1641845703125 -0.1171875

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