photos_on_a_map (view)

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

View and edit SQL

date (date)

  • 2019-08-24 · 4
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

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 15.668ms · About: dogsheep/dogsheep-photos