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

Active Projects - Infrastructure (Historical)

rukc-mmquHousing & Development9 columns
List of currently active infrastructure projects including description and high level schedule and budget range.
View on NYC Open Data↗

Quality

B80.9 / 100

From a 340-row sample across 9 columns.

completeness100/ 25% weight
consistency94/ 20% weight
accuracy100/ 20% weight
timeliness0/ 15% weight
usability85/ 20% weight
  • · No obvious temporal column — limits time-series joins

Related datasets

  • DOB Stalled Construction Sites0.34
  • Capital Project Schedules and Budgets0.31
  • Upcoming contracts to be awarded (CIP)0.31
  • Property Data (Buildings Information System) - Now Retired0.27
  • Historical DOB Permit Issuance0.27
  • Buildings Selected for the Alternative Enforcement Program (AEP)0.26
  • Affordable Housing Production by Project0.26
    joins onproject_id

Sample rows

project_iddescriptionclient_agencydivisionphaseprojected_construction_completionscopedollar_amountstatus
HWK700BReconstruction of Columbia Street Area Phase II (BED-768B)TRANSPORTATIONInfrastructureDesign2024-07-14T00:00:00.000RECONSTRUCTION OF COLUMBIA STREET AREA PHASE II HAS BEEN DEVELOPED IN COORDINATION WITH NYCDEP BED-768B. IT INCLUDES ALL THE STREETS IN THAT PROJECT SOUTH OF HAMILTON AVE AND ALSO INCLUDES A SERIES OF STREETS IN THE NEIGHBORHOOD REQUIRING CAPITAL RECONSTRUCTION. PROPOSED WORK INCLUDES FULL RECONSTRUCTION OF SEVERAL BLOCKS ALONG WITH STREETSCAPE AND SAFETY IMPROVEMENTS AT A SERIES OF INTERSECTIONS. THE OVERALL PURPOSE OF THIS PROJECT IS TO BRING THE STREETS IN THIS AREA TO A STATE OF GOOD REPAIR IN CONJUNCTION WITH UTILITY REPLACEMENT AND TO PROVIDE SAFETY ENHANCEMENTS AT KEY LOCATIONS.

Columns

9 queryable · 9 profiled

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

FieldTypeDescriptionNullValues
project_idtextProject Identification Number0%HWK700BDOTSEQ02DOTSEQ01
descriptiontextProject description indicating type(s) and/or location(s)0%Pedestrian Ramp Rehabili…Pedestrian Ramp Rehabili…Prior Notice Sidewalks- …
client_agencycategoricalName of the agency to which a project belongs to0%TRANSPORTATIONENVIRONMENTAL PROTECTIONPARKS & RECREATIONof 6
divisiontextNature of a project / Division at DDC that is in charge of the project: e.g.) Infrastructure / Public Buildings0%

Query this from your own app

