photos_with_apple_metadata (view)

261 rows where albums = "["Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

albums ✖

  • ["Public"] · 261 ✖
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
214 E2A17559-5121-45E2-9FAB-6CF7C38F3F50 2018-02-09T17:37:37+00:00 
[
    "Public"
]
 
[]
 jpeg 69e98fd0fb8cb4a36d9feb83957fb0415c54a63bcef3c27720300496bfb8267c 4877381     1 0 0 0 0 0 0 0       E2A17559-5121-45E2-9FAB-6CF7C38F3F50 0.76171875 0.75 0.0 0.06261473575621161 0.10000000149011612 -0.000720977783203125 -0.004779815673828125 0.0038242340087890625 0.009999999776482582 0.07135009765625 -0.047515869140625 0.39404296875 0.0005726814270019531 -0.0162811279296875 -0.06329345703125 -0.25390625 -0.0662841796875 0.2359619140625 -0.07958984375 -0.0005092620849609375 -0.0269012451171875 0.0033893585205078125 0.005138397216796875 -0.0037364959716796875 -0.5478515625 -0.17724609375 -0.1026611328125
66 8E27300C-9123-40E7-B4CF-E796FC0C5B35 2018-02-09T17:37:30+00:00 
[
    "Public"
]
 
[]
 jpeg 1e75e97d2e8a1ffe1ab3980856b20b05b648af8fb1c0ab19aa3a097597f39ae3 5924049     0 0 0 0 0 0 0 0       8E27300C-9123-40E7-B4CF-E796FC0C5B35 0.70849609375 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.003780364990234375 0.0531005859375 0.00319671630859375 0.009999999776482582 -0.8896484375 -0.0182647705078125 0.3046875 0.026702880859375 -0.023468017578125 -0.014251708984375 -0.03143310546875 -0.0396728515625 0.094482421875 0.0289306640625 -0.1292724609375 -0.00994110107421875 0.0037364959716796875 0.062103271484375 0.02972412109375 0.12115478515625 0.18701171875 -0.0015716552734375
232 E2378A42-70B5-42A2-B8D8-CFE99DBCE627 2018-02-09T17:37:26+00:00 
[
    "Public"
]
 
[]
 jpeg 723a6e638a563a37ff666683b28f4190a29777475aca5428660fa22d5cff5a07 5948701     1 0 0 0 0 0 0 0       E2378A42-70B5-42A2-B8D8-CFE99DBCE627 0.66845703125 0.75 0.0 0.06111104934270145 0.10000000149011612 -0.0024051666259765625 0.013336181640625 0.005619049072265625 0.009999999776482582 -0.91796875 -0.020965576171875 0.1314697265625 0.0007791519165039062 -0.00600433349609375 -0.007549285888671875 0.01007080078125 -0.02764892578125 0.0210418701171875 0.03363037109375 -0.0223388671875 -0.005645751953125 0.00313568115234375 0.044769287109375 0.005462646484375 0.16259765625 0.283935546875 0.00146484375
336 B70635AD-65F3-462C-993A-C13F0CA868D3 2018-02-09T17:35:32+00:00 
[
    "Public"
]
 
[]
 jpeg a3dbd04c291b7218a634d6b0c960a80cb44a3fab625fbd7129547e61ee61dd72 4293844     1 0 0 0 0 0 0 0       B70635AD-65F3-462C-993A-C13F0CA868D3 0.7548828125 0.75 0.0 0.06261863644796474 0.10000000149011612 -0.006587982177734375 0.00927734375 0.02386474609375 0.009999999776482582 -0.357421875 -0.03594970703125 -0.0675048828125 0.0537109375 -0.06671142578125 -0.08197021484375 -0.20751953125 -0.3515625 0.27001953125 0.02850341796875 0.005828857421875 -0.01332855224609375 0.023956298828125 0.0029811859130859375 -0.0265045166015625 -0.02191162109375 -0.1678466796875 -0.0030670166015625
384 FF1D2E63-A1A2-4C67-A49B-090C603F8346 2018-02-09T17:35:20+00:00 
[
    "Public"
]
 
[]
 jpeg bf76ef31bcc06d65e439b74f09c7c7bfa3bfeaa4d463972520c658db7c59b061 4526609     0 0 0 0 0 0 0 0       FF1D2E63-A1A2-4C67-A49B-090C603F8346 0.7490234375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0016937255859375 0.0145416259765625 0.006744384765625 0.009999999776482582 -0.91455078125 -0.021575927734375 0.235107421875 0.0006165504455566406 -0.004886627197265625 -0.01410675048828125 -0.0574951171875 -0.023193359375 0.051849365234375 0.025177001953125 -0.02044677734375 -0.007793426513671875 0.00443267822265625 0.0311431884765625 -0.0015411376953125 0.08612060546875 0.1700439453125 -0.0013217926025390625
435 7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 2018-02-09T17:34:45+00:00 
[
    "Public"
]
 
[]
 jpeg dccff810ab672e497ad4c6cf850a9093a2b7caec871f3f8bd212af56bc935f40 6095738     0 0 0 0 0 0 0 0       7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 0.76806640625 0.5 0.0 0.043546182053689736 0.10000000149011612 -0.0016613006591796875 0.02593994140625 0.00881195068359375 0.009999999776482582 -0.9111328125 -0.0190582275390625 0.1021728515625 0.002452850341796875 -0.00469970703125 -0.00550079345703125 0.1080322265625 0.03466796875 0.08251953125 0.08984375 -0.01934814453125 -0.00405120849609375 0.0110321044921875 0.06744384765625 0.03228759765625 0.1116943359375 0.28125 0.0033588409423828125
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
306 BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 2018-02-09T17:34:41+00:00 
[
    "Public"
]
 
[]
 jpeg 945618e1454a17db6e8f66f5a72266b3e47c4c14f99a38c9792e9b10133e55bd 5522490     1 0 0 0 0 0 0 0       BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 0.65625 0.75 0.0 0.06109191898171228 0.10000000149011612 -0.0017137527465820312 0.021484375 0.0060272216796875 0.009999999776482582 -0.91748046875 -0.021331787109375 0.2049560546875 0.0011119842529296875 -0.0050201416015625 -0.0079498291015625 -0.02685546875 0.02593994140625 0.0287628173828125 0.036224365234375 -0.029022216796875 -0.0055999755859375 0.0026836395263671875 0.050811767578125 0.01702880859375 0.08807373046875 0.1494140625 0.0010223388671875
