photos_with_apple_metadata (view)

3 rows where ZPLEASANTSYMMETRYSCORE = "0.00455474853515625"

View and edit SQL

Suggested facets: albums, ext, favorite, ZBEHAVIORALSCORE, 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
147 3504AC65-3614-451D-BE1A-F49B6CEB5E10 2020-01-25T19:58:43+00:00
[
    "Public"
]
[]
jpeg 4680cd4fb84a80defcdf6d6f65856a9b4a2e530096bfc0589f4a86c60ee56b2c 7103284     1 0 0 0 0 0 0 0       3504AC65-3614-451D-BE1A-F49B6CEB5E10 0.6123046875 0.75 0.0 0.06111884981621313 0.5063990354537964 -0.0011882781982421875 0.048492431640625 0.002620697021484375 0.009999999776482582 0.62109375 -0.040985107421875 0.092041015625 0.06536865234375 -0.0310211181640625 0.0171356201171875 0.1435546875 0.16357421875 0.03594970703125 0.1630859375 0.0496826171875 0.00411224365234375 0.00455474853515625 0.168212890625 0.1630859375 0.2236328125 0.705078125 0.43408203125
489 B78C4087-CE43-411C-AEAF-16C585DF6D67 2017-12-16T11:52:17+00:00
[
    "Public"
]
[]
heic fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a 2091779 51.5034 -0.13202783333333332 0 0 0 0 0 0 0 0 London England United Kingdom B78C4087-CE43-411C-AEAF-16C585DF6D67 0.71337890625 0.5 0.0 0.8068936312471637 0.10000000149011612 -0.005344390869140625 0.017913818359375 0.01094818115234375 0.009999999776482582 -0.55078125 -0.05865478515625 -0.06689453125 0.01129150390625 -0.01666259765625 -0.03057861328125 -0.1268310546875 -0.252197265625 0.020172119140625 0.0902099609375 0.0024738311767578125 -0.00368499755859375 0.00455474853515625 0.0104522705078125 -0.033721923828125 0.0194854736328125 0.00994873046875 0.019500732421875
492 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 2017-03-31T00:48:54+00:00
[
    "Stolen monasteries",
    "Public"
]
[]
jpeg fe7c5489ffa8c070183fe2c559c00b6d5880a6b9a9c53f807962166ec96c4375 4984812 37.7692 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States D3CF77DA-B6DD-47F1-A69C-3E01122F133E 0.497314453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.002002716064453125 0.0117950439453125 0.002010345458984375 0.019999999552965164 -0.28369140625 -0.018341064453125 0.296630859375 0.002132415771484375 -0.038604736328125 -0.031494140625 -0.022735595703125 -0.041351318359375 0.188232421875 -0.038330078125 0.0035552978515625 -0.016143798828125 0.00455474853515625 0.07452392578125 0.034332275390625 0.2244873046875 0.4072265625 -0.01230621337890625

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