photos_with_apple_metadata (view)

2 rows where albums = "["Stolen monasteries", "Public"]" and "date" is on date 2018-11-26

View and edit SQL

Suggested facets: 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
404 C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 2018-11-26T23:47:36+00:00
[
    "Stolen monasteries",
    "Public"
]
[]
heic c8f40ecddd5157c98a12110e1a9e11a97b72940d1ba4555f73eb17d229559031 3821687 37.7672 -122.46752166666667 0 0 0 0 0 0 0 0 San Francisco CA United States C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 0.457275390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.006877899169921875 -0.005374908447265625 0.0021076202392578125 0.009999999776482582 -0.27880859375 -0.1282958984375 0.11395263671875 0.0087432861328125 -0.042572021484375 -0.10498046875 -0.58642578125 -0.257080078125 0.08251953125 -0.16015625 -0.005096435546875 -0.02154541015625 0.0016355514526367188 0.010009765625 -0.08673095703125 -0.447509765625 -0.22705078125 -0.115234375
25 40C65283-9CB3-4FAE-A390-4FDC22BCC29F 2018-11-26T23:46:00+00:00
[
    "Stolen monasteries",
    "Public"
]
[]
heic 0daddeb8eb5e2b05b1b21bc51bf14355201de8303222502595c716f8e52b47fd 1789046 37.767125 -122.46747 0 0 0 0 0 0 0 0 San Francisco CA United States 40C65283-9CB3-4FAE-A390-4FDC22BCC29F 0.251708984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.024383544921875 -0.0081024169921875 0.002834320068359375 0.009999999776482582 -0.47119140625 -0.1044921875 -0.090087890625 0.1077880859375 -0.1966552734375 -0.06512451171875 -0.67138671875 -0.5810546875 0.05145263671875 -0.09759521484375 -0.0024623870849609375 -0.0153656005859375 0.0017004013061523438 0.0024929046630859375 -0.1163330078125 -0.259765625 -0.4462890625 -0.08624267578125

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