photos_on_a_map (view)

5 rows where "date" is on date 2017-12-16 and latitude = "51.5034" sorted by sha256

descending

date	latitude	longitude	sha256 ▼	ext	popup
2017-12-16T11:52:15+00:00	51.5034	-0.1320305	7579f41e5a983976df725e86a94b7261d7dd42ce20b6fd1e1ac24157a5f423a6	heic	{ "title": "Taken on 2017-12-16T11:52:15+00:00", "image": "https://photos.simonwillison.net/i/7579f41e5a983976df725e86a94b7261d7dd42ce20b6fd1e1ac24157a5f423a6.heic?w=400", "link": "https://photos.simonwillison.net/i/7579f41e5a983976df725e86a94b7261d7dd42ce20b6fd1e1ac24157a5f423a6.heic?w=1200" }
2017-12-16T11:52:19+00:00	51.5034	-0.132025	9ae44af9c6d663d44e03539a41fed0bb4679519f542ba99439f00a44a22d262c	heic	{ "title": "Taken on 2017-12-16T11:52:19+00:00", "image": "https://photos.simonwillison.net/i/9ae44af9c6d663d44e03539a41fed0bb4679519f542ba99439f00a44a22d262c.heic?w=400", "link": "https://photos.simonwillison.net/i/9ae44af9c6d663d44e03539a41fed0bb4679519f542ba99439f00a44a22d262c.heic?w=1200" }
2017-12-16T11:52:14+00:00	51.5034	-0.1320305	d84a166371c9d0f249aa25afbac69ba5cd310a5392fddf2c113736b53f0c6d5e	heic	{ "title": "Taken on 2017-12-16T11:52:14+00:00", "image": "https://photos.simonwillison.net/i/d84a166371c9d0f249aa25afbac69ba5cd310a5392fddf2c113736b53f0c6d5e.heic?w=400", "link": "https://photos.simonwillison.net/i/d84a166371c9d0f249aa25afbac69ba5cd310a5392fddf2c113736b53f0c6d5e.heic?w=1200" }
2017-12-16T11:52:26+00:00	51.5034	-0.13202216666666666	f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62	heic	{ "title": "Taken on 2017-12-16T11:52:26+00:00", "image": "https://photos.simonwillison.net/i/f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62.heic?w=400", "link": "https://photos.simonwillison.net/i/f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62.heic?w=1200" }
2017-12-16T11:52:17+00:00	51.5034	-0.13202783333333332	fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a	heic	{ "title": "Taken on 2017-12-16T11:52:17+00:00", "image": "https://photos.simonwillison.net/i/fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a.heic?w=400", "link": "https://photos.simonwillison.net/i/fb7c3040191817d74897ed937836a9993cf3759f84a3bd4662f474c3635ec19a.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;