112 558FFB4E-06B0-4782-962A-FA28C8F0B415 2018-02-09T17:34:26+00:00 
[
    "Public"
]
 
[]
 jpeg 370c4f936c1cb84f1bbeea091005103b5fa94d264733dc20d24371b1ea9fb27a 6150089     0 0 0 0 0 0 0 0       558FFB4E-06B0-4782-962A-FA28C8F0B415 0.576171875 0.5 0.0 0.04201630736125334 0.1015571802854538 -0.0010004043579101562 0.081298828125 0.002208709716796875 0.009999999776482582 0.1552734375 -0.026702880859375 0.27734375 0.011962890625 -0.00885009765625 0.02862548828125 0.1475830078125 0.19580078125 0.09979248046875 0.2252197265625 0.06927490234375 -0.00176239013671875 0.00482940673828125 0.493408203125 0.671875 0.397216796875 0.70751953125 0.040496826171875
451 B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB 2018-02-09T17:34:17+00:00 
[
    "Public"
]
 
[]
 jpeg e45462e175fd04ec7b1f37d8c3e8ebe7fd783d07a6e2c4895bd67e594d5f2693 4663245     1 0 0 0 0 0 0 0       B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB 0.76953125 0.75 0.0 0.06261473575621161 0.10000000149011612 -0.0027370452880859375 0.0142059326171875 0.010986328125 0.009999999776482582 -0.451171875 -0.072265625 0.030364990234375 0.016021728515625 -0.018096923828125 -0.13037109375 -0.3876953125 -0.20703125 0.1900634765625 0.0311279296875 0.00605010986328125 -0.039947509765625 0.0119171142578125 0.005199432373046875 -0.0121917724609375 -0.03753662109375 -0.2171630859375 -0.001007080078125
390 C721AC7F-4D2E-447B-A789-B605FA9B9D99 2018-02-09T17:33:32+00:00 
[
    "Public"
]
 
[]
 jpeg c3f1191b7ce8e4f4643e3ec3efb3040e0668e42bb966e6b90c5b4e7b36e8ecfd 5895146     0 0 0 0 0 0 0 0       C721AC7F-4D2E-447B-A789-B605FA9B9D99 0.734375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.002704620361328125 0.00797271728515625 0.0014047622680664062 0.009999999776482582 -0.296875 -0.040252685546875 0.11865234375 0.00586700439453125 -0.060211181640625 -0.05859375 -0.097412109375 -0.121826171875 0.0604248046875 -0.057373046875 0.002368927001953125 -0.017059326171875 0.0032100677490234375 0.06634521484375 0.012908935546875 0.12347412109375 0.464111328125 -0.00754547119140625
229 A1095B7D-7675-4585-BEAE-C9A072A793C7 2018-02-09T17:31:07+00:00 
[
    "Public"
]
 
[]
 jpeg 71e3566c31cd0e96cb2c336357d709242c5c1f87d8ef11934c0b49a558ca4604 4511956     0 0 0 0 0 0 0 0       A1095B7D-7675-4585-BEAE-C9A072A793C7 0.7509765625 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0017547607421875 0.03582763671875 0.00714874267578125 0.009999999776482582 -0.87255859375 -0.034820556640625 0.05584716796875 0.004116058349609375 -0.0030517578125 -0.004730224609375 0.11669921875 0.052490234375 0.0301055908203125 0.1285400390625 -0.0123748779296875 -0.0027141571044921875 0.0074615478515625 0.097412109375 0.06146240234375 0.08624267578125 0.35400390625 0.010589599609375
337 365D28C9-AF11-425E-A648-3C3479A5CDE4 2018-02-09T17:31:04+00:00 
[
    "Public"
]
 
[]
 jpeg a444857c4ac71ceae6af5192c8acc5ac35934ed589259136df0ed11295dbb085 4738644     1 0 0 0 0 0 0 0       365D28C9-AF11-425E-A648-3C3479A5CDE4 0.8291015625 0.75 0.0 0.06263034170820513 0.504890501499176 -0.0005297660827636719 0.1136474609375 0.005641937255859375 0.009999999776482582 0.0384521484375 -0.005428314208984375 0.36669921875 0.0032482147216796875 -0.00841522216796875 0.00429534912109375 0.256591796875 0.1605224609375 0.056121826171875 0.144775390625 0.046630859375 0.00334930419921875 0.006877899169921875 0.1749267578125 0.0360107421875 0.68701171875 0.6845703125 0.037322998046875
92 C04ECCFD-2679-4E64-823F-290C47A16396 2018-02-09T17:31:04+00:00 
[
    "Public"
]
 
[]
 jpeg 28615e09f1a3d49a3392d0a8c61397d75d9dd1a6224389328565692def29b678 4471977     0 0 0 0 0 0 0 0       C04ECCFD-2679-4E64-823F-290C47A16396 0.7802734375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0010280609130859375 0.040283203125 0.001949310302734375 0.009999999776482582 -0.0384521484375 -0.0369873046875 0.30859375 0.0029697418212890625 -0.0143890380859375 -0.0029296875 -0.00372314453125 0.03985595703125 0.10302734375 0.10400390625 0.02288818359375 -0.016357421875 0.003749847412109375 0.1630859375 0.1119384765625 0.253173828125 0.52294921875 0.0050048828125
96 628C1DF6-48DA-40FA-B6B7-BFB0AA99103B 2018-02-09T17:30:59+00:00 
[
    "Public"
]
 
[]
 jpeg 2be9ea6baf18726f34da4e447a5851b4c072fe24c12989f969d8d356009003eb 4475373     0 0 0 0 0 0 0 0       628C1DF6-48DA-40FA-B6B7-BFB0AA99103B 0.7734375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0020580291748046875 0.00391387939453125 0.0029811859130859375 0.009999999776482582 -0.59130859375 -0.08465576171875 0.1370849609375 0.0033111572265625 -0.0184783935546875 -0.150390625 -0.458740234375 -0.140380859375 0.11199951171875 -0.11077880859375 -0.00164031982421875 -0.049957275390625 0.0035800933837890625 0.01312255859375 -0.007232666015625 -0.1181640625 -0.14794921875 -0.0172882080078125
149 8A4D8382-B56E-4B87-8185-3702FA3AC0CF 2018-02-09T17:30:50+00:00 
[
    "Public"
]
 
