`scripts/seed-sponsors.sql`

43 lines
-- Seed the 9 sponsor firms. Idempotent (ON CONFLICT).
INSERT INTO sponsors (slug, name, kind, role, tagline, website, listings_url, logo_path, tos_risk, notes) VALUES
 ('loopnet','LoopNet','marketplace','broker',
  'The most-trafficked commercial real estate marketplace',
  'https://www.loopnet.com','https://www.loopnet.com/search/commercial-real-estate/los-angeles-ca/for-lease/?sk=sublease',
  '/assets/logos/loopnet.jpg','high','CoStar-owned. Aggressive anti-bot + litigious on scraping — public pages only, rate-limited, run gated.'),
 ('costar','CoStar','data','broker',
  'The industry standard for commercial real estate information',
  'https://www.costar.com','https://www.costar.com','/assets/logos/costar.jpg','high',
  'Subscription/paywalled data. Historically litigious on data scraping — treat as directory sponsor + official-feed only.'),
 ('cbre','CBRE','brokerage','broker',
  'The world''s largest commercial real estate services firm',
  'https://www.cbre.com','https://www.cbre.com/properties/properties-for-lease','/assets/logos/cbre.jpg','medium',
  'Public property search on cbre.com; filter to sublease space.'),
 ('naicapital','NAI Capital','brokerage','broker',
  'Commercial Real Estate Services, Worldwide',
  'https://www.naicapital.com','https://www.naicapital.com/properties/','/assets/logos/naicapital.jpg','low',
  'Independent LA-based brokerage; public listing search.'),
 ('premierworkspaces','Premier Workspaces','operator','broker',
  'Flexible office, coworking & executive suites',
  'https://www.premierworkspaces.com','https://premierworkspaces.com/locations/','/assets/logos/premierworkspaces.jpg','low',
  'Office/coworking operator — locations map to sublease-style flexible space.'),
 ('fidelity','Fidelity Mortgage Lenders','lender','financing_partner',
  'Commercial & Residential mortgage lending',
  'https://www.fidelityca.com',NULL,'/assets/logos/fidelity.jpg','low',
  'Financing partner — no listings; sponsors deals via CRE lending.'),
 ('provident','Provident Bank','lender','financing_partner',
  'Commercial banking & real estate lending',
  'https://www.provident.bank',NULL,'/assets/logos/provident.jpg','low',
  'Financing partner — commercial RE lending.'),
 ('mizrahi','Mizrahi Tefahot Bank (UMTB)','lender','financing_partner',
  'International commercial banking · Member FDIC',
  'https://www.umtb.com',NULL,'/assets/logos/mizrahi.jpg','low',
  'Financing partner — UMTB, Member FDIC.'),
 ('walker','Walker Realty Capital','lender','financing_partner',
  'Commercial real estate capital & advisory',
  NULL,NULL,'/assets/logos/walker.jpg','low',
  'Financing partner — capital markets / advisory.')
ON CONFLICT (slug) DO UPDATE SET
  name=EXCLUDED.name, kind=EXCLUDED.kind, role=EXCLUDED.role, tagline=EXCLUDED.tagline,
  website=EXCLUDED.website, listings_url=EXCLUDED.listings_url, logo_path=EXCLUDED.logo_path,
  tos_risk=EXCLUDED.tos_risk, notes=EXCLUDED.notes;