Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Capital Projects Database (CPDB) - Projects (Points)

h2ic-zdwsCity Government52 columns
The Capital Projects Database reports information at the project level on discrete capital investments from the Capital Commitment Plan.Each row is uniquely identified by its Financial Management Service (FMS) ID, and contains data pertaining to the sponsoring and managing agency. To explore the data, please visit Capital Planning Explorer For additional information, please visit A Guide to The Capital Budget All previously released versions of this data are available on the DCP Website: BYTES of the BIG APPLE . Current version: 26exec
View on NYC Open Data↗

Quality

B89.4 / 100

From a 500-row sample across 52 columns.

completeness100/ 25% weight
consistency58/ 20% weight
accuracy92/ 20% weight
timeliness96/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Capital Projects Database (CPDB) - Projects (Polygons)0.96
    joins onccpversionspent_ccnonexemptspent_ccexempt+49
  • Capital Projects Database (CPDB) - Projects0.88
    joins onccpversionspent_ccnonexemptspent_ccexempt+41

Geography

Mappable — Socrata point column `the_geom`.

Open on the map →

Sample rows

ccpversionmaprojidmagencyacromagencymagencynamedescriptionprojectidmindatemaxdatetypecategoryplannedcommit_ccnonexemptplannedcommit_ccexempt
fisa_2026037LNCA13AGLNYPL037New York Public LibraryAGUILAR - Technology UpgradesLNCA13AGL2027-06-01T00:00:00.0002027-06-01T00:00:00.000ITT, Vehicles, and Equipment0.00.0

Columns

52 queryable · 51 profiled

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

FieldTypeDescriptionNullValues
ccpversiontextReports the version of the Capital Commitment Plan which the record is based on.0%fisa_2026of 1
maprojidtextUnique identifier that defines a discrete project. The maprojid is a concatenation of magency and projectid and it is the primary key.0%846P-201STRN846P-1OWEND2846P-3PAVRSP
magencyacrotextCommon acronym of the city agency managing the project. This value is derived from the three digit managing agency code.0%DPRDDCDOT
magencytextThree digit code of the distinct City agency managing the project. The managing agency is the agency overseeing the construction or implementation of a project.0%

Query this from your own app

