photos_on_a_map (view)

3 rows where "date" is on date 2019-03-23 sorted by popup

View and edit SQL

date (date)

  • 2019-03-23 · 3
date latitude longitude sha256 ext popup ▼
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"
}
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-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"
}

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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;
Powered by Datasette · Query took 16.641ms · About: dogsheep/dogsheep-photos