photos_with_apple_metadata (view)

3 rows where ZPLEASANTSYMMETRYSCORE = "0.0019044876098632812"

View and edit SQL

Suggested facets: persons, ext, ZINTERACTIONSCORE, 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
291 C8CCC8EE-382E-4265-8236-E2F30764A55C 2018-04-21T23:55:50+00:00
[
    "Museums",
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
heic 8d0760a255defeab12023c2ad8704cab6b5bd9d20c69bd325ea242a6b22402a9 1719608 37.57926666666667 -122.3442 0 0 0 0 0 0 0 0 Burlingame CA United States C8CCC8EE-382E-4265-8236-E2F30764A55C 0.2325439453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028228759765625 -0.00146484375 0.0015306472778320312 0.03999999910593033 0.1011962890625 -0.07305908203125 0.1485595703125 0.006511688232421875 -0.046722412109375 -0.03564453125 -0.249755859375 -0.18994140625 0.0582275390625 -0.07696533203125 -0.0020275115966796875 -0.0162353515625 0.0019044876098632812 0.0194244384765625 -0.01031494140625 -0.405029296875 0.190185546875 -0.0648193359375
181 3E20BE4D-619A-42EC-9CAA-6F67508892E4 2017-10-27T20:41:30+00:00
[
    "Museums",
    "Public"
]
[]
heic 5a3a4b0ffc8de931dd6dd0c977df4b444421a404c820c795346c8faffc984ffa 1744396 37.809145 -122.42119666666666 0 0 0 0 0 0 0 0 San Francisco CA United States 3E20BE4D-619A-42EC-9CAA-6F67508892E4 0.49169921875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0024929046630859375 -0.006275177001953125 0.003692626953125 0.009999999776482582 -0.309814453125 -0.0948486328125 0.2303466796875 0.0018968582153320312 -0.022247314453125 -0.13623046875 -0.5966796875 -0.132568359375 0.188232421875 -0.1619873046875 -0.0025348663330078125 -0.020538330078125 0.0019044876098632812 0.004505157470703125 -0.01824951171875 -0.40283203125 -0.51416015625 -0.1053466796875
395 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 2016-04-19T22:24:36+00:00
[
    "Museums",
    "Public"
]
[]
jpeg c5da768a066d3ed8487b4cf7520c8960f46510357e13edb68729cd3b0565fcbb 2044936 37.863186666666664 -122.49463666666666 0 0 0 0 0 0 0 0 Sausalito CA United States 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 0.331298828125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018033981323242188 0.00077056884765625 0.0028667449951171875 0.009999999776482582 -0.32421875 -0.03790283203125 0.44921875 0.0005192756652832031 -0.016845703125 -0.1064453125 -0.2491455078125 -0.05010986328125 0.149169921875 -0.19384765625 0.000110626220703125 -0.04498291015625 0.0019044876098632812 0.0162811279296875 0.00072479248046875 -0.204833984375 -0.1358642578125 -0.047576904296875

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