[]
 jpeg 4864ce041cb9789b351bee246199845dbd66866c44576a409c755995327bf070 4978336     0 0 0 0 0 0 0 0       8A4D8382-B56E-4B87-8185-3702FA3AC0CF 0.6328125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0016613006591796875 0.0130462646484375 0.0018100738525390625 0.009999999776482582 -0.320556640625 -0.032470703125 0.2236328125 0.0037078857421875 -0.0207977294921875 -0.024261474609375 -0.063720703125 -0.041015625 0.10992431640625 -0.00274658203125 0.005218505859375 -0.05413818359375 0.00498199462890625 0.092529296875 0.05181884765625 0.07879638671875 0.434326171875 -0.007740020751953125
402 F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 2018-02-09T17:27:30+00:00 
[
    "Public"
]
 
[]
 jpeg c7f136a2c859e0cf4683e9c496fb21501ba2d22b326f91ee68a61b048d3cf75d 6152857     0 0 0 0 0 0 0 0       F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 0.52978515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0015249252319335938 -0.0049591064453125 0.004039764404296875 0.009999999776482582 -0.37744140625 -0.07696533203125 0.2646484375 0.0016355514526367188 -0.01751708984375 -0.0535888671875 -0.484130859375 -0.067626953125 0.138916015625 -0.064453125 -0.0138397216796875 -0.0174102783203125 0.001926422119140625 0.00930023193359375 -0.00273895263671875 -0.4765625 -0.3681640625 -0.083740234375
248 E6BE07D8-2034-485F-9362-F9E0EC53453A 2018-02-09T17:25:46+00:00 
[
    "Public"
]
 
[]
 jpeg 793d55151710ba958b585f1956ba22787bcd2ec91882beeb20ff432bb287ce52 5996815     0 0 0 0 0 0 0 0       E6BE07D8-2034-485F-9362-F9E0EC53453A 0.525390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.05792236328125 -0.006591796875 0.0074310302734375 0.009999999776482582 -0.513671875 -0.09503173828125 -0.1875 0.07080078125 -0.16259765625 -0.070556640625 -0.57177734375 -0.6787109375 0.093994140625 -0.0762939453125 -0.002361297607421875 -0.0206298828125 0.005535125732421875 0.0016679763793945312 -0.44384765625 -0.1187744140625 -0.3017578125 -0.049591064453125
372 B2AF6A23-95AB-462A-9AF9-AA5792FE43A0 2018-02-09T17:22:44+00:00 
[
    "Public"
]
 
[]
 jpeg b693381f085f8eccc64d6d4a372870542ed55390621b48e7f0acdd878de466ee 4447612     0 0 0 0 0 0 0 0       B2AF6A23-95AB-462A-9AF9-AA5792FE43A0 0.71044921875 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.0005679130554199219 0.01261138916015625 0.002521514892578125 0.009999999776482582 -0.0411376953125 -0.042388916015625 0.340087890625 0.00147247314453125 -0.007175445556640625 -0.0174560546875 -0.077880859375 -0.019287109375 0.1181640625 -0.009429931640625 0.0051727294921875 -0.160888671875 0.007488250732421875 0.049224853515625 0.01480865478515625 -0.186279296875 0.419921875 -0.0118408203125
284 A9CC4A89-22E0-42B3-8026-B07334120C45 2018-02-09T17:21:25+00:00 
[
    "Public"
]
 
[]
 jpeg 8887d5b42995cb3e6d0959d3cabca4a4b9a4ef9658de25a72ad232b282ca9f99 4911035     0 0 0 0 0 0 0 0       A9CC4A89-22E0-42B3-8026-B07334120C45 0.68212890625 0.5 0.0 0.04201816466018444 0.10000000149011612 -0.0282745361328125 -0.006748199462890625 0.0014162063598632812 0.009999999776482582 -0.4091796875 -0.08990478515625 -0.07373046875 0.057373046875 -0.342041015625 -0.06829833984375 -0.51513671875 -0.55810546875 0.0455322265625 -0.142822265625 -0.0050048828125 -0.01666259765625 0.0017747879028320312 0.00646209716796875 -0.19921875 -0.36328125 -0.099609375 -0.1099853515625
95 A4CA92F3-A131-498E-8205-62E1BF5A4EF4 2018-02-09T17:12:24+00:00 
[
    "Public"
]
 
[]
 jpeg 2bb66fd402f278b2d94fe7858cc0433d75c10ae4b7dad602fea6f6d8c3cdb57f 6153631     1 0 0 0 0 0 0 0       A4CA92F3-A131-498E-8205-62E1BF5A4EF4 0.60595703125 0.75 0.0 0.06109619049625542 0.10000000149011612 -0.0016813278198242188 -0.0042266845703125 0.002834320068359375 0.019999999552965164 -0.5615234375 -0.033599853515625 0.300048828125 0.001220703125 -0.0206451416015625 -0.06109619140625 -0.2479248046875 -0.1029052734375 0.1707763671875 -0.0718994140625 -0.003936767578125 -0.048583984375 0.004070281982421875 0.0121917724609375 -0.003787994384765625 -0.199462890625 -0.051025390625 -0.02569580078125
117 E1D818E2-89E8-4AA6-9D53-BA54F32F332B 2018-02-09T17:09:57+00:00 
[
    "Public"
]
 
[]
 jpeg 38d2cbc031e651476e9e6f76a9771e6fa9a50ca34841f6e4dab9ca5479932f11 5452392     0 0 0 0 0 0 0 0       E1D818E2-89E8-4AA6-9D53-BA54F32F332B 0.6748046875 0.5 0.0 0.042008692071638036 0.10000000149011612 -0.0063629150390625 0.00811004638671875 0.0115509033203125 0.009999999776482582 -0.20556640625 -0.03875732421875 0.03302001953125 0.0517578125 -0.062103271484375 -0.0701904296875 -0.25439453125 -0.26416015625 0.3876953125 -0.01654052734375 0.00994873046875 -0.02093505859375 0.01348114013671875 0.004314422607421875 -0.0185546875 -0.0633544921875 -0.2301025390625 -0.01535797119140625
