public

Custom SQL query returning 8 rows (hide)

select 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 from photos_with_apple_metadata where "ZINTERACTIONSCORE" = :p0 and "place_city" = :p1 limit 101

Query parameters

This data as json, CSV

rowid	uuid	date	albums	persons	ext	sha256	size	latitude	longitude	place_city	place_state_province	place_country	ZUUID	ZOVERALLAESTHETICSCORE	ZCURATIONSCORE	ZHIGHLIGHTVISIBILITYSCORE	ZBEHAVIORALSCORE	ZFAILURESCORE	ZHARMONIOUSCOLORSCORE	ZIMMERSIVENESSSCORE	ZINTERACTIONSCORE	ZINTERESTINGSUBJECTSCORE	ZINTRUSIVEOBJECTPRESENCESCORE	ZLIVELYCOLORSCORE	ZLOWLIGHT	ZNOISESCORE	ZPLEASANTCAMERATILTSCORE	ZPLEASANTCOMPOSITIONSCORE	ZPLEASANTLIGHTINGSCORE	ZPLEASANTPATTERNSCORE	ZPLEASANTPERSPECTIVESCORE	ZPLEASANTPOSTPROCESSINGSCORE	ZPLEASANTREFLECTIONSSCORE	ZPLEASANTSYMMETRYSCORE	ZSHARPLYFOCUSEDSUBJECTSCORE	ZTASTEFULLYBLURREDSCORE	ZWELLCHOSENSUBJECTSCORE	ZWELLFRAMEDSUBJECTSCORE	ZWELLTIMEDSHOTSCORE
141	ADE9C25D-18D3-42C0-8BE9-CE2A30781B43	2018-02-20T23:28:04+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	4343b8b78aceac81aafddb11d751033ab74b55a41ed0b075e238d272fcfd100c	1495974	37.74249666666667	-122.44919666666667	San Francisco	CA	United States	ADE9C25D-18D3-42C0-8BE9-CE2A30781B43	0.49755859375	0.5	0.038931297721298594	0.5044282078742981	-0.0012111663818359375	0.1588134765625	0.03533935546875	0.019999999552965164	0.2685546875	-0.026702880859375	0.157470703125	0.02484130859375	-0.007755279541015625	-0.00732421875	0.225341796875	0.22412109375	0.04132080078125	0.22412109375	0.09417724609375	0.01018524169921875	0.006511688232421875	0.0301055908203125	0.01500701904296875	0.05633544921875	0.040435791015625	0.058685302734375
37	A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC	2018-02-20T23:05:22+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	1410392329d163954b764fbf466079c543add302f7fccd5eb9158c132ca093d4	1570524	37.742808333333336	-122.449255	San Francisco	CA	United States	A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC	0.34521484375	0.5	0.038931297721298594	0.10000000149011612	-0.0012254714965820312	0.0301361083984375	0.00919342041015625	0.019999999552965164	0.2430419921875	-0.0616455078125	-0.0184326171875	0.0119171142578125	-0.0135345458984375	-0.0247650146484375	0.134033203125	-0.022705078125	0.02532958984375	0.2529296875	0.0094757080078125	0.00237274169921875	0.0082855224609375	0.0211181640625	-0.0068359375	0.052947998046875	0.224609375	0.245361328125
350	A92AF32A-7C12-48CC-B1C3-5C83D05B76AA	2017-11-05T23:06:58+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	a981be272530aba690ff4d6e292c3dbfeb1fee4c9fcca39346043012cf486e49	3639642	37.76914166666667	-122.46450833333333	San Francisco	CA	United States	A92AF32A-7C12-48CC-B1C3-5C83D05B76AA	0.4189453125	0.5	0.038931297721298594	0.10000000149011612	-0.0011157989501953125	0.06903076171875	0.00734710693359375	0.019999999552965164	-0.3623046875	-0.03521728515625	0.1944580078125	0.0282135009765625	-0.01137542724609375	-0.0245361328125	-0.04638671875	0.085205078125	0.2430419921875	0.192626953125	0.03240966796875	-0.01221466064453125	0.01450347900390625	0.060516357421875	0.03424072265625	0.024658203125	0.1572265625	0.00374603271484375
132	F142B8D1-24B8-4108-AFB7-0C454C72E625	2017-11-05T23:06:49+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	3c189d4ca97d42b444c05d69f5f798f0ecb1c4066123d5f75d1d0d60e332a475	4231615	37.76921166666666	-122.46446166666666	San Francisco	CA	United States	F142B8D1-24B8-4108-AFB7-0C454C72E625	0.468017578125	0.6	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
420	60198E20-708E-4125-B793-4466A87B2DDA	2017-06-16T00:56:17+00:00	[ "Stolen monasteries", "Public" ]	[]	jpeg	d553261ef8ec0fc2d81eb04e584491dfcba6d4d58b8455cc741c362ec21eea22	5956608	37.76925	-122.46415	San Francisco	CA	United States	60198E20-708E-4125-B793-4466A87B2DDA	0.392578125	0.5	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
438	57650917-1883-4D73-AD2B-B45C6A661534	2017-03-31T00:53:31+00:00	[ "Stolen monasteries", "Public" ]	[]	jpeg	ddea960de035d2fc5726dd94a94692f90f7dc60c7e28e19b45fcc765e2d0813c	4243346	37.769146666666664	-122.46449166666666	San Francisco	CA	United States	57650917-1883-4D73-AD2B-B45C6A661534	0.3447265625	0.5	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	San Francisco	CA	United States	D3CF77DA-B6DD-47F1-A69C-3E01122F133E	0.497314453125	0.6	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
288	57EAA6E6-990D-45CF-842D-E0DD2CE521A3	2016-04-09T20:10:29+00:00	[ "Public" ]	[]	jpeg	8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001	3046776	37.78546166666667	-122.43050333333333	San Francisco	CA	United States	57EAA6E6-990D-45CF-842D-E0DD2CE521A3	0.41064453125	0.5	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