Capital Projects Database: NYC Capital Investment Projects with Geospatial Polygons

A database of discrete capital investment projects from New York City's Capital Commitment Plan, uniquely identified by Financial Management Service (FMS) IDs. The dataset includes information on sponsoring and managing agencies, project descriptions, and financial commitments. It was last updated on December 10, 2025, and is hosted by data.cityofnewyork.us.

Use Cases

• Analyzing capital expenditure allocation by agency using magency, magenname, and altotal columns.
• Mapping project locations and spatial distribution using the geometry column.
• Tracking project timelines and phases using mindate and maxdate columns.
• Categorizing funding sources and project types using columns like alnccfed, alnccstate, spcc, and typecat.

Strengths

• Includes a geometry column for geospatial analysis of project locations.
• Provides over 30 columns of detailed financial and administrative data per project.
• Data is uniquely identified by Financial Management Service (FMS) IDs for record linkage.

Limitations

• Row count is unknown, which may limit suitability assessment.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

data.cityofnewyork.us

Collection Method

Likely compiled from official Capital Commitment Plan reports and agency submissions.

Time Range

Temporal coverage is not explicitly stated, but columns mindate and maxdate suggest date ranges for individual projects.

Freshness

Last updated 2025-12-10 18:07:36; freshness should be verified.

Geography

Spatial coverage is New York City, as indicated by the platform tags and description links.