photos_with_apple_metadata (view)

251 rows where favorite = 0

✎ View and edit SQL

This data as json, CSV (advanced)

hdr ✖

  • 0 249
  • 1 2

favorite ✖

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
132 F142B8D1-24B8-4108-AFB7-0C454C72E625 2017-11-05T23:06:49+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 3c189d4ca97d42b444c05d69f5f798f0ecb1c4066123d5f75d1d0d60e332a475 4231615 37.76921166666666 -122.46446166666666 0 0 0 0 0 0 0 0 San Francisco CA United States F142B8D1-24B8-4108-AFB7-0C454C72E625 0.468017578125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.0019121170043945312 0.0162353515625 0.0016231536865234375 0.019999999552965164 -0.1405029296875 -0.0204925537109375 0.308349609375 0.0012693405151367188 -0.0310821533203125 -0.024505615234375 0.00177001953125 -0.03289794921875 0.05572509765625 -0.046142578125 0.0059814453125 -0.0129547119140625 0.0024623870849609375 0.11993408203125 0.04132080078125 0.31396484375 0.54833984375 -0.00934600830078125
218 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 2017-11-05T23:05:51+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 6cd24772dbd1f463325dba1e5ab734ceb559741953324b590eb89d3497cda1f4 2789234 37.768953333333336 -122.464425 0 0 0 0 0 0 0 0 San Francisco CA United States 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 0.373779296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011920928955078125 0.0150299072265625 0.0024242401123046875 0.009999999776482582 0.0262451171875 -0.05340576171875 0.35107421875 0.0018529891967773438 -0.01525115966796875 -0.019927978515625 -0.121337890625 -0.013916015625 0.078369140625 -0.033782958984375 -0.0024566650390625 -0.01345062255859375 0.0018177032470703125 0.0472412109375 0.041656494140625 -0.119140625 0.26513671875 -0.02508544921875
38 1EAE7EE2-CBE6-491B-A8EF-337859628659 2017-11-05T23:05:44+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 1423536b7567da6562cd1e842bd93be31d8ebe84d797afe4a81644bac2a2c9e3 2979362 37.768975 -122.46446166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 1EAE7EE2-CBE6-491B-A8EF-337859628659 0.347900390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028896331787109375 0.01885986328125 0.004116058349609375 0.03999999910593033 0.1094970703125 -0.053192138671875 0.1767578125 0.00254058837890625 -0.019561767578125 -0.03076171875 -0.08697509765625 -0.03570556640625 0.029815673828125 0.0164794921875 0.00586700439453125 -0.00499725341796875 0.001926422119140625 0.037261962890625 -0.0113525390625 0.08465576171875 0.339599609375 0.105224609375
121 76336F73-88DA-4E89-8E57-4A38FEA2986B 2017-10-27T20:53:21+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 39fd5df732f4fb55c94fc2d90bbe3abcf8e5a748d6b5800817d063c4f1a5e0c5 1735752 37.80936166666667 -122.42176166666667 0 0 0 0 0 0 0 0 San Francisco CA United States 76336F73-88DA-4E89-8E57-4A38FEA2986B 0.413818359375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007381439208984375 0.0229949951171875 0.0022258758544921875 0.009999999776482582 -0.254638671875 -0.0230255126953125 0.07403564453125 0.00905609130859375 -0.01450347900390625 0.0073089599609375 0.19091796875 0.10369873046875 0.03436279296875 0.240478515625 0.0076141357421875 -0.003936767578125 0.0083160400390625 0.33203125 0.13232421875 0.221435546875 0.76416015625 0.01605224609375
181 3E20BE4D-619A-42EC-9CAA-6F67508892E4 2017-10-27T20:41:30+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 5a3a4b0ffc8de931dd6dd0c977df4b444421a404c820c795346c8faffc984ffa 1744396 37.809145 -122.42119666666666 0 0 0 0 0 0 0 0 San Francisco CA United States 3E20BE4D-619A-42EC-9CAA-6F67508892E4 0.49169921875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0024929046630859375 -0.006275177001953125 0.003692626953125 0.009999999776482582 -0.309814453125 -0.0948486328125 0.2303466796875 0.0018968582153320312 -0.022247314453125 -0.13623046875 -0.5966796875 -0.132568359375 0.188232421875 -0.1619873046875 -0.0025348663330078125 -0.020538330078125 0.0019044876098632812 0.004505157470703125 -0.01824951171875 -0.40283203125 -0.51416015625 -0.1053466796875
396 AC4419FA-ED22-473F-8FB0-15B647BB2FBD 2017-10-27T20:35:55+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic c5e23798acf2cbff48fd65696d94e1326f128cf3e60230b7023fece6bebafa87 1777363 37.81 -122.422325 0 0 0 0 0 0 0 0 San Francisco CA United States AC4419FA-ED22-473F-8FB0-15B647BB2FBD 0.4951171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.01016998291015625 -0.0117034912109375 0.004364013671875 0.009999999776482582 -0.28955078125 -0.061431884765625 0.0799560546875 0.017181396484375 -0.1041259765625 -0.07489013671875 -0.485107421875 -0.324462890625 0.2017822265625 -0.0938720703125 -0.0036525726318359375 -0.0207061767578125 0.003063201904296875 0.00263214111328125 -0.061798095703125 -0.392822265625 -0.4423828125 -0.12066650390625
393 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 2017-10-27T20:27:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic c57c252d8bb404e1de2a5015c6ac7b6a99e131d72a9ce002dd65564b4f8b10fd 1638873 37.80999666666666 -122.42220333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 0.459228515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004791259765625 0.033355712890625 0.00323486328125 0.009999999776482582 -0.90087890625 -0.0262603759765625 0.24462890625 0.01953125 -0.0194549560546875 -0.021209716796875 -0.134521484375 -0.09967041015625 0.0704345703125 0.013671875 -0.0697021484375 -0.011474609375 0.003040313720703125 0.038330078125 0.0077056884765625 0.04486083984375 0.0809326171875 -0.00347137451171875
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
62 ADE494D7-0048-491A-B410-D04C5C58B0DD 2017-07-23T22:20:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1cfb72be21bffca1c026c49845045769dc2791f7844d85d14e74257325d83b23 1988831 37.84245 -122.27783333333333 0 0 0 0 0 0 0 0 Oakland CA United States ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
470 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 2017-07-23T22:13:38+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 jpeg edcd504a5dc67013013c8de46adbc2f586d9d56e572d634d594390fd81b20a95 2233683 37.84250333333333 -122.27778666666667 0 0 0 0 0 0 0 0 Oakland CA United States 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 0.405517578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0017681121826171875 -0.00296783447265625 0.0022258758544921875 0.009999999776482582 -0.478271484375 -0.06671142578125 0.252685546875 0.0009074211120605469 -0.0202178955078125 -0.118896484375 -0.44580078125 -0.0966796875 0.0823974609375 -0.167724609375 -0.0023097991943359375 -0.034423828125 0.0016355514526367188 0.01061248779296875 -0.007694244384765625 -0.294677734375 -0.1962890625 -0.0555419921875
303 97F0AC20-F45C-40F3-BA5F-66210B77A487 2017-07-23T22:11:35+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 91cd63d05fe337816cae4ca57e9882ccdc5d6f8b921236e703a55e50f116d08d 2629022 37.8424 -122.27777166666667 0 0 0 0 0 0 0 0 Oakland CA United States 97F0AC20-F45C-40F3-BA5F-66210B77A487 0.297119140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0029354095458984375 0.0163421630859375 0.007232666015625 0.009999999776482582 -0.96923828125 -0.013427734375 0.134765625 0.0004189014434814453 -0.00426483154296875 -0.003582000732421875 0.0882568359375 0.003173828125 0.0131683349609375 0.037261962890625 -0.044189453125 -0.003276824951171875 0.0025806427001953125 0.063720703125 0.0175018310546875 0.2188720703125 0.2841796875 0.0013952255249023438
56 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 2017-07-23T22:07:25+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1b68d008a6d555d3a21f96a9ea31e9c1c6513395b93d3349061a5cc8825080b1 2341575 37.842288333333336 -122.27801333333333 0 0 0 0 0 0 0 0 Oakland CA United States 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 0.35009765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00399017333984375 0.00577545166015625 0.004100799560546875 0.009999999776482582 -0.92431640625 -0.02276611328125 0.242431640625 0.0013723373413085938 -0.0115509033203125 -0.0203857421875 -0.1290283203125 -0.090576171875 0.090087890625 -0.0042724609375 -0.0312347412109375 -0.01210784912109375 0.0033893585205078125 0.022796630859375 -0.008026123046875 0.05572509765625 0.0567626953125 -0.005092620849609375
188 F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 2017-06-16T01:28:19+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5dd80ab326459d68c5d9acc8f7094aa4761b9f98ff7f774a3c8b1c25cbf49f83 4286630 37.772616666666664 -122.45991333333333 0 0 0 0 0 0 0 0 San Francisco CA United States F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 0.453857421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0008759498596191406 0.00547027587890625 0.004665374755859375 0.009999999776482582 0.0380859375 -0.0469970703125 0.416259765625 0.0010776519775390625 -0.01242828369140625 -0.03662109375 -0.201904296875 -0.02239990234375 0.16748046875 -0.04937744140625 -0.00043487548828125 -0.0169219970703125 0.0029354095458984375 0.0142822265625 0.00278472900390625 -0.38525390625 -0.0262451171875 -0.069580078125
420 60198E20-708E-4125-B793-4466A87B2DDA 2017-06-16T00:56:17+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg d553261ef8ec0fc2d81eb04e584491dfcba6d4d58b8455cc741c362ec21eea22 5956608 37.76925 -122.46415 0 0 0 0 0 0 0 0 San Francisco CA United States 60198E20-708E-4125-B793-4466A87B2DDA 0.392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00307464599609375 0.0094757080078125 0.001220703125 0.019999999552965164 0.1380615234375 -0.056854248046875 0.2802734375 0.00313568115234375 -0.04559326171875 -0.04010009765625 -0.107666015625 -0.0838623046875 0.048492431640625 -0.160400390625 0.00628662109375 -0.0150909423828125 0.0010166168212890625 0.060760498046875 0.06494140625 -0.0399169921875 0.345947265625 -0.05755615234375
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
278 F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 2017-06-16T00:54:59+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg 85c32ecbb8b5b4e75514799212c4bdd8c51469269e931a1fb6aa53f87dc92676 4565297 37.76912 -122.46459166666666 0 0 0 0 0 0 0 0 San Francisco CA United States F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 0.361572265625 0.5 0.0 0.038931297721298594 0.10087591409683228 -0.0004372596740722656 0.1085205078125 0.00908660888671875 0.009999999776482582 -0.0367431640625 -0.020172119140625 0.271484375 0.01512908935546875 -0.008544921875 0.01593017578125 0.140869140625 0.227294921875 0.212890625 0.343505859375 0.08966064453125 -0.0034332275390625 0.0169830322265625 0.10992431640625 0.03192138671875 0.1953125 0.363037109375 0.009735107421875
105 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 2017-06-16T00:54:53+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg 318022d1b2b2e9804d550276366c3b8ad3a61fe5efaf79af0c59d0ae647ff195 5269532 37.76909666666667 -122.46451666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 0.431396484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0034961700439453125 -0.001842498779296875 0.0022335052490234375 0.009999999776482582 -0.29736328125 -0.0699462890625 -0.09381103515625 0.055206298828125 -0.091064453125 -0.052276611328125 -0.311767578125 -0.4609375 0.08251953125 -0.017852783203125 -0.001033782958984375 -0.0304718017578125 0.01137542724609375 0.01238250732421875 -0.03204345703125 -0.20263671875 0.256103515625 -0.00457763671875
155 CECB8318-5241-46BB-AABF-8CF8A3B72890 2017-03-31T00:53:35+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg 4b6d5de8dc4967be44dc73b9c1e8a47dc0b247c0d08b0020ab69947f1441aada 4589169 37.76917 -122.46453 0 0 0 0 0 0 0 0 San Francisco CA United States CECB8318-5241-46BB-AABF-8CF8A3B72890 0.50390625 0.6 0.0 0.8099236641335124 0.10000000149011612 -0.0006070137023925781 0.0191497802734375 0.0021572113037109375 0.009999999776482582 -0.14599609375 -0.0272216796875 0.1993408203125 0.0025119781494140625 -0.01560211181640625 0.00469970703125 0.0372314453125 0.05133056640625 0.06842041015625 0.1199951171875 0.005828857421875 -0.007843017578125 0.0053863525390625 0.1773681640625 0.05712890625 0.1580810546875 0.6240234375 0.0072479248046875
438 57650917-1883-4D73-AD2B-B45C6A661534 2017-03-31T00:53:31+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg ddea960de035d2fc5726dd94a94692f90f7dc60c7e28e19b45fcc765e2d0813c 4243346 37.769146666666664 -122.46449166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 57650917-1883-4D73-AD2B-B45C6A661534 0.3447265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0022525787353515625 0.00321197509765625 0.004627227783203125 0.019999999552965164 -0.00634765625 -0.1229248046875 0.0634765625 0.00844573974609375 -0.0203704833984375 -0.053375244140625 -0.448974609375 -0.152587890625 0.0966796875 -0.019805908203125 -0.00054168701171875 -0.01448822021484375 0.00441741943359375 0.0119171142578125 -0.027587890625 -0.298583984375 -0.009033203125 0.0059814453125
492 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 2017-03-31T00:48:54+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg fe7c5489ffa8c070183fe2c559c00b6d5880a6b9a9c53f807962166ec96c4375 4984812 37.7692 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States D3CF77DA-B6DD-47F1-A69C-3E01122F133E 0.497314453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.002002716064453125 0.0117950439453125 0.002010345458984375 0.019999999552965164 -0.28369140625 -0.018341064453125 0.296630859375 0.002132415771484375 -0.038604736328125 -0.031494140625 -0.022735595703125 -0.041351318359375 0.188232421875 -0.038330078125 0.0035552978515625 -0.016143798828125 0.00455474853515625 0.07452392578125 0.034332275390625 0.2244873046875 0.4072265625 -0.01230621337890625
394 1657E7D6-94E7-4344-BCFE-1F924546CE11 2017-03-31T00:48:44+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg c5b53e0765f828354402aad8d9de6be1c70b4c78cc0db97d30f31697b01fb591 4595669 37.76913 -122.46448666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 1657E7D6-94E7-4344-BCFE-1F924546CE11 0.482421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0031108856201171875 0.0105438232421875 0.00511932373046875 0.009999999776482582 -0.958984375 -0.02056884765625 0.1424560546875 0.00046372413635253906 -0.00482940673828125 -0.00754547119140625 -0.01824951171875 -0.0391845703125 0.020599365234375 0.026031494140625 -0.02587890625 -0.005725860595703125 0.0027370452880859375 0.04779052734375 0.0046844482421875 0.154541015625 0.262451171875 -0.0001735687255859375
191 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 2016-11-05T21:21:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5f9968989d0aad8a9dd9c6aabd5e495444a44a8714a1fa3296a96132b67de178 2555246 37.82716333333333 -122.52745833333333 0 0 0 0 0 0 0 0 Sausalito CA United States 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 0.50244140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.005535125732421875 0.004665374755859375 0.019999999552965164 -0.384033203125 -0.036773681640625 0.181396484375 0.0038852691650390625 -0.02947998046875 -0.0823974609375 -0.1904296875 -0.1136474609375 0.1702880859375 -0.056884765625 0.001659393310546875 -0.056396484375 0.006587982177734375 0.01467132568359375 -0.00415802001953125 -0.0748291015625 0.009765625 -0.01593017578125
432 69C46054-1D8F-4FD6-ABC7-2369C79921F4 2016-11-05T20:55:46+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 jpeg d966b699790953594f2be6cc03c5e5b3d478ebf27122037a7dc022db7642411e 2299000 37.828136666666666 -122.52736666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 69C46054-1D8F-4FD6-ABC7-2369C79921F4 0.4814453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0009508132934570312 0.047760009765625 0.05499267578125 0.009999999776482582 -0.06640625 -0.043701171875 0.10211181640625 0.0026111602783203125 -0.004505157470703125 -0.045806884765625 0.0196533203125 0.0323486328125 0.05194091796875 0.1417236328125 0.0133056640625 0.00213623046875 0.00971221923828125 0.00661468505859375 -0.0017147064208984375 -0.00029754638671875 -0.0811767578125 0.0098724365234375
302 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 2016-11-05T20:55:42+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 90f7eaebeafeb0eeb14cdc064d541761d82d969c173687df7d0bd3551f1ae240 2520930 37.827938333333336 -122.52742 0 0 0 0 0 0 0 0 Sausalito CA United States 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 0.31591796875 0.5 0.0 0.038931297721298594 0.503017008304596 -0.001956939697265625 0.0648193359375 0.0282745361328125 0.009999999776482582 0.2083740234375 -0.04913330078125 -0.018768310546875 0.05291748046875 -0.01306915283203125 -0.023773193359375 0.1820068359375 0.0557861328125 0.120849609375 0.4013671875 0.07073974609375 0.00934600830078125 0.0231475830078125 0.0257568359375 0.020965576171875 0.044036865234375 0.0660400390625 0.041961669921875
206 07509762-A841-4CEB-AA42-B65439E9C3DD 2016-11-05T20:50:06+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 679f1f8f0d139dba297bf0d5ecadcaed7259d6c812e6a825e2d3999cc301d5b3 3572478 37.82793 -122.52746666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 07509762-A841-4CEB-AA42-B65439E9C3DD 0.6259765625 0.5 0.0 0.8053737856049574 0.10000000149011612 -0.0006985664367675781 0.037078857421875 0.00669097900390625 0.009999999776482582 0.080078125 -0.0257110595703125 0.2083740234375 0.0021152496337890625 -0.009674072265625 -0.003387451171875 0.104736328125 0.0789794921875 0.060516357421875 0.1619873046875 0.01324462890625 -0.003513336181640625 0.0063629150390625 0.08209228515625 0.025970458984375 0.15087890625 0.417236328125 0.03619384765625
255 EECDD2BE-E93F-4830-8435-68681476E833 2016-11-05T20:47:12+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 7c8518ac608ee1cec1d652018536ba1e77fd2434536d5016ef825e0990b80bb6 1551766 37.82842 -122.527275 0 0 0 0 0 1 0 0 Sausalito CA United States EECDD2BE-E93F-4830-8435-68681476E833 0.432861328125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020198822021484375 0.009552001953125 0.00595855712890625 0.009999999776482582 -0.31591796875 -0.06304931640625 0.0941162109375 0.01016998291015625 -0.0251312255859375 -0.0953369140625 -0.33154296875 -0.14111328125 0.1279296875 -0.02105712890625 0.0037994384765625 -0.0222930908203125 0.00626373291015625 0.01073455810546875 -0.00830078125 -0.09222412109375 -0.0933837890625 -0.0088958740234375
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
304 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 2016-04-19T22:25:45+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 923523f764375c334e0a6e2337ae2d97d43f5d4a351c27e71aa5b531b56c6719 2419091 37.863213333333334 -122.49489666666666 0 0 0 0 0 0 0 0 Sausalito CA United States 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 0.317626953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020751953125 -0.004993438720703125 0.0036792755126953125 0.009999999776482582 -0.30029296875 -0.0723876953125 0.1903076171875 0.002811431884765625 -0.021209716796875 -0.0906982421875 -0.456787109375 -0.178466796875 0.153076171875 -0.08172607421875 -0.0020656585693359375 -0.053619384765625 0.004100799560546875 0.005161285400390625 -0.0158538818359375 -0.394287109375 -0.25048828125 -0.05572509765625
101 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 2016-04-19T22:25:25+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 303e5a7d0a3d1c3f5d5429bafb9ff301b9b5b333714db85a6b4fcd750600a7da 2650748 37.863236666666666 -122.49486666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 0.328369140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0005011558532714844 0.004261016845703125 0.002452850341796875 0.009999999776482582 0.1724853515625 -0.08978271484375 0.260986328125 0.0016813278198242188 -0.0083160400390625 -0.033538818359375 -0.302734375 -0.04412841796875 0.09844970703125 -0.038177490234375 6.4849853515625e-05 -0.026275634765625 0.003551483154296875 0.0202484130859375 0.0052032470703125 -0.46142578125 0.1236572265625 -0.02587890625
412 A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 2016-04-19T22:24:58+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg d0645484f8416d699b4c9bb4a33ce66030db5ce8dbaf7a6145e16cbec845369c 2369867 37.863236666666666 -122.49486666666667 0 0 0 0 0 0 0 0 Sausalito CA United States A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 0.31884765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0002613067626953125 0.040557861328125 0.02203369140625 0.009999999776482582 -0.0977783203125 -0.038238525390625 0.161865234375 0.0029582977294921875 -0.0029354095458984375 -0.005157470703125 0.0755615234375 0.1986083984375 0.126708984375 0.1787109375 0.0121917724609375 -0.003826141357421875 0.021697998046875 0.042083740234375 0.00931549072265625 -0.01641845703125 0.2021484375 0.012298583984375
144 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 2016-04-19T22:24:47+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 44458ddd988ba5866c6a1e5db026a57add085c80d64a6f0f52fffacd816e52ad 2181535 37.86320833333333 -122.49472 0 0 0 0 0 0 0 0 Sausalito CA United States D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 0.35009765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.033966064453125 0.005153656005859375 0.006824493408203125 0.009999999776482582 -0.6083984375 -0.09271240234375 -0.2470703125 0.2117919921875 -0.1104736328125 -0.038299560546875 -0.44970703125 -0.623046875 0.0164642333984375 0.0101318359375 0.0024871826171875 -0.005985260009765625 0.0029582977294921875 0.004398345947265625 -0.1490478515625 -0.0050201416015625 -0.127197265625 0.0197906494140625
395 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 2016-04-19T22:24:36+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg c5da768a066d3ed8487b4cf7520c8960f46510357e13edb68729cd3b0565fcbb 2044936 37.863186666666664 -122.49463666666666 0 0 0 0 0 0 0 0 Sausalito CA United States 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 0.331298828125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0018033981323242188 0.00077056884765625 0.0028667449951171875 0.009999999776482582 -0.32421875 -0.03790283203125 0.44921875 0.0005192756652832031 -0.016845703125 -0.1064453125 -0.2491455078125 -0.05010986328125 0.149169921875 -0.19384765625 0.000110626220703125 -0.04498291015625 0.0019044876098632812 0.0162811279296875 0.00072479248046875 -0.204833984375 -0.1358642578125 -0.047576904296875
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
264 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 2016-01-13T20:43:53+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 7fa46682650e464a6bd09bee294607900c198152b680393dc4f3f5666c0db695 2302070 37.78062833333333 -122.41036166666666 0 0 0 0 0 0 0 0 San Francisco CA United States B3EDB403-A948-4ABA-BFE4-2C504A636F7A 0.365478515625 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0060272216796875 0.0101470947265625 0.0297088623046875 0.009999999776482582 -0.211669921875 -0.046722412109375 -0.1920166015625 0.11181640625 -0.053192138671875 -0.039581298828125 -0.1484375 -0.43408203125 0.22802734375 0.0792236328125 0.00518035888671875 -0.0051727294921875 0.043853759765625 0.004085540771484375 -0.05242919921875 -0.0291748046875 -0.06365966796875 0.00762176513671875
211 E4D43462-07AB-4803-9DCB-02B8321D8D94 2016-01-13T20:30:46+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 692e3b73c2d9297f354c7b9827d05cd697fd4b83885747a869b2478ec44632c5 2259762 37.78168 -122.411025 0 0 0 0 0 0 0 0 San Francisco CA United States E4D43462-07AB-4803-9DCB-02B8321D8D94 0.22265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007615089416503906 0.0242156982421875 0.0022258758544921875 0.009999999776482582 -0.11474609375 -0.08343505859375 0.0714111328125 0.0144500732421875 -0.01009368896484375 -0.0028076171875 -0.100341796875 0.0386962890625 0.07476806640625 0.2037353515625 0.00543975830078125 -0.00792694091796875 0.008575439453125 0.1524658203125 0.10986328125 -0.04443359375 0.56005859375 0.039520263671875
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
219 3C683CF5-1644-412C-AA01-F6A2EAE58319 2015-10-05T15:01:36+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 6d2e02585f44104e7d40f2e1fc471bafe4fef77c91e130d09eb7fd2db8aba4b6 3487122 35.716544999999996 -83.50289333333333 0 0 0 0 0 0 0 0 Gatlinburg TN United States 3C683CF5-1644-412C-AA01-F6A2EAE58319 0.728515625 0.5 0.0 0.04353355223895939 0.10000000149011612 -0.00263214111328125 0.01399993896484375 0.001934051513671875 0.019999999552965164 0.07373046875 -0.137939453125 0.07965087890625 0.010406494140625 -0.01363372802734375 -0.016876220703125 -0.309814453125 -0.050537109375 0.0301513671875 0.03619384765625 0.0016632080078125 -0.00664520263671875 0.0018892288208007812 0.08282470703125 0.1552734375 -0.134521484375 0.359375 0.1292724609375
220 BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 2015-10-05T14:55:32+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 6f0558a227b6c1acc2259af4e4d3d6aac4ce7148cda96ad212c4a6fd45ef36a1 2840560     0 0 0 0 0 0 0 0       BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 0.3583984375 0.5 0.0 0.038931297721298594 0.5039172768592834 -0.0008168220520019531 0.03851318359375 0.001949310302734375 0.03999999910593033 0.2958984375 -0.03314208984375 0.058319091796875 0.0271759033203125 -0.007038116455078125 0.0072479248046875 0.328125 0.2447509765625 0.01450347900390625 0.1962890625 0.0167236328125 0.000606536865234375 0.006488800048828125 0.58203125 0.58935546875 0.2381591796875 0.88427734375 0.1051025390625
72 40AA745C-DB5B-47B8-A6A6-C8C941826009 2015-10-05T14:55:12+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 2071cfe9798e06cfa5873f217d3730d260f1c077dbcd7fec74a0cbe1fee26a99 2739005     0 0 0 0 0 0 0 0       40AA745C-DB5B-47B8-A6A6-C8C941826009 0.4677734375 0.5 0.0 0.03893487945995258 0.10000000149011612 -0.00128936767578125 0.0287322998046875 0.001926422119140625 0.11999999731779099 -0.044677734375 -0.042083740234375 0.066162109375 0.01337432861328125 -0.0041351318359375 0.005237579345703125 0.227294921875 0.2181396484375 0.0167236328125 0.15771484375 0.0079193115234375 -0.00101470947265625 0.00443267822265625 0.61474609375 0.80126953125 0.1617431640625 0.82421875 0.06573486328125
283 369683A6-C32A-4E2D-9492-25BD553B1B6E 2015-10-05T14:54:39+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 8761c02e415f940008d5feba68d55aad1706623d537a18f6cf51d59d7eee284f 3834055     0 0 0 0 0 0 0 0       369683A6-C32A-4E2D-9492-25BD553B1B6E 0.50244140625 0.5 0.0 0.038931297721298594 0.10065693408250809 -0.0005769729614257812 0.0262603759765625 0.0010280609130859375 0.009999999776482582 0.466064453125 -0.054107666015625 0.1572265625 0.00701141357421875 -0.00582122802734375 0.017608642578125 0.1396484375 0.184814453125 0.01473236083984375 0.09417724609375 0.016204833984375 -0.00644683837890625 0.0023975372314453125 0.59375 0.72412109375 0.156005859375 0.84423828125 0.058746337890625
86 B426930E-FED6-4916-BBB9-73934393B5C8 2015-10-05T14:48:06+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 2512ce4ad5e082d62744af9268e903dde304867ff95f8782c0da3925835ff1ac 3416230     0 0 0 0 0 0 0 0       B426930E-FED6-4916-BBB9-73934393B5C8 0.3740234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.0109710693359375 0.0017137527465820312 0.019999999552965164 0.400390625 -0.044525146484375 0.01666259765625 0.030792236328125 -0.0701904296875 -0.0020904541015625 0.03350830078125 -0.1026611328125 0.021820068359375 0.078369140625 0.003688812255859375 -0.0031890869140625 0.004024505615234375 0.08648681640625 0.02398681640625 0.042236328125 0.68115234375 0.265869140625
433 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 2008-10-12T11:08:24+00:00 
[
    "Museums",
    "Saved from Flickr",
    "Public"
]
 
[]
 jpeg d9f59c4c2c01c61648d6f674daf87ead919acf6c9590869ff095163f2458d70f 2842517     0 0 0 0 0 0 0 0       351DAFC9-ABE1-41B8-8613-E1A73CE951B0 0.47998046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00243377685546875 0.01280975341796875 0.010650634765625 0.009999999776482582 -0.415771484375 -0.11578369140625 -0.0576171875 0.022674560546875 -0.0143890380859375 -0.07208251953125 -0.44140625 -0.229736328125 0.0592041015625 0.10528564453125 0.0046234130859375 -0.0079498291015625 0.00800323486328125 0.006771087646484375 -0.0199127197265625 -0.0235748291015625 -0.1326904296875 0.02508544921875

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