photos_with_apple_metadata (view)

1 row where place_state_province = "TN" sorted by ZFAILURESCORE

View and edit SQL

Suggested facets: 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
219 3C683CF5-1644-412C-AA01-F6A2EAE58319 2015-10-05T15:01:36+00:00
[
    "Museums",
    "Niche museums",
    "Public"
]
[]
jpeg 6d2e02585f44104e7d40f2e1fc471bafe4fef77c91e130d09eb7fd2db8aba4b6 3487122 35.716544999999996 -83.50289333333333 0 0 0 0 0 0 0 0 Gatlinburg TN United States 3C683CF5-1644-412C-AA01-F6A2EAE58319 0.728515625 0.5 0.0 0.04353355223895939 0.10000000149011612 -0.00263214111328125 0.01399993896484375 0.001934051513671875 0.019999999552965164 0.07373046875 -0.137939453125 0.07965087890625 0.010406494140625 -0.01363372802734375 -0.016876220703125 -0.309814453125 -0.050537109375 0.0301513671875 0.03619384765625 0.0016632080078125 -0.00664520263671875 0.0018892288208007812 0.08282470703125 0.1552734375 -0.134521484375 0.359375 0.1292724609375

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