photos_on_a_map (view)

4 rows where "date" is on date 2016-04-09 sorted by sha256

View and edit SQL

Suggested facets: date, latitude, longitude

date (date)

  • 2016-04-09 · 4
date latitude longitude sha256 ▼ ext popup
2016-04-09T20:12:10+00:00 37.78550333333333 -122.43043666666667 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 jpeg
{
    "title": "Taken on 2016-04-09T20:12:10+00:00",
    "image": "https://photos.simonwillison.net/i/75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8.jpeg?w=400",
    "link": "https://photos.simonwillison.net/i/75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8.jpeg?w=1200"
}
2016-04-09T20:10:28+00:00 37.78546166666667 -122.43050333333333 7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419 jpeg
{
    "title": "Taken on 2016-04-09T20:10:28+00:00",
    "image": "https://photos.simonwillison.net/i/7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419.jpeg?w=400",
    "link": "https://photos.simonwillison.net/i/7f16bd84f8301f158a2a512549c0f1594ce92b7bfa05d2787e28a9d890b63419.jpeg?w=1200"
}
2016-04-09T20:10:29+00:00 37.78546166666667 -122.43050333333333 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 jpeg
{
    "title": "Taken on 2016-04-09T20:10:29+00:00",
    "image": "https://photos.simonwillison.net/i/8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001.jpeg?w=400",
    "link": "https://photos.simonwillison.net/i/8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001.jpeg?w=1200"
}
2016-04-09T20:12:10+00:00 37.78550333333333 -122.43043666666667 a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e jpeg
{
    "title": "Taken on 2016-04-09T20:12:10+00:00",
    "image": "https://photos.simonwillison.net/i/a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e.jpeg?w=400",
    "link": "https://photos.simonwillison.net/i/a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e.jpeg?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 19.861ms · About: dogsheep/dogsheep-photos