Sidewalk Management Database - Built
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. Tracks the repairs that were performed via NYC DOT's Prior Notice Sidewalk Repair contracts and on properties that were repaired privately or by other organizations. 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.
Overdue
- Says it updates
- Daily
- Actually updates about every
- 60 days
- Publisher last updated the data
- Oct 2, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Oct 2, 2026, 8:04 AM
- Rows in our copy
- 106,564
- Rows at the source
- 106,564
- 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 14 columns carry a concept; 14 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 |
|---|---|---|---|---|---|---|---|---|
dot_contstruct_date | DOT_CONTSTRUCT_DATE | The last time the taxlot was repaired via a Prior Notice Sidewalk Repair contract. | Not bound | Calendar date | dot_contstruct_date | timestamp | — | |
totallfcurbrepaired | TotalLFCurbRepaired | Total linear foot of curb repaired at taxlot | Not bound | Number | totallfcurbrepaired | numeric | — | |
contract | CONTRACT | This field identifies the Prior Notice contract number for performed sidewalk repairs. | Not bound | Text | contract | text | — | |
totallfcurbrepairedstree | TotalLFCurbRepairedStreetTreeOnly | Total linear foot of sidewalk repaired where defects were caused by trees | Not bound | Number | totallfcurbrepairedstree | numeric | — | |
atdbystreettree | ATDByStreetTree | Identifies that all sidewalk defects repaired that were caused by a City tree | Not bound | Text | atdbystreettree | text | — | |
dbo | DBO | Sidewalk repair was performed by a contractor/private entity other than a Prior Notice Sidewalk Repair contract. | Not bound | Text | dbo | text | — | |
portionofdefectbystreettree | PortionofDefectByStreetTree | Identifies that a portion of sidewalk defects repaired were caused by a City tree. | Not bound | Text | portionofdefectbystreettree | text | — | |
dbo_date | DBO_Date | The date the taxlot was found to DBO. |
Download
This file was produced on Oct 2, 2026, 10:16 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/ugc8-s3f6
- Version
- Content hash:
047f3c0a43d9b4816d0f12b28f752ce93d21e6d9b1035c45176f78d7e63cbd93 - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Oct 2, 2026, 8:04 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Oct 2, 2026, 3:55 PM | full_replace | success | 106,564 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Oct 1, 2026, 3:50 PM | full_replace | success | 106,313 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.84 |
| Aug 29, 2026, 1:30 AM | full_replace | success | 105,990 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.73 |