Street and Highway Capital Reconstruction Projects - Intersection

Source Metadata

name Street and Highway Capital Reconstruction Projects - Intersection
description This data is a spatial representation of street construction projects. Street and Highway capital projects are major street reconstruction projects, ranging from general street resurfacing projects to full reconstruction of the roadbed, sidewalks, sewer and water pipes and other utilities. Capital projects are essential to keep the City's infrastructure in a state of good repair.
attribution Department of Transportation (DOT)
id 97nd-ff3i
assetType dataset
category Transportation
createdAt 2021-05-05 21:35:02
provenance official
rowsUpdatedAt 2025-12-01 14:57:05
Columns
Name Data Type Description Field Name
the_geom multipoint the_geom
ProjectID number A unique number assigned to identify a capital project. projectid
ProjTitle text The full title of the capital project. projtitle
FMSID text The unique budget code assigned to the capital project in the citywide Financial Management System (FMS). fmsid
FMSAgencyID number The three number citywide Financial Management System (FMS) agency code. fmsagencyi
LeadAgency text The primary agency leading the capital project in three letter acronym. leadagency
Managing Agency number The agency that manages the project in three letter acronym. managingag
ProjectDescription text The description of the capital project. projectdes
ProjectTypeCode text The three letter code that identifies the type of work being performed. projecttyp
ProjectType text The full description on the type of work that is being performed for the capital project. projectt_1
ProjectStatus text The current status of the capital project. projectsta
ConstructionFY number The fiscal year of the capital project. constructi
DesignStartDate calendar_date The date the design phase of the capital project starts. designstar
ConstructionEndDate calendar_date The date the project will be completed. construc_2
CurrentFunding number Estimated current funding allocated for this capital project. currentfun
ProjectCost number Estimated cost of the capital project. projectcos
OversallScope text Overall brief description of the capital projects. overallsco
SafetyScope text Brief description for a safety related capital projects. safetyscop
OtherScope text Brief description for any other capital projects. otherscope
ProjectJustification text The reason for the initiation of the project. projectjus
OnStreetName text The street where the capital project is taking place. onstreetna
FromStreetName text The nearest cross street from where the capital project is taking place. fromstreet
ToStreetName text The nearest cross street to where the capital project is taking place. tostreetna
BoroughName text The New York City borough where the project would take place. boroughnam
OFTCode text A 18 digit code consisting of three 6-digit street codes representing On-From-To streets as returned by GeoSupport functions. oftcode
DesignFY number The fiscal year in which the design was initiated. designfy
Latitude number latitude
Longitude number longitude
x text x
y text y

Databook Transformation

Normalized Fields LeadAgency, FMSID
Next Update Scheduled
Activity
Source Data Last Updated 2025-12-01 14:57:05
Transformed Data Last Updated
Columns Added Calculating...
Added Column Names Calculating...

Data Previews

Loading data...