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