How the budget PDFs become cited answers

How the budget PDFs become cited answers A data-flow diagram generated by Archify. 01 / Source 02 / Extract 03 / Check and index 04 / Store 05 / Look up Budget PDFs · 224 + 455 pages · 01 / Source · read-only Budget PDFs 224 + 455 pages read-only Python extraction · pdfplumber + pandas · 02 / Extract · run once Python extraction pdfplumber + pandas run once Number checks · golden numbers + totals · 03 / Check and index · blocks deploy Number checks golden numbers + totals blocks deploy Narrative passages · Voyage voyage-4 · 03 / Check and index · embedded Narrative passages Voyage voyage-4 embedded Budget tables · Postgres on Neon · 04 / Store · page + line Budget tables Postgres on Neon page + line Passage index · pgvector + full-text · 04 / Store · page cited Passage index pgvector + full-text page cited Figure lookups · typed SQL queries · 05 / Look up · exact numbers Figure lookups typed SQL queries exact numbers Hybrid search · vector + keyword, RRF · 05 / Look up · context Hybrid search vector + keyword, RRF context pages text + tables figures with page narrative passages checked data gates deploy vectors 1024 dims SQL read-only matches ranked Legend primary data data store data flow