GET /api/datasets/h2ic-zdws
GET /api/datasets/h2ic-zdws/quality
GET /api/datasets/h2ic-zdws/related
GET /api/columns?dataset=h2ic-zdws
  • Capital Projects Database (CPDB) - Commitments0.59
    joins onccpversionmaprojidmagency+1
  • Revenue Budget & Financial Plan--Qtr10.31
  • Mayor's Management Report Spending and Budget0.30
  • Expense Financial Plan - Qtr10.29
  • Parking Violations Issued - Fiscal Year 20270.29
  • Primary Land Use Tax Lot Output (PLUTO)0.29
    • fisa_2026846P-411C567DPR846Department of Parks and RecreationUdall's Cove Land AcquisitionP-411C5672010-04-21T00:00:00.0002030-06-01T00:00:00.000Fixed Asset4540000.0
    fisa_2026068JJZROSSLBACS068Administration for Children's ServicesTHE CROSSROADS JUVENILE CENTER - LIBRARY RENOVATIONJJZROSSLB2013-11-27T00:00:00.0002033-06-01T00:00:00.000Fixed Asset1000000.0
    fisa_2026068LUCILLEACS068Administration for Children's ServicesLucille Rose Day Care and Rockaway HeadStartLUCILLE2030-06-01T00:00:00.0002030-06-01T00:00:00.000Fixed Asset570000.0
    fisa_2026039LQD122MV1QPL039Queens Borough Public LibraryMIDDLE VILLAGE - New Site AcquisitionLQD122MV12027-06-01T00:00:00.0002027-06-01T00:00:00.000Fixed Asset1000000.0
    fisa_2026039LQMTGRMSQPL039Queens Borough Public LibraryBRIARWOOD, KGH, POMONOK, AND HILLCRESTLQMTGRMS2027-06-01T00:00:00.0002027-06-01T00:00:00.000—0.00.0
    fisa_2026850LBM16GSFCDDC850Department of Design and ConstructionGRAVESEND FACADE REHABLBM16GSFC2017-12-13T00:00:00.0002029-06-01T00:00:00.000Fixed Asset6430000.0
    fisa_2026850PV354BETTDDC850Department of Design and ConstructionRTC - Roundabout Theatre Co. - AA Theatre Comp. BettermentPV354BETT2025-07-01T00:00:00.0002026-07-01T00:00:00.000Fixed Asset110840000.0
    fisa_2026856WD77STARDCAS856Department of Citywide Administrative ServicesSTAR ENGINEERING LABWD77STAR2029-06-01T00:00:00.0002029-06-01T00:00:00.000ITT, Vehicles, and Equipment3500000.0
    fisa_2026039LQLARSCARQPL039Queens Borough Public LibraryLAURELTON AND ROSEDALE COMPUTER CARTSLQLARSCAR2028-06-01T00:00:00.0002028-06-01T00:00:00.000ITT, Vehicles, and Equipment0.00.0

    Showing 12 of 52 columns. All of them are listed below.

    846850841
    magencynametextCommon name for the city agency mananging the project. This value is derived from the three digit managing agency code.0%Department of Parks and …Department of Design and…Department of Transporta…
    descriptiontextShort description of the project as described by the sponsor agency. If one projectid had many descriptions the longest description is reported by CPDB.0%FUEL TANK REPLACEMENTInterfaith Medical Cente…ODA PRIMARY HEALTH CARE …
    projectidtextAlphanumeric code created by the sponsor agency that identifies a distinct project. A Project ID must be unique within a managing agency.0%P-213CNTRP-412P157P-218MPNC
    mindatedatetimeThe earliest panned commitment date associated with the project.0%2026-06-01T00:00:00.0002027-06-01T00:00:00.0002029-06-01T00:00:00.000
    maxdatedatetimeThe latest panned commitment date associated with the project.0%2033-06-01T00:00:00.0002030-06-01T00:00:00.0002026-06-01T00:00:00.000
    typecategorycategoricalClassification given by DCP based on keywords found in the short description describing if a projects is Fixed Asset, Lump Sum, or ITT, Vehicles, and Equipment.5%Fixed AssetITT, Vehicles, and Equip…Lump Sumof 3
    plannedcommit_ccnonexemptintegerSum of City Cost (Non-Exempt) funding across all commitments associated with the project.0%0.05000001000
    plannedcommit_ccexemptintegerSum of City Cost (Exempt) funding across all commitments associated with the project.0%0.011509800010948000
    plannedcommit_citycostintegerSum of City funding across all commitments associated with the project.0%0.05000001000
    plannedcommit_nccstateintegerSum of State funding across all commitments associated with the project.0%0.01000000500000
    plannedcommit_nccfederalintegerSum of Federal funding across all commitments associated with the project.0%0.0277590009000
    plannedcommit_nccotherintegerSum of Other funding across all commitments associated with the project.0%0.050000088000
    plannedcommit_noncitycostintegerSum of Non-City funding across all commitments associated with the project.0%0.05000001000000
    plannedcommit_totalintegerSum of City Cost and Non-City Cost, which reports the total planned commitments for the project allocated in the Capital Commitment Plan.0%0.05000001000
    adopt_ccnonexemptintegerSum of City adopted funding (Non-Exempt) associated with the project within in the City's budget.0%0.05000001000000
    adopt_ccexemptintegerSum of City adopted funding (Exempt) with the project within in the City's budget.0%0.01000000514000
    adopt_citycostintegerSum of City adopted funding associated with the project within in the City's budget.0%0.05000001000000
    adopt_nccstateintegerSum of State adopted funding associated with the project within in the City's budget.0%0.01000000500000
    adopt_nccfederalintegerSum of Federal adopted funding associated with the project within in the City's budget.0%0.0277590009000000
    adopt_nccotherintegerSum of Other adopted funding associated with the project within in the City's budget.0%0.05000002000000
    adopt_noncitycostintegerSum of Non-City adopted funding associated with the project within in the City's budget.0%0.01000000500000
    adopt_totalintegerSum of of the total adopted funding associated with the project within the City's budget.0%0.05000001000000
    allocate_ccnonexemptintegerSum of City allocated funding (Non-Exempt) associated with the project within in the City's budget.0%0.05000001000000
    allocate_ccexemptfloatSum of City allocated funding (Exempt) with the project within in the City's budget.0%0.010000001.0
    allocate_citycostintegerSum of City allocated funding associated with the project within in the City's budget.0%0.05000001000000
    allocate_nccstatefloatSum of State allocated funding associated with the project within in the City's budget.0%0.05000001000000
    allocate_nccfederalfloatSum of Federal allocated funding associated with the project within in the City's budget.0%0.027759000200.0
    allocate_nccotherfloatSum of Other allocated funding associated with the project within in the City's budget.0%0.05000002000
    allocate_noncitycostfloatSum of Non-City allocated funding associated with the project within in the City's budget.0%0.050000027759000
    allocate_totalintegerSum of of the total allocated funding associated with the project within the City's budget.0%0.05000001000000
    commit_ccnonexemptfloatSum of City committed funding (Non-Exempt) associated with the project within in the City's budget.0%0.00.02100000
    commit_ccexemptfloatSum of City committed funding (Exempt) with the project within in the City's budget.0%0.041562660.52236719.59
    commit_citycostfloatSum of City committed funding associated with the project within in the City's budget.0%0.00.02100000
    commit_nccstatefloatSum of State committed funding associated with the project within in the City's budget.0%0.05758227.0118529.78
    commit_nccfederalfloatSum of Federal committed funding associated with the project within in the City's budget.0%0.054353.03487868.12
    commit_nccothercategoricalSum of Other committed funding associated with the project within in the City's budget.0%0.037344.52937101.68of 15
    commit_noncitycostfloatSum of Non-City committed funding associated with the project within in the City's budget.0%0.00.0117500
    commit_totalfloatSum of of the total committed funding associated with the project within the City's budget.0%0.00.02100000
    spent_ccnonexemptfloatSum of City funding spent (Non-Exempt) associated with the project within in the City's budget.0%0.01000002000000
    spent_ccexemptfloatSum of City funding spent (Exempt) with the project within in the City's budget.0%0.0100000024633.16
    spent_citycostfloatSum of City funding spent associated with the project within in the City's budget.0%0.01000002000000
    spent_nccstatefloatSum of State funding spent associated with the project within in the City's budget.0%0.01000000500000
    spent_nccfederalfloatSum of Federal funding spent associated with the project within in the City's budget.0%0.02123128.581271422.73
    spent_nccotherfloatSum of Other funding spent associated with the project within in the City's budget.0%0.05000002000000
    spent_noncitycostfloatSum of Non-City funding spent associated with the project within in the City's budget.0%0.01000000500000
    spent_totalfloatSum of of the total funding spent associated with the project within the City's budget.0%0.0100000200000
    spent_total_checkbooknycfloatSum of check values from Checkbook NYC associated with the project.0%0.017000001210735.09
    the_geomcoordinateSpatial data for the project.——