photos_with_apple_metadata (view)

1 row where place_country = "United States" and place_state_province = "OR"

View and edit SQL

Suggested facets: 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
5 A421A342-2706-4A6E-B993-38426E52421B 2018-12-24T20:06:03+00:00
[
    "Museums",
    "Public"
]
[]
heic 02e54839ec51f00bd8e4eaed08112c24b77cfedad2a2ea6563e421fcada75a44 1521065 45.20411333333333 -123.14530833333333 1 0 0 0 0 0 0 0 McMinnville OR United States A421A342-2706-4A6E-B993-38426E52421B 0.47509765625 0.75 0.0 0.058016162621610946 0.10000000149011612 -0.0010728836059570312 0.0234527587890625 0.001720428466796875 0.009999999776482582 -0.172119140625 -0.04046630859375 0.2279052734375 0.0035381317138671875 -0.01519012451171875 0.004852294921875 -0.03466796875 0.05120849609375 0.0616455078125 0.08056640625 0.0070037841796875 -0.0078887939453125 0.0027790069580078125 0.23388671875 0.19970703125 0.09521484375 0.51953125 0.004180908203125

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