Sidewalk Management Database - All Tree Damage (ATD)
Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. Tracks properties where all sidewalk defects on the tax lot are due to trees/tree roots (All Tree Defects - ATD) 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
- —
- Publisher last updated the data
- Mar 18, 2026
Our mirror
Whether our copy of this data is current with the source.
In sync
- We last synced
- Mar 18, 2026, 8:08 AM
- Rows in our copy
- 17,661
- Rows at the source
- 17,661
- 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 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 |
|---|---|---|---|---|---|---|---|---|
onstname | ONSTNAME | The street name where the ATD was found. | Not bound | Text | onstname | text | — | |
bblid | BBLID | The ID number assigned to a Borough-Block-Lot (BBL) value in the Lotinfo table; BBLID is an identifier for a BBL and should not be interpreted as the BBL itself. | Not bound | Number | bblid | numeric | — | |
inspectionid | InspectionId | Unique five digit numerical ID used to track inspection records. | Not bound | Number | inspectionid | numeric | — | |
reinspectionid | ReInspectionId | Six digit identifier to uniquely identify the inspector for the reinspection. | Not bound | Number | reinspectionid | numeric | — | |
violationid | ViolationId | A sequential count for the sidewalk violations. | Not bound | Number | violationid | numeric | — | |
atdissuedate | ATDIssueDate | The date an ATD was determined based on an inspection. | Not bound | Calendar date | atdissuedate | timestamp | — | |
atddismissedon | ATDDismissedOn | The date the violation was resolved. | Not bound | Calendar date | atddismissedon | timestamp | — | |
atddismissed | ATDDismissed | The all tree damage on the sidewalk was resolved. | Not bound | Text | atddismissed | text |
Download
This file was produced on Aug 20, 2026, 10:06 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/j6v2-6uxq
- Version
- Content hash:
a74ac2b3a7118eed360490302ee788ac9189e16491b9d1a6a590616294b2edae - What we changed
- We did not change the data. We stored it as published.
- Publisher
- codenownyc
- We retrieved it
- Mar 18, 2026, 8:08 AM
Update history
| Started | Kind | Result | Rows written | Produced by |
|---|---|---|---|---|
| Aug 20, 2026, 2:24 PM | full_replace | success | 17,661 | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 1:06 PM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 11:51 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 10:36 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 9:12 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |
| Aug 20, 2026, 7:51 AM | full_replace | failed | — | codenow-nycmesh-container-oci.jfrog.io/codenow/citytap-pull:0.1.64 |