photos_with_apple_metadata (view)

3 rows where ZNOISESCORE = "-0.01751708984375"

View and edit SQL

Suggested facets: albums, 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
400 2B30643F-7BEC-4E40-8C9F-BF0994C38197 2018-02-13T18:55:11+00:00
[
    "Geotaggable Photos geotagged",
    "Public"
]
[]
jpeg c737f0db8b99bd2bff7581902d55319005ce8f7557654af7d985e66e91bfdb85 5545619 25.73648106575451 -111.09070456885036 0 0 0 0 0 0 0 0     Mexico 2B30643F-7BEC-4E40-8C9F-BF0994C38197 0.5947265625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.0022602081298828125 -0.00171661376953125 0.00908660888671875 0.009999999776482582 -0.2548828125 -0.059112548828125 0.2274169921875 0.0010442733764648438 -0.01751708984375 -0.12164306640625 -0.4638671875 -0.110595703125 0.2010498046875 -0.132080078125 0.0008869171142578125 -0.0180816650390625 0.00266265869140625 0.002521514892578125 -0.0098876953125 -0.1746826171875 -0.50390625 -0.057098388671875
402 F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 2018-02-09T17:27:30+00:00
[
    "Public"
]
[]
jpeg c7f136a2c859e0cf4683e9c496fb21501ba2d22b326f91ee68a61b048d3cf75d 6152857     0 0 0 0 0 0 0 0       F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 0.52978515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0015249252319335938 -0.0049591064453125 0.004039764404296875 0.009999999776482582 -0.37744140625 -0.07696533203125 0.2646484375 0.0016355514526367188 -0.01751708984375 -0.0535888671875 -0.484130859375 -0.067626953125 0.138916015625 -0.064453125 -0.0138397216796875 -0.0174102783203125 0.001926422119140625 0.00930023193359375 -0.00273895263671875 -0.4765625 -0.3681640625 -0.083740234375
338 9C0E4F98-A2A8-45F8-8078-792720435621 2018-02-09T17:09:09+00:00
[
    "Public"
]
[]
jpeg a4613c06f65f7d13e8c36a1c59025b23caf787d4775a44945e6ae2f5e7fd3929 5496634     1 0 0 0 0 0 0 0       9C0E4F98-A2A8-45F8-8078-792720435621 0.74267578125 0.75 0.0 0.06261882208685839 0.10000000149011612 -0.001964569091796875 0.00035858154296875 0.0014209747314453125 0.009999999776482582 -0.379638671875 -0.055511474609375 0.37548828125 0.001094818115234375 -0.01751708984375 -0.0670166015625 -0.27587890625 -0.0677490234375 0.0838623046875 -0.1505126953125 -0.00411224365234375 -0.0555419921875 0.0017614364624023438 0.040679931640625 0.0148162841796875 -0.3125 0.1396484375 -0.047760009765625

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