photos_with_apple_metadata (view)

3 rows where ZPLEASANTSYMMETRYSCORE = "0.002590179443359375"

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
142 A6FB150E-71C0-4524-8344-57CF59FE1B9E 2019-11-02T20:30:45+00:00
[
    "Public"
]
[]
jpeg 4360afbd37be230bf9fd6afcc48245e76bf9c81786713400653b2c81fb63f9e7 4649025     0 0 0 0 0 0 0 0       A6FB150E-71C0-4524-8344-57CF59FE1B9E 0.671875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0011243820190429688 0.0157928466796875 0.004364013671875 0.009999999776482582 -0.005615234375 -0.12188720703125 0.214599609375 0.00577545166015625 -0.0089874267578125 -0.04571533203125 -0.452880859375 -0.0048828125 0.090087890625 -0.01739501953125 4.57763671875e-05 -0.017822265625 0.002590179443359375 0.0214080810546875 0.0196380615234375 -0.337646484375 -0.1243896484375 0.0
243 18939B2A-0A75-461C-B1D0-7ABD87282C2D 2019-08-02T07:06:42+00:00
[
    "To Instagram",
    "Public"
]
[]
jpeg 77bff818519fbcb9928b5259e5865f7f16a90fca872e7372a6bb06be7ac89fd9 4601240     1 0 0 0 0 0 0 0       18939B2A-0A75-461C-B1D0-7ABD87282C2D 0.73486328125 0.75 0.0 0.06263108016880414 0.10000000149011612 -0.00131988525390625 0.0268707275390625 0.0013151168823242188 0.009999999776482582 -0.0050048828125 -0.04803466796875 0.258544921875 0.005138397216796875 -0.014617919921875 0.016845703125 -0.0245361328125 0.05230712890625 0.06939697265625 0.068603515625 0.00927734375 -0.009765625 0.002590179443359375 0.316650390625 0.431640625 0.0804443359375 0.6259765625 0.010986328125
380 D735F0CE-A3D7-49CB-B83E-594604415A1C 2017-06-16T00:55:34+00:00
[
    "Stolen monasteries",
    "Public"
]
[]
jpeg be2e31a4d8ecf12e6631c7fbd0a093a446a7d23ef5dbeb412c41c14907357d16 5296680 37.76930333333333 -122.46441666666666 0 0 0 0 0 0 0 0 San Francisco CA United States D735F0CE-A3D7-49CB-B83E-594604415A1C 0.498291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.003063201904296875 -0.00627899169921875 0.0009851455688476562 0.05999999865889549 -0.296875 -0.03656005859375 0.28271484375 0.002140045166015625 -0.06622314453125 -0.07977294921875 -0.1859130859375 -0.1502685546875 0.1431884765625 -0.178466796875 -0.00289154052734375 -0.0833740234375 0.002590179443359375 0.0217742919921875 -0.00293731689453125 -0.33740234375 0.17333984375 -0.05267333984375

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