photos_on_a_map (view)

5 rows where "date" is on date 2019-09-15 sorted by popup

View and edit SQL

Suggested facets: latitude, longitude

date (date)

  • 2019-09-15 · 5
date latitude longitude sha256 ext popup ▼
2019-09-15T14:37:30+00:00 30.234196666666666 -89.66815833333334 7104ebd9287ca4e5d2556496eafd7d34ada9901997cbff1dbdd7c33281d65566 heic
{
    "title": "Taken on 2019-09-15T14:37:30+00:00",
    "image": "https://photos.simonwillison.net/i/7104ebd9287ca4e5d2556496eafd7d34ada9901997cbff1dbdd7c33281d65566.heic?w=400",
    "link": "https://photos.simonwillison.net/i/7104ebd9287ca4e5d2556496eafd7d34ada9901997cbff1dbdd7c33281d65566.heic?w=1200"
}
2019-09-15T14:38:47+00:00 30.234196666666666 -89.66815833333334 d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2 heic
{
    "title": "Taken on 2019-09-15T14:38:47+00:00",
    "image": "https://photos.simonwillison.net/i/d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2.heic?w=400",
    "link": "https://photos.simonwillison.net/i/d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2.heic?w=1200"
}
2019-09-15T15:15:38+00:00 30.243286666666666 -89.68092166666666 e0418d31b3a2b842b3514b954ac271355a51ba93194dc39cfadb7ee9ecb1acac heic
{
    "title": "Taken on 2019-09-15T15:15:38+00:00",
    "image": "https://photos.simonwillison.net/i/e0418d31b3a2b842b3514b954ac271355a51ba93194dc39cfadb7ee9ecb1acac.heic?w=400",
    "link": "https://photos.simonwillison.net/i/e0418d31b3a2b842b3514b954ac271355a51ba93194dc39cfadb7ee9ecb1acac.heic?w=1200"
}
2019-09-15T15:16:37+00:00 30.243796666666668 -89.68113 95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753 heic
{
    "title": "Taken on 2019-09-15T15:16:37+00:00",
    "image": "https://photos.simonwillison.net/i/95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753.heic?w=400",
    "link": "https://photos.simonwillison.net/i/95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753.heic?w=1200"
}
2019-09-15T15:36:30+00:00 30.24152 -89.67729166666666 847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554 heic
{
    "title": "Taken on 2019-09-15T15:36:30+00:00",
    "image": "https://photos.simonwillison.net/i/847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554.heic?w=400",
    "link": "https://photos.simonwillison.net/i/847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554.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 27.174ms · About: dogsheep/dogsheep-photos