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

Street and Highway Capital Reconstruction Projects - Intersection

97nd-ff3iTransportation30 columns
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.
View on NYC Open Data↗

Quality

A90.1 / 100

From a 500-row sample across 29 columns.

completeness90/ 25% weight
consistency79/ 20% weight
accuracy94/ 20% weight
timeliness99/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Street and Highway Capital Reconstruction Projects - Block0.87
    joins onprojectcosconstruc_2oftcode+23
  • Street Construction Inspections and Corrective Action Requests0.34
  • Street Construction Permits (2022 - Present)0.33
    joins onoftcode
  • Street Seats (2021 - 2024)0.32
    joins onlatitudelongitude
  • Parking Regulation Locations and Signs0.32

Geography

Mappable — Socrata point column `the_geom`.

Open on the map →

Sample rows

the_geomprojectidprojtitlefmsidfmsagencyileadagencymanagingagprojecttypprojectt_1projectstaconstructicurrentfun
{"type":"MultiPoint","coordinates":[[-74.03084507407647,40.61669948866578]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0

Columns

30 queryable · 29 profiled

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

FieldTypeDescriptionNullValues
the_geomcoordinate———
projectidintegerA unique number assigned to identify a capital project.0%606636185962290
projtitletextThe full title of the capital project.0%DIST WATER MAIN REPLACEM…New WM, trunk main ext, …Safe Routes to Schools
fmsidtextThe unique budget code assigned to the capital project in the citywide Financial Management System (FMS).0%QED-1005QED-991HWPR17Q

Query this from your own app

GET /api/datasets/97nd-ff3i
GET /api/datasets/97nd-ff3i/quality
GET /api/datasets/97nd-ff3i/related
GET /api/columns?dataset=97nd-ff3i
Street Sign Work Orders0.31
  • Street Seats (2014 - 2019)0.31
    joins onlatitudelongitude
  • Sidewalk Management Database - Violations0.30
    • {"type":"MultiPoint","coordinates":[[-74.02984260201036,40.619153816274704]]}
    299
    Distribution water mains in 4 AVe from 80th St to 94th Street
    BED-774
    826
    DEP
    3
    SEW
    DEP SEWER PROJECTS
    Completed Project
    2004
    132780.0
    {"type":"MultiPoint","coordinates":[[-74.02626315462682,40.62791995677246]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    NaN, NaN299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    {"type":"MultiPoint","coordinates":[[-74.02743725022025,40.62502760893534]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    {"type":"MultiPoint","coordinates":[[-74.03017406733534,40.61834033359506]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    {"type":"MultiPoint","coordinates":[[-74.03122817467904,40.61572295135896]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    {"type":"MultiPoint","coordinates":[[-74.02835031631533,40.622798627093026]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    NaN, NaN299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0
    {"type":"MultiPoint","coordinates":[[-74.02656062888789,40.627187181417405]]}299Distribution water mains in 4 AVe from 80th St to 94th StreetBED-774826DEP3SEWDEP SEWER PROJECTSCompleted Project2004132780.0

    Showing 12 of 23 columns. All of them are listed below.

    fmsagencyi
    categorical
    The three number citywide Financial Management System (FMS) agency code.
    0%
    826841850of 7
    leadagencycategoricalThe primary agency leading the capital project in three letter acronym.0%DEPDOTDDCof 6
    managingagcategoricalThe agency that manages the project in three letter acronym.0%301of 7
    projectdestextThe description of the capital project.3%WAT4R MAIN INSTALLATIONNEW TRUNK & WATER MAIN I…Rehabilitation (repair a…
    projecttypcategoricalThe three letter code that identifies the type of work being performed.1%RECSEWWATof 10
    projectt_1categoricalThe full description on the type of work that is being performed for the capital project.1%CAPITAL RECONSTRUCTIONDEP SEWER PROJECTSDEP - WATER PROJECTSof 10
    projectstacategoricalThe current status of the capital project.0%Completed ProjectSubstantial CompletionFinal Completionof 3
    constructiintegerThe fiscal year of the capital project.0%201720162015
    designstartextThe date the design phase of the capital project starts.73%2016/05/25 00:00:002009/06/02 00:00:002012/07/30 00:00:00
    construc_2textThe date the project will be completed.71%2020/02/28 00:00:002020/10/09 00:00:002013/11/27 00:00:00
    currentfunintegerEstimated current funding allocated for this capital project.0%1.00.0198378.0
    projectcosintegerEstimated cost of the capital project.0%1.0198378.00.0
    overallscocategoricalOverall brief description of the capital projects.39%General RoadwaySidewalk (Standalone)General Roadway,Sidewalk…of 13
    safetyscoptextBrief description for a safety related capital projects.76%Curb ExtensionsBus Bulb,Curb Extensions…Curb Extensions,Plaza
    otherscopecategoricalBrief description for any other capital projects.76%Localized FloodingGreen OpportunitiesSIP Buildoutof 18
    projectjustextThe reason for the initiation of the project.72%The Nostrand Avenue Sele…Construction of this pro…Replacement of 8" and 12…
    onstreetnatextThe street where the capital project is taking place.0%BROADWAYBEND3 AVENUE
    fromstreettextThe nearest cross street from where the capital project is taking place.0%NOSTRAND AVENUEROCKAWAY BEACH BOULEVARDNYCTA SUBWAY
    tostreetnatextThe nearest cross street to where the capital project is taking place.100%—
    boroughnamcategoricalThe New York City borough where the project would take place.0%QUEENSBROOKLYNSTATEN ISLANDof 5
    oftcodetextA 18 digit code consisting of three 6-digit street codes representing On-From-To streets as returned by GeoSupport functions.0%331230347630000000305280315180000000110710115210000000
    designfyintegerThe fiscal year in which the design was initiated.0%020032011
    latitudefloat—0%40.706942738945840.681519176860740.7336325085628
    longitudefloat—0%-73.9832643447638-73.9177366290748-73.9192216263568
    xcoordinate—0%988891.7626861331007057.676813561006964.05167273
    ycoordinate—0%196845.495794475187572.676741734187802.14773947