Street Pavement Ratings
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.
Open in the graph · Relate this dataset · What these columns mean
Freshness
The publisher's promise
How the agency that publishes this data says it keeps the data current.
Fresh
- Says it updates
- Monthly
- Actually updates about every
- 30.5 days
- Publisher last updated the data
- Oct 1, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 1, 2026, 6:12 AM
- Rows in our copy
- 524,928
- Rows at the source
- 524,928
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
1 of 13 columns carry a concept; 13 carry a description from the publisher. Read the concept column before you join. A column with no concept carries no claim from us, and a name that looks like a key is not one.
| Source field | Display name | What the publisher says it is | Concept | Source type | Stored as | Stored type | Row identifier | Unit |
|---|---|---|---|---|---|---|---|---|
boroughname | BoroughName | The borough where the inspected street segment is located. | boroughdeclared | Text | boroughname | text | — | |
direction | Direction | The compass direction of the street. | Not bound | Text | direction | text | — | |
the_geom | the_geom | The geometry type of the entry. | Not bound | MultiLine | the_geom | text | — | |
tostreetna | ToStreetName | The closest intersection to the on street in the opposite direction. | Not bound | Text | tostreetna | text | — | |
inspection | InspectionTime | The date the rating information was collected. | Not bound | Calendar date | inspection | timestamp | — | |
oftcode | OFTCode | A unique numerical 18 digit code for the On- From- To location of the street segment. | Not bound | Text | oftcode | text | — | |
ismultipass | IsMultiPass | This specifies if this street (OFT) has multiple road type (main/ service/ overpass/ underpass) or direction (North, South, East, West) combinations. | Not bound | Number | ismultipass | numeric | — | |
nonratingreason | NonRatingReason | The reason a street pavement rating was not conducted. | Not bound | Text | nonratingreason | text |
Download
This file was produced on Oct 1, 2026, 10:02 PM.
Refresh this dataset
Source and attribution
Where this data comes from, which version we hold, and what we changed.
- Source
- https://data.cityofnewyork.us/d/6yyb-pb25
- Version
- Content hash:
3fe99e664aee90e0fe20d706cb5cbef0f181636ad1c3f615c2d660bbc0e5380e - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 1, 2026, 6:12 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 1, 2026, 4:05 PM | full_replace | success | 524,928 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 1, 2026, 11:30 AM | full_replace | success | 519,413 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |
| Aug 5, 2026, 3:17 AM | full_replace | success | 514,521 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.45 |