photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.00266265869140625"

View and edit SQL

Suggested facets: ext, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, 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
41 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 2018-05-18T19:45:49+00:00
[
    "Museums",
    "Public"
]
[]
heic 14efd697b9572b24b1853d1a3effab60609c0fcb477ad4739e85194c32afe8ba 1849449 37.0415695 -122.0726305 0 0 0 0 0 0 0 0 Felton CA United States 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 0.43701171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020503997802734375 0.0012054443359375 0.00266265869140625 0.03999999910593033 -0.0677490234375 -0.093505859375 0.361328125 0.0033111572265625 -0.01525115966796875 -0.0430908203125 -0.4287109375 -0.0633544921875 0.1295166015625 -0.07568359375 -0.00975799560546875 -0.01381683349609375 0.0014162063598632812 0.01934814453125 0.02264404296875 -0.5283203125 -0.20849609375 -0.10821533203125
244 BB4A90B3-D3CA-4E17-B54E-C736B625DDA7 2018-02-20T23:13:01+00:00
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
[]
heic 787c5bc73010b0a6c630900e95ca3a8921ad9104dec5cd2fe647510660e7f5d7 1663642 37.74267 -122.44931666666666 0 0 0 0 0 0 0 0 San Francisco CA United States BB4A90B3-D3CA-4E17-B54E-C736B625DDA7 0.266357421875 0.5 0.0 0.038931297721298594 0.5024574398994446 -0.0007853507995605469 0.035736083984375 0.00266265869140625 0.009999999776482582 0.58984375 -0.0574951171875 0.03900146484375 0.0142822265625 -0.005489349365234375 0.0088958740234375 0.298828125 0.258056640625 0.0185394287109375 0.2476806640625 0.0126800537109375 0.002330780029296875 0.005619049072265625 0.3330078125 0.459228515625 0.145263671875 0.78955078125 0.5693359375
326 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 2018-02-09T17:07:59+00:00
[
    "Public"
]
[]
jpeg 9e06275e7fa0e4f84d6a1e7a8ae97c27a59eebc6f3769f5b0129e492bf9c40c1 5328743     1 0 0 0 0 0 0 0       5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 0.6591796875 0.75 0.0 0.06111104934270145 0.10000000149011612 -0.0221099853515625 -0.0023956298828125 0.00266265869140625 0.009999999776482582 -0.417236328125 -0.0574951171875 0.162353515625 0.003185272216796875 -0.055206298828125 -0.064208984375 -0.300048828125 -0.2000732421875 0.036712646484375 -0.1666259765625 -0.0035400390625 -0.01611328125 0.0010690689086914062 0.017303466796875 -0.206787109375 -0.138916015625 0.03955078125 -0.0994873046875

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