← back to Stayclaim
db/seed-bh.sql
109 lines
-- Beverly Hills seed addresses for the pilot geography.
-- All names/owners are FICTIONAL and historical (deceased) — no current residences.
-- Coordinates are approximate within BH bounds (34.06–34.10 N, -118.43 to -118.38 W).
INSERT INTO listing (slug, source, source_id, title, headline, description, address_line1, city, state, postal_code, latitude, longitude, bedrooms, bathrooms, sleeps, property_type, amenities, hero_image, images, nightly_price, source_url)
VALUES
('1100-elden-way', 'manual', 'bh-1001',
'1100 Elden Way',
'Storybook English on a quiet block below Sunset.',
'Brick Tudor with a slate roof and a courtyard wrapped in star jasmine. The kind of house people slow their cars for.',
'1100 Elden Wy', 'Beverly Hills', 'CA', '90210', 34.0859, -118.4035, 5, 4.5, 10, 'Single-family',
'["Pool","Carriage house","Gated motor court","Original casement windows"]'::jsonb,
'https://images.unsplash.com/photo-1564013799919-ab600027ffc6?w=1600',
'["https://images.unsplash.com/photo-1564013799919-ab600027ffc6?w=1600"]'::jsonb,
1850.00, NULL),
('814-roxbury-drive', 'manual', 'bh-1002',
'814 Roxbury Drive',
'Spanish Colonial Revival, 1928 — restored down to the original wrought iron.',
'Two-story stucco with red barrel tile, arched loggias, and a fountain courtyard. The neighbor at 802 was a band leader; the one at 822 was a studio executive.',
'814 N Roxbury Dr', 'Beverly Hills', 'CA', '90210', 34.0795, -118.4129, 6, 5, 12, 'Single-family',
'["Original tile","Wrought iron","Pool","Tennis court"]'::jsonb,
'https://images.unsplash.com/photo-1572120360610-d971b9d7767c?w=1600',
'["https://images.unsplash.com/photo-1572120360610-d971b9d7767c?w=1600"]'::jsonb,
2400.00, NULL),
('512-camden-drive', 'manual', 'bh-1003',
'512 Camden Drive',
'Mid-century glass house, 1957 — wall of olive trees, lap pool below.',
'Steel and glass, single story, 18-foot ceilings in the great room. The lot drops twenty feet so the pool sits above the living room sightline like a held breath.',
'512 N Camden Dr', 'Beverly Hills', 'CA', '90210', 34.0721, -118.4082, 4, 4, 8, 'Single-family',
'["Lap pool","Olive grove","Floor-to-ceiling glass","Detached studio"]'::jsonb,
'https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=1600',
'["https://images.unsplash.com/photo-1600585154340-be6161a56a0c?w=1600"]'::jsonb,
1650.00, NULL),
('1037-loma-vista-drive', 'manual', 'bh-1004',
'1037 Loma Vista Drive',
'Hilltop modern, 1971 — concrete and walnut, looking south to Catalina.',
'A house built around the view, by a husband-wife team who taught at SCI-Arc. Original cantilevered terrace remains intact.',
'1037 Loma Vista Dr', 'Beverly Hills', 'CA', '90210', 34.0938, -118.4175, 3, 3.5, 6, 'Single-family',
'["View","Cantilevered terrace","Walnut interior","Pool"]'::jsonb,
'https://images.unsplash.com/photo-1613490493576-7fde63acd811?w=1600',
'["https://images.unsplash.com/photo-1613490493576-7fde63acd811?w=1600"]'::jsonb,
1300.00, NULL),
('600-bedford-drive', 'manual', 'bh-1005',
'600 Bedford Drive',
'Georgian Revival on a flag lot — front lawn behind a hedge.',
'Symmetrical, white brick, six chimneys. Built in 1934 and modernized invisibly in 2008. The front gates are taller than the trees.',
'600 N Bedford Dr', 'Beverly Hills', 'CA', '90210', 34.0729, -118.4044, 8, 7, 14, 'Single-family',
'["Pool","Pool house","Gym","Wine cellar","Original library paneling"]'::jsonb,
'https://images.unsplash.com/photo-1605276374104-dee2a0ed3cd6?w=1600',
'["https://images.unsplash.com/photo-1605276374104-dee2a0ed3cd6?w=1600"]'::jsonb,
3200.00, NULL),
('230-palm-drive', 'manual', 'bh-1006',
'230 Palm Drive',
'Pink stucco bungalow, 1923 — eight rooms, one block from the flats.',
'A small, perfect Mediterranean. The original kitchen tile remains. Rented continuously to the same family from 1957 to 1996.',
'230 S Palm Dr', 'Beverly Hills', 'CA', '90212', 34.0648, -118.3981, 3, 2, 5, 'Single-family',
'["Original tile","Citrus","Detached garage","Walk to retail"]'::jsonb,
'https://images.unsplash.com/photo-1549517045-bc93de075e53?w=1600',
'["https://images.unsplash.com/photo-1549517045-bc93de075e53?w=1600"]'::jsonb,
620.00, NULL),
('925-benedict-canyon', 'manual', 'bh-1007',
'925 Benedict Canyon',
'Cliff-side estate, 1962 — A. Quincy Jones plan, sympathetic 2014 update.',
'Long, low, single-floor pavilion stretched along the ridge. Glass walls retract; the house and the garden become one room. Original pool tile.',
'925 Benedict Canyon Dr', 'Beverly Hills', 'CA', '90210', 34.1015, -118.4127, 5, 5.5, 10, 'Single-family',
'["Pool","Outdoor kitchen","Original tile","Walk-in pantry","Vintage barware"]'::jsonb,
'https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?w=1600',
'["https://images.unsplash.com/photo-1600596542815-ffad4c1539a9?w=1600"]'::jsonb,
2700.00, NULL),
('410-rexford-drive', 'manual', 'bh-1008',
'410 Rexford Drive',
'French Normandy, 1939 — turret, slate, hand-painted shutters.',
'A storybook house with a working dovecote in the garden. Restored over three years (2006–2009) by a husband-and-wife team that did the Greystone library wing.',
'410 N Rexford Dr', 'Beverly Hills', 'CA', '90210', 34.0741, -118.4102, 5, 4, 9, 'Single-family',
'["Turret","Dovecote","Library","Cellar","Garden walls"]'::jsonb,
'https://images.unsplash.com/photo-1600210492486-724fe5c67fb0?w=1600',
'["https://images.unsplash.com/photo-1600210492486-724fe5c67fb0?w=1600"]'::jsonb,
1480.00, NULL)
ON CONFLICT (slug) DO NOTHING;
-- Add a couple more historical entities so the address graph isn't sparse.
INSERT INTO entity (slug, kind, display_name, birth_year, death_year, is_living, bio_short, wiki_url)
VALUES
('a-quincy-jones', 'architect', 'A. Quincy Jones', 1913, 1979, false,
'Mid-century Los Angeles architect — Eichler tracts, Sunnylands, the Brody House.',
'https://en.wikipedia.org/wiki/Archibald_Quincy_Jones'),
('rudolph-schindler', 'architect', 'Rudolph Schindler', 1887, 1953, false,
'Vienna-trained, LA-based modernist. Schindler House (1922), Lovell Beach House.',
'https://en.wikipedia.org/wiki/Rudolph_Schindler_(architect)')
ON CONFLICT (slug) DO NOTHING;
-- Tie A. Quincy Jones to 925 Benedict Canyon.
WITH
aqj AS (SELECT id FROM entity WHERE slug = 'a-quincy-jones'),
bc AS (SELECT id FROM listing WHERE slug = '925-benedict-canyon')
INSERT INTO entity_place_association (entity_id, listing_id, relation, date_from, date_to, summary, source_tier, source_urls, confidence, review_status, public_visible)
SELECT aqj.id, bc.id, 'designer', DATE '1962-01-01', DATE '1963-12-31',
'Working drawings on file at the Quincy Jones archive, UCLA Library Special Collections.',
'B', ARRAY['https://www.library.ucla.edu/'], 0.78, 'approved', true
FROM aqj, bc
ON CONFLICT DO NOTHING;