293 F8A949C8-9034-4437-A685-765B42D87052 2018-02-09T17:09:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8d72f82e8b04528c211dca24f9cb846e4b5f6aca72b7047714bd04eb5bdfed70 5236836     0 0 0 0 0 0 0 0       F8A949C8-9034-4437-A685-765B42D87052 0.76318359375 0.5 0.0 0.043549711012658275 0.10000000149011612 -0.002758026123046875 0.007160186767578125 0.0054473876953125 0.009999999776482582 -0.9423828125 -0.0203704833984375 0.2205810546875 0.0003936290740966797 -0.006511688232421875 -0.0133209228515625 -0.08416748046875 -0.04241943359375 0.036834716796875 0.005096435546875 -0.0263824462890625 -0.00873565673828125 0.00243377685546875 0.0274810791015625 -0.0011138916015625 0.096923828125 0.10662841796875 -0.0027599334716796875
31 620F538F-0190-4AD6-8EAA-9E274EC04BD7 2018-02-09T17:09:13+00:00 
[
    "Public"
]
 
[]
 jpeg 12f9020c547f61512034092d35272e60e2c076da78016ef8ae7b229e04dbc479 5772763     1 0 0 0 0 0 0 0       620F538F-0190-4AD6-8EAA-9E274EC04BD7 0.73876953125 0.75 0.0 0.06261715042682095 0.10000000149011612 -0.0023059844970703125 0.0190277099609375 0.006072998046875 0.009999999776482582 -0.93701171875 -0.0162200927734375 0.12213134765625 0.0006799697875976562 -0.004055023193359375 -0.00333404541015625 0.11285400390625 0.0120849609375 0.0164031982421875 0.052642822265625 -0.0272674560546875 -0.003326416015625 0.00359344482421875 0.08477783203125 0.0305023193359375 0.2288818359375 0.40283203125 0.0032062530517578125
338 9C0E4F98-A2A8-45F8-8078-792720435621 2018-02-09T17:09:09+00:00 
[
    "Public"
]
 
[]
 jpeg a4613c06f65f7d13e8c36a1c59025b23caf787d4775a44945e6ae2f5e7fd3929 5496634     1 0 0 0 0 0 0 0       9C0E4F98-A2A8-45F8-8078-792720435621 0.74267578125 0.75 0.0 0.06261882208685839 0.10000000149011612 -0.001964569091796875 0.00035858154296875 0.0014209747314453125 0.009999999776482582 -0.379638671875 -0.055511474609375 0.37548828125 0.001094818115234375 -0.01751708984375 -0.0670166015625 -0.27587890625 -0.0677490234375 0.0838623046875 -0.1505126953125 -0.00411224365234375 -0.0555419921875 0.0017614364624023438 0.040679931640625 0.0148162841796875 -0.3125 0.1396484375 -0.047760009765625
325 51BEC73B-C230-4B0F-8174-7EFD498DBC9B 2018-02-09T17:09:05+00:00 
[
    "Public"
]
 
[]
 jpeg 9decc7b3b382c0f79961f2d54c6928822549d21c10d503811ea31ce39ce28e45 4940822     1 0 0 0 0 0 0 0       51BEC73B-C230-4B0F-8174-7EFD498DBC9B 0.8017578125 0.75 0.0 0.0626148303956476 0.10000000149011612 -0.0026836395263671875 0.02777099609375 0.007205963134765625 0.009999999776482582 -0.9072265625 -0.01861572265625 0.1287841796875 0.001956939697265625 -0.00530242919921875 -0.005096435546875 0.09722900390625 0.00592041015625 0.042388916015625 0.06536865234375 -0.02935791015625 -0.0037250518798828125 0.00591278076171875 0.06927490234375 0.0316162109375 0.158935546875 0.318115234375 0.0050048828125
307 CE82D764-5190-4817-8027-18562D6C4E44 2018-02-09T17:09:01+00:00 
[
    "Public"
]
 
[]
 jpeg 9482db6d0ad87c6629f59ad3a1952b14be4efe363fc7f6b7d52d9d63c6c5529b 4737344     0 0 0 0 0 0 0 0       CE82D764-5190-4817-8027-18562D6C4E44 0.7080078125 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.00106048583984375 0.00131988525390625 0.0025310516357421875 0.009999999776482582 0.1129150390625 -0.0872802734375 0.288330078125 0.0020198822021484375 -0.0216217041015625 -0.09893798828125 -0.33544921875 -0.074951171875 0.2939453125 -0.1087646484375 -0.0019989013671875 -0.0322265625 0.0035381317138671875 0.01049041748046875 -0.00115203857421875 -0.4990234375 -0.13134765625 -0.06817626953125
276 16243B99-6AFB-4401-9E29-90CAFB201343 2018-02-09T17:08:34+00:00 
[
    "Public"
]
 
[]
 jpeg 8476e9f946979ae2b0f1a8c1a06165e123b700464986ca846f91595a7825728a 4595280     0 0 0 0 0 0 0 0       16243B99-6AFB-4401-9E29-90CAFB201343 0.71142578125 0.5 0.0 0.04354488212643689 0.10000000149011612 -0.0030269622802734375 0.020294189453125 0.0089874267578125 0.009999999776482582 -0.92431640625 -0.0231475830078125 0.01873779296875 0.00243377685546875 -0.0050201416015625 -0.003948211669921875 0.1689453125 -0.0125732421875 0.015838623046875 0.093505859375 -0.0188446044921875 -0.002872467041015625 0.0068511962890625 0.07159423828125 0.012542724609375 0.1868896484375 0.427490234375 0.00797271728515625
138 78EDF691-C593-4162-B20C-F96D5675DA46 2018-02-09T17:08:28+00:00 
[
    "Public"
]
 
[]
 jpeg 3f52e7508a28417a832fb8d369adc520002ad808bc8bf480e5fca9134d16d616 4432185     0 0 0 0 0 0 0 0       78EDF691-C593-4162-B20C-F96D5675DA46 0.74755859375 0.5 0.0 0.04354636769258339 0.10000000149011612 -0.0011119842529296875 0.03460693359375 0.0135345458984375 0.009999999776482582 -0.77978515625 -0.01467132568359375 0.1280517578125 0.004772186279296875 -0.006931304931640625 -0.00461578369140625 0.178955078125 0.076171875 0.1982421875 0.11798095703125 -0.01154327392578125 -0.003734588623046875 0.025421142578125 0.06451416015625 0.024993896484375 0.1263427734375 0.33251953125 0.00576019287109375
239 11D38304-FE06-43AD-B3F0-18FCB7697365 2018-02-09T17:08:15+00:00 
[
    "Public"
]
 
