photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.006824493408203125"

View and edit SQL

Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, 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
357 8E150DC5-5E6A-4286-9110-44501EC99304 2020-04-23T23:20:00+00:00
[
    "Photography homework composition April 2020",
    "Public"
]
[]
jpeg ada4f24e3ed43ef25da0ae2be782edc1bd9330d15661a67614cbafccb3277d63 7711907     1 0 0 0 0 0 0 0       8E150DC5-5E6A-4286-9110-44501EC99304 0.50390625 0.75 0.0 0.05801526718694745 0.7075425386428833 -0.0005192756652832031 0.07769775390625 0.006824493408203125 0.009999999776482582 0.3955078125 -0.041839599609375 0.260009765625 0.0034694671630859375 -0.004791259765625 0.0063018798828125 0.1600341796875 0.209716796875 0.025177001953125 0.13916015625 0.0210418701171875 0.00106048583984375 0.003376007080078125 0.11297607421875 0.06793212890625 0.1895751953125 0.517578125 0.210205078125
343 0B9B2460-9D4D-421F-92C0-8F0921632AEC 2017-12-03T22:49:55+00:00
[
    "Museums",
    "Public"
]
[]
heic a6c77dd4fb9cd10a38e56b6d1d0962b03d79a57e4cad71921d4a583d8b86b298 748252 37.333663333333334 -121.92330833333334 0 0 0 0 0 0 0 0 San Jose CA United States 0B9B2460-9D4D-421F-92C0-8F0921632AEC 0.4404296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007915496826171875 0.0180816650390625 0.006824493408203125 0.009999999776482582 -0.1405029296875 -0.049407958984375 0.1383056640625 0.00284576416015625 -0.01312255859375 -0.04608154296875 -0.11279296875 0.01507568359375 0.10760498046875 0.0987548828125 0.0095062255859375 -0.0106201171875 0.007694244384765625 0.031494140625 0.00435638427734375 0.03155517578125 0.231689453125 0.008331298828125
144 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 2016-04-19T22:24:47+00:00
[
    "Museums",
    "Public"
]
[]
jpeg 44458ddd988ba5866c6a1e5db026a57add085c80d64a6f0f52fffacd816e52ad 2181535 37.86320833333333 -122.49472 0 0 0 0 0 0 0 0 Sausalito CA United States D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 0.35009765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.033966064453125 0.005153656005859375 0.006824493408203125 0.009999999776482582 -0.6083984375 -0.09271240234375 -0.2470703125 0.2117919921875 -0.1104736328125 -0.038299560546875 -0.44970703125 -0.623046875 0.0164642333984375 0.0101318359375 0.0024871826171875 -0.005985260009765625 0.0029582977294921875 0.004398345947265625 -0.1490478515625 -0.0050201416015625 -0.127197265625 0.0197906494140625

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