photos_with_apple_metadata (view)

1 row where albums contains "Museums", longitude = "-4.251666666666667" and place_state_province = "England"

View and edit SQL

Suggested facets: date (date)

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
6 F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 2018-09-04T14:29:33+00:00
[
    "Museums",
    "Public"
]
[]
heic 03546cdc3eb2bd9bb65aa3004efbb8e1ca942ba52a6e860582f7c7f725f7a624 2302711 50.65674666666666 -4.251666666666667 0 0 0 0 0 0 0 0 Lifton England United Kingdom F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 0.365966796875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.01322174072265625 0.014678955078125 0.00653839111328125 0.009999999776482582 -0.32958984375 -0.170654296875 -0.1690673828125 0.0567626953125 -0.017852783203125 -0.037261962890625 -0.337890625 -0.43310546875 0.01495361328125 0.1483154296875 0.0036945343017578125 -0.00209808349609375 0.004055023193359375 0.01061248779296875 -0.17578125 0.00453948974609375 0.00518798828125 0.1861572265625

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