[]
 jpeg 75acbbcbf1e97c8a33742aff62ac0255ed9eb67de35bcae0d51d9176a4f6ffe7 4604119     1 0 0 0 0 0 0 0       11D38304-FE06-43AD-B3F0-18FCB7697365 0.7958984375 0.75 0.0 0.06264114652881185 0.10000000149011612 -0.0010042190551757812 0.0269622802734375 0.001483917236328125 0.009999999776482582 -0.148681640625 -0.04345703125 0.1900634765625 0.005405426025390625 -0.00974273681640625 0.0116119384765625 0.0089111328125 0.07745361328125 0.054901123046875 0.1292724609375 0.01070404052734375 -0.00806427001953125 0.0035381317138671875 0.342041015625 0.37939453125 0.143798828125 0.662109375 0.0079345703125
455 5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E 2018-02-09T17:08:14+00:00 
[
    "Public"
]
 
[]
 jpeg e740c4271b7e85d680e53c1d4ea48662b8636d0586027b866de11f5532eb4250 4467400     1 0 0 0 0 0 0 0       5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E 0.82470703125 0.75 0.0 0.06263840062017659 0.10000000149011612 -0.00391387939453125 0.0081329345703125 0.006439208984375 0.009999999776482582 -0.93212890625 -0.037689208984375 0.02410888671875 0.0015363693237304688 -0.007549285888671875 -0.0147247314453125 -0.1170654296875 -0.140625 0.018341064453125 0.036651611328125 -0.01104736328125 -0.00743865966796875 0.00391387939453125 0.0247039794921875 -0.02410888671875 0.0745849609375 0.177001953125 0.0007457733154296875
22 E77313F1-D351-4F1C-85BA-7D88CCE26FE7 2018-02-09T17:08:14+00:00 
[
    "Public"
]
 
[]
 jpeg 0cbc72959305698cc602c5aa38a7b95b7cd3e3c7411273d63bfb3db481edffcd 4757357     0 0 0 0 0 0 0 0       E77313F1-D351-4F1C-85BA-7D88CCE26FE7 0.71875 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.006290435791015625 0.02703857421875 0.006122589111328125 0.019999999552965164 -0.939453125 -0.03192138671875 0.076416015625 0.00609588623046875 -0.005706787109375 -0.00545501708984375 -0.0206298828125 -0.045166015625 0.044342041015625 0.05059814453125 -0.043212890625 -0.005584716796875 0.004215240478515625 0.073974609375 0.135498046875 0.067138671875 0.154052734375 0.00299835205078125
326 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 2018-02-09T17:07:59+00:00 
[
    "Public"
]
 
[]
 jpeg 9e06275e7fa0e4f84d6a1e7a8ae97c27a59eebc6f3769f5b0129e492bf9c40c1 5328743     1 0 0 0 0 0 0 0       5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 0.6591796875 0.75 0.0 0.06111104934270145 0.10000000149011612 -0.0221099853515625 -0.0023956298828125 0.00266265869140625 0.009999999776482582 -0.417236328125 -0.0574951171875 0.162353515625 0.003185272216796875 -0.055206298828125 -0.064208984375 -0.300048828125 -0.2000732421875 0.036712646484375 -0.1666259765625 -0.0035400390625 -0.01611328125 0.0010690689086914062 0.017303466796875 -0.206787109375 -0.138916015625 0.03955078125 -0.0994873046875
215 C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 2018-02-09T17:07:45+00:00 
[
    "Public"
]
 
[]
 jpeg 6b5b1aca3fb2810239c1f3003ce4a0c538c9aa9ac9a9eaf0549ad24ab255ad49 5800574     0 0 0 0 0 0 0 0       C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 0.63037109375 0.5 0.0 0.04202726551594625 0.10000000149011612 -0.0227203369140625 -0.009124755859375 0.00536346435546875 0.009999999776482582 -0.3115234375 -0.061309814453125 -0.0322265625 0.0345458984375 -0.1669921875 -0.059539794921875 -0.443359375 -0.478515625 0.1287841796875 -0.07940673828125 -0.0029850006103515625 -0.0196990966796875 0.004180908203125 0.00243377685546875 -0.163330078125 -0.285400390625 -0.2890625 -0.097900390625
213 FC705948-B3D8-4B7A-90A6-E617B3ED80F6 2018-02-09T17:07:31+00:00 
[
    "Public"
]
 
[]
 jpeg 69c533c4c5bfc739e1eced0562e7a2945919176fa7e13a432e5a0ee5731a59ae 5878523     0 0 0 0 0 0 0 0       FC705948-B3D8-4B7A-90A6-E617B3ED80F6 0.58740234375 0.5 0.0 0.04203098011380844 0.10000000149011612 -0.00243377685546875 0.008056640625 0.0013408660888671875 0.009999999776482582 -0.2054443359375 -0.036285400390625 0.333740234375 0.0038547515869140625 -0.02337646484375 -0.02716064453125 -0.0999755859375 -0.0706787109375 0.161376953125 -0.068359375 0.001575469970703125 -0.10321044921875 0.003795623779296875 0.07476806640625 0.0780029296875 -0.124755859375 0.33203125 -0.0229339599609375
26 B19BB608-7B37-4094-AE9B-504B13660278 2018-01-14T23:22:43+00:00 
[
    "Public"
]
 
[]
 heic 0ecd701f9983b7f759eab2d53911b05de86cf0dfcde086d85c480c70cc8b8f43 3510677 37.76555333333334 -122.440025 0 0 0 0 0 0 0 0 San Francisco CA United States B19BB608-7B37-4094-AE9B-504B13660278 0.3291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016231536865234375 0.041717529296875 0.0011377334594726562 0.03999999910593033 -0.0711669921875 -0.0386962890625 0.30029296875 0.005199432373046875 -0.0154266357421875 0.0089111328125 0.0123291015625 0.0244140625 0.0794677734375 0.08740234375 0.020721435546875 -0.0150146484375 0.00274658203125 0.324462890625 0.397705078125 0.28076171875 0.62158203125 0.00057220458984375
480 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 2017-12-16T11:52:26+00:00 
[
    "Public"
]
 
[]
 heic f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62 2274468 51.5034 -0.13202216666666666 0 0 0 0 0 0 0 0 London England United Kingdom E1468521-C7AB-4BA9-B4A9-D136FC9D4958 0.6083984375 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.00974273681640625 0.00029754638671875 0.0013513565063476562 0.019999999552965164 -0.35498046875 -0.07879638671875 0.183349609375 0.004486083984375 -0.08526611328125 -0.072021484375 -0.189697265625 -0.219970703125 0.0309600830078125 -0.11846923828125 -0.09161376953125 -0.03326416015625 0.0009851455688476562 0.0284881591796875 -0.07403564453125 -0.1715087890625 0.30859375 -0.041015625
