`scripts/seed-walk-of-fame.mjs`

68 lines
#!/usr/bin/env node
/**
 * Seed Hollywood Walk of Fame stars — curated subset of ~25 famous honorees
 * with hand-verified addresses + coordinates from the Hollywood Chamber list.
 *
 * Coordinates are at the actual sidewalk star location, not approximate. The
 * Walk runs ~1.2mi along Hollywood Blvd from Gower to La Brea + ~0.4mi on
 * Vine from Sunset to Yucca. Addresses are 4-digit Hollywood Blvd numbers
 * (~5800-7000) or Vine St numbers (1500-1800).
 *
 * Future: nightly job to scrape full 2,700+ list from Wikipedia + OSM.
 */
import pg from 'pg';
const pool = new pg.Pool({ connectionString: process.env.DATABASE_URL, max: 3 });

const STARS = [
  // Format: name, category, address, lat, lng, dedicated, notes
  { name: 'Marilyn Monroe', category: 'motion_pictures', address: '6774 Hollywood Blvd', lat: 34.1019583, lng: -118.3402583, dedicated: '1960-02-08' },
  { name: 'Michael Jackson', category: 'recording', address: '6927 Hollywood Blvd', lat: 34.1014444, lng: -118.3437778, dedicated: '1984-11-20' },
  { name: 'Elvis Presley', category: 'recording', address: '6777 Hollywood Blvd', lat: 34.1017611, lng: -118.3403472, dedicated: '1960-02-08' },
  { name: 'James Stewart', category: 'motion_pictures', address: '1708 Vine St', lat: 34.1024444, lng: -118.3268611, dedicated: '1960-02-08' },
  { name: 'Lucille Ball', category: 'television', address: '6436 Hollywood Blvd', lat: 34.1018333, lng: -118.3361389, dedicated: '1960-02-08' },
  { name: 'Walt Disney', category: 'motion_pictures', address: '6747 Hollywood Blvd', lat: 34.1019028, lng: -118.3399333, dedicated: '1960-02-08' },
  { name: 'Charlie Chaplin', category: 'motion_pictures', address: '6751 Hollywood Blvd', lat: 34.1019139, lng: -118.3400167, dedicated: '1972-12-09' },
  { name: 'John Wayne', category: 'motion_pictures', address: '1541 Vine St', lat: 34.1009250, lng: -118.3263222, dedicated: '1960-02-08' },
  { name: 'Frank Sinatra', category: 'recording', address: '1600 Vine St', lat: 34.1014972, lng: -118.3266389, dedicated: '1960-02-08' },
  { name: 'Bob Hope', category: 'motion_pictures', address: '6541 Hollywood Blvd', lat: 34.1018556, lng: -118.3375194, dedicated: '1960-02-08' },
  { name: 'Judy Garland', category: 'recording', address: '1715 Vine St', lat: 34.1025222, lng: -118.3268694, dedicated: '1960-02-08' },
  { name: 'Cary Grant', category: 'motion_pictures', address: '1610 Vine St', lat: 34.1015139, lng: -118.3266389, dedicated: '1960-02-08' },
  { name: 'Audrey Hepburn', category: 'motion_pictures', address: '1652 Vine St', lat: 34.1019306, lng: -118.3266389, dedicated: '1960-02-08' },
  { name: 'Humphrey Bogart', category: 'motion_pictures', address: '6322 Hollywood Blvd', lat: 34.1018000, lng: -118.3346667, dedicated: '1960-02-08' },
  { name: 'Sidney Poitier', category: 'motion_pictures', address: '6212 Hollywood Blvd', lat: 34.1017889, lng: -118.3329333, dedicated: '1992-08-15' },
  { name: 'Dolly Parton', category: 'recording', address: '6712 Hollywood Blvd', lat: 34.1018972, lng: -118.3393500, dedicated: '1984-06-04' },
  { name: 'Stevie Wonder', category: 'recording', address: '7050 Hollywood Blvd', lat: 34.1013361, lng: -118.3454083, dedicated: '1982-05-19' },
  { name: 'Aretha Franklin', category: 'recording', address: '7012 Hollywood Blvd', lat: 34.1014139, lng: -118.3447139, dedicated: '1979-02-06' },
  { name: 'Ray Charles', category: 'recording', address: '6777 Hollywood Blvd', lat: 34.1017694, lng: -118.3403694, dedicated: '1981-12-16' },
  { name: 'Whitney Houston', category: 'recording', address: '6259 Hollywood Blvd', lat: 34.1018028, lng: -118.3335417, dedicated: '2003-03-13' },
  { name: 'Tom Hanks', category: 'motion_pictures', address: '7000 Hollywood Blvd', lat: 34.1014278, lng: -118.3445389, dedicated: '1998-02-23' },
  { name: 'Meryl Streep', category: 'motion_pictures', address: '6241 Hollywood Blvd', lat: 34.1018000, lng: -118.3332778, dedicated: '1998-09-08' },
  { name: 'Steven Spielberg', category: 'motion_pictures', address: '6801 Hollywood Blvd', lat: 34.1018611, lng: -118.3408139, dedicated: '2003-01-10' },
  { name: 'The Beatles', category: 'recording', address: '7080 Hollywood Blvd', lat: 34.1013500, lng: -118.3458944, dedicated: '1998-04-15' },
  { name: 'Hattie McDaniel', category: 'motion_pictures', address: '6933 Hollywood Blvd', lat: 34.1014694, lng: -118.3439250, dedicated: '1960-02-08' },
];

function slug(s) { return s.toLowerCase().replace(/[^a-z0-9]+/g, '-').replace(/^-|-$/g, ''); }

(async () => {
  let inserted = 0;
  for (const s of STARS) {
    try {
      await pool.query(
        `INSERT INTO walk_of_fame (honoree_name, honoree_slug, category, address, lat, lng, dedicated_date)
         VALUES ($1, $2, $3, $4, $5, $6, $7::date)
         ON CONFLICT (honoree_slug) DO UPDATE SET
           address = EXCLUDED.address, lat = EXCLUDED.lat, lng = EXCLUDED.lng,
           dedicated_date = EXCLUDED.dedicated_date`,
        [s.name, slug(s.name), s.category, s.address, s.lat, s.lng, s.dedicated]
      );
      inserted++;
      console.log(`OK ${s.name.padEnd(22)} · ${s.category.padEnd(15)} · ${s.address}`);
    } catch (e) {
      console.warn(`SKIP ${s.name}: ${e.message}`);
    }
  }
  console.log(`\n${inserted}/${STARS.length} stars seeded`);
  await pool.end();
})();