photos_with_apple_metadata (view)

3 rows where ZOVERALLAESTHETICSCORE = "0.4208984375"

View and edit SQL

Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, 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
190 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 2020-01-25T17:38:42+00:00
[
    "Public"
]
[]
heic 5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048 2742993 37.114983329999994 -122.32553833000001 1 0 0 0 0 0 0 0 Pescadero CA United States 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 0.4208984375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0012493133544921875 0.0186309814453125 0.0016107559204101562 0.009999999776482582 0.235107421875 -0.0975341796875 0.1732177734375 0.0165252685546875 -0.0266571044921875 -0.0413818359375 -0.244384765625 -0.07073974609375 0.09234619140625 -0.02294921875 0.00799560546875 -0.012939453125 0.0030879974365234375 0.048309326171875 0.033538818359375 -0.25537109375 0.279541015625 0.024658203125
319 2FBB5984-3AAC-4565-9233-9B05EF887714 2018-04-22T00:09:19+00:00
[
    "Museums",
    "Public"
]
[]
heic 9bfa1e978780e33d9a9f007e41b3a57f6b57f2cfe5c9a5dff2486a1ccbd1d68d 1272884 37.579208333333334 -122.34419166666666 0 0 0 0 0 0 0 0 Burlingame CA United States 2FBB5984-3AAC-4565-9233-9B05EF887714 0.4208984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.10968017578125 -0.01126861572265625 0.0083770751953125 0.009999999776482582 -0.4384765625 -0.077392578125 -0.07342529296875 0.03912353515625 -0.236572265625 -0.06561279296875 -0.578125 -0.57568359375 0.07489013671875 -0.11090087890625 -0.004486083984375 -0.012664794921875 0.002208709716796875 0.0013303756713867188 -0.6240234375 -0.270751953125 -0.458740234375 -0.2105712890625
260 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 2017-09-29T01:17:17+00:00
[
    "Public"
]
[]
jpeg 7ef1fc100a8feb54edec02b3dda0255d5fd0e8260c015c1b4feeb8be39bcabca 4772665 37.77751666666666 -122.42583333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 0.4208984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004665374755859375 -0.000202178955078125 0.0026416778564453125 0.009999999776482582 0.003662109375 -0.10797119140625 0.034637451171875 0.009857177734375 -0.038238525390625 -0.07037353515625 -0.394775390625 -0.30859375 0.07366943359375 -0.051483154296875 -0.0014400482177734375 -0.02740478515625 0.0038700103759765625 0.0070648193359375 -0.0821533203125 -0.29833984375 0.0435791015625 0.01141357421875

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