Session 20 — TB-17 All Tiers Complete + File Registry

What was built

  • Archive Document Backfill (TB-17, all tiers complete)
    • Tier 2: 418 certs parsed, 29 inspection dates applied
    • Tier 3: 1,093 files reclassified via filename heuristics
    • Tier 3b: 1,552 files reclassified via Vision Sonnet (912 CERTS, 187 PERMITS, 187 PLANS, 185 INVOICES, 79 PHOTOS, 2 DRIVELOGS)
    • OTHER bucket cleaned: .mov deleted (9), .jfif moved to PHOTOS (2), PDFs deleted (38)
    • Final OTHER: 18 files (99.3% classified)
  • file-registry-service confirmed — Supabase project_files table with pg_trgm trigram search, migration 006
  • Portal: /file-search page with filename search, category/source filters, pagination

Services touched