GET /api/datasets/rukc-mmqu
GET /api/datasets/rukc-mmqu/quality
GET /api/datasets/rukc-mmqu/related
GET /api/columns?dataset=rukc-mmqu
DOB Safety Violations0.26
$30M to 100M
Active
BB05-01-AGI - Cons of ROW Bioswales & Stormwwater GS in BB-005, Ph 1ENVIRONMENTAL PROTECTIONInfrastructureProcurement2021-09-15T00:00:00.000GI - CONSTRUCTION OF ROW GI IN BB-005 PHASE I IN THE QUEENS BOROUGH. CONSTRUCTION OF ROW GREEN INFRASTRUCTURE IN TRIBUTARY AREA BB005 INCLUDES BIOSWALES, GREENSTRIPS, INFILTRATION BASINS AND STORMWATER GREENSTREETS. ROW BIOSWALES ARE VEGETATED SYSTEMS THAT MANAGE STORMWATER RUNOFF BY STORING, INFILTRATING AND EVAPOTRANSPIRATION ELIMINATING IT FROM THE CITY'S COMBINED SEWER SYSTEM. CONSTRUCTION INVOLVES EXCAVATION, BACKFILL OF BROKEN STONE AND ENGINEERED SOIL, CONSTRUCTION OF CONCRETE INLETS AND OUTLETS, CONCRETE CURBS AND HEADERS, SIDEWALK AND PLANTINGS WHICH MAY INCLUDE TREES.$10M to 30MActive
P-1SAND01STARLIGHT PARK PEDESTRIAN BRIDGE (P-1PBSTAR)PARKS & RECREATIONInfrastructureConstruction2020-06-04T00:00:00.000STARLIGHT PARK - PEDESTRIAN BRIDGES, BRONX$3M to 10MActive
BB05-02-AGI - Cons of ROW Bioswales & Stormwwater GS in BB-005, Ph 2ENVIRONMENTAL PROTECTIONInfrastructureDesign2021-09-15T00:00:00.000GI - CONSTRUCTION OF ROW GI IN BB-005 PHASE 2 IN THE QUEENS BOROUGH. CONSTRUCTION OF ROW GREEN INFRASTRUCTURE IN TRIBUTARY AREA BB005 INCLUDES BIOSWALES, GREENSTRIPS, INFILTRATION BASINS AND STORMWATER GREENSTREETS. ROW BIOSWALES ARE VEGETATED SYSTEMS THAT MANAGE STORMWATER RUNOFF BY STORING, INFILTRATING AND EVAPOTRANSPIRATION ELIMINATING IT FROM THE CITY'S COMBINED SEWER SYSTEM. CONSTRUCTION INVOLVES EXCAVATION, BACKFILL OF BROKEN STONE AND ENGINEERED SOIL, CONSTRUCTION OF CONCRETE INLETS AND OUTLETS, CONCRETE CURBS AND HEADERS, SIDEWALK AND PLANTINGS WHICH MAY INCLUDE TREES.$10M to 30MActive
BED778ATrunk & Dist WM Rep in Atlantic Ave b/t Carlton & PortlandENVIRONMENTAL PROTECTIONInfrastructureProcurement2021-04-11T00:00:00.000Trunk and Distribution Water Mains Replacement in Atlantic Avenue between Carlton Avenue and Portland Avenue in the Borough of Brooklyn. Water Main (WM-6) in: 1. Atlantic Avenue from Carlton Avenue to South Portland Avenue. 2. Intersection of Atlantic Avenue and Carlton Avenue. Water Main(WM -1) in: 1. Atlantic Avenue(SS) from Carlton Avenue to South Portland Avenue 2. Intersection of Atlantic Avenue and Carlton Avenue 3. Intersection of Atlantic Avenue and Cumberland Street.$10M to 30MActive
P-1STARLPBRONX RIVER GREENWAY: STARLIGHT PARK PHASE II, STAGE 2, BXPARKS & RECREATIONInfrastructureConstruction2021-06-01T00:00:00.000BRONX RIVER GREENWAY - STARLIGHT PARK PHASE II, STAGE 2, BRONX$30M to 100MActive
BED79872" Replacement in Flatbush Avenue between Sterling Pl & 8thENVIRONMENTAL PROTECTIONInfrastructureConstruction2021-07-12T00:00:00.00072" Trunk Water Main and Combined Sewer Replacement in Flatbush Ave. between Sterling Pl. and 8th Ave., etc., Borough of Brooklyn. WM-6 in: 1. Flatbush Ave. between Park Place and 8th Ave 2. 8th Ave. between Flatbush Ave. and Lincoln Place 3. Park Place between 5th Ave. and 6th Avenue 4. St. Johns Place between 5th Ave. and 8th Ave 5. 6th Avenue between Park Place and Union Street WM-1 in: 1. Flatbush Avenue between Park Place and 8th Avenue Combined sewer in: 1. Park Place between 5th Ave. and 6th Avenue 2. St. Johns Place between 5th Ave. and Flatbush Ave. 3. 6th Avenue between Park Place and Union Street 4. 8th Ave. between St. John's Place and Lincoln Place Additional scope: Reconstruction of triangle at 8th Avenue and Flatbush Avenue removed from HWK300-01 and to be constructed under the BED-798.$30M to 100MActive
BED809Replacement of Water Mains in Avenue SENVIRONMENTAL PROTECTIONInfrastructureConstruction2021-09-21T00:00:00.000RECONSTRUCTION OF WATER MAIN IN AVENUE S, BK$10M to 30MActive
BED819WM replacement in Oriental BlvdENVIRONMENTAL PROTECTIONInfrastructureProcurement2022-07-28T00:00:00.000WATERMAIN REPLACEMENT IN ORIENTAL BLVD, BROOKLYN$30M to 100MActive
BED-827Regulator Chamber Roof ReplacementsENVIRONMENTAL PROTECTIONInfrastructureDesign2022-02-08T00:00:00.000REGULATOR CHAMBER ROOF REPLACEMENTS: BROOKLYN (5), BRONX (1). FIVE REGULATOR LOCATIONS IN BROOKLYN AND ONE REGULATOR LOCATION IN THE BRONX WILL HAVE THEIR EXISTING CONCRETE SLAB ROOFS REMOVED AND REPLACED WITH NEWLY POURED ROOFS SO THAT ACCESS COVERS ARE APPROPRIATELY CENTERED OVER DISTRIBUTION ASSETS. THIS WORK WILL INCLUDE THE DESIGN AND CONSTRUCTION OF STRUCTURAL STEEL SUPPORTING THE CONCRETE ROOFS.$1M or lessActive
Infrastructureof 1
phasecategoricalA particular stage in project process0%DesignConstructionProcurementof 6
projected_construction_completiondatetimeProjected date for the completion of a construction or a project0%2024-09-13T00:00:00.0002023-08-14T00:00:00.0002021-06-26T00:00:00.000
scopetextSimilar to or more detailed project description0%REHABILITATION (REPAIR A…RECONSTRUCTION OF EXISTI…RECONSTRUCTION OF COLUMB…
dollar_amountcategoricalRough estimate of project cost0%$3M to 10M$10M to 30M$30M to 100Mof 7
statustextSimple status of a project0%Activeof 1