317 0D23847A-0863-4F18-938A-9839C8E28B91 2017-12-16T11:52:19+00:00 
[
    "Public"
]
 
[]
 heic 9ae44af9c6d663d44e03539a41fed0bb4679519f542ba99439f00a44a22d262c 2126432 51.5034 -0.132025 0 0 0 0 0 0 0 0 London England United Kingdom 0D23847A-0863-4F18-938A-9839C8E28B91 0.65576171875 0.5 0.0 0.04200813515495708 0.5031630396842957 -0.0005359649658203125 0.145263671875 0.0312042236328125 0.009999999776482582 0.46923828125 -0.038604736328125 0.1214599609375 0.0169219970703125 -0.0041351318359375 -0.0017242431640625 0.31689453125 0.330810546875 0.0548095703125 0.306884765625 0.0665283203125 0.01551055908203125 0.01262664794921875 0.034759521484375 0.0131072998046875 0.050567626953125 0.1435546875 0.239990234375
489 B78C4087-CE43-411C-AEAF-16C585DF6D67 2017-12-16T11:52:17+00:00 
[
    "Public"
]
 
[]
 heic fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a 2091779 51.5034 -0.13202783333333332 0 0 0 0 0 0 0 0 London England United Kingdom B78C4087-CE43-411C-AEAF-16C585DF6D67 0.71337890625 0.5 0.0 0.8068936312471637 0.10000000149011612 -0.005344390869140625 0.017913818359375 0.01094818115234375 0.009999999776482582 -0.55078125 -0.05865478515625 -0.06689453125 0.01129150390625 -0.01666259765625 -0.03057861328125 -0.1268310546875 -0.252197265625 0.020172119140625 0.0902099609375 0.0024738311767578125 -0.00368499755859375 0.00455474853515625 0.0104522705078125 -0.033721923828125 0.0194854736328125 0.00994873046875 0.019500732421875
238 C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 2017-12-16T11:52:15+00:00 
[
    "Public"
]
 
[]
 heic 7579f41e5a983976df725e86a94b7261d7dd42ce20b6fd1e1ac24157a5f423a6 2545737 51.5034 -0.1320305 0 0 0 0 0 0 0 0 London England United Kingdom C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 0.6943359375 0.5 0.0 0.8053669137809113 0.5068126320838928 -0.00046372413635253906 0.07562255859375 0.00809478759765625 0.009999999776482582 0.449951171875 -0.027069091796875 0.2340087890625 0.0027675628662109375 -0.0068511962890625 -0.003997802734375 0.20849609375 0.1182861328125 0.036895751953125 0.19921875 0.0247955322265625 0.0036468505859375 0.006824493408203125 0.046905517578125 0.005023956298828125 0.21826171875 0.459228515625 0.18798828125
426 A5E3DEAF-E22B-454C-9543-CF68191F349A 2017-12-16T11:52:14+00:00 
[
    "Public"
]
 
[]
 heic d84a166371c9d0f249aa25afbac69ba5cd310a5392fddf2c113736b53f0c6d5e 2498824 51.5034 -0.1320305 0 0 0 0 0 0 0 0 London England United Kingdom A5E3DEAF-E22B-454C-9543-CF68191F349A 0.64990234375 0.5 0.0 0.8053667281420176 0.5036982893943787 -0.0003859996795654297 0.0845947265625 0.01322174072265625 0.009999999776482582 0.51171875 -0.04193115234375 0.064208984375 0.0112457275390625 -0.005321502685546875 0.00323486328125 0.36376953125 0.281494140625 0.02947998046875 0.3935546875 0.042724609375 0.0096282958984375 0.01312255859375 0.058349609375 0.00994110107421875 0.156005859375 0.45751953125 0.295166015625
385 F6F45595-4033-4C79-A9F9-86DCA9088C37 2017-12-16T11:52:13+00:00 
[
    "Public"
]
 
[]
 heic bfe920659a1e209114e738c58fcc9e1df8cdd1eaed6ac7af4721f05865ba8935 2341576 51.50340333333333 -0.13203616666666668 0 0 0 0 0 0 0 0 London England United Kingdom F6F45595-4033-4C79-A9F9-86DCA9088C37 0.6103515625 0.5 0.0 0.8053669137809113 0.10000000149011612 -0.00572967529296875 -0.000789642333984375 0.0010814666748046875 0.019999999552965164 0.0447998046875 -0.095703125 0.048583984375 0.01238250732421875 -0.08880615234375 -0.05389404296875 -0.29736328125 -0.29248046875 0.0289306640625 -0.12152099609375 -0.001251220703125 -0.0276031494140625 0.0015192031860351562 0.022796630859375 -0.032806396484375 -0.325439453125 0.28076171875 -0.0489501953125
403 C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 2017-12-16T11:51:56+00:00 
[
    "Public"
]
 
[]
 heic c8b559b15a474986fdfb54b369eb86e9c5a65ec65c5fd1f6d37f3065953943d1 1699083 51.503391666666666 -0.13205283333333334 0 0 0 0 0 0 0 0 London England United Kingdom C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 0.6298828125 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.001995086669921875 0.07391357421875 0.02069091796875 0.009999999776482582 -0.05419921875 -0.0638427734375 0.0679931640625 0.011962890625 -0.009521484375 -0.06158447265625 -0.0850830078125 0.0257568359375 0.0330810546875 0.201416015625 0.018402099609375 0.003326416015625 0.0038547515869140625 0.00971221923828125 -0.006549835205078125 0.006866455078125 -0.07818603515625 0.1031494140625
355 6CE10468-228C-4110-AB0B-663558FCF258 2017-12-16T11:51:32+00:00 
[
    "Public"
]
 
[]
 heic ac2fa4d70ca17a1face556a46a10868917800a96e5c48d0322a7e8a6903b6ae9 2369444 51.50336166666666 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6CE10468-228C-4110-AB0B-663558FCF258 0.6875 0.5 0.0 0.04202670814426801 0.10000000149011612 -0.0016489028930664062 0.08026123046875 0.0219879150390625 0.009999999776482582 0.25732421875 -0.055938720703125 0.0203857421875 0.01363372802734375 -0.0082550048828125 -0.040130615234375 0.19677734375 0.017578125 0.023193359375 0.279296875 0.022216796875 0.03936767578125 0.00760650634765625 0.01116180419921875 -0.00557708740234375 0.022735595703125 0.031005859375 0.200927734375
