photos_with_apple_metadata (view)

3 rows where ZPLEASANTSYMMETRYSCORE = "0.003223419189453125"

View and edit SQL

Suggested facets: albums, ext, ZHIGHLIGHTVISIBILITYSCORE, 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
479 FF230430-EDD4-4E3F-83F9-C105A7EE7598 2019-11-02T20:31:02+00:00
[
    "Public"
]
[]
jpeg f5540186893e81abf2b46cb2108caa981d5a1e063e184f7242709e6287437911 4817123     0 0 0 0 0 0 0 0       FF230430-EDD4-4E3F-83F9-C105A7EE7598 0.76220703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0017681121826171875 -0.0049896240234375 0.002349853515625 0.019999999552965164 0.139404296875 -0.047515869140625 0.317626953125 0.00147247314453125 -0.0364990234375 -0.051422119140625 -0.1719970703125 -0.1263427734375 0.1759033203125 -0.0941162109375 -0.0011386871337890625 -0.03131103515625 0.003223419189453125 0.0094146728515625 -0.01128387451171875 -0.53125 0.0823974609375 -0.117431640625
265 B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E 2018-04-22T00:04:28+00:00
[
    "Museums",
    "Public"
]
[]
heic 7ff235acd3b220a7af4ba71085813dcdce87ec322760ed6582ce5e4b4fb3230c 816374 37.57928 -122.34413833333333 0 0 0 0 0 0 0 0 Burlingame CA United States B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E 0.312255859375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012998580932617188 0.0130767822265625 0.0015974044799804688 0.009999999776482582 -0.0648193359375 -0.0279083251953125 0.3154296875 0.0017547607421875 -0.0207672119140625 -0.0150146484375 -0.02239990234375 -0.03936767578125 0.07696533203125 -0.02813720703125 0.003704071044921875 -0.0173797607421875 0.003223419189453125 0.09466552734375 0.042572021484375 0.090087890625 0.52490234375 -0.01253509521484375
42 E7C46C63-F84B-4535-86A7-A5028CC63E4B 2018-04-22T00:03:12+00:00
[
    "Museums",
    "Public"
]
[]
heic 15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6 2320879 37.57927 -122.34416166666666 0 0 0 0 0 0 0 0 Burlingame CA United States E7C46C63-F84B-4535-86A7-A5028CC63E4B 0.36865234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00518035888671875 0.01081085205078125 0.004924774169921875 0.009999999776482582 -0.9609375 -0.0221099853515625 0.053680419921875 0.0009508132934570312 -0.0069580078125 -0.00634002685546875 0.0328369140625 -0.09417724609375 0.012969970703125 0.037017822265625 -0.029510498046875 -0.00531768798828125 0.003223419189453125 0.051177978515625 -0.01397705078125 0.2305908203125 0.384765625 0.0015316009521484375

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