NYC Capital Projects · Open Data

Schedules × Budgets
the many-to-many anatomy of the capital portfolio

Every active project carries two identities. A PID is a construction schedule — what gets built, and when. An FMS ID is a budget line — where the money comes from. They are not the same thing, and they do not line up one-for-one. This is a map of how they connect, and of how $158 billion is distributed across them.

PID — the schedule side

What is built & when

Phase, forecast completion, delay. Read for anything time-related. 3,003 active schedules this period.

FMS ID — the budget side

Where money comes from

Commitments, spend, budget change. Read for anything dollar-related. 3,238 funding lines tie to a live schedule.

01

Mostly one-to-one — but the exceptions matter

Across the 3,003 PIDs and 3,238 budget lines active in period 202601, there are 3,389 schedule↔budget links. The majority are clean 1:1 pairs. But a meaningful minority fan out — roughly 7% of schedules draw on several budgets, and about 2% of budgets bankroll many schedules. Whenever an ID resolves to multiple counterparts, all of them count; none is silently dropped.

0
Active PIDs · schedules
0
Linked FMS budget lines
0
Schedule ↔ budget links
0
IDs that fan out (6.9% / 2.1%)

Proportion that stays 1:1 vs. fans out

Share of each side resolving to exactly one counterpart, period 202601.

0% SINGLE BUDGET
PID → FMS
2,797 of 3,003 draw on one budget · 206 split across several
0% SINGLE SCHEDULE
FMS → PID
3,170 of 3,238 fund one schedule · 68 are shared
02

The shape of the fan-out

Hover any node to trace its links. Use the filters to isolate the three kinds of connection. The diagram is schematic — proportions of each pattern are faithful to the data; node counts in the fans are illustrative of the real extremes.

How many budgets fund one PID

Distribution of budget-line counts per schedule.

How many PIDs one budget funds

Distribution of schedule counts per budget line.

03

The tangled few

The extremes are programmatic. On the budget side, a handful of NYPD city-wide lines (ADA compliance, general police facilities) each bankroll a dozen-plus separate site schedules. On the schedule side, complex projects are stitched together from several distinct funding sources — and Parks' citywide reconstruction programs now lead that pattern. Tangled PIDs also tend to run larger: a median $18M versus $5M for single-budget schedules.

Shared budgets — one FMS line funding many PIDs
FMS · PO79-ADA2
25 PIDs
NYPD · city-wide ADA compliance
FMS · PO79-ADA
15 PIDs
NYPD · ADA compliance (gen.)
FMS · PO79-GEN
13 PIDs
NYPD · general facilities
FMS · KENS-EAST
5 PIDs
DEP · Kensico-Eastview
Split funding — one PID stitched from many budgets
PID · 64
5 budgets
Multi-source schedule
RS-CICTRAVLIFTTRAVSIDEWRAISESHORRS-PH1
PID · 4752
5 budgets
Multi-source schedule
CB-QE25CB-KR25CB-X25BWSOREI26CB-QW25
PID · 4028
5 budgets
Jerome Ave · multi-source
HWXJEROMENDF-JEROMHED583HED584HED585
PID · 4067
4 budgets
Sandy recovery · multi-source
SANDY4-31SANDY4-30HBPED800QQED1062
04

Who tangles, and who stays clean

Thirteen managing agencies execute the 3,003 active schedules. Decomposing the fan-out by executor reveals three distinct behaviors. Parks (DPR) is the largest source of split funding: its citywide reconstruction programs — play areas, fencing, synthetic turf — are each a single schedule drawing on a dozen-plus site budget lines (one, PID 2911, spans 14). The construction managers — DDC and EDC — split for a different reason, stitching one schedule from many funding sources on behalf of other agencies. NYPD does the reverse: a few city-wide budget lines bankroll dozens of precinct sites (shared budgets). The remaining agencies run an essentially perfect one-to-one shop.

Two ways to tangle — agencies positioned by behavior

Horizontal: share of an agency's schedules funded by multiple budgets. Vertical: share of its budget lines shared across multiple schedules. Bubble area ∝ number of schedules. Hover any bubble for detail.

Each agency's one-to-one vs. multi-budget split

Every agency's schedules, divided into single-budget (1:1) and multi-budget. The trailing tag shows its budget-sharing rate (1 line → many schedules).

1:1 — single-budget schedules split — multi-budget schedules
05

Where the money lives

Budget lines sorted into size bands at the (managing agency × FMS ID) grain. Toggle the view and watch the distribution invert: by count the portfolio is a sea of small lines; by dollars it is a handful of giants. This is the single most important thing to understand about the capital budget.

Concentration curve

Cumulative share of budget lines (smallest → largest) against cumulative share of dollars. The further the curve bows from the dashed line of equality, the more concentrated the portfolio.

82% of lines

are under $25M — yet they account for just 16% of all committed dollars.

34% of dollars

sit in just 33 mega-lines over $500M — six-tenths of one percent of all budget lines.

$158B committed

across 5,529 budget lines active in the portfolio this reporting period.