photos_on_a_map (view)

5 rows where "date" is on date 2018-04-22 and longitude = "-122.344155"

descending

date	latitude	longitude	sha256	ext	popup
2018-04-22T00:28:56+00:00	37.57899666666667	-122.344155	2505fedb3a6c4adda57f5fafeeb29bbbe3447a7da7bf09c014addd6f79ba756e	heic	{ "title": "Taken on 2018-04-22T00:28:56+00:00", "image": "https://photos.simonwillison.net/i/2505fedb3a6c4adda57f5fafeeb29bbbe3447a7da7bf09c014addd6f79ba756e.heic?w=400", "link": "https://photos.simonwillison.net/i/2505fedb3a6c4adda57f5fafeeb29bbbe3447a7da7bf09c014addd6f79ba756e.heic?w=1200" }
2018-04-22T00:19:14+00:00	37.57926666666667	-122.344155	246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410	heic	{ "title": "Taken on 2018-04-22T00:19:14+00:00", "image": "https://photos.simonwillison.net/i/246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410.heic?w=400", "link": "https://photos.simonwillison.net/i/246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410.heic?w=1200" }
2018-04-22T00:09:15+00:00	37.57917	-122.344155	c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb	heic	{ "title": "Taken on 2018-04-22T00:09:15+00:00", "image": "https://photos.simonwillison.net/i/c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb.heic?w=400", "link": "https://photos.simonwillison.net/i/c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb.heic?w=1200" }
2018-04-22T00:09:10+00:00	37.579005	-122.344155	a1c2d7f8756e2101b0239087ebb5d55c79665b49f2e5800fd492e41afa56e8ba	heic	{ "title": "Taken on 2018-04-22T00:09:10+00:00", "image": "https://photos.simonwillison.net/i/a1c2d7f8756e2101b0239087ebb5d55c79665b49f2e5800fd492e41afa56e8ba.heic?w=400", "link": "https://photos.simonwillison.net/i/a1c2d7f8756e2101b0239087ebb5d55c79665b49f2e5800fd492e41afa56e8ba.heic?w=1200" }
2018-04-22T00:04:35+00:00	37.57924666666667	-122.344155	8d672867493a2635c0ce87db82e6bb9558101a21240edf4046975c067f2c7ccf	heic	{ "title": "Taken on 2018-04-22T00:04:35+00:00", "image": "https://photos.simonwillison.net/i/8d672867493a2635c0ce87db82e6bb9558101a21240edf4046975c067f2c7ccf.heic?w=400", "link": "https://photos.simonwillison.net/i/8d672867493a2635c0ce87db82e6bb9558101a21240edf4046975c067f2c7ccf.heic?w=1200" }

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIEW photos_on_a_map AS select
      date,
      latitude,
      longitude,
      apple_photos.sha256,
      uploads.ext,
      json_object(
        'title',
        'Taken on ' || date,
        'image',
        'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=400',
        'link',
        'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=1200'
      ) as popup
    from
      apple_photos
      join uploads on apple_photos.sha256 = uploads.sha256
    where
      latitude is not null
    order by
      date desc;