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

Public Design Commission Monthly Design Review

tfrc-rjtrHousing & Development10 columns
List of projects that were reviewed by the Public Design Commission on a monthly basis.
View on NYC Open Data↗

Quality

A95.9 / 100

From a 500-row sample across 10 columns.

completeness100/ 25% weight
consistency85/ 20% weight
accuracy100/ 20% weight
timeliness93/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Property Data (Buildings Information System) - Now Retired0.30
  • Capital Project Schedules and Budgets0.30
  • Active Projects - Public Buildings (Historical)0.30
    joins onproject_id
  • Upcoming contracts to be awarded (CIP)0.28
  • Public Design Commission Outdoor Public Art Inventory0.28
    joins ontitleborough
  • NYCHA Residential Addresses0.27
    joins onborough

Geography

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

Sample rows

dateproject_idtitleboroughlevel_of_reviewagencycertificate_numberpublic_privateactionproject_type
2026-06-22T00:00:00.00024954Rehabilitation of the Harlem Railroad North Siphon Chamber and adjacent site work, Upper Catskill Aqueduct, adjacent to Saw Mill River Parkway, Westchester CountyUpstatePreliminary and FinalDEP30419PublicCalendared for ConsentArchitecture
2026-06-22T00:00:00.00024717

Columns

10 queryable · 10 profiled

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

FieldTypeDescriptionNullValues
datedatetimeThe Commission meeting date on which the project was reviewed0%2020-03-30T00:00:00.0002020-04-20T00:00:00.0002018-05-14T00:00:00.000
project_idintegerUnique identifier for an individual project0%215162212622602
titletextName assigned to an individual project including the construction type, scope and location0%Reconstruction of the 21…Construction of a recrea…Removal of Upright (1992…
boroughcategorical

Query this from your own app

GET /api/datasets/tfrc-rjtr
GET /api/datasets/tfrc-rjtr/quality
GET /api/datasets/tfrc-rjtr/related
GET /api/columns?dataset=tfrc-rjtr
Active Projects - Infrastructure (Historical)0.27
joins onproject_id
  • DOB Stalled Construction Sites0.27
    • Modifications to the installation of an interim sally port and bail payment center, Manhattan Detention Complex, 100 Centre Street, Manhattan
    Manhattan
    Amended Final
    DDC/DOC
    30414
    Public
    Calendared for Consent
    Architecture
    2026-06-22T00:00:00.00024793Construction of a reading garden and installation of an ADA ramp, Forest Hills Library, 108-19 71st Avenue, Forest Hills, QueensQueensPreliminaryDDC/QPL30416PublicCalendared for ConsentLandscape architecture
    2026-06-22T00:00:00.00024953Rehabilitation of the Croton Lake Downtake Chamber and adjacent site work, Upper Catskill Aqueduct, 985 Chapman Road, Westchester CountyUpstatePreliminary and FinalDEP30418PublicCalendared for ConsentArchitecture
    2026-06-22T00:00:00.00024950Modifications to the installation of Urban Poet by Alexandre Arrechea, Atlantic Avenue median between Conduit Boulevard and Fountain Avenue, BrooklynBrooklynAmended PreliminaryDCLA%/DDC/DOT30412PublicCalendared for ConsentArchitecture
    2026-06-22T00:00:00.00024951Construction of a pavilion, Queens Botanical Garden, 43-50 Main Street, Elder Avenue between 134th Street and 136th Street, Flushing, QueensQueensFinalDCLA/DPR30413Public and PrivateCalendared for ConsentArchitecture
    2026-06-22T00:00:00.00024949Construction of carport structures and installation of photovoltaic panels, the Brooklyn Museum, 200 Eastern Parkway, BrooklynBrooklynPreliminaryDCLA30411Public and PrivateCalendared for ConsentArchitecture
    2026-06-22T00:00:00.00024993Reconstruction of the Queens Detention Complex, 126-02 82nd Avenue, Kew Gardens, QueensQueensFinalDDC/DOT30415PublicCalendared for ConsentArchitecture
    2026-06-22T00:00:00.00024952Reconstruction of an office building for use as DEP Police 7th Precinct, 750 McLean Avenue, Yonkers, Westchester CountyUpstateFinalDEP30417PublicCalendared for ConsentArchitecture
    2026-06-22T00:00:00.00024955Rehabilitation of the Hunter Brook North Siphon Chamber and adjacent site work, Upper Catskill Aqueduct, adjacent to Jacob Road and Hunter Brook Road, Westchester CountyUpstatePreliminary and FinalDEP30420PublicCalendared for ConsentArchitecture
    General location of a project in New York City.
    0%
    BrooklynManhattanQueensof 10
    level_of_reviewcategoricalThe stage of design development at which the project was submitted for review0%Preliminary and FinalPreliminaryFinalof 8
    agencytextThe City agency or agencies that have jurisdiction over the property on which the project is located0%DPRDOTEDC
    certificate_numberintegerThe number assigned to a certificate0%284982850128504
    public_privatecategoricalIndicates if the project is open to the public or a private structure(s) that extends over City-owned land0%PublicPublic and PrivatePrivateof 4
    actioncategoricalIndicates whether a project was calendared for consent or public hearing.0%Calendared for ConsentDelegation ApprovalCalendared for Public He…of 4
    project_typecategoricalThe major category that the project falls under0%Landscape architectureArchitectureBuilding systems & Modif…of 11