135 6274A881-9445-44D6-9E7C-776DAEF1C603 2017-12-16T11:51:31+00:00 
[
    "Public"
]
 
[]
 heic 3eb13ed43499313a2db919adf2b109b55dd49377096ac3edc35444b735a95b69 2120984 51.503355 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6274A881-9445-44D6-9E7C-776DAEF1C603 0.626953125 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.002208709716796875 0.041107177734375 0.0035648345947265625 0.019999999552965164 0.14013671875 -0.07147216796875 0.12841796875 0.01009368896484375 -0.01061248779296875 -0.02294921875 0.0084228515625 -0.0406494140625 0.03143310546875 0.1263427734375 0.01114654541015625 -0.019287109375 0.005428314208984375 0.060211181640625 0.024200439453125 0.04046630859375 0.45068359375 0.143798828125
173 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 2017-12-16T11:51:14+00:00 
[
    "Public"
]
 
[]
 heic 57da25cee1c32557167b6d5458ac3ea56f683150c2611d6d8ad6a9b6dbb27276 2072848 51.503303333333335 -0.1321805 1 0 0 0 0 0 0 0 London England United Kingdom 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 0.5703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008358955383300781 0.032989501953125 0.00313568115234375 0.009999999776482582 -0.45654296875 -0.043121337890625 0.239501953125 0.0038547515869140625 -0.00919342041015625 -0.02197265625 -0.1068115234375 0.0599365234375 0.09857177734375 0.10504150390625 0.00670623779296875 -0.011199951171875 0.004467010498046875 0.097900390625 0.051239013671875 0.05975341796875 0.29052734375 -8.392333984375e-05
415 48EECE84-27A5-4AEC-9B09-6173F8700CEA 2017-12-16T11:51:09+00:00 
[
    "Public"
]
 
[]
 heic d1f5ff1dc55f467cc316d31897840e7ab50a1894823780b56c36e9ee6bda5c08 1806032 51.503303333333335 -0.1321805 0 0 0 0 0 0 0 0 London England United Kingdom 48EECE84-27A5-4AEC-9B09-6173F8700CEA 0.58349609375 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.004520416259765625 0.0024871826171875 0.00269317626953125 0.019999999552965164 -0.498291015625 -0.06878662109375 0.1837158203125 0.006931304931640625 -0.023101806640625 -0.06317138671875 -0.370361328125 -0.158447265625 0.11920166015625 -0.0765380859375 -0.003047943115234375 -0.0631103515625 0.0030155181884765625 0.021575927734375 0.007659912109375 -0.190673828125 -0.0775146484375 -0.033233642578125
30 8876C417-C39E-453A-A865-2A997A6DAAF0 2017-12-16T11:51:05+00:00 
[
    "Public"
]
 
[]
 heic 11b66e49de0d6187d44d38601aefce96dfa29f419444d201b1e03422bd76dc14 1999722 51.503296666666664 -0.13221116666666666 0 0 0 0 0 0 0 0 London England United Kingdom 8876C417-C39E-453A-A865-2A997A6DAAF0 0.65673828125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.01029205322265625 -0.0067291259765625 0.0014553070068359375 0.009999999776482582 -0.26220703125 -0.10125732421875 0.0670166015625 0.006984710693359375 -0.120361328125 -0.1640625 -0.50146484375 -0.361328125 0.06671142578125 -0.2410888671875 -0.0035266876220703125 -0.053955078125 0.0016489028930664062 0.005344390869140625 -0.1005859375 -0.46533203125 -0.158203125 -0.1329345703125
157 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 2017-10-21T19:31:24+00:00 
[
    "Public"
]
 
[]
 jpeg 4b7a039dc64647efadfb959fdf8fedc82c753e590a5dc5f3a0caebc150706b1b 4252995 37.77567166666667 -122.51278666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 0.50732421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0038089752197265625 -0.00676727294921875 0.0021076202392578125 0.009999999776482582 0.10498046875 -0.060760498046875 0.019775390625 0.0230712890625 -0.1339111328125 -0.04217529296875 -0.253662109375 -0.3642578125 0.1802978515625 -0.0487060546875 -0.004413604736328125 -0.02642822265625 0.00800323486328125 0.00806427001953125 -0.045440673828125 -0.55615234375 0.2083740234375 -0.0648193359375
1 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 2017-10-21T18:11:34+00:00 
[
    "Public"
]
 
[]
 jpeg 00485aa2f328e85a25275dbdbf97af63c36e869f012302206b4c8d1f1e60c26d 5184871 37.77535 -122.51298666666666 0 0 0 0 0 0 0 0 San Francisco CA United States F78D8339-34E9-4A9A-9BF8-6A73F52566EE 0.53271484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00037550926208496094 0.03216552734375 0.01073455810546875 0.009999999776482582 -0.34033203125 -0.0699462890625 0.1435546875 0.00524139404296875 -0.00469970703125 -0.0418701171875 -0.28076171875 0.1400146484375 0.11181640625 0.1612548828125 0.0097198486328125 -0.0096893310546875 0.0101318359375 0.026763916015625 0.0047454833984375 -0.07196044921875 -0.0020751953125 0.010009765625
187 A3621F93-93FE-4025-8C7A-ECC62CA9F326 2017-10-21T18:11:33+00:00 
[
    "Public"
]
 
[]
 jpeg 5dbba9e4d6c335f966573806fbdc841ee4fa917e1b13427e1bb6a5ff61420c44 5474835 37.77533666666667 -122.51297833333334 0 0 0 0 0 0 0 0 San Francisco CA United States A3621F93-93FE-4025-8C7A-ECC62CA9F326 0.45751953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005428314208984375 0.00844573974609375 0.0136871337890625 0.009999999776482582 -0.230712890625 -0.06549072265625 0.0655517578125 0.0208892822265625 -0.0268096923828125 -0.061126708984375 -0.352294921875 -0.170166015625 0.386962890625 -0.00115966796875 0.005817413330078125 -0.0172271728515625 0.012969970703125 0.00867462158203125 -0.0306396484375 -0.1173095703125 -0.221435546875 -0.022216796875
260 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 2017-09-29T01:17:17+00:00 
[
    "Public"
]
 
