`db/migrations/022_restaurant_closed_images.sql`

95 lines
-- Hand-curated public-domain / CC / archival-editorial-use images for the 16
-- closed celebrity restaurants. Sourced 2026-05-02 by la-research-agent across
-- LAPL TESSA2, Wikimedia Commons, and California Historical Society.
--
-- 13 of 16 have verified hot-linkable images (URLs returned HTTP 200 at
-- sourcing time). 3 are intentionally left NULL — no freely-licensed image
-- exists in the archives we're allowed to use:
--   cock-n-bull         — best candidate is a CSL postcard with rights
--                          "contact institution" — needs CSL release request
--   morton-s-melrose    — zero hits across LAPL/USC/Wikimedia/DPLA/LOC/IA
--   nate-n-als          — zero hits; needs LAPL in-person Security Pacific
--                          search or family-direct release
--
-- LAPL note: TESSA2 photos are NOT CC-licensed but LAPL's standard policy
-- permits editorial reproduction (see https://tessa.lapl.org/OrderingUse.html).
-- We tag these as `Editorial use — LAPL Photo Collection` per Steve's standing
-- "no stock images, citation required" rule.

UPDATE restaurant AS r SET
  hero_image            = v.image_url,
  hero_image_credit     = v.credit,
  hero_image_license    = v.license,
  hero_image_source_url = v.source_url
FROM (VALUES
  -- Wikimedia Commons (Public Domain / CC)
  ('bistro-garden',
   'https://upload.wikimedia.org/wikipedia/commons/3/37/President_Ronald_Reagan_and_Nancy_Reagan_with_Leonore_Annenberg_and_Walter_Annenberg.jpg',
   'Reagan White House Photographs via Wikimedia Commons / NARA',
   'Public Domain',
   'https://commons.wikimedia.org/wiki/File:President_Ronald_Reagan_and_Nancy_Reagan_with_Leonore_Annenberg_and_Walter_Annenberg.jpg'),
  ('brown-derby',
   'https://upload.wikimedia.org/wikipedia/commons/5/5d/Brown_Derby_Restaurant%2C_Los_Angeles%2C_Kodachrome_by_Chalmers_Butterfield.jpg',
   'Photo: Chalmers Butterfield via Wikimedia Commons',
   'CC BY 2.5',
   'https://commons.wikimedia.org/wiki/File:Brown_Derby_Restaurant,_Los_Angeles,_Kodachrome_by_Chalmers_Butterfield.jpg'),
  ('chasens',
   'https://upload.wikimedia.org/wikipedia/commons/c/ca/Chasen%27s_Awning_2.JPG',
   'Photo: Bigfatloser via Wikimedia Commons',
   'Public Domain',
   'https://commons.wikimedia.org/wiki/File:Chasen%27s_Awning_2.JPG'),
  ('coles-french-dip',
   'https://upload.wikimedia.org/wikipedia/commons/4/42/ColesFrenchDip.jpg',
   'Photo: Mark Steven Brown via Wikimedia Commons',
   'CC BY-SA 3.0',
   'https://commons.wikimedia.org/wiki/File:ColesFrenchDip.jpg'),
  ('don-the-beachcomber',
   'https://upload.wikimedia.org/wikipedia/commons/9/94/Menu%2C_Don_the_Beachcomber%2C_Hollywood_%28cover%29_%2812001506164%29.jpg',
   'California Historical Society via Wikimedia Commons',
   'No known copyright restrictions',
   'https://commons.wikimedia.org/wiki/File:Menu,_Don_the_Beachcomber,_Hollywood_(cover)_(12001506164).jpg'),

  -- LAPL TESSA2 IIIF (Editorial use per LAPL ordering policy)
  ('ma-maison',
   'https://tessa2.lapl.org/digital/iiif/photos/117641/full/max/0/default.jpg',
   'Photo: Carol Westwood / LAPL Los Angeles Photographers Collection',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/117641'),
  ('pacific-dining-car',
   'https://tessa2.lapl.org/digital/iiif/photos/87487/full/max/0/default.jpg',
   'Photo: Security Pacific National Bank Collection / LAPL',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/87487'),
  ('perinos',
   'https://tessa2.lapl.org/digital/iiif/photos/121432/full/max/0/default.jpg',
   'Photo: Anne Laskey / LAPL Marlene & Anne Laskey Wilshire Boulevard Collection',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/121432'),
  ('romanoff-s',
   'https://tessa2.lapl.org/digital/iiif/photos/87491/full/max/0/default.jpg',
   'Photo: Morris & Associates / Security Pacific National Bank Collection / LAPL',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/87491'),
  ('schwab-s-pharmacy',
   'https://tessa2.lapl.org/digital/iiif/photos/12469/full/max/0/default.jpg',
   'Photo: Michael Haering / Herald Examiner Collection / LAPL',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/12469'),
  ('tail-o-the-cock',
   'https://tessa2.lapl.org/digital/iiif/photos/45384/full/max/0/default.jpg',
   'Photo: Gordon Dean / Valley Times Collection / LAPL',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/45384'),
  ('taix-french-restaurant',
   'https://tessa2.lapl.org/digital/iiif/photos/124883/full/max/0/default.jpg',
   'Photo: William Reagh / LAPL Los Angeles Photographers Collection',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/124883'),
  ('trader-vics-beverly-hilton',
   'https://tessa2.lapl.org/digital/iiif/photos/18166/full/max/0/default.jpg',
   'Photo: Herald Examiner Collection / LAPL',
   'Editorial use — LAPL Photo Collection',
   'https://tessa2.lapl.org/digital/collection/photos/id/18166')
) AS v(slug, image_url, credit, license, source_url)
WHERE r.slug = v.slug;