New York City Capital Project Milestones with Agency and Schedule Data

Capital Project Detail Data - Milestones contains capital commitment plan data from the City of New York. The dataset includes project schedules, managing agencies, and descriptions, and was updated three times a year until January 2024. It is hosted on data.cityofnewyork.us and was last updated on 2024-03-19.

Use Cases

• Analyze project schedule adherence by comparing ORIG_START_DATE and ORIG_END_DATE to TASK_START_DATE and TASK_END_DATE.
• Categorize capital spending by BORO and MANAGING_AGCY to assess geographic and departmental allocation.
• Track project lifecycle and milestone descriptions using PROJECT_ID, SEQ_NUMBER, and TASK_DESCRIPTION.
• Examine historical planning cycles by filtering records based on PUB_DATE from different commitment plan phases.

Strengths

• Includes temporal columns for both original and actual task dates (ORIG_START_DATE, TASK_END_DATE, etc.) enabling schedule variance analysis.
• Provides project identification and description columns (PROJECT_ID, PROJECT_DESCR) for detailed tracking.
• Data is structured with clear agency codes (MANAGING_AGCY_CD) and borough information (BORO).

Limitations

• Last updated 2024-03-19; freshness should be verified as updates ceased in January 2024.
• Row count is unknown, which may limit suitability assessment for large-scale analysis.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

data.cityofnewyork.us, likely from the New York City Office of Management and Budget (OMB).

Collection Method

Collected as part of the city's capital commitment planning process.

Time Range

Temporal coverage is not explicitly stated, but data reflects capital plans updated until January 2024.

Freshness

Update frequency was three times a year (Preliminary, Executive, Adopted plans). Updates ceased in January 2024.

Geography

Spatial coverage is New York City, indicated by the BORO column and organization.