photos_with_apple_metadata (view)

4 rows where "date" is on date 2018-03-25, panorama = 0 and screenshot = 0

View and edit SQL

Suggested facets: latitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
150 C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 2018-03-25T23:58:04+00:00
[
    "Museums",
    "Public"
]
[]
heic 486a9d6bad60a510919292a3e18dd70e4ca8159162f601bbce169d6e1af9ff7c 1807589 37.73271666666667 -122.468375 0 0 0 0 0 0 0 0 San Francisco CA United States C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 0.404052734375 0.6 0.0 0.04656488550755814 0.7025547623634338 -0.0005035400390625 0.2156982421875 0.046295166015625 0.009999999776482582 0.42041015625 -0.0386962890625 0.1458740234375 0.0095977783203125 -0.0024623870849609375 -0.0104217529296875 0.35400390625 0.337890625 0.03265380859375 0.347900390625 0.052764892578125 0.0186767578125 0.00701141357421875 0.021331787109375 0.00738525390625 0.01324462890625 -0.004425048828125 0.153564453125
312 C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 2018-03-25T23:57:33+00:00
[
    "Museums",
    "Public"
]
[]
heic 978eaabc0e123d079004bd4c698fc270eb2f9809bede347ae862d7c1cebe68fd 1546916 37.73271166666667 -122.46839166666666 0 0 0 0 0 0 0 0 San Francisco CA United States C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 0.386962890625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.007965087890625 0.041656494140625 0.0216522216796875 0.009999999776482582 -0.0947265625 -0.0699462890625 -0.07989501953125 0.046905517578125 -0.01971435546875 -0.039886474609375 0.04833984375 -0.2398681640625 0.018402099609375 0.1732177734375 0.007965087890625 0.0758056640625 0.006565093994140625 0.00494384765625 -0.03369140625 0.00649261474609375 -0.0401611328125 0.244384765625
267 A91633D1-A015-4857-AFD6-C27279445751 2018-03-25T23:57:19+00:00
[
    "Museums",
    "Public"
]
[]
heic 814e5de6c8f35a62f5dacc6749fd74aa11f0ba3c80704f3f929b0d1e03895c23 1996328 37.73272 -122.4684 0 0 0 0 0 0 0 0 San Francisco CA United States A91633D1-A015-4857-AFD6-C27279445751 0.363037109375 0.5 0.0 0.038931297721298594 0.5035036206245422 -0.0007352828979492188 0.0462646484375 0.0279083251953125 0.009999999776482582 0.416015625 -0.05706787109375 -0.11419677734375 0.024993896484375 -0.00586700439453125 -0.00908660888671875 0.41357421875 0.03125 0.0203704833984375 0.34326171875 0.0140380859375 0.00809478759765625 0.020965576171875 0.020721435546875 0.00106048583984375 0.01141357421875 0.102783203125 0.078369140625
120 14B6764F-C911-4A53-8A56-28D1DE9F634A 2018-03-25T23:57:03+00:00
[
    "Museums",
    "Public"
]
[]
heic 3987ed15effdd8611ae43e0dbfa66d69bf3f246de9ebcc481524d5b5b75a7b2c 1567970 37.73272 -122.46841333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 14B6764F-C911-4A53-8A56-28D1DE9F634A 0.453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.027069091796875 0.00571441650390625 0.01029205322265625 0.009999999776482582 -0.689453125 -0.0970458984375 -0.28955078125 0.05987548828125 -0.04949951171875 -0.03485107421875 -0.38720703125 -0.634765625 0.012237548828125 0.04443359375 0.0016651153564453125 -0.00444793701171875 0.0038547515869140625 0.0036640167236328125 -0.157470703125 0.002780914306640625 -0.08416748046875 0.01250457763671875

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