[]
 jpeg 7ef1fc100a8feb54edec02b3dda0255d5fd0e8260c015c1b4feeb8be39bcabca 4772665 37.77751666666666 -122.42583333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 0.4208984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004665374755859375 -0.000202178955078125 0.0026416778564453125 0.009999999776482582 0.003662109375 -0.10797119140625 0.034637451171875 0.009857177734375 -0.038238525390625 -0.07037353515625 -0.394775390625 -0.30859375 0.07366943359375 -0.051483154296875 -0.0014400482177734375 -0.02740478515625 0.0038700103759765625 0.0070648193359375 -0.0821533203125 -0.29833984375 0.0435791015625 0.01141357421875
198 B1FADEF4-2284-4D74-B306-1ADB41409035 2016-06-26T03:00:36+00:00 
[
    "Public"
]
 
[]
 jpeg 63ecdd738ea57a07688300501485b22be6b193e852f6af7404295da8e5a6bcee 2091348 37.784641666666666 -122.43603666666667 0 0 0 0 0 0 0 0 San Francisco CA United States B1FADEF4-2284-4D74-B306-1ADB41409035 0.1707763671875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018243789672851562 0.017547607421875 0.005535125732421875 0.009999999776482582 -0.0880126953125 -0.044586181640625 0.0906982421875 0.01262664794921875 -0.021453857421875 -0.017578125 -0.0570068359375 -0.0455322265625 0.2359619140625 0.08258056640625 0.00566864013671875 -0.00803375244140625 0.0125274658203125 0.043701171875 0.041717529296875 -0.0128173828125 0.256103515625 0.0222320556640625
405 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 2016-06-26T03:00:34+00:00 
[
    "Public"
]
 
[]
 jpeg c9364c1faae70f2d66c2e6511d612a75cf53d3a5c06da311206ac8eff3b7eab9 2104203 37.784595 -122.43608833333333 0 0 0 0 0 0 0 0 San Francisco CA United States 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 0.2841796875 0.6 0.0 0.8099236641335124 0.10000000149011612 -0.0007791519165039062 0.06878662109375 0.06231689453125 0.009999999776482582 -0.0009765625 -0.0229339599609375 0.310302734375 0.0006265640258789062 -0.0035114288330078125 -0.03521728515625 0.0626220703125 0.063232421875 0.06292724609375 0.09722900390625 0.0171356201171875 -0.000911712646484375 0.00595855712890625 0.0089874267578125 -8.58306884765625e-05 0.01532745361328125 -0.065185546875 0.000820159912109375
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
346 9B076964-9931-4790-AE2D-A06011B97CE7 2016-04-09T20:12:10+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 jpeg a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e 2665460 37.78550333333333 -122.43043666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 9B076964-9931-4790-AE2D-A06011B97CE7 0.434326171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014209747314453125 0.0190582275390625 0.0013408660888671875 0.009999999776482582 0.150634765625 -0.06256103515625 0.31884765625 0.0022869110107421875 -0.01666259765625 -0.009002685546875 -0.1044921875 -0.00030517578125 0.0293121337890625 -0.04010009765625 0.001861572265625 -0.00848388671875 0.0009546279907226562 0.10015869140625 0.10113525390625 -0.07080078125 0.4228515625 0.02374267578125
240 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 2016-04-09T20:12:10+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 jpeg 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 2689457 37.78550333333333 -122.43043666666667 0 0 0 0 0 1 0 0 San Francisco CA United States 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 0.486572265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004314422607421875 -0.00701141357421875 0.002452850341796875 0.009999999776482582 -0.121826171875 -0.1026611328125 0.11175537109375 0.005619049072265625 -0.0521240234375 -0.133544921875 -0.4990234375 -0.270263671875 0.165283203125 -0.1573486328125 -0.0026302337646484375 -0.0262451171875 0.0035381317138671875 0.00557708740234375 -0.07470703125 -0.5068359375 -0.1641845703125 -0.1171875
288 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 2016-04-09T20:10:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 3046776 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375
261 93C7D5C0-E78B-47A0-8953-9A143D65597D 2016-04-09T20:10:28+00:00 
[
    "Public"
]
 
[]
 jpeg 7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419 3094751 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 93C7D5C0-E78B-47A0-8953-9A143D65597D 0.50537109375 0.5 0.0 0.038931297721298594 0.7079561948776245 -0.0005235671997070312 0.051239013671875 0.0180511474609375 0.009999999776482582 0.4306640625 -0.02447509765625 0.27685546875 0.0020503997802734375 -0.006587982177734375 -0.0058441162109375 0.11236572265625 0.08697509765625 0.10577392578125 0.07672119140625 0.022308349609375 0.0009765625 0.008575439453125 0.021575927734375 0.00565338134765625 0.06109619140625 0.185546875 0.0660400390625
134 CF759040-2FAD-4203-8C0F-88DF33C894BC 2016-03-21T00:20:29+00:00 
[
    "Public"
]
 
[]
 jpeg 3cb22fc3dc3413773a9a2d5a54948c5ffaafd400b09b6c327ff29360ad0d498d 2336745 37.80468333333334 -122.47161166666666 0 0 0 0 0 0 0 0 San Francisco CA United States CF759040-2FAD-4203-8C0F-88DF33C894BC 0.1688232421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0005173683166503906 0.01345062255859375 0.004024505615234375 0.009999999776482582 0.29541015625 -0.0188751220703125 0.46044921875 0.0005035400390625 -0.01450347900390625 -0.011962890625 0.0089111328125 -0.0125732421875 0.1661376953125 -0.0172119140625 0.00833892822265625 -0.0139617919921875 0.004924774169921875 0.02288818359375 0.00434112548828125 0.0689697265625 0.395751953125 -0.023162841796875
224 C9AA2D9B-2CC7-43FC-8315-7CB184C5D490 2016-01-07T23:36:26+00:00 
[
    "Public"
]
 
[]
 png 704ab23c6ea7d143d50fedc5e435a3e1cf4abb201630ad0229dad24be817565a 1733341     0 0 1 0 0 0 0 0       C9AA2D9B-2CC7-43FC-8315-7CB184C5D490 0.80517578125 0.25 0.0 0.024447264562126335 0.10000000149011612 -0.003376007080078125 0.003421783447265625 0.005405426025390625 0.009999999776482582 -0.30078125 -0.0489501953125 -0.009033203125 0.049407958984375 -0.06396484375 -0.038909912109375 -0.2022705078125 -0.251953125 0.29833984375 0.027587890625 0.00077056884765625 -0.0265045166015625 0.02056884765625 0.015716552734375 -0.01141357421875 -0.1124267578125 0.10162353515625 0.0004425048828125

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