Affordability Commitment Tracker

HPD's Assistant Commissioner for Strategic Operations & Analytics asked whether the affordability commitments buried across decades of regulatory agreements, deed restrictions, and scanned documents in ACRIS could be automatically identified, have their key terms extracted, and generate reliable expiration alerts. The desired outcome was an MVP that flags upcoming expirations, summarizes agreement terms, and cuts down the manual, document-by-document review HPD staff do today. HPD offered ACRIS metadata and scanned documents, internal agreement knowledge, and staff time in return.

Sponsor: Maggie Raife, Asst. Commissioner, Strategic Operations & Analytics · NYC HPD

The Affordability Commitment Tracker identifies HPD/HDC regulatory agreements, deed restrictions, declarations, amendments, and terminations from public ACRIS metadata, fetches the recorded scan pages, and extracts affordability terms with a vision LLM. Every extracted field is displayed beside the scanned page passage that supports it, so a reviewer can check the AI's work at a glance instead of trusting it blindly. Commitments roll up into a portfolio view filterable by borough, neighborhood, and expiration horizon, and drill down to a single building or a single ACRIS document. Cross-checks against HPD LL44, HPD Housing Production, DOF J-51, and DOF Property Exemption data show extracted values next to independent reference values, surfacing disagreement as a visible state rather than silently picking one.

• Portfolio · /affordability
• Map · /affordability/map
• Alerts · /affordability/alerts
• Methodology · /affordability/methodology

• 4,823 qualifying HPD/HDC ACRIS documents (16,488 document-party rows; 58,256 document-legal rows)
• 15,920 valid document page scans fetched across 832 documents (15,706 page images stored in Postgres)
• 457 completed vision-LLM extraction runs covering 199 documents — 4,567 extracted fields
• 1,014 HPD LL44 projects; 8,313 HPD Housing Production rows
• 12,795 DOF J-51 rows; 97,579 DOF Property Exemption rows

A Socrata pipeline joins ACRIS Parties, Master, and Legals to identify qualifying documents, geocodes them to BBLs, fetches page scans from ACRIS's GetImage endpoint, and runs vision-LLM extraction (Claude Sonnet 4.5) with a per-field confidence score. Everything lands in Postgres (`nyc.affordability_*`, 22 tables) and serves the live pages through Next.js API routes.

Live verification rated this product TRUSTWORTHY, with 3 documented warnings and no critical findings: all 18 done-when criteria passed, and the methodology page discloses its gaps honestly rather than hiding them.

• HPD's internal 8609/8823 LIHTC compliance database and HDC's private loan portfolio — agency-only
• DHCR rent-stabilization apartment-level registrations and HUD Section-8 renewal files — not public
• High-volume, sanctioned access to ACRIS document images requires a DOF partnership; today's access uses an undocumented, throttled endpoint
• Richmond County (Staten Island) records sit outside ACRIS's coverage