photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.00208282470703125"

View and edit SQL

Suggested facets: albums, favorite, ZCURATIONSCORE, 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
310 F92B1415-1D5D-45A6-A736-54D988748BBF 2020-01-25T19:32:06+00:00
[
    "Public"
]
[]
jpeg 96bc3134c1bd2553c164f1eee6971a22ed15893dc5dabcc717fc1f72317e044a 5851617     1 0 0 0 0 0 0 0       F92B1415-1D5D-45A6-A736-54D988748BBF 0.5068359375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.030731201171875 0.00522613525390625 0.00208282470703125 0.009999999776482582 -0.45166015625 -0.199951171875 -0.006561279296875 0.033905029296875 -0.04132080078125 -0.09454345703125 -0.6005859375 -0.357666015625 0.0240936279296875 -0.1298828125 0.002777099609375 -0.021331787109375 0.0008692741394042969 0.020294189453125 -0.1363525390625 -0.057342529296875 -0.0946044921875 -0.033966064453125
434 C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 2020-01-25T19:22:04+00:00
[
    "Public"
]
[]
jpeg db785fae4d60624d0a90c7fc24ec36f2b6b95f6d158b42d8973210f3cabba91a 6428626     1 0 0 0 0 0 0 0       C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 0.64501953125 0.75 0.0 0.06110269104251425 0.10000000149011612 -0.001972198486328125 0.003810882568359375 0.00208282470703125 0.009999999776482582 0.3271484375 -0.042022705078125 0.2122802734375 0.0031108856201171875 -0.0309600830078125 -0.0080718994140625 -0.04730224609375 -0.1087646484375 0.04803466796875 -0.0256805419921875 2.288818359375e-05 -0.01338958740234375 0.002704620361328125 0.039642333984375 0.016815185546875 -0.213623046875 0.50048828125 -0.026947021484375
269 7705FF4E-2F25-45B9-B795-EA58244F3273 2018-02-13T18:53:28+00:00
[
    "Geotaggable Photos geotagged",
    "Public"
]
[]
jpeg 81f94d4de59b28e89df4ff8ac3a7250e624cbd261e7d93701e6a8cafeeeb971e 5483241 25.737587971741938 -111.09106443298224 0 0 0 0 0 0 0 0     Mexico 7705FF4E-2F25-45B9-B795-EA58244F3273 0.708984375 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.06915283203125 -0.00589752197265625 0.00208282470703125 0.019999999552965164 -0.390869140625 -0.14306640625 -0.1083984375 0.0775146484375 -0.12322998046875 -0.06463623046875 -0.58837890625 -0.66650390625 0.024566650390625 -0.1026611328125 -0.0028285980224609375 -0.06109619140625 0.0018100738525390625 0.00464630126953125 -0.52734375 -0.286376953125 -0.095458984375 -0.10565185546875

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