Capital Projects Dashboard - Citywide Budget and Schedule

fb86-vt7uCity Government27 columns

All major capital infrastructure projects with a committed budget. Financial information and agency schedule details for each project are joined via FMS ID. Only projects in the design phase or later have project schedules displayed. This dataset is part of the Capital Projects Dashboard . Note: Each row is uniquely identified by its Financial Management Service (FMS) ID. FMS ID is the unique ID that OMB uses for the FMS (Financial Information System). This ID can be universally joined with any OMB dataset that has the same field. The Capital Projects Dashboard is the result of joining OMB’s fiscal data with the agency’s schedule data. FMS IDs and agency projects don't always have a one-to-one relationship (i.e., one project schedule may correlate to multiple FMS IDs, and one FMS may correct to multiple projects with different schedules).

View on NYC Open Data

Quality

C77.7 / 100

From a 500-row sample across 27 columns.

completeness49/ 25% weight

consistency70/ 20% weight

accuracy88/ 20% weight

timeliness92/ 15% weight

usability100/ 20% weight

· Has geographic keys — joinable to other NYC datasets

Related datasets

Capital Projects Dashboard - Citywide Budget and Spend by Fiscal Year0.70
joins onfms_idmanaging_agencyreporting_period
Capital Projects Dashboard - Citywide Schedule History and Variance0.49
joins onpidcurrent_phasemanaging_agency+2
Capital Projects Dashboard - Citywide Budget Spend History and Variance0.46
joins onspend_to_datefms_idmanaging_agency+2
Expense Budget0.34
Parking Violations Issued - Fiscal Year 20270.33

Geography

Has borough codes (`borough`) — joinable, but needs boundary shapes to draw.

Sample rows

reporting_period	managing_agency	fms_id	total_budget	spend_to_date	spend_to_date_1	fms_project_name	current_phase	borough	community_board	budget_line	ten_year_plan_category
202305	ACS	ACSPDF	66808000.00	0.00	0.00	Renovation projects for field offices	(Pre-Design)	Citywide	Citywide	CS-0003	SOCIAL SERVICE BUILDINGS

Columns

27 queryable · 27 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`reporting_period`	categorical	The year and the month the report is published (format YYYYMM). The dataset is updated 3 times a year following OMB’s commitment plan release date in Jan/May/Sep.	0%	`202605202305202505`of 10
`managing_agency`	text	Common acronym of the city agency that is responsible for managing the construction and delivery of the capital project. This value is derived from the three digit managing agency code.	0%	`DPRDDCDOT`
`sponsor_agency`	text	Common acronym of the city agency that the capital project is being managed on behalf of. This value is derived from the three digit sponsor agency code. May include multiple agencies.	47%	`DPRDOTDEP`
`pid`	integer	Unique identifier that represent a set of schedule managed by agency.

Query this from your own app

GET /api/datasets/fb86-vt7u
GET /api/datasets/fb86-vt7u/quality
GET /api/datasets/fb86-vt7u/related
GET /api/columns?dataset=fb86-vt7u