photos_with_apple_metadata (view)

4 rows where ZPLEASANTSYMMETRYSCORE = "0.005039215087890625"

View and edit SQL

Suggested facets: favorite, ZCURATIONSCORE, ZINTERACTIONSCORE, 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
341 65600C73-CFBC-4FD9-AADE-9CA39F776FC2 2019-11-02T20:30:31+00:00
[
    "Public"
]
[]
jpeg a50d3c5dc31188f36a8f2f6176c6469a5b62cb270962ba63737b3bfc5c9462f8 4837662     0 0 0 0 0 0 0 0       65600C73-CFBC-4FD9-AADE-9CA39F776FC2 0.70703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.004070281982421875 0.00601959228515625 0.01132965087890625 0.019999999552965164 -0.5419921875 -0.152099609375 0.0072021484375 0.012725830078125 -0.01111602783203125 -0.11370849609375 -0.69384765625 -0.262939453125 0.1044921875 -0.0220947265625 0.00093841552734375 -0.0264434814453125 0.005039215087890625 0.0030517578125 -0.03656005859375 -0.08477783203125 -0.47119140625 -0.0071563720703125
388 B9265412-3353-4812-8BBA-E6FF72DC5718 2019-08-21T16:05:33+00:00
[
    "Public"
]
[]
jpeg c2d88a3854c6bb06ebdedec26082e81bb4b47eaf629ae3c72a9a94550e715336 6764565     1 0 0 0 0 0 0 0       B9265412-3353-4812-8BBA-E6FF72DC5718 0.720703125 0.75 0.0 0.06263200881826969 0.10000000149011612 -0.0012845993041992188 0.0119476318359375 0.00690460205078125 0.009999999776482582 0.1044921875 -0.053009033203125 0.203857421875 0.0021076202392578125 -0.0117340087890625 -0.011871337890625 -0.11676025390625 0.00732421875 0.100341796875 0.016571044921875 0.003482818603515625 -0.009002685546875 0.005039215087890625 0.037811279296875 0.025299072265625 -0.1329345703125 0.2939453125 0.00823974609375
20 89820B37-8A27-49A7-BDDF-B64253FD23FA 2018-02-09T17:34:42+00:00
[
    "Public"
]
[]
jpeg 0be986eb6ca9a9770d1c8fceecaa6d30f1c7b7514ac226b22ca2acff432e096b 5741137     0 0 0 0 0 0 0 0       89820B37-8A27-49A7-BDDF-B64253FD23FA 0.74267578125 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0011692047119140625 0.02850341796875 0.0276336669921875 0.009999999776482582 -0.180419921875 -0.037261962890625 0.343017578125 0.0012445449829101562 -0.00714874267578125 -0.06915283203125 -0.2344970703125 -0.00421142578125 0.1766357421875 -0.0137939453125 0.005542755126953125 -0.00787353515625 0.005039215087890625 0.004962921142578125 -0.0036334991455078125 -0.069580078125 -0.296630859375 -0.0173797607421875
110 BF295F44-7050-4EF5-9D2D-597144A55C46 2016-04-17T20:01:45+00:00
[
    "Public"
]
[]
jpeg 365135c4f3997964b978de088f7a21599630a500aa7881331e6f4f7107ea2cb4 4661564 37.779955 -122.41871666666667 0 0 0 0 0 0 0 0 San Francisco CA United States BF295F44-7050-4EF5-9D2D-597144A55C46 0.49853515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0006566047668457031 0.0270233154296875 0.004486083984375 0.009999999776482582 -0.2177734375 -0.056549072265625 0.248779296875 0.0025806427001953125 -0.0069580078125 -0.04290771484375 -0.18701171875 0.0396728515625 0.10052490234375 0.05615234375 0.011260986328125 -0.0211639404296875 0.005039215087890625 0.0457763671875 0.0168304443359375 -0.03985595703125 0.1614990234375 -0.00495147705078125

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