From a 500-row sample across 56 columns.
boroughcoordinatesHas borough codes (`borough`) — joinable, but needs boundary shapes to draw.
| project_name | project_received_date | project_id_number_op | project_description_type | impacted_park_id_s | impacted_park_name_s | borough | multisite_project | sponsoring_agency_entity | primary_scope_of_work | impacted_parks_division_s | park_impact_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Filling of Five Bridges over Abandoned CSX Line in Melrose, Bronx | 2018-09-25T00:00:00.000 | HBX163 | Project to fill-in bridges passing over an abandoned sub-grade freight train line in the Melrose neighborhood of the Bronx. Potential work area and staging area on parks property. Potential tree impacts. | XZ79;X052;X053; | GREENSTREET;Triangle;O'Neill Triangle; | Bronx |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
project_name | text | — | 0% | Right-of-Way Green Infra…Complex Pedestrian Ramp …Right-of-Way Green Infra… |
project_received_date | datetime | — | 0% | 2017-06-23T00:00:00.0002017-06-30T00:00:00.0002020-02-13T00:00:00.000 |
project_id_number_op | text | — | 40% | M360SANDRESM1NYSDEC Site No. 224055 |
project_description_type | text | — | 0% |
GET /api/datasets/wye7-nyek GET /api/datasets/wye7-nyek/quality GET /api/datasets/wye7-nyek/related GET /api/columns?dataset=wye7-nyek
| Single Site |
| CDOT |
| Bridge Reconstruction (Major) |
| Borough Forestry;#Borough Operations;#Borough Horticulture |
| Staging;#Partial Park Closure;#Excavation;#Sidewalk Closure;#Total Park Closure |
| Red flag repairs at the Passerelle bridge | 2021-03-08T00:00:00.000 | LGA-124.431 WO14A | Red flag repairs at the Passerelle bridge | Q099; | Flushing Meadows Corona Park; | Queens | Single Site | PANYNJ | Bridge Component Rehabilitation | Borough Operations;#Capital Projects;#Legal/MOUs;#Planning and Parklands | Park Improvement;#Access-Only |
| Rehabilitation of East 169th Street, East 175th Street, and East 180th Street Bridges Over Metro North Railroad | 2016-04-08T00:00:00.000 | HBX1670; HBX1215; HBX180 | Rehabilitation of three bridges. No parkland. | — | — | Bronx | Single Site | CDOT | Bridge Component Rehabilitation | — | No Parkland Impact |
| Mobility Improvement on Northbound Bruckner Expressway | 2015-08-19T00:00:00.000 | X731.27 | Reconfiguration of expressway and parkway interchange ramps to improve traffic flow, NYSDOT running project partially on behalf of NY Thruway Authority, who asserts rights to interchange. Scope will include landscape, natural area restoration, improved bike/ped facility, and removal and restoration of grove associated with the Bronx Victory Memorial. Permanent easements will be acquired through Eminent Domain Procedure and Highway Law, technically reducing parkland by est 2.67 acres. In reality, no effective loss of parkland is anticipated. | X039;X101; | Pelham Bay Park;Hutchinson River Parkway; | Bronx | Multi Site | SDOT | Parkway/Arterial Improvement | Borough Operations;#Borough Forestry;#Central Forestry;#Landmarks/Preservation;#Arts & Antiquities;#Natural Resources Group (NRG);#Planning and Parklands;#Capital Projects;#Legal/MOUs;#CDOT Arterial Maintenance | Staging;#Excavation;#Partial Park Closure;#Park Improvement;#Other;#Loss of Property |
| Groundwater Sustainability of the Long Island Aquifer System | 2019-02-01T00:00:00.000 | LK00GHP | Installation of five deep monitoring wells for DEC-funded research to monitor Long Island's saltwater incursion to groundwater, and groundwater presence and quality, and develop a groundwater flow model. Associated with the City's long term contingency plan (circa 2002) to tap the old Jamaica Water Supply as an emergency backup in the event of the failure of the upstate surface-fed system. | Q220C;B247;B057;B058;B052;Q107;B372;Q084;Q131; | Dr. Charles R. Drew Park;Breukelen Ballfields;Marine Park;McCarren Park;Leif Ericson Park;Springfield Park;Friends Field;Grand Central Parkway;Frank Principe Park; | Queens;#Brooklyn | Multi Borough | USGS | Resiliency | Borough Operations;#Other;#Borough Forestry | Excavation;#Other;#Partial Park Closure |
| PS 26Q Exploratory Borings | 2020-12-04T00:00:00.000 | — | Exploratory borings (different contractor than original permit issued) | Q221; | Farm Playground; | Queens | Single Site | SCA | Public Building | Borough Operations;#Borough Forestry | Staging |
| Construction, Installation and Maintenance of Fencing at the Bronx Whitestone Bridge (“BWB”) | 2020-04-14T00:00:00.000 | — | Construction, Installation and Maintenance of Fencing at the Bronx Whitestone Bridge (“BWB”) | X126; | Ferry Point Park; | Bronx | Single Site | MTA B&T | Bridge Component Rehabilitation | Borough Operations;#Planning and Parklands;#Legal/MOUs;#Capital Projects | Staging |
| PS 26/ Farm Playground School Expansion | 2020-10-14T00:00:00.000 | — | Access to perform four (4) exploratory borings to facilitate the design of a proposed future school addition | Q221; | Farm Playground; | Queens | Single Site | SCA | Public Building | Borough Operations;#Borough Forestry | Other |
| Riverside Drive Viaduct over West 158th Street | 2016-12-14T00:00:00.000 | HBM1165 | Bridge rehabilitation project to rehab the Riverside Drive Viaduct from West 153rd Street to West 161st Street in Manhattan. | M140; | Recreational Area; | Manhattan | Single Site | CDOT | Bridge Component Rehabilitation | Borough Operations;#Conservancy | Staging;#Other;#Park Improvement |
| Painters Playground C/S Gas Upgrade | 2021-02-23T00:00:00.000 | — | Access and minor excavation to facilitate the upgrade of existing utilities servicing the comfort station | Q306; | The Painter's Playground; | Queens | Single Site | National Grid | — | Borough Operations;#Borough Forestry | Excavation |
Showing 12 of 45 columns. All of them are listed below.
Right-of-Way BioswalesSidewalk corner quadrant…This project will instal… |
impacted_park_id_s | text | — | 17% | Q099;M360;X039; |
impacted_park_name_s | text | — | 17% | Flushing Meadows Corona …Riverside Park;The High Line; |
address_intersection | text | — | 40% | Multi-siteMerrick Blvd and Baisley…Intersection of Along Fo… |
borough | text | — | 0% | ManhattanQueensBrooklyn |
multisite_project | categorical | — | 0% | Single SiteMulti SiteMulti Boroughof 3 |
sponsoring_agency_entity | text | — | 0% | DDCParks - Partner GroupSDOT |
primary_scope_of_work | text | — | 22% | Sewer/Water MainPark Improvement/New Par…Bridge Component Rehabil… |
impacted_parks_division_s | text | — | 17% | Borough OperationsBorough Operations;#Boro…Borough Forestry |
park_impact_type | text | — | 15% | No Parkland ImpactStagingOther |
contract_value_op | float | — | 83% | 500008000500000 |
current_phase | categorical | — | 1% | ConstructionPresumed CompleteFinal-Accepted (Closed O…of 5 |
scoping_initiated_kick_off_op | datetime | — | 99% | 2017-06-27T00:00:00.0002017-07-24T00:00:00.0002017-02-15T00:00:00.000of 7 |
scoping_response_due_date_op | datetime | — | 100% | 2017-10-13T00:00:00.000of 1 |
design_consultant_op | text | — | 96% | DewberryAECOMAKRF |
public_design_commission_approval_required | categorical | — | 89% | NoYesof 2 |
preliminary_public_design_commission_approval | datetime | — | 99% | 2010-10-15T00:00:00.0002013-11-12T00:00:00.0002015-08-03T00:00:00.000of 10 |
final_public_design_commission_approval | datetime | — | 99% | 2016-08-22T00:00:00.0002017-05-22T00:00:00.0002017-10-16T00:00:00.000of 12 |
mass_mailing_1_received_date | datetime | — | 97% | 2015-09-09T00:00:00.0002017-02-08T00:00:00.0002018-03-28T00:00:00.000 |
mass_mailing_2_received_date | datetime | — | 97% | 2006-08-04T00:00:00.0002015-07-21T00:00:00.0002016-01-21T00:00:00.000 |
mass_mailing_3_received_date | datetime | — | 98% | 2015-10-01T00:00:00.0002018-04-20T00:00:00.0002017-05-12T00:00:00.000 |
design_completion_date_op | datetime | — | 98% | 2014-07-28T00:00:00.0002016-02-07T00:00:00.0002016-07-01T00:00:00.000 |
construction_manager_op | text | — | 89% | EICREResident Engineer |
construction_manager_company_op | text | — | 91% | NYSDOTDDCDEP |
construction_kickoff_op | datetime | — | 93% | 2010-06-21T00:00:00.0002013-02-25T00:00:00.0002014-04-30T00:00:00.000 |
expected_construction_end_date_op | datetime | — | 93% | 2018-10-21T00:00:00.0002023-01-31T00:00:00.0002017-03-31T00:00:00.000 |
actual_construction_end_date_op | datetime | — | 98% | 2016-03-31T00:00:00.0002016-05-10T00:00:00.0002017-10-13T00:00:00.000 |
contractor_for_construction_permit_firm_name | text | — | 27% | Consolidated Edison Comp…National GridTBO Sitescapes |
construction_permit_request_received_date | datetime | — | 47% | 2017-03-07T00:00:00.0002016-08-25T00:00:00.0002018-03-28T00:00:00.000 |
construction_permit_id | text | — | 31% | M104.20200904M062.20180717RG.20170821 |
latest_site_visit | datetime | — | 73% | 2019-04-03T00:00:00.0002019-05-14T00:00:00.0002018-08-01T00:00:00.000 |
forestry_permit_status | categorical | — | 58% | ApprovedNot RequiredPendingof 4 |
forestry_permit_id_number | text | — | 81% | WSP103MF18FY16-405I18-003 |
construction_permit_special_conditions | text | — | 74% | N/AP-CON-C-1.0i. Occupying, using or i… |
borough_approval_date | datetime | — | 60% | 2018-04-19T00:00:00.0002019-04-24T00:00:00.0002020-09-09T00:00:00.000 |
permit_issuance_date | datetime | — | 84% | 2016-11-15T00:00:00.0002016-07-06T00:00:00.0002016-09-30T00:00:00.000 |
permit_start_date | datetime | — | 34% | 2018-07-30T00:00:00.0002018-08-20T00:00:00.0002019-05-06T00:00:00.000 |
original_permit_expiration_date | datetime | — | 33% | 2018-12-31T00:00:00.0002019-12-31T00:00:00.0002017-12-31T00:00:00.000 |
latest_permit_extension_amendment_request_date | datetime | — | 82% | 2019-12-12T00:00:00.0002020-08-27T00:00:00.0002019-10-29T00:00:00.000 |
latest_permit_extension_amendment_issuance_date | datetime | — | 81% | 2019-12-06T00:00:00.0002021-03-04T00:00:00.0002020-09-08T00:00:00.000 |
latest_permit_expiration_date | datetime | — | 70% | 2019-12-31T00:00:00.0002020-04-30T00:00:00.0002020-12-31T00:00:00.000 |
permit_amendment_content | text | — | 89% | 1) Two sites in two Quee…1. West Side Area added
…2017 May: seperate permi… |
exploratory_permit_id | text | — | 95% | CNYG.E.20200602X039.E.20181016Q099.E.20190124 |
substantial_completion_date_op | datetime | — | 94% | 2014-07-31T00:00:00.0002014-11-12T00:00:00.0002015-01-12T00:00:00.000 |
final_inspection_date | datetime | — | 94% | 2015-12-04T00:00:00.0002016-05-10T00:00:00.0002016-10-07T00:00:00.000 |
latest_inspection_site_visit | datetime | — | 93% | 2019-10-21T00:00:00.0002018-10-24T00:00:00.0002020-03-03T00:00:00.000 |
punchlist_generated | datetime | — | 96% | 2019-05-08T00:00:00.0002019-07-03T00:00:00.0002018-12-07T00:00:00.000 |
conditional_letter_issued | datetime | — | 96% | 2019-10-22T00:00:00.0002018-10-25T00:00:00.0002016-02-07T00:00:00.000 |
final_acceptance_of_park_by_borough | datetime | — | 95% | 2020-08-11T00:00:00.0002020-07-17T00:00:00.0002017-12-29T00:00:00.000 |
final_acceptance_letter_date | datetime | — | 94% | 2016-03-29T00:00:00.0002016-07-01T00:00:00.0002016-07-11T00:00:00.000 |
created | datetime | — | 0% | 2017-11-09T13:41:00.0002016-09-07T16:56:00.0002018-07-19T10:48:00.000 |
modified | datetime | — | 0% | 2019-11-05T15:29:00.0002019-11-05T15:14:00.0002019-11-05T15:11:00.000 |
coordinates | text | — | 29% | 40.723313, -73.96054640.741895,-73.98930840.831608, -73.883164 |