This data as json, CSV (advanced)
Suggested facets: date (date)
| date | latitude | longitude | sha256 | ext | popup |
|---|---|---|---|---|---|
| 2019-03-23T22:59:53+00:00 | 34.506328333333336 | -117.82743 | 43b53dbbae15a9c322fc74b76f2b646e3e2e04339fcd42a876fb3dc048423467 | heic | {
"title": "Taken on 2019-03-23T22:59:53+00:00",
"image": "https://photos.simonwillison.net/i/43b53dbbae15a9c322fc74b76f2b646e3e2e04339fcd42a876fb3dc048423467.heic?w=400",
"link": "https://photos.simonwillison.net/i/43b53dbbae15a9c322fc74b76f2b646e3e2e04339fcd42a876fb3dc048423467.heic?w=1200"
} |
| 2019-03-23T17:56:08+00:00 | 33.92010833333333 | -116.77295 | e9600c56afe37e32ec148695c3dc40a5539235ac4b656c78d516d7665aa9be74 | heic | {
"title": "Taken on 2019-03-23T17:56:08+00:00",
"image": "https://photos.simonwillison.net/i/e9600c56afe37e32ec148695c3dc40a5539235ac4b656c78d516d7665aa9be74.heic?w=400",
"link": "https://photos.simonwillison.net/i/e9600c56afe37e32ec148695c3dc40a5539235ac4b656c78d516d7665aa9be74.heic?w=1200"
} |
| 2019-03-23T17:49:38+00:00 | 33.92028333333333 | -116.77268333333333 | 49d5950465c58d12cdf4a1d8ebb444154166e209ff3da59fd386c6d3a8455273 | heic | {
"title": "Taken on 2019-03-23T17:49:38+00:00",
"image": "https://photos.simonwillison.net/i/49d5950465c58d12cdf4a1d8ebb444154166e209ff3da59fd386c6d3a8455273.heic?w=400",
"link": "https://photos.simonwillison.net/i/49d5950465c58d12cdf4a1d8ebb444154166e209ff3da59fd386c6d3a8455273.heic?w=1200"
} |
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;