Add Alameda CA/Oakland (1460, descriptive) + Oregon counties (1273, COM/IND codes) commercial. Commercial now 20 counties/510145. Free-from-loaded-parcels coverage largely exhausted

ed1e6975e852160da29d2016ba1104d284c0ac05 · 2026-07-31 02:25:36 -0700 · steve@designerwallcoverings.com

Files touched

M src/ingest/commercial/engine.ts

Diff

commit ed1e6975e852160da29d2016ba1104d284c0ac05
Author: steve@designerwallcoverings.com <steve@designerwallcoverings.com>
Date:   Fri Jul 31 02:25:36 2026 -0700

    Add Alameda CA/Oakland (1460, descriptive) + Oregon counties (1273, COM/IND codes) commercial. Commercial now 20 counties/510145. Free-from-loaded-parcels coverage largely exhausted
---
 src/ingest/commercial/engine.ts | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/src/ingest/commercial/engine.ts b/src/ingest/commercial/engine.ts
index deb9a17..ff55834 100644
--- a/src/ingest/commercial/engine.ts
+++ b/src/ingest/commercial/engine.ts
@@ -36,6 +36,14 @@ const ADAPTERS: Record<string, () => Promise<{ run: () => Promise<{ upserted: nu
   // + bare-commercial fallback added post-cycle-13). NY/TX handled by the coded materializer above.
   cook: async () => ({ run: (await import('./from_parcel.ts')).ingestCommercialFromParcel('17031', 'Cook County IL (Chicago)') }),
   // FL Miami-Dade + OH Franklin: descriptive use_desc with subtypes (OFFICE/STORE/WAREHOUSE/HOTEL) → from_parcel classifies directly.
+  alameda: async () => ({ run: (await import('./from_parcel.ts')).ingestCommercialFromParcel('06001', 'Alameda County CA (Oakland)') }),
+  // Oregon counties use 3-letter use codes (COM=commercial, IND=industrial) — small explicit map.
+  oregon: async () => {
+    const m = await import('./from_parcel.ts');
+    const classify = (u: string) => { const c = (u || '').trim().toUpperCase(); if (c === 'IND') return 'industrial' as const; return c === 'COM' ? 'other' as const : null; };
+    const CO: [string, string][] = [['41067', 'Washington OR'], ['41051', 'Multnomah OR'], ['41005', 'Clackamas OR'], ['41047', 'Marion OR'], ['41035', 'Klamath OR']];
+    return { run: async () => { let up = 0; for (const [fips, name] of CO) up += (await m.ingestCommercialFromParcelCoded(fips, name, '^(COM|IND)$', classify)()).upserted; return { upserted: up }; } };
+  },
   miami: async () => ({ run: (await import('./from_parcel.ts')).ingestCommercialFromParcel('12086', 'Miami-Dade County FL') }),
   franklin: async () => ({ run: (await import('./from_parcel.ts')).ingestCommercialFromParcel('39049', 'Franklin County OH (Columbus)') }),
   // Fulton GA (Atlanta): numeric land-use codes → authoritative label map (Fulton Assessor

← 0cfcfdb Add Fulton GA/Atlanta commercial (15178) via authoritative F · back to Nationalrealestate · Add recent_commercial_deals view — closed commercial deals f 06c2d3a →