photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.00395965576171875"

View and edit SQL

Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZBEHAVIORALSCORE, 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
353 C0471BD8-EBE8-49F4-A9BB-D6C067279A87 2020-02-22T23:13:39+00:00
[
    "Public"
]
[]
jpeg ab7c204eddcf3e5af89f6d55ca9d174684fb5350b6c013117efe3a801c6e2e42 6247543     1 0 0 0 0 0 0 0       C0471BD8-EBE8-49F4-A9BB-D6C067279A87 0.65673828125 0.75 0.0 0.06110306277529884 0.10000000149011612 -0.0009546279907226562 0.01290130615234375 0.00395965576171875 0.009999999776482582 -0.064453125 -0.03662109375 0.233642578125 0.0014104843139648438 -0.01363372802734375 -0.0123443603515625 -0.0489501953125 0.00372314453125 0.048675537109375 0.005401611328125 0.00226593017578125 -0.0153045654296875 0.0026721954345703125 0.0391845703125 0.016632080078125 0.0863037109375 0.330810546875 -0.0025634765625
327 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 2020-01-25T19:45:34+00:00
[
    "Public"
]
[]
jpeg 9f498cd0be0d5dcd46726651f0a3124f26218483c8dea3749507a4867ab325bd 5827512     1 0 0 0 0 0 0 0       4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 0.6240234375 0.75 0.0 0.06109860516686476 0.10000000149011612 -0.00034737586975097656 0.0128173828125 0.00395965576171875 0.009999999776482582 -0.19140625 -0.0374755859375 0.2568359375 0.0023784637451171875 -0.007843017578125 -0.013397216796875 -0.09765625 0.03204345703125 0.2281494140625 0.043853759765625 0.000957489013671875 -0.0231170654296875 0.01348114013671875 0.04534912109375 0.0098876953125 -0.172607421875 0.347412109375 -0.00164031982421875
125 CC3EF420-EAC4-4661-8D68-C2009F892C04 2018-04-22T00:11:12+00:00
[
    "Museums",
    "Public"
]
[]
heic 3b435a93ced7320d53ff8a654508641529d82949253df7256c3baeb6a919385d 1565205 37.57926666666667 -122.34417 0 0 0 0 0 0 0 0 Burlingame CA United States CC3EF420-EAC4-4661-8D68-C2009F892C04 0.23974609375 0.5 0.0 0.038931297721298594 0.5029440522193909 -0.0008831024169921875 0.11505126953125 0.00395965576171875 0.019999999552965164 0.0281982421875 -0.0225067138671875 0.27880859375 0.01009368896484375 -0.0069580078125 0.039337158203125 0.1673583984375 0.260498046875 0.1424560546875 0.36865234375 0.142822265625 -0.00147247314453125 0.00600433349609375 0.501953125 0.66943359375 0.48828125 0.607421875 0.0160064697265625

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