From a 500-row sample across 35 columns.
project_idHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| project_id | project_name | project_brief | project_status | public_status | ulurp_non | ulurp_numbers | primary_applicant | applicant_type | borough | community_district | certified_referred |
|---|---|---|---|---|---|---|---|---|---|---|---|
| P1977X0531 | SAY CHEESE | CONSENT-UNENCL SIDEWALK CAFE | Complete | Completed | ULURP | C770207TCX | DECUFFA, R & COHAN, M | Private | Bronx | X10 | 1977-08-08T00:00:00.000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
project_id | text | Unique internal application identifier. | 0% | P1981M0059P1983K1019P1985M0922 |
project_name | text | Name of application/project provided by the applicant. | 7% | C-O-PDISPOSITION OF CITY-OWNE…SALE OF CITY-OWNED PROPE… |
project_brief | text | Description of the application and the development it will facilitate. | 2% | DISPOSITION OF CITY-OWNE…LDAUNRESTRICTED DISPOSITION… |
project_status | categorical | This indicates whether the application is actively being worked on or not. | 0% |
GET /api/datasets/hgx4-8ukb GET /api/datasets/hgx4-8ukb/quality GET /api/datasets/hgx4-8ukb/related GET /api/columns?dataset=hgx4-8ukb
project_namecommunity_districtborough| 2026X0354 | 2 Ploughmans Bush SNAD | A SNAD Certification (ZR 105-41) to facilitate the construction of a deck on an existing Single family dwelling, is being sought by the private applicant, represented by Michael Goldblum Building Studio Architects, at 2 Ploughmans Bush in Riverdale, Community District 8, the Bronx. | Active | Filed | Non-ULURP | — | Michael Goldblum | Private | Bronx | X08 | — |
| P1984Y1090 | — | — | Withdrawn-Other | Completed | — | — | Unknown | — | Citywide | — | 2011-01-31T00:00:00.000 |
| P1981Q0478 | 107-06 150TH ST | LDA | Withdrawn-Other | Completed | ULURP | — | HPD | Other Public Agency | Queens | Q12 | 1981-05-26T00:00:00.000 |
| 2026M0366 | 301 E 71st Street Transit Easement Certification | A private application by 301 East 71 Investors LLC seeking a joint certification by the City Planning Commission and the Metropolitan Transportation Authority pursuant to ZR Section 95-041 to determine whether a transit easement volume is required for a zoning lot located at 301 East 71st Street in Manhattan Community District 8. | Active | Filed | Non-ULURP | N260302ZCM | 301 East 71 Investors LLC | Private | Manhattan | M08 | — |
| 2026M0312 | 460 Tenth Avenue DIB Certification | A Chairperson certification pursuant to Section 93-31 of the Zoning Resolution to increase the maximum permitted FAR on the zoning lot consisting of Lots 66, 67, 68 and 70 on Manhattan Block 733 from 6.5 to 13.0 through a contribution to the Special Hudson Yards District Improvement Fund, is being sought by private applicant Sherwood 36 Associates, L.P. in connection with the development of a mixed use building at 460 Tenth Avenue in Hudson Yards, Community District 4, Manhattan. | Active | Completed | ULURP | 260266ZCM | Jonathan Snider | Private | Manhattan | M04 | 2026-03-23T00:00:00.000 |
| 2026M0432 | 31 West 52nd Street - Fogo de Chao OAC Renewal | This is a private application by Fogo de Chao W. 53rd Street requesting a chair certification pursuant to 37-73(c) to facilitate an open air café at 31 W. 52nd Street in Midtown, Manhattan CD 5. This will be the 3rd renewal, 4th Term. | Active | Filed | Non-ULURP | N260368ZCM; 260369LDM | Shaneka Lee | Private | Manhattan | M05 | — |
| P1977Q0013 | FOREST HILLS,DITMARS BLVD | MODIFICATION TO BUS ROUTE, Q23 | Withdrawn-Other | Completed | ULURP | — | TRIBORO COACH CORP | Private | Queens | Q05,Q06 | 1977-01-17T00:00:00.000 |
| P1985K0400 | DISPOSITION OF CITY-OWNED PROPERTY | DISPOSITION OF CITY-OWNED PROPERTY, 8 PARCELS | Complete | Completed | ULURP | C850424PPK | DRP | Other Public Agency | Brooklyn | K03 | 1985-02-19T00:00:00.000 |
| P1985K0402 | 426,640,798 GLENMORE AVE. | DISPOSITION OF CITY-OWNED PROPERTY, 5 PARCELS | Complete | Completed | ULURP | C850426PPK | DRP | Other Public Agency | Brooklyn | K05 | 1985-02-19T00:00:00.000 |
Showing 12 of 28 columns. All of them are listed below.
CompleteWithdrawn-OtherTerminatedof 7 |
public_status | categorical | The public status of the application. | 0% | CompletedFiledIn Public Reviewof 4 |
ulurp_non | categorical | Flag that indicates if a project is subject to ULURP or not. Applications can either follow the Uniform Land Use Review Procedure (ULURP) or are designated as Non-ULURP, and are therefore not restricted to ULURP rules and timing. | 7% | Non-ULURPULURPELURPof 3 |
actions | text | The type of action(s) included in the application. There may be multiple land use actions attached to an application to facilitate a single development. Many action types on historical applications are retired. | 95% | ZM; ZRZCRC |
ulurp_numbers | text | The ULURP number is a unique identifier for each application's action. The first 2-characters (number) are the fiscal year the application was filed, followed by 4-character unique number, if an application was modified it will be followed by a 1-character (letter), followed by 2-character (letter) action code, followed by a 1-character (letter) borough code. | 15% | C870526HAKN860877TCMN040031ZCM |
ceqr_type | categorical | Indicates the type of environmental review | 90% | Type IIUnlistedType Iof 4 |
ceqr_number | text | Unique environmental review identifier | 70% | 81-040R82-248K03DCP031M |
eas_eis | categorical | Flag that indicates the environmental review document issued. Environmental Assessment Statement (EAS), Environmental Impact Statement (EIS), Technical Memorandum (Tech Memo) | 97% | EASEISTech Memoof 3 |
ceqr_leadagency | text | The agency responsible for determining if an environmental review is required. | 85% | DCPHPDLPC |
primary_applicant | text | Name of the project's primary applicant. | 0% | DRPHPDLPC |
applicant_type | categorical | Indicates if the applicant is a private or public entity. | 6% | PrivateOther Public AgencyDCPof 3 |
borough | categorical | Borough that is affected by the land use application. | 0% | ManhattanStaten IslandBrooklynof 6 |
community_district | text | Community District(s) associated to the project | 6% | R03M02M08 |
cc_district | integer | City Council District(s) associated to the project | 95% | 51350 |
flood_zone_a | categorical | Flag that indicates if project is in the 1% annual chance floodplain. Areas subject to the 1% annual chance flood (100 year flood) and are considered high-risk. | 87% | falsetrueof 2 |
flood_zone_shadedx | categorical | Flag that indicates if project is in the 0.2% annual chance floodplain. Areas subject to the 0.2% annual chance flood (500 year flood) and are considered moderate-risk. | 87% | falsetrueof 2 |
current_milestone | text | The current milestone related to the review of a land use application | 94% | EAS - Project CompletedRC - Project CompletedZC - Project Completed |
current_milestone_date | datetime | The start date of the current milestone related to the review of a land use application | 94% | 2022-10-11T00:00:00.0002019-06-05T00:00:00.0002019-09-30T00:00:00.000 |
current_envmilestone | text | The current milestone related to the CEQR/environmental review of an application. | 99% | EAS - Review Filed EASEAS - Prepare Filed EASEIS - Prepare and Review… |
current_envmilestone_date | datetime | The start date of the current milestone related to the CEQR/environmental review of an application. | 99% | 2026-04-30T00:00:00.0002026-05-28T00:00:00.0002023-10-27T00:00:00.000 |
app_filed_date | datetime | The date an application(s) was filed with the Department of City Planning (DCP) | 96% | 2018-05-04T00:00:00.0002018-05-15T00:00:00.0002018-06-04T00:00:00.000 |
noticed_date | datetime | The date notice was given that an application will certify no sooner than 30 days per the City Charter requirement. This only applies to ULURP projects. | 99% | 2020-08-14T00:00:00.0002020-10-02T00:00:00.0002026-06-26T00:00:00.000 |
certified_referred | datetime | The date an application was certified or referred. This is also the official start of the ULURP process. | 3% | 2011-01-31T00:00:00.0001982-05-18T00:00:00.0001991-11-13T00:00:00.000 |
approval_date | datetime | The date an application was approved. | 97% | 2024-08-15T00:00:00.0002026-02-24T00:00:00.0002021-12-15T00:00:00.000 |
completed_date | datetime | The date the application processing was completed. | 9% | 1982-05-18T00:00:00.0001991-11-13T00:00:00.0001983-04-28T00:00:00.000 |
mih_flag | categorical | Flag that indicates if Mandatory Inclusionary Housing (MIH) is proposed to be mapped through an amendment to the Zoning Resolution. | 95% | falsetrueof 2 |
mih_option1 | categorical | Flag that indicates MIH Option 1 is proposed to be mapped (25% Units/60% AMI) | 95% | falsetrueof 2 |
mih_option2 | categorical | Flag that indicates MIH Option 2 is proposed to be mapped (30% Units/80% AMI) | 95% | FalseTrueof 2 |
mih_workforce | categorical | Flag that indicates the MIH Workforce option is proposed to be mapped (30% Units/115% AMI) | 95% | falsetrueof 2 |
mih_deepaffordability | categorical | Flag that indicates the MIH Deep Affordability option is proposed to be mapped (20% Units/40% AMI) | 95% | falsetrueof 2 |
mih_mapped_no_res | categorical | Flag that indicates Mandatory Inclusionary Housing (MIH) is proposed to be mapped, but no residential units are proposed | 100% | falsetrueof 2 |
dcp_visibility | text | — | 0% | General Publicof 1 |