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

DOT In-house Street Resurfacing Projects

ffaf-8mrvTransportation21 columns
List of all New York City Department of Transportation (NYC DOT) in-house street paving and milling projects for a street block or at an intersection. For information, please the DOT website: https://www.nyc.gov/html/dot/html/motorist/resurfintro.shtml
View on NYC Open Data↗

Quality

B88.1 / 100

From a 500-row sample across 21 columns.

completeness78/ 25% weight
consistency71/ 20% weight
accuracy97/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Street Resurfacing Schedule0.53
    joins onlocation_node_idlocation_wktlocation_segment_id
  • Street Closures due to Construction Activities by Block and Intersection0.37
  • Street Closures due to Construction Activities by Intersection0.36
    joins onborough_code
  • Sidewalk Management Database - Violations0.35
  • Protected Streets Block (Dataset)0.35
  • Protected Streets Intersection (Dataset)0.35

Geography

Has borough codes (`borough_code`) — joinable, but needs boundary shapes to draw.

Sample rows

oft_codeproject_typeborough_codelocation_on_streetlocation_from_streetlocation_to_streetproject_idproject_statuslocation_community_boardlocation_actual_milling_start_datelocation_actual_milling_end_datelocation_actual_paving_start_date
439595407790407990BlockQCOLLEGE POINT BOULEVARD30 AVENUE31 AVENUEQ202507058Paving Completed4072026-07-09T00:00:00.0002026-07-09T00:00:00.000

Columns

21 queryable · 21 profiled

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

FieldTypeDescriptionNullValues
oft_codetextA unique numerical 18 digit code for the On- From- To location of the street segment.0%544900529315546520129690113113130850305280344690000000
project_typecategoricalFlags whether the street resurfacing project is for the block or intersection0%BlockIntersectionof 2
borough_codecategoricalThe borough of the street segment in one letter format.0%QBSof 5
location_on_streettextThe name of the street where the construction embargo is taking place.0%

Query this from your own app

GET /api/datasets/ffaf-8mrv
GET /api/datasets/ffaf-8mrv/quality
GET /api/datasets/ffaf-8mrv/related
GET /api/columns?dataset=ffaf-8mrv
Street and Highway Capital Reconstruction Projects - Block
0.35
  • Street Sign Work Orders0.34
    • 2026-08-04T00:00:00.000
    553000523908548550BlockSVICTORY BOULEVARDSTATEN ISLAND EXPRESSWAYSOUTH GANNON AVENUES202601006Completed Project5022026-07-20T00:00:00.0002026-07-20T00:00:00.0002026-07-22T00:00:00.000
    319630335780340930BlockBBEVERLEY ROADEAST 22 STREETFLATBUSH AVENUEB202614018Paving Completed3142026-09-08T00:00:00.0002026-09-08T00:00:00.0002026-09-24T00:00:00.000
    455590421070445290BlockQMERRICK BOULEVARD118 AVENUEFOCH BOULEVARDQ202612009Ready for Tasking412———
    333530335730340930BlockBDORCHESTER ROADEAST 21 STREETFLATBUSH AVENUEB202514018Ready for Paving3142026-09-28T00:00:00.0002026-09-28T00:00:00.000—
    314380390830000000IntersectionBAVENUE PWEST 7 STREET—B202611017Ready for Tasking311———
    119430110010110110BlockMEAST 124 STREET1 AVENUE2 AVENUEM202411018Paving Completed1112026-07-28T00:00:00.0002026-07-28T00:00:00.0002026-08-12T00:00:00.000
    463590410890459490BlockQST JAMES AVENUE51 AVENUEPOYER STREETQ202404009Paving Completed4042026-08-27T00:00:00.0002026-08-27T00:00:00.0002026-09-21T00:00:00.000
    424340451590000000IntersectionQ166 STREETJEWEL AVENUE—Q202408010Paving Completed4082026-07-13T00:00:00.0002026-07-13T00:00:00.0002026-08-04T00:00:00.000
    212550276450000000IntersectionXBENDWEST FARMS ROAD—X202502007Paving Completed2032026-07-27T00:00:00.0002026-07-27T00:00:00.0002026-08-05T00:00:00.000

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

    BENDRICHMOND ROADBROADWAY
    location_from_streettextThe closest intersection to the on street in one direction.0%BENDFOUR CORNERS ROADDEAD END
    location_to_streettextThe closest intersection to the on street in the opposite direction.31%PO THOMAS SCHIMENTI JR C…ST CLAIR PLACEBEND
    project_idtextThe unique identifier assigned to the capital project.0%S2018-02-50S2010-02-31M2005-09-10
    project_statuscategoricalThe project status.0%Completed ProjectPaving CompletedReady for Taskingof 7
    project_speed_bumpscategoricalThe street block contains a speed reducer.26%012of 9
    location_community_boardintegerThe three digit borough code and community board where the street resurfacing takes place.0%502501503
    location_actual_milling_start_datedatetimeThe actual start date for road milling.31%2019-08-09T00:00:00.0002012-08-29T00:00:00.0002014-07-23T00:00:00.000
    location_actual_milling_end_datedatetimeThe actual end date for road milling.31%2019-08-15T00:00:00.0002012-08-29T00:00:00.0002014-07-24T00:00:00.000
    location_actual_paving_start_datedatetimeThe actual start date for road paving.30%2019-08-19T00:00:00.0002012-09-12T00:00:00.0002014-07-31T00:00:00.000
    location_actual_paving_end_datedatetimeThe actual end date for road paving.11%2019-08-27T00:00:00.0002012-09-12T00:00:00.0002006-05-24T00:00:00.000
    location_actual_protect_untildatetimeThe actual date the street is protected until after street replacement.11%2024-08-27T00:00:00.0002017-09-12T00:00:00.0002011-05-24T00:00:00.000
    location_actual_lane_milesfloatThe number of lane miles paved.30%0.130.120.18
    location_actual_paving_squarefloatThe amount of square yards paved.30%100900850
    location_statuscategoricalThe project paving and milling status at the location.84%Paving CompletedReady for MillingReady for Pavingof 4
    location_segment_idintegerUnique identifier for the street block.0%011338218398
    location_wkttextA text markup language for representing vector geometry objects on a map and spatial reference systems of spatial objects.0%LINESTRING (956223.97820…LINESTRING (995131.47720…MULTIPOINT ((985298.5056…
    location_node_idtextUnique identifier for the street intersections.69%488251065008