photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.00217437744140625"

View and edit SQL

Suggested facets: ext, favorite, panorama, ZCURATIONSCORE, 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
99 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A 2019-12-21T10:01:09+00:00
[
    "Public"
]
[]
heic 2f6b03abdcfe2f4c21f60485ddd9206bc4313e77f9b06e72eb38050d9978685b 7211598 51.17876333 -1.8266950000000002 1 0 0 0 0 0 0 1 Salisbury England United Kingdom 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A 0.638671875 0.75 0.0 0.06109879080575841 0.10000000149011612 -0.0005421638488769531 0.03216552734375 0.00217437744140625 0.009999999776482582 0.0615234375 -0.049041748046875 0.1693115234375 0.006389617919921875 -0.0068511962890625 0.0143280029296875 0.0623779296875 0.139404296875 0.044769287109375 0.1705322265625 0.008758544921875 -0.00537872314453125 0.005260467529296875 0.2900390625 0.2193603515625 0.0245361328125 0.66064453125 0.036163330078125
331 1B6765D2-F281-48DB-A23A-C081FFAC69DC 2019-11-02T20:31:26+00:00
[
    "Public"
]
[]
jpeg a12312146b3a13e844481394def7506dbc27b794f150796b466c07c65e2d77b0 4561109     0 0 0 0 0 0 0 0       1B6765D2-F281-48DB-A23A-C081FFAC69DC 0.7705078125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0023326873779296875 -0.00392913818359375 0.00217437744140625 0.009999999776482582 -0.1573486328125 -0.11859130859375 0.0679931640625 0.00864410400390625 -0.030670166015625 -0.083984375 -0.52197265625 -0.2744140625 0.12139892578125 -0.083740234375 -0.001941680908203125 -0.02880859375 0.004199981689453125 0.00841522216796875 -0.029266357421875 -0.431396484375 -0.082763671875 -0.0531005859375
28 14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D 2019-08-21T15:33:02+00:00
[
    "Public"
]
[]
jpeg 10fbcfa8d9bde9eea951ffd25147dfcca838591911ffa1c2b4b5ada2cc73bf7c 6692650     1 0 0 0 0 0 0 0       14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D 0.6298828125 0.75 0.0 0.06110566308480183 0.7047688364982605 -0.00042057037353515625 0.060150146484375 0.00217437744140625 0.009999999776482582 0.78271484375 -0.0309600830078125 0.0841064453125 0.010009765625 -0.0027256011962890625 0.00811004638671875 0.48193359375 0.420166015625 0.017242431640625 0.26513671875 0.02313232421875 0.00504302978515625 0.00530242919921875 0.67822265625 0.82177734375 0.273193359375 0.88427734375 0.67822265625

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