LL97 Compliance Operations

DOB Sustainability's Senior Analyst asked how the agency could optimize LL97 data utilization and analysis to improve service delivery and intra-government coordination. Local Law 97 requires roughly 50,000 covered buildings to cut greenhouse gas emissions 40% by 2030 and reach net zero by 2050, and DOB wanted an operational dashboard integrating emissions data, compliance trends, and report processing to track progress and support more equitable enforcement. DOB offered LL97 data, staff time, and inter-agency connections in return.

Sponsor: Ioanna Tsoulou, Senior Analyst · NYC DOB Sustainability

LL97 Compliance Operations is a public dashboard that shows, from public data alone, how covered buildings are tracking against the 2024 and 2030 emissions caps, where penalty risk concentrates, and what the enforcement pipeline looks like — the portfolio-wide, regulator's-eye view that owner-facing tools like BE-Ex don't provide. A visitor can search a building, drill into its emissions and compliance history, review 2030 exposure projections against a benchmark with an equity overlay, and inspect the public enforcement pipeline stage by stage. Every filtered list exports to CSV with a shareable deep link.

• Overview · /ll97
• Buildings · /ll97/buildings
• 2030 Cliff · /ll97/cliff
• Enforcement · /ll97/enforcement
• BEAM Workflow (Simulated) · /ll97/processing
• Methodology · /ll97/methodology

• LL84 building emissions — 106,248 rows (80,413 current-year + 25,835 CY2021)
• DOB Covered Buildings List — 26,974 unique BBLs
• LL33/LL95 letter grades — 12,208 rows
• PLUTO parcels — 858,602 rows
• Enforcement events across DOB/ECB/OATH datasets — 320,152 rows
• 19 public sources total, roughly 1.39 million rows

Ingest scripts pull from Socrata SODA, DOB PDF/XLSX filings, and NYS GIS sources into Neon Postgres (`nyc` schema, `ll97_` tables) on a weekly refresh, and Next.js route handlers serve the live pages directly from that data. There's no predictive model; this is a compliance-tracking and enforcement-visibility dashboard.

Live verification rated this product TRUSTWORTHY WITH TWO WARNINGS: 17 of 18 done-when criteria passed (one partial), and 8 of 8 citation spot-checks matched the underlying Socrata data exactly.

• Per-building BEAM filing records — announced by DOB but not yet public; the processing page is labeled Simulated
• NYC LL64 environmental-justice tract data sits behind a login wall; the product uses the NYS PEJA dataset as a disclosed fallback
• The EPA-property-type-to-LL97-occupancy-group crosswalk is an approximation, using BE-Ex's disclosed method