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 Resurfacing Schedule

xnfm-u3k5Transportation16 columns
DOT issues a list of streets where crews will be doing milling or resurfacing work each week.* *Schedules are subject to change due to inclement weather or equipment issues. For more information, visit NYC DOT website: https://www.nyc.gov/html/dot/html/motorist/resurfintro.shtml
View on NYC Open Data↗

Quality

A95.2 / 100

From a 500-row sample across 15 columns.

completeness95/ 25% weight
consistency83/ 20% weight
accuracy99/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Street Closures due to Construction Activities by Intersection0.42
    joins ononstreetnamefromstreetname
  • Street Closures due to Construction Activities by Block0.40
    joins ononstreetnamefromstreetnametostreetname
  • Sidewalk Management Database - Violations0.39
  • Street Pavement Ratings0.38
    joins onboroughnameoftcode
  • Street Sign Work Orders0.37
  • Protected Streets Block (Dataset)0.36

Geography

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

Sample rows

workscheduleprojectlocationidboroughnamedaydateonstreetnamefromstreetnamecommunityboardworktypecrewtypeshifttypeoftcodelocation_segment_id
337732STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADBLAND PLACE503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505189300000000
337735

Columns

16 queryable · 16 profiled

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

FieldTypeDescriptionNullValues
workscheduleprojectlocationidintegerUnique ID0%141747165443201395
boroughnamecategoricalThe New York City borough where the resurfacing would take place.0%BROOKLYNQUEENSSTATEN ISLANDof 6
daycategoricalDay of the week the resurfacing was conducted0%ThursdayTuesdayWednesdayof 7
datedatetimeThe date and times that the resurfacing occurred0%2021-09-10T00:00:00.000

Query this from your own app

GET /api/datasets/xnfm-u3k5
GET /api/datasets/xnfm-u3k5/quality
GET /api/datasets/xnfm-u3k5/related
GET /api/columns?dataset=xnfm-u3k5
joins onoftcode
  • Street Pothole Work Orders - Closed (Dataset)0.36
  • Historical Driver Application Status0.36
    • STATEN ISLAND
    Friday
    2026-10-23T00:00:00.000
    AMBOY ROAD
    HUGUENOT AVENUE
    503
    PAVING
    IN-HOUSE CREW
    NIGHT SHIFT
    515650533650534992
    2820
    337729STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADARBUTUS AVENUE503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505160400000000
    337731STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADARBUTUS AVENUE503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505160405702742933
    337733STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADCOLON STREET503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505239830000000
    337734STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADCOLON STREET503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505239835702742930
    337727STATEN ISLANDFriday2026-10-23T00:00:00.000ALVINE AVENUEAMBOY ROAD503PAVINGIN-HOUSE CREWNIGHT SHIFT5155405156500000000
    337728STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADALVINE AVENUE503PAVINGIN-HOUSE CREWNIGHT SHIFT515650515540545910109775
    337730STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADARBUTUS AVENUE503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505160405189302948
    337736STATEN ISLANDFriday2026-10-23T00:00:00.000AMBOY ROADKINGDOM AVENUE503PAVINGIN-HOUSE CREWNIGHT SHIFT5156505349920000000

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

    2020-07-30T00:00:00.000
    2021-09-09T00:00:00.000
    onstreetnametextRoadway segment where street resurfacing is taking place0%4 AVENUE5 AVENUE3 AVENUE
    fromstreetnametextStreet name at the start of the onstreet segment, or intersection0%BENDDEAD ENDBROADWAY
    tostreetnametextStreet name at the end of the onstreet segment, or intersection37%BENDDEAD ENDNYCTA SUBWAY
    communityboardintegerNew York City Community Board where the resurfacing was located4%501503413
    areatextThe neighborhood name of the resurfacing project.43%East New YorkCanarsieWest Village
    worktypecategoricalThe crew conducting the work, DOT in-house crew or contractors0%PAVINGMILLINGof 2
    crewtypecategoricalThe type of work being complete by either in-house crew or contractors0%IN-HOUSE CREWCONTRACT WORKof 2
    shifttypecategoricalShift of the work being completed0%DAY SHIFTNIGHT SHIFTof 2
    oftcodetextA 18 digit code consisting of three 6-digit street codes representing On-From-To streets as returned by GeoSupport functions.0%544750553000570392127790125985125985110010117310117350
    location_segment_idintegerUnique identifier for the street block.2%0548872843
    location_wkttextA text markup language for representing vector geometry objects on a map and spatial reference systems of spatial objects.0%LINESTRING (939151.32520…LINESTRING (1002020.0295…LINESTRING (989614.05419…
    location_node_idnumericUnique identifier for the street intersections.100%—