photos_on_a_map (view)

4 rows where "date" is on date 2019-08-24

descending

date	latitude	longitude	sha256	ext	popup
2019-08-24T13:59:14+00:00	48.866238333333335	2.3550033333333333	cb68fc3efc0aea4f4b216de475ddeaacd084e89f4251821dda1021a96662e84e	heic	{ "title": "Taken on 2019-08-24T13:59:14+00:00", "image": "https://photos.simonwillison.net/i/cb68fc3efc0aea4f4b216de475ddeaacd084e89f4251821dda1021a96662e84e.heic?w=400", "link": "https://photos.simonwillison.net/i/cb68fc3efc0aea4f4b216de475ddeaacd084e89f4251821dda1021a96662e84e.heic?w=1200" }
2019-08-24T12:37:43+00:00	48.860908333333334	2.3425616666666667	1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a	heic	{ "title": "Taken on 2019-08-24T12:37:43+00:00", "image": "https://photos.simonwillison.net/i/1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a.heic?w=400", "link": "https://photos.simonwillison.net/i/1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a.heic?w=1200" }
2019-08-24T12:33:18+00:00	48.860925	2.342713333333333	3ef3e28be7d606d9972c1a4303285a75703ade48e48c138f3ca9936251811cab	heic	{ "title": "Taken on 2019-08-24T12:33:18+00:00", "image": "https://photos.simonwillison.net/i/3ef3e28be7d606d9972c1a4303285a75703ade48e48c138f3ca9936251811cab.heic?w=400", "link": "https://photos.simonwillison.net/i/3ef3e28be7d606d9972c1a4303285a75703ade48e48c138f3ca9936251811cab.heic?w=1200" }
2019-08-24T12:32:07+00:00	48.86095	2.342538333333333	7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458	heic	{ "title": "Taken on 2019-08-24T12:32:07+00:00", "image": "https://photos.simonwillison.net/i/7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458.heic?w=400", "link": "https://photos.simonwillison.net/i/7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458.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;