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 Pavement Ratings

6yyb-pb25Transportation13 columns
The Agency performs ongoing assessments of New York City street pavement. Ratings are based on a scale from 1 to 10, and results are grouped in the following categories: - Good (%) - ratings of 8.00 to 10 - Fair (%) - ratings of 4.00 to 7.00 (except on local streets where a 7 is good) - Poor (%) - ratings of 1.00 to 3.00. Inspectors rate roadway pavement conditions throughout the five boroughs using the scale above.
View on NYC Open Data↗

Quality

A92.3 / 100

From a 500-row sample across 10 columns.

completeness100/ 25% weight
consistency75/ 20% weight
accuracy97/ 20% weight
timeliness100/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Protected Streets Block (Dataset)0.43
    joins onfromstreetoftcodetostreetna+2
  • Street Resurfacing Schedule0.38
    joins onboroughnameoftcode
  • Street Pothole Work Orders - Closed (Dataset)0.37
    joins onthe_geom
  • Protected Streets Intersection (Dataset)0.36
    joins onfromstreetoftcodeonstreetna+1
  • Street Closures due to Construction Activities by Block0.35

Geography

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

Sample rows

the_geomoftcodeboroughnameonstreetnafromstreettostreetnaismultipasssystemratinginspectionlocationgeometry_stlength
{"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}110110117510117530Manhattan2 AVENUEEAST 26 STREETEAST 27 STREET05.772019-06-01T00:00:00.000252.198000232
{"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}

Columns

13 queryable · 12 profiled

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

FieldTypeDescriptionNullValues
the_geomunknownThe geometry type of the entry.——
oftcodetextA unique numerical 18 digit code for the On- From- To location of the street segment.0%113610137750137790360530368250375760236420200468217020
boroughnamecategoricalThe borough where the inspected street segment is located.0%QueensBrooklynBronxof 5
onstreetnatextThe name of the street for the street rating to be located on.0%BROADWAY3 AVENUENORTHERN BOULEVARD

Query this from your own app

GET /api/datasets/6yyb-pb25
GET /api/datasets/6yyb-pb25/quality
GET /api/datasets/6yyb-pb25/related
GET /api/columns?dataset=6yyb-pb25
joins onthe_geom
  • Taxi and For Hire Vehicle (FHV) Relief Stands0.34
    joins onthe_geom
  • Routes0.34
  • DOT In-house Street Resurfacing Projects0.34
    • 110110117510117530
    Manhattan
    2 AVENUE
    EAST 26 STREET
    EAST 27 STREET
    0
    9.69
    2022-09-10T00:00:00.000
    252.198000232
    {"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}110110117510117530Manhattan2 AVENUEEAST 26 STREETEAST 27 STREET09.932023-11-04T00:00:00.000252.198000232
    {"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}110110117510117530Manhattan2 AVENUEEAST 26 STREETEAST 27 STREET08.952025-11-09T00:00:00.000252.198000232
    {"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}110110117510117530Manhattan2 AVENUEEAST 26 STREETEAST 27 STREET09.112021-07-17T00:00:00.000252.198000232
    {"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}110110117510117530Manhattan2 AVENUEEAST 26 STREETEAST 27 STREET09.472024-11-09T00:00:00.000252.198000232
    {"type":"MultiLineString","coordinates":[[[-73.97950261314755,40.73978194555648],[-73.97907686452608,40.740393750170476]]]}110110117510117530Manhattan2 AVENUEEAST 26 STREETEAST 27 STREET09.592026-07-11T00:00:00.000252.198000232
    {"type":"MultiLineString","coordinates":[[[-73.9781681528791,40.74164251286421],[-73.97861648193141,40.74102185852045],[-73.97907686452608,40.740393750170476],[-73.97950261314755,40.73978194555648]]]}110110117510117570Manhattan2 AVENUEEAST 26 STREETEAST 29 STREET07.382018-06-16T00:00:00.000772.202492667
    {"type":"MultiLineString","coordinates":[[[-73.9781681528791,40.74164251286421],[-73.97861648193141,40.74102185852045],[-73.97907686452608,40.740393750170476],[-73.97950261314755,40.73978194555648]]]}110110117510117570Manhattan2 AVENUEEAST 26 STREETEAST 29 STREET010.02019-09-07T00:00:00.000772.202492667
    {"type":"MultiLineString","coordinates":[[[-73.97907686452608,40.740393750170476],[-73.97861648193141,40.74102185852045]]]}110110117530117550Manhattan2 AVENUEEAST 27 STREETEAST 28 STREET05.932019-06-01T00:00:00.000261.999290789
    fromstreet
    text
    The closest intersection to the on street in one direction.
    0%
    DEAD ENDBENDBROADWAY
    tostreetnatextThe closest intersection to the on street in the opposite direction.0%DEAD ENDBENDLINDEN BOULEVARD
    ismultipasscategoricalThis specifies if this street (OFT) has multiple road type (main/ service/ overpass/ underpass) or direction (North, South, East, West) combinations.0%01of 2
    directioncategoricalThe compass direction of the street.91%NorthSouthWestof 4
    road_typecategoricalThe classification of the street type.91%MainServiceUnderPassof 4
    systemratingfloatThe numeric value of the Street Assessment rating on a scale of 1.00-10, 1.00 being a low or poor rating and 10.00 being a high or good rating.0%0.010.09.93
    nonratingreasoncategoricalThe reason a street pavement rating was not conducted.86%DuplicateConstructionMulti-passof 17
    inspectiondatetimeThe date the rating information was collected.0%2020-01-30T00:00:00.0002021-11-16T00:00:00.0002020-03-02T00:00:00.000
    locationgeometry_stlengthfloatThe length of the street line (block).0%734.056280137521.762292718739.092284458