photos_on_a_map (view)

3 rows where "date" is on date 2018-04-22 and longitude = "-122.34416166666666"

descending

✎ View and edit SQL

This data as json, CSV (advanced)

date	latitude	longitude	sha256	ext	popup
2018-04-22T00:03:54+00:00	37.579186666666665	-122.34416166666666	20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556	heic	{ "title": "Taken on 2018-04-22T00:03:54+00:00", "image": "https://photos.simonwillison.net/i/20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556.heic?w=400", "link": "https://photos.simonwillison.net/i/20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556.heic?w=1200" }
2018-04-22T00:03:12+00:00	37.57927	-122.34416166666666	15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6	heic	{ "title": "Taken on 2018-04-22T00:03:12+00:00", "image": "https://photos.simonwillison.net/i/15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6.heic?w=400", "link": "https://photos.simonwillison.net/i/15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6.heic?w=1200" }
2018-04-22T00:03:04+00:00	37.57926166666667	-122.34416166666666	f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378	heic	{ "title": "Taken on 2018-04-22T00:03:04+00:00", "image": "https://photos.simonwillison.net/i/f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378.heic?w=400", "link": "https://photos.simonwillison.net/i/f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378.heic?w=1200" }

date

latitude

longitude

sha256

ext

2018-04-22T00:03:54+00:00

37.579186666666665

-122.34416166666666

20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556

heic

{
    "title": "Taken on 2018-04-22T00:03:54+00:00",
    "image": "https://photos.simonwillison.net/i/20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556.heic?w=400",
    "link": "https://photos.simonwillison.net/i/20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556.heic?w=1200"
}

2018-04-22T00:03:12+00:00

37.57927

-122.34416166666666

15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6

heic

{
    "title": "Taken on 2018-04-22T00:03:12+00:00",
    "image": "https://photos.simonwillison.net/i/15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6.heic?w=400",
    "link": "https://photos.simonwillison.net/i/15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6.heic?w=1200"
}

2018-04-22T00:03:04+00:00

37.57926166666667

-122.34416166666666

f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378

heic

{
    "title": "Taken on 2018-04-22T00:03:04+00:00",
    "image": "https://photos.simonwillison.net/i/f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378.heic?w=400",
    "link": "https://photos.simonwillison.net/i/f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378.heic?w=1200"
}

Advanced export

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;