Sidewalk Management Database - Inspection
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks Identifies locations where DOT inspectors performed sidewalk inspections for defects. For more information please visit NYC DOT website: www.nyc.gov/sidewalks
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.
Due
- Says it updates
- Daily
- Actually updates about every
- 1 days
- Publisher last updated the data
- Oct 7, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 6, 2026, 8:18 AM
- Rows in our copy
- 404,078
- Rows at the source
- 404,078
- Our copy trails the source by
- under a minute
Columns
Each source column, with the name and type we use to store it.
0 of 17 columns carry a concept; 17 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 |
|---|---|---|---|---|---|---|---|---|
is_311_inspection | Is 311 Inspection | To determine if the sidewalk inspection occurred at a taxlot where a 311 complaint for defective sidewalk was received. | Not bound | Text | is_311_inspection | text | — | |
cancel | Cancel | An outstanding violation cancelled - no sidewalk defects identified. | Not bound | Text | cancel | text | — | |
other | Other | To determine if the sidewalk inspection occurred due to a reason other than the receipt of a 311 complaint or correspondence. | Not bound | Text | other | text | — | |
pickupsidewalk | Pickup Sidewalk | To determine if the sidewalk inspection occurred at a taxlot where a 311 complaint for defective sidewalk was received on the block. | Not bound | Text | pickupsidewalk | text | — | |
damagetypecode | Damage Type Code | Identifies if all or any of the sidewalk defects are caused by a City tree | Not bound | Text | damagetypecode | text | — | |
ownerwilldoit | Owner Will Do It | Property owner will perform the sidewalk repairs. | Not bound | Text | ownerwilldoit | text | — | |
inspectiondate | Inspection Date | Inspection Date | Not bound | Calendar date | inspectiondate | timestamp | — | |
inspectionid | Inspection ID | Unique five digit numerical ID used to track inspection records. |
Download
This file was produced on Oct 6, 2026, 10:07 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/dntt-gqwq
- Version
- Content hash:
30c4bfe7f328d50764141139a32cba8dc391da9a7e3a5c74a2180c5ce0a349f7 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 6, 2026, 8:18 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 6, 2026, 3:30 PM | full_replace | success | 404,078 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 4, 2026, 4:30 PM | full_replace | success | 403,917 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 4, 2026, 3:15 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 3, 2026, 3:15 PM | full_replace | success | 403,916 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 2, 2026, 3:16 PM | full_replace | success | 403,843 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 3:18 PM | full_replace | success | 403,804 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 30, 2026, 3:10 PM | full_replace | success | 403,700 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 29, 2026, 3:33 PM | full_replace | success | 403,649 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 26, 2026, 3:22 PM | full_replace | success | 403,531 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Sep 25, 2026, 3:22 PM | full_replace | success | 403,511 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |