photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.0018033981323242188"

View and edit SQL

Suggested facets: ext, favorite, ZCURATIONSCORE, 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
59 E28B94C5-3FD9-4199-B291-5727F3D40053 2019-11-02T20:32:12+00:00
[
    "Public"
]
[]
jpeg 1bf6f978059091efb89907071b2796f19db07ba2994d6826fc794dcb1ce3d38a 4830969     0 0 0 0 0 0 0 0       E28B94C5-3FD9-4199-B291-5727F3D40053 0.7939453125 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.0024433135986328125 0.001224517822265625 0.0018033981323242188 0.009999999776482582 -0.83935546875 -0.09027099609375 0.05169677734375 0.002811431884765625 -0.011199951171875 -0.04876708984375 -0.432861328125 -0.2054443359375 0.03314208984375 -0.02099609375 -0.005584716796875 -0.0362548828125 0.00319671630859375 0.0261077880859375 -0.0133209228515625 -0.05126953125 0.1944580078125 -0.007366180419921875
461 CE0B0837-963E-4427-8C83-23D6DC01DFEC 2019-03-23T17:56:08+00:00
[
    "Super bloom 2019",
    "Public"
]
[]
heic e9600c56afe37e32ec148695c3dc40a5539235ac4b656c78d516d7665aa9be74 2040240 33.92010833333333 -116.77295 1 0 0 0 0 0 0 0 Cabazon CA United States CE0B0837-963E-4427-8C83-23D6DC01DFEC 0.591796875 0.75 0.0 0.06112145012571611 0.10000000149011612 -0.0006237030029296875 0.021240234375 0.0018033981323242188 0.009999999776482582 -0.149658203125 -0.059539794921875 0.117431640625 0.005279541015625 -0.01016998291015625 0.00030517578125 -0.0347900390625 0.05010986328125 0.052520751953125 0.1978759765625 0.006084442138671875 -0.0106201171875 0.006191253662109375 0.183349609375 0.08062744140625 0.0382080078125 0.61279296875 0.0202484130859375
279 A8949702-A151-4ACD-8F3C-D5957F481E5A 2018-02-13T18:55:13+00:00
[
    "Geotaggable Photos geotagged",
    "Public"
]
[]
jpeg 85d802ffe4def2a666fed10fe1da638ef804d8e499a8899c23471705df60163c 5342238 25.736453769238338 -111.09069569453112 0 0 0 0 0 0 0 0     Mexico A8949702-A151-4ACD-8F3C-D5957F481E5A 0.72412109375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0010480880737304688 0.025848388671875 0.0018033981323242188 0.009999999776482582 -0.166748046875 -0.020172119140625 0.36181640625 0.0021991729736328125 -0.016845703125 0.00335693359375 0.013946533203125 0.0294189453125 0.1356201171875 0.03472900390625 0.0109405517578125 -0.019073486328125 0.00391387939453125 0.1959228515625 0.1380615234375 0.236572265625 0.525390625 -0.006011962890625

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